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.GML_GPOAO dependencies on ECE_EXTRACT_UTILS_PUB

Line 594: ece_extract_utils_pub.select_clause ( p_TransactionType,

590: /* the SQL call. */
591: /* */
592:
593: xProgress := 'GPOAOB-10-1210';
594: ece_extract_utils_pub.select_clause ( p_TransactionType,
595: p_CommunicationMethod,
596: p_ORD_Interface,
597: v_ORD_Table,
598: v_ORD_Select,

Line 603: ece_extract_utils_pub.select_clause ( p_TransactionType,

599: v_ORD_From,
600: v_ORD_Where );
601:
602: xProgress := 'GPOAOB-10-1220';
603: ece_extract_utils_pub.select_clause ( p_TransactionType,
604: p_CommunicationMethod,
605: p_OAC_Interface,
606: v_OAC_Table,
607: v_OAC_Select,

Line 612: ece_extract_utils_pub.select_clause ( p_TransactionType,

608: v_OAC_From,
609: v_OAC_Where );
610:
611: xProgress := 'GPOAOB-10-1230';
612: ece_extract_utils_pub.select_clause ( p_TransactionType,
613: p_CommunicationMethod,
614: p_OTX_Interface,
615: v_OTX_Table,
616: v_OTX_Select,

Line 621: ece_extract_utils_pub.select_clause ( p_TransactionType,

617: v_OTX_From,
618: v_OTX_Where );
619:
620: xProgress := 'GPOAOB-10-1240';
621: ece_extract_utils_pub.select_clause ( p_TransactionType,
622: p_CommunicationMethod,
623: p_DTL_Interface,
624: v_DTL_Table,
625: v_DTL_Select,

Line 630: ece_extract_utils_pub.select_clause ( p_TransactionType,

626: v_DTL_From,
627: v_DTL_Where );
628:
629: xProgress := 'GPOAOB-10-1250';
630: ece_extract_utils_pub.select_clause ( p_TransactionType,
631: p_CommunicationMethod,
632: p_DAC_Interface,
633: v_DAC_Table,
634: v_DAC_Select,

Line 639: ece_extract_utils_pub.select_clause ( p_TransactionType,

635: v_DAC_From,
636: v_DAC_Where );
637:
638: xProgress := 'GPOAOB-10-1260';
639: ece_extract_utils_pub.select_clause ( p_TransactionType,
640: p_CommunicationMethod,
641: p_DTX_Interface,
642: v_DTX_Table,
643: v_DTX_Select,

Line 648: ece_extract_utils_pub.select_clause ( p_TransactionType,

644: v_DTX_From,
645: v_DTX_Where );
646:
647: xProgress := 'GPOAOB-10-1270';
648: ece_extract_utils_pub.select_clause ( p_TransactionType,
649: p_CommunicationMethod,
650: p_ALL_Interface,
651: v_ALL_Table,
652: v_ALL_Select,

Line 893: ece_extract_utils_pub.G_MaxColWidth );

889: xProgress := 'GPOAOB-10-1605';
890: dbms_sql.define_column ( v_ORD_Cursor,
891: v_LoopCount,
892: v_ORD_Select,
893: ece_extract_utils_pub.G_MaxColWidth );
894: END LOOP;
895:
896: xProgress := 'GPOAOB-10-1610';
897: FOR v_LoopCount IN 1..v_OAC_Count

Line 903: ece_extract_utils_pub.G_MaxColWidth );

899: xProgress := 'GPOAOB-10-1615';
900: dbms_sql.define_column ( v_OAC_Cursor,
901: v_LoopCount,
902: v_OAC_Select,
903: ece_extract_utils_pub.G_MaxColWidth );
904: END LOOP;
905:
906: xProgress := 'GPOAOB-10-1620';
907: FOR v_LoopCount IN 1..v_OTX_Count

Line 913: ece_extract_utils_pub.G_MaxColWidth );

909: xProgress := 'GPOAOB-10-1625';
910: dbms_sql.define_column ( v_OTX_Cursor,
911: v_LoopCount,
912: v_OTX_Select,
913: ece_extract_utils_pub.G_MaxColWidth );
914: END LOOP;
915:
916: xProgress := 'GPOAOB-10-1630';
917: FOR v_LoopCount IN 1..v_DTL_Count

Line 923: ece_extract_utils_pub.G_MaxColWidth );

919: xProgress := 'GPOAOB-10-1635';
920: dbms_sql.define_column ( v_DTL_Cursor,
921: v_LoopCount,
922: v_DTL_Select,
923: ece_extract_utils_pub.G_MaxColWidth );
924: END LOOP;
925:
926: xProgress := 'GPOAOB-10-1640';
927: FOR v_LoopCount IN 1..v_DAC_Count

Line 933: ece_extract_utils_pub.G_MaxColWidth );

929: xProgress := 'GPOAOB-10-1645';
930: dbms_sql.define_column ( v_DAC_Cursor,
931: v_LoopCount,
932: v_DAC_Select,
933: ece_extract_utils_pub.G_MaxColWidth );
934: END LOOP;
935:
936: xProgress := 'GPOAOB-10-1650';
937: FOR v_LoopCount IN 1..v_DTX_Count

Line 943: ece_extract_utils_pub.G_MaxColWidth );

939: xProgress := 'GPOAOB-10-1655';
940: dbms_sql.define_column ( v_DTX_Cursor,
941: v_LoopCount,
942: v_DTX_Select,
943: ece_extract_utils_pub.G_MaxColWidth );
944: END LOOP;
945:
946: xProgress := 'GPOAOB-10-1660';
947: FOR v_LoopCount IN 1..v_ALL_Count

Line 953: ece_extract_utils_pub.G_MaxColWidth );

949: xProgress := 'GPOAOB-10-1665';
950: dbms_sql.define_column ( v_ALL_Cursor,
951: v_LoopCount,
952: v_ALL_Select,
953: ece_extract_utils_pub.G_MaxColWidth );
954: END LOOP;
955:
956: /* */
957: /* Bind the variables in the Order level SELECT clause. */

Line 1033: ece_extract_utils_pub.find_pos ( v_ORD_Table,

1029: /* the SELECT clauses of the other levels. */
1030: /* */
1031:
1032: xProgress := 'GPOAOB-10-1750';
1033: ece_extract_utils_pub.find_pos ( v_ORD_Table,
1034: 'ORDER_ID',
1035: v_Order_Id_Position );
1036:
1037: /*

Line 1071: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1067: INTO v_ORD_Key
1068: FROM sys.dual;
1069:
1070: xProgress := 'GPOAOB-10-1820';
1071: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1072: p_TransactionType,
1073: p_CommunicationMethod,
1074: p_ORD_Interface,
1075: v_ORD_Table,

Line 1141: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1137:
1138: v_OAC_Key := v_ORD_Key;
1139:
1140: xProgress := 'GPOAOB-10-1890';
1141: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1142: p_TransactionType,
1143: p_CommunicationMethod,
1144: p_OAC_Interface,
1145: v_OAC_Table,

Line 1213: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1209:
1210: v_OTX_Key := v_ORD_Key;
1211:
1212: xProgress := 'GPOAOB-10-1950';
1213: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1214: p_TransactionType,
1215: p_CommunicationMethod,
1216: p_OTX_Interface,
1217: v_OTX_Table,

Line 1270: ece_extract_utils_pub.find_pos ( v_DTL_Table,

1266: /* the SELECT clauses of the other levels. */
1267: /* */
1268:
1269: xProgress := 'GPOAOB-10-2020';
1270: ece_extract_utils_pub.find_pos ( v_DTL_Table,
1271: 'Line_ID',
1272: v_Line_Id_Position );
1273:
1274: /*

Line 1309: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1305: FROM sys.dual;
1306: ec_debug.pl( 3, 'V_DTL_Key:', v_DTL_Key);
1307:
1308: xProgress := 'GPOAOB-10-2080';
1309: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1310: p_TransactionType,
1311: p_CommunicationMethod,
1312: p_DTL_Interface,
1313: v_DTL_Table,

Line 1377: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1373:
1374: v_DAC_Key := v_DTL_Key;
1375:
1376: xProgress := 'GPOAOB-10-2140';
1377: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1378: p_TransactionType,
1379: p_CommunicationMethod,
1380: p_DAC_Interface,
1381: v_DAC_Table,

Line 1448: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1444:
1445: v_DTX_Key := v_DTL_Key;
1446:
1447: xProgress := 'GPOAOB-10-2220';
1448: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1449: p_TransactionType,
1450: p_CommunicationMethod,
1451: p_DTX_Interface,
1452: v_DTX_Table,

Line 1517: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1513:
1514: v_ALL_Key := v_DTL_Key;
1515:
1516: xProgress := 'GPOAOB-10-2220';
1517: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1518: p_TransactionType,
1519: p_CommunicationMethod,
1520: p_ALL_Interface,
1521: v_ALL_Table,

Line 2349: ece_extract_utils_pub.G_MaxColWidth );

2345: xProgress := 'GPOAOB-40-1510';
2346: dbms_sql.define_column ( v_ORD_Select_Cursor,
2347: v_LoopCount,
2348: v_ORD_Select,
2349: ece_extract_utils_pub.G_MaxColWidth );
2350: END LOOP;
2351:
2352: /* */
2353: /* Define the ROWIDs for the DELETE statements. */

Line 2381: ece_extract_utils_pub.G_MaxColWidth );

2377: xProgress := 'GPOAOB-40-1610';
2378: dbms_sql.define_column ( v_OAC_Select_Cursor,
2379: v_LoopCount,
2380: v_OAC_Select,
2381: ece_extract_utils_pub.G_MaxColWidth );
2382: END LOOP;
2383:
2384: /* */
2385: /* Define the ROWIDs for the DELETE statements. */

Line 2415: ece_extract_utils_pub.G_MaxColWidth );

