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_MVSTO_TRANSACTION dependencies on ECE_EXTRACT_UTILS_PUB

Line 413: -- call. The ece_extract_utils_pub.select_clause uses the EDI data dictionary

409: l_key_tbl);
410:
411: -- ****************************************************************************
412: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic SQL
413: -- call. The ece_extract_utils_pub.select_clause uses the EDI data dictionary
414: -- for the build.
415: -- ****************************************************************************
416:
417: xProgress := 'MVSTOB-20-1050';

Line 418: ece_extract_utils_pub.select_clause(cTransaction_Type,

414: -- for the build.
415: -- ****************************************************************************
416:
417: xProgress := 'MVSTOB-20-1050';
418: ece_extract_utils_pub.select_clause(cTransaction_Type,
419: cCommunication_Method,
420: cHeader_Interface,
421: l_header_tbl,
422: cHeader_select,

Line 427: ece_extract_utils_pub.select_clause(cTransaction_Type,

423: cHeader_from,
424: cHeader_where);
425:
426: xProgress := 'MVSTOB-20-1060';
427: ece_extract_utils_pub.select_clause(cTransaction_Type,
428: cCommunication_Method,
429: cLine_Interface,
430: l_line_tbl,
431: cLine_select,

Line 436: ece_extract_utils_pub.select_clause(cTransaction_Type,

432: cLine_from,
433: cLine_where);
434:
435: xProgress := 'MVSTOB-20-1070';
436: ece_extract_utils_pub.select_clause(cTransaction_Type,
437: cCommunication_Method,
438: cLocation_Interface,
439: l_location_tbl,
440: cLocation_select,

Line 648: ece_extract_utils_PUB.G_MaxColWidth,

644:
645: xProgress := 'MVSTOB-20-1290';
646: ece_flatfile_pvt.DEFINE_INTERFACE_COLUMN_TYPE(Header_sel_c,
647: cHeader_select,
648: ece_extract_utils_PUB.G_MaxColWidth,
649: l_Header_tbl);
650:
651: xProgress := 'MVSTOB-20-1300';
652: ece_flatfile_pvt.DEFINE_INTERFACE_COLUMN_TYPE(Line_sel_c,

Line 654: ece_extract_utils_PUB.G_MaxColWidth,

650:
651: xProgress := 'MVSTOB-20-1300';
652: ece_flatfile_pvt.DEFINE_INTERFACE_COLUMN_TYPE(Line_sel_c,
653: cLine_select,
654: ece_extract_utils_PUB.G_MaxColWidth,
655: l_Line_tbl);
656:
657: xProgress := 'MVSTOB-20-1310';
658: ece_flatfile_pvt.DEFINE_INTERFACE_COLUMN_TYPE(Location_sel_c,

Line 660: ece_extract_utils_PUB.G_MaxColWidth,

656:
657: xProgress := 'MVSTOB-20-1310';
658: ece_flatfile_pvt.DEFINE_INTERFACE_COLUMN_TYPE(Location_sel_c,
659: cLocation_select,
660: ece_extract_utils_PUB.G_MaxColWidth,
661: l_Location_tbl);
662:
663: -- **************************************************************
664: -- *** The following is custom tailored for this transaction

Line 675: ece_extract_utils_pub.Find_pos(l_header_tbl,

671: -- we will need values for the join condition.
672: -- ***************************************************
673:
674: xProgress := 'MVSTOB-20-1320';
675: ece_extract_utils_pub.Find_pos(l_header_tbl,
676: ece_extract_utils_pub.G_Transaction_date,
677: n_trx_date_pos);
678: ec_debug.pl(3, 'n_trx_date_pos: ', n_trx_date_pos);
679:

Line 676: ece_extract_utils_pub.G_Transaction_date,

672: -- ***************************************************
673:
674: xProgress := 'MVSTOB-20-1320';
675: ece_extract_utils_pub.Find_pos(l_header_tbl,
676: ece_extract_utils_pub.G_Transaction_date,
677: n_trx_date_pos);
678: ec_debug.pl(3, 'n_trx_date_pos: ', n_trx_date_pos);
679:
680: -- Bind the Variables

Line 822: ece_Extract_Utils_PUB.insert_into_interface_tbl(iRun_id,

818: END;
819: ec_debug.pl(3, 'l_header_fkey: ',l_header_fkey);
820:
821: xProgress := 'MVSTOB-20-1490';
822: ece_Extract_Utils_PUB.insert_into_interface_tbl(iRun_id,
823: cTransaction_Type,
824: cCommunication_Method,
825: cHeader_Interface,
826: l_header_tbl,

Line 862: ece_extract_utils_pub.Find_pos(l_line_tbl,

858: l_line_tbl,
859: l_key_tbl);
860:
861: xProgress := 'MVSTOB-20-1551';
862: ece_extract_utils_pub.Find_pos(l_line_tbl,
863: 'BILL_TO_SITE_USE_ID',
864: nBill_To_Site_pos);
865: ec_debug.pl(3, 'nBill_To_Site_pos: ',nBill_To_Site_pos);
866:

Line 868: ece_extract_utils_pub.Find_pos(l_line_tbl,

864: nBill_To_Site_pos);
865: ec_debug.pl(3, 'nBill_To_Site_pos: ',nBill_To_Site_pos);
866:
867: xProgress := 'MVSTOB-20-1552';
868: ece_extract_utils_pub.Find_pos(l_line_tbl,
869: 'SHIP_TO_SITE_USE_ID',
870: nShip_To_Site_pos);
871: ec_debug.pl(3, 'nShip_To_Site_pos: ',nShip_To_Site_pos);
872:

Line 874: ece_extract_utils_pub.Find_pos(l_line_tbl,

870: nShip_To_Site_pos);
871: ec_debug.pl(3, 'nShip_To_Site_pos: ',nShip_To_Site_pos);
872:
873: xProgress := 'MVSTOB-20-1554';
874: ece_extract_utils_pub.Find_pos(l_line_tbl,
875: 'VENDOR_SITE_ID',
876: nVendor_Site_pos);
877: ec_debug.pl(3, 'nVendor_To_Site_pos: ',nVendor_Site_pos);
878:

Line 880: ece_extract_utils_pub.Find_pos(l_line_tbl,

876: nVendor_Site_pos);
877: ec_debug.pl(3, 'nVendor_To_Site_pos: ',nVendor_Site_pos);
878:
879: xProgress := 'MVSTOB-20-1555';
880: ece_extract_utils_pub.Find_pos(l_line_tbl,
881: 'MOVEMENT_ID',
882: nLine_key_pos);
883: ec_debug.pl(3, 'nLine_key_pos: ',nLine_key_pos);
884:

Line 889: ece_extract_utils_pub.Find_pos(l_line_tbl,

885: n_movement_id := l_line_tbl(nLine_key_pos).value;
886: ec_debug.pl(3, 'n_movement_id: ',n_movement_id);
887:
888: xProgress := 'MVSTOB-20-1555';
889: ece_extract_utils_pub.Find_pos(l_line_tbl,
890: 'TRANSACTION_HEADER_ID',
891: nLine_head_pos);
892: ec_debug.pl(3, 'nLine_head_pos: ',nLine_head_pos);
893:

Line 898: ece_extract_utils_pub.Find_pos(l_line_tbl,

894: l_line_tbl(nLine_head_pos).value := l_header_fkey;
895: ec_debug.pl(3, 'l_line_tbl(nLine_head_pos).value: ',l_line_tbl(nLine_head_pos).value);
896:
897: xProgress := 'MVSTOB-20-1560';
898: ece_extract_utils_pub.Find_pos(l_line_tbl,
899: 'EDI_TRANSACTION_REFERENCE',
900: nEdi_TransRef_pos);
901: ec_debug.pl(3, 'nEdi_TransRef_pos: ',nEdi_TransRef_pos);
902:

Line 937: ece_Extract_Utils_PUB.insert_into_interface_tbl(iRun_id,

933: END;
934: ec_debug.pl(3, 'l_line_fkey: ',l_line_fkey);
935:
936: xProgress := 'MVSTOB-20-1600';
937: ece_Extract_Utils_PUB.insert_into_interface_tbl(iRun_id,
938: cTransaction_Type,
939: cCommunication_Method,
940: cLine_Interface,
941: l_line_tbl,

Line 1011: ece_extract_utils_pub.Find_pos(l_location_tbl,

1007: p_key_tbl => l_key_tbl,
1008: p_tbl => l_location_tbl);
1009:
1010:
1011: ece_extract_utils_pub.Find_pos(l_location_tbl,
1012: 'TRANSACTION_HEADER_ID',
1013: nLoc_head_pos);
1014: ec_debug.pl(3, 'nLoc_head_pos: ',nLoc_head_pos);
1015:

Line 1020: ece_extract_utils_pub.Find_pos(l_location_tbl,

1016: l_location_tbl(nLoc_head_pos).value := l_header_fkey;
1017: ec_debug.pl(3, 'l_location_tbl(nLoc_head_pos).value: ',l_location_tbl(nLoc_head_pos).value);
1018:
1019: xProgress := 'MVSTOB-20-1555';
1020: ece_extract_utils_pub.Find_pos(l_location_tbl,
1021: 'TRANSACTION_LINE_ID',
1022: nLoc_line_pos);
1023: ec_debug.pl(3, 'nLoc_line_pos: ',nLoc_line_pos);
1024:

Line 1046: ece_Extract_Utils_PUB.insert_into_interface_tbl(iRun_id,

1042: END;
1043: ec_debug.pl(3, 'l_location_fkey: ',l_location_fkey);
1044:
1045: xProgress := 'MVSTOB-20-1690';
1046: ece_Extract_Utils_PUB.insert_into_interface_tbl(iRun_id,
1047: cTransaction_Type,
1048: cCommunication_Method,
1049: cLine_Interface,
1050: l_location_tbl,