DBA Data[Home] [Help]

PACKAGE: APPS.GCS_ENG_CP_UTILITY_PKG

Source


1 PACKAGE GCS_ENG_CP_UTILITY_PKG as
2 /* $Header: gcs_cpeng_uts.pls 120.1 2005/10/30 05:17:12 appldev noship $ */
3 
4   --
5   -- Procedure
6   --   generate_xml_and_ntfs()
7   -- Purpose
8   --   Concurrent program to generate the XML and notifications
9   -- Arguments
10   --   x_errbuf			Standard error buffer
11   --   x_retcode		Standard return code
12   --   p_execution_type		"CONS_PROCESS", "IMPACT_ENGINE", "NTF_ONLY"
13   --   p_run_name		Process Identifier
14   --   p_cons_entity_id		Consolidation Entity
15   --   p_category_code		Category Code
16   --   p_child_entity_id	Child Entity
17   --   p_run_detail_id		Run Detail Identifier
18   --   p_entry_id		Entry Identifier
19   --   p_load_id		Load Identifier
20   -- Notes
21   --
22    PROCEDURE generate_xml_and_ntfs(
23 				x_errbuf			OUT NOCOPY VARCHAR2,
24 				x_retcode			OUT NOCOPY VARCHAR2,
25 				p_execution_type		IN VARCHAR2,
26 				p_run_name			IN VARCHAR2,
27 				p_cons_entity_id		IN NUMBER,
28 				p_category_code			IN VARCHAR2,
29 				p_child_entity_id		IN NUMBER,
30 				p_run_detail_id			IN NUMBER 	DEFAULT NULL,
31 				p_entry_id			IN NUMBER	DEFAULT NULL,
32 				p_load_id			IN NUMBER	DEFAULT NULL);
33 
34   --
35   -- Procedure
36   --   submit_xml_ntf_program()
37   -- Purpose
38   --   API to submit concurrent request to generate notifications and XML
39   -- Arguments
40   --   p_execution_type         "CONS_PROCESS", "IMPACT_ENGINE", "NTF_ONLY"
41   --   p_run_name               Process Identifier
42   --   p_cons_entity_id         Consolidation Entity
43   --   p_category_code          Category Code
44   --   p_child_entity_id        Child Entity
45   --   p_run_detail_id          Run Detail Identifier
46   --   p_entry_id               Entry Identifier
47   --   p_load_id                Load Identifier
48   -- Notes
49   --
50    PROCEDURE submit_xml_ntf_program(
51                                 p_execution_type                IN VARCHAR2,
52                                 p_run_name                      IN VARCHAR2,
53                                 p_cons_entity_id                IN NUMBER,
54                                 p_category_code                 IN VARCHAR2,
55                                 p_child_entity_id               IN NUMBER	DEFAULT NULL,
56                                 p_run_detail_id                 IN NUMBER       DEFAULT NULL,
57                                 p_entry_id                      IN NUMBER       DEFAULT NULL,
58                                 p_load_id                       IN NUMBER       DEFAULT NULL);
59 
60 END GCS_ENG_CP_UTILITY_PKG;
61