2411: xProgress := 'GPOAOB-40-1710';
2412: dbms_sql.define_column ( v_OTX_Select_Cursor,
2413: v_LoopCount,
2414: v_OTX_Select,
2415: ece_extract_utils_pub.G_MaxColWidth );
2416: END LOOP;
2417:
2418: /* */
2419: /* Define the ROWIDs for the DELETE statements. */

Line 2448: ece_extract_utils_pub.G_MaxColWidth );

2444: xProgress := 'GPOAOB-40-1810';
2445: dbms_sql.define_column ( v_DTL_Select_Cursor,
2446: v_LoopCount,
2447: v_DTL_Select,
2448: ece_extract_utils_pub.G_MaxColWidth );
2449: END LOOP;
2450:
2451: /* */
2452: /* Define the ROWIDs for the DELETE statements. */

Line 2481: ece_extract_utils_pub.G_MaxColWidth );

2477: xProgress := 'GPOAOB-40-1910';
2478: dbms_sql.define_column ( v_DAC_Select_Cursor,
2479: v_LoopCount,
2480: v_DAC_Select,
2481: ece_extract_utils_pub.G_MaxColWidth );
2482: END LOOP;
2483:
2484: /* */
2485: /* Define the ROWIDs for the DELETE statements. */

Line 2514: ece_extract_utils_pub.G_MaxColWidth );

2510: xProgress := 'GPOAOB-40-2010';
2511: dbms_sql.define_column ( v_DTX_Select_Cursor,
2512: v_LoopCount,
2513: v_DTX_Select,
2514: ece_extract_utils_pub.G_MaxColWidth );
2515: END LOOP;
2516:
2517: /* */
2518: /* Define the ROWIDs for the DELETE statements. */

Line 2547: ece_extract_utils_pub.G_MaxColWidth );

2543: xProgress := 'GPOAOB-40-2110';
2544: dbms_sql.define_column ( v_ALL_Select_Cursor,
2545: v_LoopCount,
2546: v_ALL_Select,
2547: ece_extract_utils_pub.G_MaxColWidth );
2548: END LOOP;
2549:
2550: /* */
2551: /* Define the ROWIDs for the DELETE statements. */