1 PACKAGE ece_inbound as
2 -- $Header: ECEINBS.pls 120.3 2005/09/28 11:24:57 arsriniv ship $
3 /*#
4 * This package contains routines to process data in the staging tables and
5 * populates the open interface tables.
6 * @rep:scope internal
7 * @rep:product EC
8 * @rep:lifecycle active
9 * @rep:displayname Process Data from Staging Tables to Open Interface Tables
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY EC_INBOUND
12 */
13
14 -- Global variables --
15 m_file_tbl_empty ec_utils.mapping_tbl;
16 g_previous_map_id ece_stage.map_id%TYPE := -99;
17
18 Type col_rule_viol_rec is Record
19 (
20 stage_id ece_rule_violations.stage_id%type,
21 rule_id ece_rule_violations.rule_id%type,
22 interface_col_id ece_rule_violations.interface_column_id%type
23 );
24
25 TYPE col_rule_viol_tbl is table of col_rule_viol_rec index by BINARY_INTEGER;
26
27 g_col_rule_viol_tbl col_rule_viol_tbl;
28
29
30 procedure process_inbound_documents
31 (
32 i_transaction_type IN VARCHAR2,
33 i_document_id IN NUMBER
34 );
35
36 procedure process_inbound_documents
37 (
38 i_transaction_type IN VARCHAR2,
39 i_run_id IN NUMBER
40 );
41 /*#
42 * This program process the data in the staging tables and populates the open interface tables.
43 * Data is processed according to the seeded map provided for the transaction and run id
44 * obtained as output of the ece_inbound_stage.load_data program.
45 * @param i_transaction_type Transaction Type
46 * @param i_run_id Run Id Obtained as Output of Staging Process.
47 * @rep:scope internal
48 * @rep:lifecycle active
49 * @rep:displayname Process Data from Staging Tables to Open Interface Tables
50 * @rep:compatibility S
51 */
52
53 procedure process_run_inbound
54 (
55 i_transaction_type IN VARCHAR2,
56 i_run_id IN NUMBER
57 );
58
59 procedure process_inbound_documents
60 (
61 i_transaction_type IN VARCHAR2,
62 i_status IN varchar2
63 );
64
65 procedure process_inbound_documents
66 (
67 i_transaction_type IN VARCHAR2
68 );
69
70 procedure process_inbound_documents
71 (
72 i_transaction_type IN VARCHAR2,
73 i_tp_code IN varchar2,
74 i_status IN varchar2
75 );
76
77 procedure run_inbound
78 (
79 i_document_id IN number,
80 i_transaction_type IN varchar2,
81 i_select_cursor IN INTEGER
82 );
83
84 procedure update_document_status;
85
86 procedure initialize_inbound
87 (
88 i_transaction_type IN varchar2,
89 i_map_id IN number
90 );
91
92 procedure close_inbound;
93
94 procedure insert_into_violations
95 (
96 i_document_id IN number
97 );
98
99 procedure process_for_reqid
100 (
101 errbuf OUT NOCOPY varchar2,
102 retcode OUT NOCOPY varchar2,
103 i_transaction_type IN varchar2,
104 i_reqid IN number,
105 i_debug_mode IN number
106 );
107
108 procedure process_for_document_id
109 (
110 errbuf OUT NOCOPY varchar2,
111 retcode OUT NOCOPY varchar2,
112 i_transaction_type IN varchar2,
113 i_document_id IN number,
114 i_debug_mode IN number
115 );
116
117 procedure process_for_status
118 (
119 errbuf OUT NOCOPY varchar2,
120 retcode OUT NOCOPY varchar2,
121 i_transaction_type IN varchar2,
122 i_status IN varchar2,
123 i_debug_mode IN number
124 );
125
126 procedure process_for_transaction
127 (
128 errbuf OUT NOCOPY varchar2,
129 retcode OUT NOCOPY varchar2,
130 i_transaction_type IN varchar2,
131 i_debug_mode IN number
132 );
133
134 procedure process_for_tpstatus
135 (
136 errbuf OUT NOCOPY varchar2,
137 retcode OUT NOCOPY varchar2,
138 i_transaction_type IN varchar2,
139 i_tp_code IN varchar2,
140 i_status IN varchar2,
141 i_debug_mode IN number
142 );
143
144 procedure process_documents
145 (
146 i_document_id IN number,
147 i_transaction_type IN varchar2,
148 i_select_cursor IN integer
149 );
150
151 procedure select_stage
152 (
153 i_select_cursor OUT NOCOPY integer
154 );
155
156 function insert_into_prod_interface
157 (
158 i_Insert_cursor IN OUT NOCOPY INTEGER,
159 i_level IN NUMBER
160 )
161 return boolean;
162
163 end ece_inbound;