APPS.ECE_ADVO_ADVICE_PKG dependencies on ECE_ADVO_HEADERS

Line 37: p_header_interface VARCHAR2(120) := 'ECE_ADVO_HEADERS_INTERFACE';

33: p_Date_From DATE := TO_DATE(cDate_From,'YYYY/MM/DD HH24:MI:SS');
34: p_Date_To DATE := TO_DATE(cDate_To,'YYYY/MM/DD HH24:MI:SS') + 1;
35: p_output_width INTEGER := 4000;
36: p_run_id NUMBER;
37: p_header_interface VARCHAR2(120) := 'ECE_ADVO_HEADERS_INTERFACE';
38: p_line_interface VARCHAR2(120) := 'ECE_ADVO_DETAILS_INTERFACE';
39: p_transaction_date DATE := SYSDATE;
40: cEnabled VARCHAR2(1) := 'Y';
41: ece_transaction_disabled EXCEPTION;

Line 505: 'ece_advo_headers_v.tp_group_code = ' ||

501: IF p_TP_Group IS NOT NULL
502: THEN
503: cHeader_where := cHeader_where ||
504: ' AND ' ||
505: 'ece_advo_headers_v.tp_group_code = ' ||
506: ':l_TP_Group';
507: END IF;
508:
509: xProgress := 'ADVOB-10-1070';

Line 514: 'ece_advo_headers_v.tp_location_code_ext = ' ||

510: IF p_TP IS NOT NULL
511: THEN
512: cHeader_where := cHeader_where ||
513: ' AND ' ||
514: 'ece_advo_headers_v.tp_location_code_ext = ' ||
515: ':l_TP';
516: END IF;
517:
518: xProgress := 'ADVOB-10-1080';

Line 523: 'ece_advo_headers_v.related_document_id = ' ||

519: IF p_Response_to_doc IS NOT NULL
520: THEN
521: cHeader_where := cHeader_where ||
522: ' AND ' ||
523: 'ece_advo_headers_v.related_document_id = ' ||
524: ':l_Response_to_doc';
525: END IF;
526:
527: xProgress := 'ADVOB-10-1090';

Line 532: 'ece_advo_headers_v.transaction_date >= ' ||

528: IF p_Date_From IS NOT NULL
529: THEN
530: cHeader_where := cHeader_where ||
531: ' AND ' ||
532: 'ece_advo_headers_v.transaction_date >= ' ||
533: ':l_Date_From';
534: END IF;
535:
536: xProgress := 'ADVOB-10-1100';

Line 541: 'ece_advo_headers_v.transaction_date <= ' ||

537: IF p_Date_To IS NOT NULL
538: THEN
539: cHeader_where := cHeader_where ||
540: ' AND ' ||
541: 'ece_advo_headers_v.transaction_date <= ' ||
542: ':l_Date_To';
543: END IF;
544:
545: xProgress := 'ADVOB-10-1110';

Line 550: 'ece_advo_headers_v.external_reference1 = ' ||

546: IF p_ext_ref1 IS NOT NULL
547: THEN
548: cHeader_where := cHeader_where ||
549: ' AND ' ||
550: 'ece_advo_headers_v.external_reference1 = ' ||
551: ':l_ext_ref1';
552:
553: END IF;
554:

Line 560: 'ece_advo_headers_v.external_reference2 = ' ||

556: IF p_ext_ref2 IS NOT NULL
557: THEN
558: cHeader_where := cHeader_where ||
559: ' AND ' ||
560: 'ece_advo_headers_v.external_reference2 = ' ||
561: ':l_ext_ref2';
562:
563: END IF;
564:

Line 570: 'ece_advo_headers_v.external_reference3 = ' ||

566: IF p_ext_ref3 IS NOT NULL
567: THEN
568: cHeader_where := cHeader_where ||
569: ' AND ' ||
570: 'ece_advo_headers_v.external_reference3 = ' ||
571: ':l_ext_ref3';
572:
573: END IF;
574:

Line 580: 'ece_advo_headers_v.external_reference4 = ' ||

576: IF p_ext_ref4 IS NOT NULL
577: THEN
578: cHeader_where := cHeader_where ||
579: ' AND ' ||
580: 'ece_advo_headers_v.external_reference4 = ' ||
581: ':l_ext_ref4';
582:
583: END IF;
584:

Line 590: 'ece_advo_headers_v.external_reference5 = ' ||

586: IF p_ext_ref5 IS NOT NULL
587: THEN
588: cHeader_where := cHeader_where ||
589: ' AND ' ||
590: 'ece_advo_headers_v.external_reference5 = ' ||
591: ':l_ext_ref5';
592:
593: END IF;
594:

Line 600: 'ece_advo_headers_v.external_reference6 = ' ||

596: IF p_ext_ref6 IS NOT NULL
597: THEN
598: cHeader_where := cHeader_where ||
599: ' AND ' ||
600: 'ece_advo_headers_v.external_reference6 = ' ||
601: ':l_ext_ref6';
602:
603: END IF;
604:

Line 864: ** Update ECE_ADVO_HEADERS to archive the current Advice header.

860: ec_debug.pl ( 3, 'l_header_tbl(n_advice_header_id_pos).value: ',l_header_tbl(n_advice_header_id_pos).value );
861:
862: /*
863: **
864: ** Update ECE_ADVO_HEADERS to archive the current Advice header.
865: **
866: */
867:
868: UPDATE ece_advo_headers

Line 868: UPDATE ece_advo_headers

864: ** Update ECE_ADVO_HEADERS to archive the current Advice header.
865: **
866: */
867:
868: UPDATE ece_advo_headers
869: SET edi_processed_flag = 'Y',
870: edi_process_date = SYSDATE
871: WHERE advice_header_id = l_header_tbl(n_advice_header_id_pos).value;
872:

Line 883: 'ECE_ADVO_HEADERS' );

879: xProgress,
880: 'INFO',
881: 'EDI_PROCESSED_FLAG',
882: 'TABLE_NAME',
883: 'ECE_ADVO_HEADERS' );
884: END IF;
885:
886: /*
887: **

Line 920: SELECT ece_advo_headers_interface_s.nextval

916: */
917:
918: xProgress := 'ADVOB-10-1350';
919: BEGIN
920: SELECT ece_advo_headers_interface_s.nextval
921: INTO l_header_fkey
922: FROM sys.dual;
923: EXCEPTION
924: WHEN NO_DATA_FOUND THEN

Line 931: 'ECE_ADVO_HEADERS_INTERFACE_S' );

927: 'ECE_GET_NEXT_SEQ_FAILED',
928: 'PROGRESS_LEVEL',
929: xProgress,
930: 'SEQ',
931: 'ECE_ADVO_HEADERS_INTERFACE_S' );
932: END;
933:
934: ec_debug.pl ( 3, 'l_header_fkey: ',l_header_fkey );
935: