[Home] [Help]
PACKAGE: APPS.GCS_CONS_ENG_RUN_DTLS_PKG
Source
1 PACKAGE GCS_CONS_ENG_RUN_DTLS_PKG AS
2 /* $Header: gcs_eng_run_dtls.pls 120.2 2005/12/07 02:23:35 skamdar noship $ */
3 --
4 -- Procedure
5 -- insert_row()
6 -- Purpose
7 -- Inserts a row in gcs_cons_eng_run_dtls
8 -- Arguments
9 -- p_run_name VARCHAR2
10 -- p_consolidation_entity_id NUMBER
11 -- p_process_code NUMBER
12 -- p_child_entity_id NUMBER
13 -- p_contra_child_entity_id VARCHAR2
14 -- p_rule_id VARCHAR2
15 -- p_entry_id NUMBER
16 -- p_request_error_code VARCHAR2
17 -- p_bp_request_error_code VARCHAR2
18 -- p_pre_prop_entry_id NUMBER
19 -- p_pre_prop_stat_entry_id NUMBER
20
21
22 PROCEDURE insert_row ( p_run_detail_id OUT NOCOPY NUMBER,
23 p_run_name IN VARCHAR2,
24 p_consolidation_entity_id IN NUMBER,
25 p_category_code IN VARCHAR2,
26 p_child_entity_id IN NUMBER DEFAULT NULL,
27 p_contra_child_entity_id IN NUMBER DEFAULT NULL,
28 p_rule_id IN NUMBER DEFAULT NULL,
29 p_entry_id IN NUMBER DEFAULT NULL,
30 p_stat_entry_id IN NUMBER DEFAULT NULL,
31 p_request_error_code IN VARCHAR2 DEFAULT NULL,
32 p_bp_request_error_code IN VARCHAR2 DEFAULT NULL,
33 p_pre_prop_entry_id IN NUMBER DEFAULT NULL,
34 p_pre_prop_stat_entry_id IN NUMBER DEFAULT NULL,
35 p_cons_relationship_id IN NUMBER DEFAULT NULL);
36
37 --
38 -- Procedure
39 -- update_entry_headers()
40 -- Purpose
41 -- Updates the status of a particular run
42 -- Arguments
43 -- p_run_detail_id NUMBER
44 -- p_entry_id NUMBER
45 -- p_stat_entry_id NUMBER
46 -- p_pre_prop_entry_id NUMBER
47 -- p_pre_prop_stat_entry_id NUMBER
48
49 PROCEDURE update_entry_headers( p_run_detail_id IN NUMBER,
50 p_entry_id IN NUMBER DEFAULT NULL,
51 p_stat_entry_id IN NUMBER DEFAULT NULL,
52 p_pre_prop_entry_id IN NUMBER DEFAULT NULL,
53 p_pre_prop_stat_entry_id IN NUMBER DEFAULT NULL,
54 p_request_error_code IN VARCHAR2 DEFAULT NULL,
55 p_bp_request_error_code IN VARCHAR2 DEFAULT NULL
56 );
57
58 --
59 -- Procedure
60 -- update_entry_headers_async()
61 -- Purpose
62 -- Updates the status of a particular run
63 -- Arguments
64 -- p_run_detail_id NUMBER
65 -- p_entry_id NUMBER
66 -- p_stat_entry_id NUMBER
67 -- p_pre_prop_entry_id NUMBER
68 -- p_pre_prop_stat_entry_id NUMBER
69
70 PROCEDURE update_entry_headers_async( p_run_detail_id IN NUMBER,
71 p_entry_id IN NUMBER DEFAULT NULL,
72 p_stat_entry_id IN NUMBER DEFAULT NULL,
73 p_pre_prop_entry_id IN NUMBER DEFAULT NULL,
74 p_pre_prop_stat_entry_id IN NUMBER DEFAULT NULL,
75 p_request_error_code IN VARCHAR2 DEFAULT NULL,
76 p_bp_request_error_code IN VARCHAR2 DEFAULT NULL
77 );
78
79 --
80 -- Procedure
81 -- update_category_status()
82 -- Purpose
83 -- Updates the status of a particular run
84 -- Arguments
85 -- p_run_detail_id NUMBER
86 -- p_entry_id NUMBER
87 -- p_stat_entry_id NUMBER
88 -- p_pre_prop_entry_id NUMBER
89 -- p_pre_prop_stat_entry_id NUMBER
90
91 PROCEDURE update_category_status( p_run_name IN VARCHAR2,
92 p_consolidation_entity_id IN NUMBER,
93 p_category_code IN VARCHAR2,
94 p_status IN VARCHAR2);
95
96
97 --
98 -- Procedure
99 -- update_detail_requests()
100 -- Purpose
101 -- Updates gcs_cons_eng_run_dtls appropriately
102 -- Arguments
103 -- p_run_detail_id NUMBER,
104 -- p_run_process_code VARCHAR2,
105
106 PROCEDURE update_detail_requests( p_run_detail_id IN NUMBER,
107 p_run_process_code IN VARCHAR2
108 );
109
110 --
111 -- Procedure
112 -- copy_prior_run_dtls()
113 -- Purpose
114 -- Copies details from a prior run to current run
115 -- Arguments
116 -- p_prior_run_name VARCHAR2,
117 -- p_current_run_name VARCHAR2,
118 -- p_itemtype VARCHAR2
119 -- p_entity_id NUMBER
120
121 PROCEDURE copy_prior_run_dtls( p_prior_run_name IN VARCHAR2,
122 p_current_run_name IN VARCHAR2,
123 p_itemtype IN VARCHAR2,
124 p_entity_id IN NUMBER);
125
126 END GCS_CONS_ENG_RUN_DTLS_PKG;
127