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