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

Line 614: ece_extract_utils_pub.select_clause ( p_TransactionType,

610: /* the SQL call. */
611: /* */
612:
613: xProgress := 'GASNOB-10-1220';
614: ece_extract_utils_pub.select_clause ( p_TransactionType,
615: p_CommunicationMethod,
616: p_SHP_Interface,
617: v_SHP_Table,
618: v_SHP_Select,

Line 623: ece_extract_utils_pub.select_clause ( p_TransactionType,

619: v_SHP_From,
620: v_SHP_Where );
621:
622: xProgress := 'GASNOB-10-1230';
623: ece_extract_utils_pub.select_clause ( p_TransactionType,
624: p_CommunicationMethod,
625: p_STX_Interface,
626: v_STX_Table,
627: v_STX_Select,

Line 632: ece_extract_utils_pub.select_clause ( p_TransactionType,

628: v_STX_From,
629: v_STX_Where );
630:
631: xProgress := 'GASNOB-10-1240';
632: ece_extract_utils_pub.select_clause ( p_TransactionType,
633: p_CommunicationMethod,
634: p_ORD_Interface,
635: v_ORD_Table,
636: v_ORD_Select,

Line 641: ece_extract_utils_pub.select_clause ( p_TransactionType,

637: v_ORD_From,
638: v_ORD_Where );
639:
640: xProgress := 'GASNOB-10-1250';
641: ece_extract_utils_pub.select_clause ( p_TransactionType,
642: p_CommunicationMethod,
643: p_OAC_Interface,
644: v_OAC_Table,
645: v_OAC_Select,

Line 650: ece_extract_utils_pub.select_clause ( p_TransactionType,

646: v_OAC_From,
647: v_OAC_Where );
648:
649: xProgress := 'GASNOB-10-1260';
650: ece_extract_utils_pub.select_clause ( p_TransactionType,
651: p_CommunicationMethod,
652: p_OTX_Interface,
653: v_OTX_Table,
654: v_OTX_Select,

Line 659: ece_extract_utils_pub.select_clause ( p_TransactionType,

655: v_OTX_From,
656: v_OTX_Where );
657:
658: xProgress := 'GASNOB-10-1270';
659: ece_extract_utils_pub.select_clause ( p_TransactionType,
660: p_CommunicationMethod,
661: p_DTL_Interface,
662: v_DTL_Table,
663: v_DTL_Select,

Line 668: ece_extract_utils_pub.select_clause ( p_TransactionType,

664: v_DTL_From,
665: v_DTL_Where );
666:
667: xProgress := 'GASNOB-10-1280';
668: ece_extract_utils_pub.select_clause ( p_TransactionType,
669: p_CommunicationMethod,
670: p_DAC_Interface,
671: v_DAC_Table,
672: v_DAC_Select,

Line 677: ece_extract_utils_pub.select_clause ( p_TransactionType,

673: v_DAC_From,
674: v_DAC_Where );
675:
676: xProgress := 'GASNOB-10-1281';
677: ece_extract_utils_pub.select_clause ( p_TransactionType,
678: p_CommunicationMethod,
679: P_DTX_Interface,
680: v_DTX_Table,
681: v_DTX_Select,

Line 685: ece_extract_utils_pub.select_clause ( p_TransactionType,

681: v_DTX_Select,
682: v_DTX_From,
683: v_DTX_Where );
684: xProgress := 'GASNOB-10-1281';
685: ece_extract_utils_pub.select_clause ( p_TransactionType,
686: p_CommunicationMethod,
687: p_ALL_Interface,
688: v_ALL_Table,
689: v_ALL_Select,

Line 1055: ece_extract_utils_pub.G_MaxColWidth );

1051: xProgress := 'GASNOB-10-1470';
1052: dbms_sql.define_column ( v_SHP_Cursor,
1053: v_LoopCount,
1054: v_SHP_Select,
1055: ece_extract_utils_pub.G_MaxColWidth );
1056: END LOOP;
1057:
1058: xProgress := 'GASNOB-10-1480';
1059: FOR v_LoopCount IN 1..v_STX_Count

Line 1065: ece_extract_utils_pub.G_MaxColWidth );

1061: xProgress := 'GASNOB-10-1490';
1062: dbms_sql.define_column ( v_STX_Cursor,
1063: v_LoopCount,
1064: v_STX_Select,
1065: ece_extract_utils_pub.G_MaxColWidth );
1066: END LOOP;
1067:
1068: xProgress := 'GASNOB-10-1500';
1069: FOR v_LoopCount IN 1..v_ORD_Count

Line 1075: ece_extract_utils_pub.G_MaxColWidth );

1071: xProgress := 'GASNOB-10-1510';
1072: dbms_sql.define_column ( v_ORD_Cursor,
1073: v_LoopCount,
1074: v_ORD_Select,
1075: ece_extract_utils_pub.G_MaxColWidth );
1076: END LOOP;
1077:
1078: xProgress := 'GASNOB-10-1520';
1079: FOR v_LoopCount IN 1..v_OAC_Count

Line 1085: ece_extract_utils_pub.G_MaxColWidth );

1081: xProgress := 'GASNOB-10-1530';
1082: dbms_sql.define_column ( v_OAC_Cursor,
1083: v_LoopCount,
1084: v_OAC_Select,
1085: ece_extract_utils_pub.G_MaxColWidth );
1086: END LOOP;
1087:
1088: xProgress := 'GASNOB-10-1540';
1089: FOR v_LoopCount IN 1..v_OTX_Count

Line 1095: ece_extract_utils_pub.G_MaxColWidth );

1091: xProgress := 'GASNOB-10-1550';
1092: dbms_sql.define_column ( v_OTX_Cursor,
1093: v_LoopCount,
1094: v_OTX_Select,
1095: ece_extract_utils_pub.G_MaxColWidth );
1096: END LOOP;
1097:
1098: xProgress := 'GASNOB-10-1560';
1099: FOR v_LoopCount IN 1..v_DTL_Count

Line 1105: ece_extract_utils_pub.G_MaxColWidth );

1101: xProgress := 'GASNOB-10-1570';
1102: dbms_sql.define_column ( v_DTL_Cursor,
1103: v_LoopCount,
1104: v_DTL_Select,
1105: ece_extract_utils_pub.G_MaxColWidth );
1106: END LOOP;
1107:
1108: xProgress := 'GASNOB-10-1580';
1109: FOR v_LoopCount IN 1..v_DAC_Count

Line 1115: ece_extract_utils_pub.G_MaxColWidth );

1111: xProgress := 'GASNOB-10-1590';
1112: dbms_sql.define_column ( v_DAC_Cursor,
1113: v_LoopCount,
1114: v_DAC_Select,
1115: ece_extract_utils_pub.G_MaxColWidth );
1116: END LOOP;
1117:
1118: xProgress := 'GASNOB-10-1580';
1119: FOR v_LoopCount IN 1..v_DTX_Count

Line 1125: ece_extract_utils_pub.G_MaxColWidth );

1121: xProgress := 'GASNOB-10-1590';
1122: dbms_sql.define_column ( v_DTX_Cursor,
1123: v_LoopCount,
1124: v_DTX_Select,
1125: ece_extract_utils_pub.G_MaxColWidth );
1126: END LOOP;
1127:
1128: xProgress := 'GASNOB-10-1580';
1129: FOR v_LoopCount IN 1..v_ALL_Count

Line 1135: ece_extract_utils_pub.G_MaxColWidth );

1131: xProgress := 'GASNOB-10-1590';
1132: dbms_sql.define_column ( v_ALL_Cursor,
1133: v_LoopCount,
1134: v_ALL_Select,
1135: ece_extract_utils_pub.G_MaxColWidth );
1136: END LOOP;
1137:
1138: /* */
1139: /* */

Line 1216: ece_extract_utils_pub.find_pos ( v_SHP_Table,

1212: /* the SELECT clauses of the other levels. */
1213: /* */
1214:
1215: xProgress := 'GASNOB-10-1650';
1216: ece_extract_utils_pub.find_pos ( v_SHP_Table,
1217: 'BOL_ID',
1218: V_BOL_ID_Position );
1219: /* */
1220: /* Everything is stored in the PL/SQL table as VARCHAR2, so convert */

Line 1263: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1259: END;
1260: ec_debug.pl ( 3, 'v_SHP_Key: ', v_SHP_Key );
1261:
1262: xProgress := 'GASNOB-10-1820';
1263: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1264: p_TransactionType,
1265: p_CommunicationMethod,
1266: p_SHP_Interface,
1267: v_SHP_Table,

Line 1333: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1329: v_STX_Key := v_SHP_Key;
1330: ec_debug.pl ( 3, 'v_STX_Key: ', v_STX_Key );
1331:
1332: xProgress := 'GASNOB-10-1890';
1333: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1334: p_TransactionType,
1335: p_CommunicationMethod,
1336: p_STX_Interface,
1337: v_STX_Table,

Line 1390: ece_extract_utils_pub.find_pos ( v_ORD_Table,

1386: /* the SELECT clauses of the other levels. */
1387: /* */
1388:
1389: xProgress := 'GASNOB-10-1935';
1390: ece_extract_utils_pub.find_pos ( v_ORD_Table,
1391: 'Order_ID',
1392: V_Order_ID_Position );
1393:
1394: v_Order_ID := TO_NUMBER(v_ORD_Table(v_Order_ID_Position).value);

Line 1432: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1428: END;
1429: ec_debug.pl ( 3, 'v_ORD_Key: ', v_ORD_Key );
1430:
1431: xProgress := 'GASNOB-10-1960';
1432: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1433: p_TransactionType,
1434: p_CommunicationMethod,
1435: p_ORD_Interface,
1436: v_ORD_Table,

Line 1499: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1495: v_OAC_Key := v_ORD_Key;
1496: ec_debug.pl ( 3, 'v_OAC_Key: ', v_OAC_Key );
1497:
1498: xProgress := 'GASNOB-10-2040';
1499: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1500: p_TransactionType,
1501: p_CommunicationMethod,
1502: p_OAC_Interface,
1503: v_OAC_Table,

Line 1565: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1561: v_OTX_Key := v_ORD_Key;
1562: ec_debug.pl ( 3, 'v_OTX_Key: ', v_OTX_Key );
1563:
1564: xProgress := 'GASNOB-10-2120';
1565: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1566: p_TransactionType,
1567: p_CommunicationMethod,
1568: p_OTX_Interface,
1569: v_OTX_Table,

Line 1622: ece_extract_utils_pub.find_pos ( v_DTL_Table,

1618: v_DTL_Table(v_LoopCount).value );
1619: END LOOP;
1620:
1621: xProgress := 'GASNOB-10-2175';
1622: ece_extract_utils_pub.find_pos ( v_DTL_Table,
1623: 'Line_ID',
1624: V_Line_ID_Position );
1625:
1626: v_Line_ID := TO_NUMBER(v_DTL_Table(v_Line_ID_Position).value);

Line 1664: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1660: END;
1661: ec_debug.pl ( 3, 'v_DTL_Key: ', v_DTL_Key );
1662:
1663: xProgress := 'GASNOB-10-2200';
1664: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1665: p_TransactionType,
1666: p_CommunicationMethod,
1667: p_DTL_Interface,
1668: v_DTL_Table,

Line 1734: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1730: ec_debug.pl ( 3, 'v_DAC_Key: ', v_DAC_Key );
1731:
1732:
1733: xProgress := 'GASNOB-10-2280';
1734: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1735: p_TransactionType,
1736: p_CommunicationMethod,
1737: p_DAC_Interface,
1738: v_DAC_Table,

Line 1805: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1801: ec_debug.pl ( 3, 'v_DTX_Key: ', v_DTX_Key );
1802:
1803:
1804: xProgress := 'GASNOB-10-2360';
1805: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1806: p_TransactionType,
1807: p_CommunicationMethod,
1808: p_DTX_Interface,
1809: v_DTX_Table,

Line 1877: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,

1873: ec_debug.pl ( 3, 'v_ALL_Key: ', v_ALL_Key );
1874:
1875:
1876: xProgress := 'GASNOB-10-2440';
1877: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1878: p_TransactionType,
1879: p_CommunicationMethod,
1880: p_ALL_Interface,
1881: v_ALL_Table,

Line 3096: ece_extract_utils_pub.G_MaxColWidth );

3092: xProgress := 'GASNOB-40-1440';
3093: dbms_sql.define_column ( v_SHP_SelectCursor,
3094: v_LoopCount,
3095: v_SHP_Select,
3096: ece_extract_utils_pub.G_MaxColWidth );
3097: END LOOP;
3098:
3099: /* */
3100: /* Define the ROWIDs for the DELETE statements. */

Line 3129: ece_extract_utils_pub.G_MaxColWidth );

3125: xProgress := 'GASNOB-40-1500';
3126: dbms_sql.define_column ( v_STX_SelectCursor,
3127: v_LoopCount,
3128: v_STX_Select,
3129: ece_extract_utils_pub.G_MaxColWidth );
3130: END LOOP;
3131:
3132: /* */
3133: /* Define the ROWID for the DELETE statements. */

Line 3162: ece_extract_utils_pub.G_MaxColWidth );

