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

Line 777: -- The ece_extract_utils_pub.select_clause uses the EDI data dictionary for the build.

773: -- ***************************************************************************
774: --
775: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic
776: -- SQL call
777: -- The ece_extract_utils_pub.select_clause uses the EDI data dictionary for the build.
778: --
779: -- **************************************************************************
780:
781: xProgress := 'SPSOB-10-1040';

Line 782: ece_extract_utils_pub.select_clause ( cTransaction_Type,

778: --
779: -- **************************************************************************
780:
781: xProgress := 'SPSOB-10-1040';
782: ece_extract_utils_pub.select_clause ( cTransaction_Type,
783: cCommunication_Method,
784: cHeader_Interface,
785: l_header_tbl,
786: cHeader_select,

Line 791: ece_extract_utils_pub.select_clause ( cTransaction_Type,

787: cHeader_from,
788: cHeader_where );
789:
790: xProgress := 'SPSOB-10-1050';
791: ece_extract_utils_pub.select_clause ( cTransaction_Type,
792: cCommunication_Method,
793: cItem_Interface,
794: l_item_tbl,
795: cItem_select,

Line 998: ece_extract_utils_PUB.G_MaxColWidth );

994: LOOP
995: dbms_sql.define_column ( Header_sel_c,
996: k,
997: cHeader_select,
998: ece_extract_utils_PUB.G_MaxColWidth );
999: END LOOP;
1000:
1001:
1002: xProgress := 'SPSOB-10-1180';

Line 1008: ece_extract_utils_PUB.G_MaxColWidth );

1004: LOOP
1005: dbms_sql.define_column ( Item_sel_c,
1006: k,
1007: cItem_select,
1008: ece_extract_utils_PUB.G_MaxColWidth );
1009: END LOOP;
1010:
1011: -- **************************************************************
1012: -- *** The following is custom tailored for this transaction

Line 1024: n_trx_date_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,

1020: --
1021: -- ***************************************************
1022:
1023: xProgress := 'SPSOB-10-1190';
1024: n_trx_date_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1025: ece_extract_utils_pub.G_Transaction_date );
1026: ec_debug.pl ( 3, 'n_trx_date_pos: ',n_trx_date_pos );
1027:
1028: xProgress := 'SPSOB-10-1200';

Line 1025: ece_extract_utils_pub.G_Transaction_date );

1021: -- ***************************************************
1022:
1023: xProgress := 'SPSOB-10-1190';
1024: n_trx_date_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1025: ece_extract_utils_pub.G_Transaction_date );
1026: ec_debug.pl ( 3, 'n_trx_date_pos: ',n_trx_date_pos );
1027:
1028: xProgress := 'SPSOB-10-1200';
1029: n_vendor_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,

Line 1029: n_vendor_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,

1025: ece_extract_utils_pub.G_Transaction_date );
1026: ec_debug.pl ( 3, 'n_trx_date_pos: ',n_trx_date_pos );
1027:
1028: xProgress := 'SPSOB-10-1200';
1029: n_vendor_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1030: 'VENDOR_ID' );
1031: ec_debug.pl ( 3, 'n_vendor_id_pos: ',n_vendor_id_pos );
1032:
1033: xProgress := 'SPSOB-10-1210';

Line 1034: n_vendor_site_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,

1030: 'VENDOR_ID' );
1031: ec_debug.pl ( 3, 'n_vendor_id_pos: ',n_vendor_id_pos );
1032:
1033: xProgress := 'SPSOB-10-1210';
1034: n_vendor_site_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1035: 'VENDOR_SITE_ID' );
1036: ec_debug.pl ( 3, 'n_vendor_site_id_pos: ',n_vendor_site_id_pos );
1037:
1038: xProgress := 'SPSOB-10-1220';

Line 1039: n_organization_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,

1035: 'VENDOR_SITE_ID' );
1036: ec_debug.pl ( 3, 'n_vendor_site_id_pos: ',n_vendor_site_id_pos );
1037:
1038: xProgress := 'SPSOB-10-1220';
1039: n_organization_id_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1040: 'ORGANIZATION_ID' );
1041: ec_debug.pl ( 3, 'n_organization_id_pos: ',n_organization_id_pos );
1042:
1043: xProgress := 'SPSOB-10-1230';

Line 1044: n_st_org_code_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,

