sql_templates/package_spec_template.sql at master · jeffchulg/sql_templates · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
create or replace package PACKAGE_NAME is
/*------------------------------------------------------------------------------
    Program:  PACKAGE_NAME
    Author:   Zac Carlson
    Date:
    For:

    Purpose:

      Why was it created?

    Documentation:

      How does this work, what does it do?

    Installation information:

      Are there any things that need to be done as part of the installation of
      this package?

    Modification History:

      v0.1
      By: Zac Carlson
      Date:
      Description:

------------------------------------------------------------------------------*/

  procedure main;

  procedure foo (
    p_input_1 in varchar2,
    p_input_2 in varchar2,
    p_status out varchar2);

  function bar (
    p_input_1 in number,
    p_input_2 in number,
    p_result out number)

end ERS_CANCER_REGISTRY_PLMAP;