eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECE_INBOUND dependencies on ECE_STAGE

Line 91: from ece_stage

87: p_run_id in number,
88: p_transaction_type IN varchar2
89: )is
90: select document_id
91: from ece_stage
92: where run_id = p_run_id
93: and transaction_type = p_transaction_type
94: and transaction_level = 1
95: and line_number = 1

Line 181: from ece_stage

177: p_run_id in number,
178: p_transaction_type IN varchar2
179: )is
180: select document_id
181: from ece_stage
182: where run_id = p_run_id
183: and transaction_type = p_transaction_type
184: and transaction_level = 1
185: and line_number = 1

Line 198: Gather table Statistics for CBO ( ece_stage , ece_rule_violations ).

194: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
195: ec_debug.pl(3,'i_run_id',i_run_id);
196: end if;
197: /**
198: Gather table Statistics for CBO ( ece_stage , ece_rule_violations ).
199: **/
200: /**
201: fnd_stats.gather_table_stats
202: (

Line 204: 'ECE_STAGE',

200: /**
201: fnd_stats.gather_table_stats
202: (
203: 'EC',
204: 'ECE_STAGE',
205: 20,
206: null,
207: null,
208: null,

Line 283: delete from ece_stage

279: then
280: delete from ece_rule_violations
281: where document_id = c1.document_id;
282:
283: delete from ece_stage
284: where document_id = c1.document_id;
285:
286: if sql%notfound
287: then

Line 343: from ece_stage

339: p_transaction_type in varchar2,
340: p_status IN varchar2
341: )is
342: select document_id
343: from ece_stage
344: where transaction_type = p_transaction_type
345: and status = p_status
346: and transaction_level = 1
347: and line_number = 1

Line 429: from ece_stage

425: (
426: p_transaction_type in varchar2
427: )is
428: select document_id
429: from ece_stage
430: where transaction_type = p_transaction_type
431: and transaction_level = 1
432: and line_number = 1
433: for update of Document_Id NOWAIT;

Line 519: from ece_stage

515: p_tp_code in varchar2,
516: p_status IN varchar2
517: )is
518: select document_id
519: from ece_stage
520: where transaction_type = p_transaction_type
521: and tp_code = p_tp_code
522: and status = p_status
523: and transaction_level = 1

Line 533: from ece_stage

529: p_transaction_type in varchar2,
530: p_status IN varchar2
531: )is
532: select document_id
533: from ece_stage
534: where transaction_type = p_transaction_type
535: and tp_code is null
536: and status = p_status
537: and transaction_level = 1

Line 665: i_level ece_stage.transaction_level%TYPE;

661: IS
662: l_return_status VARCHAR2(1);
663: l_msg_count NUMBER;
664: l_msg_data VARCHAR2(2000);
665: i_level ece_stage.transaction_level%TYPE;
666: i_line_number ece_stage.line_number%TYPE;
667: i_field_number number;
668: dummy number;
669: i_total_records number;

Line 666: i_line_number ece_stage.line_number%TYPE;

662: l_return_status VARCHAR2(1);
663: l_msg_count NUMBER;
664: l_msg_data VARCHAR2(2000);
665: i_level ece_stage.transaction_level%TYPE;
666: i_line_number ece_stage.line_number%TYPE;
667: i_field_number number;
668: dummy number;
669: i_total_records number;
670: i_status ece_stage.status%TYPE;

Line 670: i_status ece_stage.status%TYPE;

666: i_line_number ece_stage.line_number%TYPE;
667: i_field_number number;
668: dummy number;
669: i_total_records number;
670: i_status ece_stage.status%TYPE;
671: i_map_id ece_stage.map_id%TYPE;
672: i_document_number ece_stage.document_number%TYPE;
673: i_stage_id ece_stage.stage_id%TYPE;
674: i_insert_ok BOOLEAN := FALSE;

Line 671: i_map_id ece_stage.map_id%TYPE;

667: i_field_number number;
668: dummy number;
669: i_total_records number;
670: i_status ece_stage.status%TYPE;
671: i_map_id ece_stage.map_id%TYPE;
672: i_document_number ece_stage.document_number%TYPE;
673: i_stage_id ece_stage.stage_id%TYPE;
674: i_insert_ok BOOLEAN := FALSE;
675: i_insert BOOLEAN := FALSE;

Line 672: i_document_number ece_stage.document_number%TYPE;

668: dummy number;
669: i_total_records number;
670: i_status ece_stage.status%TYPE;
671: i_map_id ece_stage.map_id%TYPE;
672: i_document_number ece_stage.document_number%TYPE;
673: i_stage_id ece_stage.stage_id%TYPE;
674: i_insert_ok BOOLEAN := FALSE;
675: i_insert BOOLEAN := FALSE;
676: i_document_failed BOOLEAN := FALSE;

Line 673: i_stage_id ece_stage.stage_id%TYPE;

669: i_total_records number;
670: i_status ece_stage.status%TYPE;
671: i_map_id ece_stage.map_id%TYPE;
672: i_document_number ece_stage.document_number%TYPE;
673: i_stage_id ece_stage.stage_id%TYPE;
674: i_insert_ok BOOLEAN := FALSE;
675: i_insert BOOLEAN := FALSE;
676: i_document_failed BOOLEAN := FALSE;
677: i_level_found BOOLEAN := FALSE;

Line 849: Field1,Field2,Field3........Field500 from ece_stage;

845: are mapped to the Staging Columns in the Stage Table. The Data from the
846: Stage table is extracted only for the mapped fields.
847: e.g. select statement build for Extract is
848: select Stage_Id,Document_Number,transaction_level,Line_number,Status,map_id,
849: Field1,Field2,Field3........Field500 from ece_stage;
850: To extract Field3 , first Find out the relative position of the Column
851: in the Select Statement which is 6 + 3 ( 3 for Field3 , 5 for Field5).
852: Pass this to the DBMS_SQL call to get the Column Value.
853: **/