1040: 'ORGANIZATION_ID' );
1041: ec_debug.pl ( 3, 'n_organization_id_pos: ',n_organization_id_pos );
1042:
1043: xProgress := 'SPSOB-10-1230';
1044: n_st_org_code_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1045: 'ST_ORG_CODE' );
1046: ec_debug.pl ( 3, 'n_st_org_code_pos: ',n_st_org_code_pos );
1047:
1048: xProgress := 'SPSOB-10-1240';

Line 1049: n_schedule_type_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,

1045: 'ST_ORG_CODE' );
1046: ec_debug.pl ( 3, 'n_st_org_code_pos: ',n_st_org_code_pos );
1047:
1048: xProgress := 'SPSOB-10-1240';
1049: n_schedule_type_pos := ece_extract_utils_pub.POS_OF ( l_header_tbl,
1050: 'SCHEDULE_TYPE' );
1051: ec_debug.pl ( 3, 'n_schedule_type_pos: ',n_schedule_type_pos );
1052:
1053: xProgress := 'SPSOB-10-1250';

Line 1054: n_st_name_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1050: 'SCHEDULE_TYPE' );
1051: ec_debug.pl ( 3, 'n_schedule_type_pos: ',n_schedule_type_pos );
1052:
1053: xProgress := 'SPSOB-10-1250';
1054: n_st_name_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1055: 'ST_NAME' );
1056: ec_debug.pl ( 3, 'n_st_name_pos: ',n_st_name_pos );
1057:
1058: ece_extract_utils_pub.Find_pos ( l_header_tbl,

Line 1058: ece_extract_utils_pub.Find_pos ( l_header_tbl,

1054: n_st_name_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1055: 'ST_NAME' );
1056: ec_debug.pl ( 3, 'n_st_name_pos: ',n_st_name_pos );
1057:
1058: ece_extract_utils_pub.Find_pos ( l_header_tbl,
1059: 'SCHEDULE_ID',
1060: n_schedule_id_pos );
1061: ec_debug.pl ( 3, 'n_schedule_id_pos: ',n_schedule_id_pos );
1062:

Line 1064: n_item_id_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1060: n_schedule_id_pos );
1061: ec_debug.pl ( 3, 'n_schedule_id_pos: ',n_schedule_id_pos );
1062:
1063: xProgress := 'SPSOB-10-1260';
1064: n_item_id_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1065: 'SCHEDULE_ITEM_ID' );
1066: ec_debug.pl ( 3, 'n_item_id_pos: ',n_item_id_pos );
1067:
1068: xProgress := 'SPSOB-10-1270';

Line 1069: n_enable_cum_flag_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1065: 'SCHEDULE_ITEM_ID' );
1066: ec_debug.pl ( 3, 'n_item_id_pos: ',n_item_id_pos );
1067:
1068: xProgress := 'SPSOB-10-1270';
1069: n_enable_cum_flag_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1070: 'ENABLE_CUM_FLAG' );
1071: ec_debug.pl ( 3, 'n_enable_cum_flag_pos: ',n_enable_cum_flag_pos );
1072:
1073: xProgress := 'SPSOB-10-1280';

Line 1074: n_cum_period_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1070: 'ENABLE_CUM_FLAG' );
1071: ec_debug.pl ( 3, 'n_enable_cum_flag_pos: ',n_enable_cum_flag_pos );
1072:
1073: xProgress := 'SPSOB-10-1280';
1074: n_cum_period_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1075: 'CUM_PERIOD_START_DATE' );
1076: ec_debug.pl ( 3, 'n_cum_period_pos: ',n_cum_period_pos );
1077:
1078: xProgress := 'SPSOB-10-1290';

Line 1079: n_item_st_org_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1075: 'CUM_PERIOD_START_DATE' );
1076: ec_debug.pl ( 3, 'n_cum_period_pos: ',n_cum_period_pos );
1077:
1078: xProgress := 'SPSOB-10-1290';
1079: n_item_st_org_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1080: 'ST_ORG_CODE' );
1081: ec_debug.pl ( 3, 'n_item_st_org_pos: ',n_item_st_org_pos );
1082:
1083: xProgress := 'SPSOB-10-1300';

Line 1084: n_st_add_1_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1080: 'ST_ORG_CODE' );
1081: ec_debug.pl ( 3, 'n_item_st_org_pos: ',n_item_st_org_pos );
1082:
1083: xProgress := 'SPSOB-10-1300';
1084: n_st_add_1_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1085: 'ST_ADDRESS_LINE1' );
1086: ec_debug.pl ( 3, 'n_st_add_1_pos: ',n_st_add_1_pos );
1087:
1088: xProgress := 'SPSOB-10-1310';