3158: xProgress := 'GASNOB-40-1540';
3159: dbms_sql.define_column ( v_ORD_SelectCursor,
3160: v_LoopCount,
3161: v_ORD_Select,
3162: ece_extract_utils_pub.G_MaxColWidth );
3163: END LOOP;
3164:
3165: /* */
3166: /* Define the ROWIDs for the DELETE statements. */

Line 3194: ece_extract_utils_pub.G_MaxColWidth );

3190: xProgress := 'GASNOB-40-1580';
3191: dbms_sql.define_column ( v_OAC_SelectCursor,
3192: v_LoopCount,
3193: v_OAC_Select,
3194: ece_extract_utils_pub.G_MaxColWidth );
3195: END LOOP;
3196:
3197: /* */
3198: /* Define the ROWIDs for the DELETE statements. */

Line 3227: ece_extract_utils_pub.G_MaxColWidth );

3223: xPRogress := 'GASNOB-40-1620';
3224: dbms_sql.define_column ( v_OTX_SelectCursor,
3225: v_LoopCount,
3226: v_OTX_Select,
3227: ece_extract_utils_pub.G_MaxColWidth );
3228: END LOOP;
3229:
3230: /* */
3231: /* Define the ROWIDs for the DELETE statements. */

Line 3260: ece_extract_utils_pub.G_MaxColWidth );