Line 1214: update ece_stage

1210: end if;
1211: /**
1212: Update Header record in the Staging Table.
1213: **/
1214: update ece_stage
1215: set status = ec_utils.g_ext_levels(1).Status
1216: where document_id = ec_utils.g_ext_levels(1).Document_id
1217: and transaction_level = 1
1218: and line_number = 1;

Line 1237: update ece_stage

1233: 'INSERT' so that it will show the 'GREEN' icon in View Staged
1234: Document form.
1235: **/
1236:
1237: update ece_stage
1238: set status = 'INSERT'
1239: where (stage_id > ec_utils.g_ext_levels(1).stage_id) and
1240: (stage_id < ec_utils.g_ext_levels(ec_utils.g_current_level).stage_id);
1241:

Line 1246: update ece_stage

1242: /**
1243: Update the Status of the Line where error encountered in
1244: the Staging Table.
1245: **/
1246: update ece_stage
1247: set status = ec_utils.g_ext_levels(ec_utils.g_current_level).Status
1248: where stage_id = ec_utils.g_ext_levels(ec_utils.g_current_level).stage_id;
1249:
1250: if sql%notfound

Line 1362: -- the dynamic select stmt on ece_stage table. Bug 2500898

1358: end loop;
1359:
1360: -- Extracting the no. from the Staging_column as this will
1361: -- be used to determine the position of staging column in
1362: -- the dynamic select stmt on ece_stage table. Bug 2500898
1363: for k in 1..ec_utils.g_file_tbl.COUNT
1364: loop
1365: ec_utils.g_file_tbl(k).staging_column_no :=
1366: to_number( substrb(

Line 1849: delete from ece_stage

1845: then
1846: delete from ece_rule_violations
1847: where document_id = i_document_id;
1848:
1849: delete from ece_stage
1850: where document_id = i_document_id;
1851:
1852: if sql%notfound
1853: then

Line 1889: i_document_number ece_stage.document_number%TYPE;

1885: error_position pls_integer;
1886: i_level pls_integer;
1887: i_line_number pls_integer;
1888: i_stage_id pls_integer;
1889: i_document_number ece_stage.document_number%TYPE;
1890: i_status ece_stage.status%TYPE;
1891: i_map_id ece_stage.map_id%TYPE;
1892: i_columns ece_stage.field1%TYPE;
1893:

Line 1890: i_status ece_stage.status%TYPE;

1886: i_level pls_integer;
1887: i_line_number pls_integer;
1888: i_stage_id pls_integer;
1889: i_document_number ece_stage.document_number%TYPE;
1890: i_status ece_stage.status%TYPE;
1891: i_map_id ece_stage.map_id%TYPE;
1892: i_columns ece_stage.field1%TYPE;
1893:
1894: begin

Line 1891: i_map_id ece_stage.map_id%TYPE;

1887: i_line_number pls_integer;
1888: i_stage_id pls_integer;
1889: i_document_number ece_stage.document_number%TYPE;
1890: i_status ece_stage.status%TYPE;
1891: i_map_id ece_stage.map_id%TYPE;
1892: i_columns ece_stage.field1%TYPE;
1893:
1894: begin
1895: if ec_debug.G_debug_level >=2 then

Line 1892: i_columns ece_stage.field1%TYPE;

1888: i_stage_id pls_integer;
1889: i_document_number ece_stage.document_number%TYPE;
1890: i_status ece_stage.status%TYPE;
1891: i_map_id ece_stage.map_id%TYPE;
1892: i_columns ece_stage.field1%TYPE;
1893:
1894: begin
1895: if ec_debug.G_debug_level >=2 then
1896: ec_debug.push('ECE_INBOUND.SELECT_STAGE');

Line 1910: i_Select_Stmt := i_Select_Stmt ||' from ECE_STAGE where Document_Id = :i_document_id order by stage_id for update of Document_id NOWAIT';

1906: i_Select_Stmt := i_Select_Stmt ||'FIELD'||i||',';
1907: end loop;
1908:
1909: i_Select_Stmt := RTRIM(i_Select_Stmt,',');
1910: i_Select_Stmt := i_Select_Stmt ||' from ECE_STAGE where Document_Id = :i_document_id order by stage_id for update of Document_id NOWAIT';
1911:
1912: /**
1913: Open the cursor and parse the SQL Statement. Trap any parsing error and
1914: report the Error Position in the SQL Statement