Line 1089: n_st_add_2_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1085: 'ST_ADDRESS_LINE1' );
1086: ec_debug.pl ( 3, 'n_st_add_1_pos: ',n_st_add_1_pos );
1087:
1088: xProgress := 'SPSOB-10-1310';
1089: n_st_add_2_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1090: 'ST_ADDRESS_LINE2' );
1091: ec_debug.pl ( 3, 'n_st_add_2_pos: ',n_st_add_2_pos );
1092:
1093: xProgress := 'SPSOB-10-1320';

Line 1094: n_st_add_3_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1090: 'ST_ADDRESS_LINE2' );
1091: ec_debug.pl ( 3, 'n_st_add_2_pos: ',n_st_add_2_pos );
1092:
1093: xProgress := 'SPSOB-10-1320';
1094: n_st_add_3_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1095: 'ST_ADDRESS_LINE3' );
1096: ec_debug.pl ( 3, 'n_st_add_3_pos: ',n_st_add_3_pos );
1097:
1098: xProgress := 'SPSOB-10-1330';

Line 1099: n_st_city_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1095: 'ST_ADDRESS_LINE3' );
1096: ec_debug.pl ( 3, 'n_st_add_3_pos: ',n_st_add_3_pos );
1097:
1098: xProgress := 'SPSOB-10-1330';
1099: n_st_city_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1100: 'ST_CITY' );
1101: ec_debug.pl ( 3, 'n_st_city_pos: ',n_st_city_pos );
1102:
1103: xProgress := 'SPSOB-10-1340';

Line 1104: n_st_county_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1100: 'ST_CITY' );
1101: ec_debug.pl ( 3, 'n_st_city_pos: ',n_st_city_pos );
1102:
1103: xProgress := 'SPSOB-10-1340';
1104: n_st_county_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1105: 'ST_COUNTY' );
1106: ec_debug.pl ( 3, 'n_st_county_pos: ',n_st_county_pos );
1107:
1108: xProgress := 'SPSOB-10-1350';

Line 1109: n_st_state_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1105: 'ST_COUNTY' );
1106: ec_debug.pl ( 3, 'n_st_county_pos: ',n_st_county_pos );
1107:
1108: xProgress := 'SPSOB-10-1350';
1109: n_st_state_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1110: 'ST_STATE' );
1111: ec_debug.pl ( 3, 'n_st_state_pos: ',n_st_state_pos );
1112:
1113: xProgress := 'SPSOB-10-1360';

Line 1114: n_st_country_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1110: 'ST_STATE' );
1111: ec_debug.pl ( 3, 'n_st_state_pos: ',n_st_state_pos );
1112:
1113: xProgress := 'SPSOB-10-1360';
1114: n_st_country_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1115: 'ST_COUNTRY' );
1116: ec_debug.pl ( 3, 'n_st_country_pos: ',n_st_country_pos );
1117:
1118: xProgress := 'SPSOB-10-1370';

Line 1119: n_st_postal_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,

1115: 'ST_COUNTRY' );
1116: ec_debug.pl ( 3, 'n_st_country_pos: ',n_st_country_pos );
1117:
1118: xProgress := 'SPSOB-10-1370';
1119: n_st_postal_pos := ece_extract_utils_pub.POS_OF ( l_item_tbl,
1120: 'ST_POSTAL_CODE' );
1121: ec_debug.pl ( 3, 'n_st_postal_pos: ',n_st_postal_pos );
1122:
1123: xProgress := 'SPSOB-10-1371';

Line 1245: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id => iRun_id,

1241: END;
1242:
1243:
1244: xProgress := 'SPSOB-10-1450';
1245: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id => iRun_id,
1246: cTransaction_Type => cTransaction_Type,
1247: cCommunication_Method => cCommunication_Method,
1248: cInterface_Table => cHeader_Interface,
1249: p_source_tbl => l_header_tbl,

Line 1552: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id => iRun_id,

1548: if ((exclude_zero_schedule_from_ff = 'N') OR
1549: (x_item_detail > 0)) Then --2944455
1550:
1551: xProgress := 'SPSOB-10-1560';
1552: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id => iRun_id,
1553: cTransaction_Type => cTransaction_Type,
1554: cCommunication_Method => cCommunication_Method,
1555: cInterface_Table => cItem_Interface,
1556: p_source_tbl => l_item_tbl,