3256: xProgress := 'GASNOB-40-1670';
3257: dbms_sql.define_column ( v_DTL_SelectCursor,
3258: v_LoopCount,
3259: v_DTL_Select,
3260: ece_extract_utils_pub.G_MaxColWidth );
3261: END LOOP;
3262:
3263: /* */
3264: /* Define the ROWIDs for the DELETE statements. */

Line 3293: ece_extract_utils_pub.G_MaxColWidth );

3289: xProgress := 'GASNOB-40-1720';
3290: dbms_sql.define_column ( v_DAC_SelectCursor,
3291: v_LoopCount,
3292: v_DAC_Select,
3293: ece_extract_utils_pub.G_MaxColWidth );
3294: END LOOP;
3295:
3296: /* */
3297: /* Define the ROWIDs for the DELETE statements. */

Line 3326: ece_extract_utils_pub.G_MaxColWidth );

3322: xProgress := 'GASNOB-40-1780';
3323: dbms_sql.define_column ( v_DTX_SelectCursor,
3324: v_LoopCount,
3325: v_DTX_Select,
3326: ece_extract_utils_pub.G_MaxColWidth );
3327: END LOOP;
3328:
3329: /* */
3330: /* Define the ROWIDs for the DELETE statements. */

Line 3359: ece_extract_utils_pub.G_MaxColWidth );

3355: xProgress := 'GASNOB-40-1811';
3356: dbms_sql.define_column ( v_ALL_SelectCursor,
3357: v_LoopCount,
3358: v_ALL_Select,
3359: ece_extract_utils_pub.G_MaxColWidth );
3360: END LOOP;
3361:
3362: /* */
3363: /* Define the ROWIDs for the DELETE statements. */