APPS.ECE_ADVO_ADVICE_PKG dependencies on ECE_EXTRACT_UTILS_PUB

Line 469: ece_extract_utils_pub.select_clause ( cTransaction_Type,

465: **
466: */
467:
468: xProgress := 'ADVOB-10-1040';
469: ece_extract_utils_pub.select_clause ( cTransaction_Type,
470: cCommunication_Method,
471: cHeader_Interface,
472: l_header_tbl,
473: cHeader_select,

Line 479: ece_extract_utils_pub.select_clause ( cTransaction_Type,

475: cHeader_where );
476:
477:
478: xProgress := 'ADVOB-10-1050';
479: ece_extract_utils_pub.select_clause ( cTransaction_Type,
480: cCommunication_Method,
481: cLine_Interface,
482: l_line_tbl,
483: cLine_select,

Line 700: ece_extract_utils_PUB.G_MaxColWidth );

696: LOOP
697: dbms_sql.define_column ( Header_sel_c,
698: k,
699: cHeader_select,
700: ece_extract_utils_PUB.G_MaxColWidth );
701: END LOOP;
702:
703: xProgress := 'ADVOB-10-1270';
704: FOR k IN 1..iLine_count

Line 709: ece_extract_utils_PUB.G_MaxColWidth );

705: LOOP
706: dbms_sql.define_column ( Line_sel_c,
707: k,
708: cLine_select,
709: ece_extract_utils_PUB.G_MaxColWidth );
710: END LOOP;
711:
712: /*
713: **

Line 720: ece_extract_utils_pub.Find_pos ( l_header_tbl,

716: **
717: */
718:
719: xProgress := 'ADVOB-10-1280';
720: ece_extract_utils_pub.Find_pos ( l_header_tbl,
721: ece_extract_utils_pub.G_Transaction_date,
722: n_trx_date_pos );
723: ec_debug.pl(3, 'n_trx_date_pos: ',n_trx_date_pos );
724:

Line 721: ece_extract_utils_pub.G_Transaction_date,

717: */
718:
719: xProgress := 'ADVOB-10-1280';
720: ece_extract_utils_pub.Find_pos ( l_header_tbl,
721: ece_extract_utils_pub.G_Transaction_date,
722: n_trx_date_pos );
723: ec_debug.pl(3, 'n_trx_date_pos: ',n_trx_date_pos );
724:
725: xProgress := 'ADVOB-10-1290';

Line 726: ece_extract_utils_pub.Find_pos ( l_header_tbl,

722: n_trx_date_pos );
723: ec_debug.pl(3, 'n_trx_date_pos: ',n_trx_date_pos );
724:
725: xProgress := 'ADVOB-10-1290';
726: ece_extract_utils_pub.Find_pos ( l_header_tbl,
727: 'ADVICE_HEADER_ID',
728: n_advice_header_id_pos );
729: ec_debug.pl(3, 'n_advice_header_id_pos: ',n_advice_header_id_pos );
730:

Line 937: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,

933:
934: ec_debug.pl ( 3, 'l_header_fkey: ',l_header_fkey );
935:
936: xProgress := 'ADVOB-10-1360';
937: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,
938: cTransaction_Type,
939: cCommunication_Method,
940: cHeader_Interface,
941: l_header_tbl,

Line 1045: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,

1041:
1042: ec_debug.pl ( 3, 'l_line_fkey: ',l_line_fkey );
1043:
1044: xProgress := 'ADVOB-10-1440';
1045: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,
1046: cTransaction_Type,
1047: cCommunication_Method,
1048: cLine_Interface,
1049: l_line_tbl,