PACKAGE: APPS.CN_COLLECTION_CUSTOM_GEN

Source

1 PACKAGE CN_COLLECTION_CUSTOM_GEN AS
2 -- $Header: cncusgens.pls 120.3 2007/09/26 19:52:02 apink ship $
3 
4 --
5 -- Procedure Name
6 --   insert_cn_not_trx
7 -- Purpose
8 --   This procedure generates the Notification code
9 -- History
10 --
11 --
12   PROCEDURE insert_cn_not_trx (
13      x_table_map_id         cn_table_maps.table_map_id%TYPE,
14      x_event_id             cn_events.event_id%TYPE,
15      code IN OUT NOCOPY            cn_utils.code_type,
16 	 x_org_id IN NUMBER);
17 
18 
19 --
20 -- Procedure Name
21 --   insert_comm_lines_api_select
22 -- Purpose
23 --   This procedure uses the Direct Column Mappings to
24 --   generate the 'INSERT INTO cn_comm_lines_api VALUES (...) SELECT ...'
25 --   portion of the SQL statement wich populates the api table
26 --
27 -- History
28 --   03-17-00   Dave Maskell    Created for Release 11i2.
29 --
30 --
31 
32 PROCEDURE insert_comm_lines_api_select(
33            	x_table_map_id   IN     cn_table_maps_v.table_map_id%TYPE,
34 	      	code             IN OUT NOCOPY cn_utils.code_type,
35 	 	   x_org_id IN NUMBER,
36 		   x_parallel_hint  IN VARCHAR2);
37 --
38 -- Procedure Name
39 --   insert_comm_lines_api
40 -- Purpose
41 --   This procedure inserts into the CN_COMM_LINES_API table
42 -- History
43 --
44 --
45   PROCEDURE insert_comm_lines_api (
46 	x_table_map_id		cn_table_maps.table_map_id%TYPE,
47      x_event_id          cn_events.event_id%TYPE,
48 	code	IN OUT NOCOPY 	cn_utils.code_type,
49 	 x_org_id IN NUMBER);
50 
51 ----------------------------------------------------------+
52 -- Procedure Name
53 --   update_comm_lines_api
54 --
55 -- Purpose
56 --   Generates code to update the CN_COMM_LINES_API table
57 --   using Indirect Mappings
58 -- History
59 -- 16-Mar-00       Dave Maskell          Created
60 --
61   PROCEDURE update_comm_lines_api (
62      x_table_map_id      cn_table_maps.table_map_id%TYPE,
63      code IN OUT NOCOPY         cn_utils.code_type,
64 	 x_org_id IN NUMBER);
65 ----------------------------------------------------------+
66 -- Procedure Name
67 --   filter_comm_lines_api
68 --
69 -- Purpose
70 --   Generates code to filter the CN_COMM_LINES_API table
71 -- History
72 -- 29-Mar-00       Dave Maskell          Created
73 --
74 
75   PROCEDURE filter_comm_lines_api (
76      x_table_map_id      cn_table_maps.table_map_id%TYPE,
77      code IN OUT NOCOPY         cn_utils.code_type,
78 	 x_org_id IN NUMBER);
79 
80 --
81 -- Procedure Name
82 --   Generate_user_code
83 -- Purpose
84 --   Gets user-specificed code for a particular location and generates that code
85 -- History
86 --   04-03-00	     Dave Maskell     Created
87 --
88 
89   PROCEDURE Generate_User_Code(
90                  p_table_map_id  IN NUMBER,
91 			  p_location_name IN VARCHAR2,
92                  code            IN OUT NOCOPY cn_utils.code_type,
93 	 x_org_id IN NUMBER);
94 
95 END cn_collection_custom_gen;