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.PO_TAX_INTERFACE_PVT dependencies on PO_CONSTANTS_SV

Line 87: AND zxlgt.application_id = PO_CONSTANTS_SV.APPLICATION_ID

83: SELECT zxlgt.trx_line_id
84: FROM zx_transaction_lines_gt zxlgt
85: WHERE p_requisition_header_id=zxlgt.trx_id
86: AND p_requisition_header_id NOT IN (SELECT trx_id FROM zx_errors_gt zxegt)
87: AND zxlgt.application_id = PO_CONSTANTS_SV.APPLICATION_ID
88: AND zxlgt.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
89: AND zxlgt.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
90:
91:

Line 88: AND zxlgt.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

84: FROM zx_transaction_lines_gt zxlgt
85: WHERE p_requisition_header_id=zxlgt.trx_id
86: AND p_requisition_header_id NOT IN (SELECT trx_id FROM zx_errors_gt zxegt)
87: AND zxlgt.application_id = PO_CONSTANTS_SV.APPLICATION_ID
88: AND zxlgt.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
89: AND zxlgt.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
90:
91:
92: -----------------------------------------------------------------------------

Line 89: AND zxlgt.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;

85: WHERE p_requisition_header_id=zxlgt.trx_id
86: AND p_requisition_header_id NOT IN (SELECT trx_id FROM zx_errors_gt zxegt)
87: AND zxlgt.application_id = PO_CONSTANTS_SV.APPLICATION_ID
88: AND zxlgt.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
89: AND zxlgt.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
90:
91:
92: -----------------------------------------------------------------------------
93: --Start of Comments

Line 357: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

353: ,zxvegt.message_text
354: ,'VALIDATE'
355: ,ph.segment1
356: FROM zx_validation_errors_gt zxvegt, po_headers_all ph
357: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
358: AND zxvegt.trx_id = ph.po_header_id;
359:
360: d_progress := 150;
361: INSERT INTO po_session_gt(

Line 382: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

378: ,'VALIDATE'
379: ,ph.segment1
380: FROM zx_validation_errors_gt zxvegt, po_headers_all ph,
381: po_releases_all pr
382: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
383: AND zxvegt.trx_id = pr.po_release_id
384: AND pr.po_header_id = ph.po_header_id;
385:
386: BEGIN

Line 409: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);

405: -- Delete data from zx gt tables for which defaulting/redefaulting failed
406: DELETE FROM zx_trx_headers_gt
407: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
408: WHERE psgt.key = l_po_session_gt_key
409: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
410: d_progress := 170;
411: DELETE FROM zx_transaction_lines_gt
412: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
413: WHERE psgt.key = l_po_session_gt_key

Line 414: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);

410: d_progress := 170;
411: DELETE FROM zx_transaction_lines_gt
412: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
413: WHERE psgt.key = l_po_session_gt_key
414: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
415:
416: ELSIF (p_calling_program <> 'COPY_DOCUMENT') THEN
417: d_progress := 180;
418: -- This API cannot handle the presence of COPY_AND_CREATE line level

Line 541: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

537: ,zxegt.message_text
538: ,'CALCULATE_TAX'
539: ,ph.segment1
540: FROM zx_errors_gt zxegt, po_headers_all ph
541: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
542: AND zxegt.trx_id = ph.po_header_id;
543:
544: d_progress := 240;
545: INSERT INTO po_session_gt(

Line 565: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

561: ,zxegt.message_text
562: ,'CALCULATE_TAX'
563: ,ph.segment1
564: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
565: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
566: AND zxegt.trx_id = pr.po_release_id
567: AND pr.po_header_id = ph.po_header_id;
568:
569: BEGIN

Line 597: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

593: -- Delete data from zx gt tables for which defaulting/redefaulting failed
594: DELETE FROM zx_trx_headers_gt
595: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
596: WHERE psgt.key = l_po_session_gt_key
597: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
598: AND psgt.char3 = 'CALCULATE_TAX');
599: d_progress := 260;
600: DELETE FROM zx_trx_headers_gt
601: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

Line 603: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

599: d_progress := 260;
600: DELETE FROM zx_trx_headers_gt
601: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
602: WHERE psgt.key = l_po_session_gt_key
603: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
604: AND psgt.char3 = 'CALCULATE_TAX');
605: d_progress := 270;
606: DELETE FROM zx_transaction_lines_gt
607: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

Line 609: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

605: d_progress := 270;
606: DELETE FROM zx_transaction_lines_gt
607: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
608: WHERE psgt.key = l_po_session_gt_key
609: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
610: AND psgt.char3 = 'CALCULATE_TAX');
611: d_progress := 280;
612: DELETE FROM zx_transaction_lines_gt
613: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

Line 615: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

611: d_progress := 280;
612: DELETE FROM zx_transaction_lines_gt
613: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
614: WHERE psgt.key = l_po_session_gt_key
615: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
616: AND psgt.char3 = 'CALCULATE_TAX');
617:
618: END IF; -- IF (l_count <> 0)
619:

Line 649: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

645: -- tax_attribute_update_code = 'CREATE'
646: UPDATE zx_trx_headers_gt zxhgt
647: SET zxhgt.event_type_code =
648: DECODE(zxhgt.event_class_code,
649: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
650: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
651: FROM DUAL
652: WHERE EXISTS
653: (SELECT 'Y'

Line 660: PO_CONSTANTS_SV.PO_REDISTRIBUTED,

656: AND (pd.tax_attribute_update_code <> 'CREATE'
657: OR pd.tax_attribute_update_code IS NULL)
658: )
659: ),
660: PO_CONSTANTS_SV.PO_REDISTRIBUTED,
661: PO_CONSTANTS_SV.PO_DISTRIBUTED
662: ),
663: --Release
664: NVL2((SELECT 'EXISTING DISTRIBUTIONS'

Line 661: PO_CONSTANTS_SV.PO_DISTRIBUTED

657: OR pd.tax_attribute_update_code IS NULL)
658: )
659: ),
660: PO_CONSTANTS_SV.PO_REDISTRIBUTED,
661: PO_CONSTANTS_SV.PO_DISTRIBUTED
662: ),
663: --Release
664: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
665: FROM DUAL

Line 674: PO_CONSTANTS_SV.REL_REDISTRIBUTED,

670: AND (pd.tax_attribute_update_code <> 'CREATE'
671: OR pd.tax_attribute_update_code IS NULL)
672: )
673: ),
674: PO_CONSTANTS_SV.REL_REDISTRIBUTED,
675: PO_CONSTANTS_SV.REL_DISTRIBUTED
676: )
677: );
678:

Line 675: PO_CONSTANTS_SV.REL_DISTRIBUTED

671: OR pd.tax_attribute_update_code IS NULL)
672: )
673: ),
674: PO_CONSTANTS_SV.REL_REDISTRIBUTED,
675: PO_CONSTANTS_SV.REL_DISTRIBUTED
676: )
677: );
678:
679: d_progress := 330;

Line 733: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

729: ,zxegt.message_text
730: ,'DETERMINE_RECOVERY'
731: ,ph.segment1
732: FROM zx_errors_gt zxegt, po_headers_all ph
733: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
734: AND zxegt.trx_id = ph.po_header_id;
735:
736: d_progress := 360;
737: INSERT INTO po_session_gt(

Line 757: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

753: ,zxegt.message_text
754: ,'DETERMINE_RECOVERY'
755: ,ph.segment1
756: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
757: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
758: AND zxegt.trx_id = pr.po_release_id
759: AND pr.po_header_id = ph.po_header_id;
760:
761: d_progress := 370;

Line 787: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

783: d_progress := 380;
784: DELETE FROM zx_itm_distributions_gt
785: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
786: WHERE psgt.key = l_po_session_gt_key
787: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
788: AND psgt.char3 = 'DETERMINE_RECOVERY');
789: d_progress := 390;
790: DELETE FROM zx_itm_distributions_gt
791: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

Line 793: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

789: d_progress := 390;
790: DELETE FROM zx_itm_distributions_gt
791: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
792: WHERE psgt.key = l_po_session_gt_key
793: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
794: AND psgt.char3 = 'DETERMINE_RECOVERY');
795:
796: d_progress := 400;
797: -- Update the distributions that errored out and yet have a tauc of null

Line 826: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

822: (SELECT SUM(zxdist.rec_nrec_tax_amt)
823: FROM zx_rec_nrec_dist zxdist
824: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
825: AND zxdist.recoverable_flag = 'Y'
826: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
827: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
828: AND zxdist.event_class_code =
829: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
830: AND zxdist.trx_id = pd.po_header_id)

Line 827: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

823: FROM zx_rec_nrec_dist zxdist
824: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
825: AND zxdist.recoverable_flag = 'Y'
826: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
827: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
828: AND zxdist.event_class_code =
829: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
830: AND zxdist.trx_id = pd.po_header_id)
831: OR

Line 829: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

825: AND zxdist.recoverable_flag = 'Y'
826: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
827: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
828: AND zxdist.event_class_code =
829: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
830: AND zxdist.trx_id = pd.po_header_id)
831: OR
832: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
833: AND zxdist.event_class_code =

Line 832: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

828: AND zxdist.event_class_code =
829: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
830: AND zxdist.trx_id = pd.po_header_id)
831: OR
832: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
833: AND zxdist.event_class_code =
834: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
835: AND zxdist.trx_id = pd.po_release_id)))
836: ,pd.nonrecoverable_tax =

Line 834: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

830: AND zxdist.trx_id = pd.po_header_id)
831: OR
832: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
833: AND zxdist.event_class_code =
834: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
835: AND zxdist.trx_id = pd.po_release_id)))
836: ,pd.nonrecoverable_tax =
837: (SELECT SUM(zxdist.rec_nrec_tax_amt)
838: FROM zx_rec_nrec_dist zxdist

Line 841: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

837: (SELECT SUM(zxdist.rec_nrec_tax_amt)
838: FROM zx_rec_nrec_dist zxdist
839: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
840: AND zxdist.recoverable_flag = 'N'
841: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
842: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
843: AND zxdist.event_class_code =
844: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
845: AND zxdist.trx_id = pd.po_header_id)

Line 842: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

838: FROM zx_rec_nrec_dist zxdist
839: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
840: AND zxdist.recoverable_flag = 'N'
841: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
842: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
843: AND zxdist.event_class_code =
844: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
845: AND zxdist.trx_id = pd.po_header_id)
846: OR

Line 844: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

840: AND zxdist.recoverable_flag = 'N'
841: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
842: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
843: AND zxdist.event_class_code =
844: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
845: AND zxdist.trx_id = pd.po_header_id)
846: OR
847: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
848: AND zxdist.event_class_code =

Line 847: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

843: AND zxdist.event_class_code =
844: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
845: AND zxdist.trx_id = pd.po_header_id)
846: OR
847: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
848: AND zxdist.event_class_code =
849: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
850: AND zxdist.trx_id = pd.po_release_id))),
851: --Bug 10305728 start

Line 849: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

845: AND zxdist.trx_id = pd.po_header_id)
846: OR
847: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
848: AND zxdist.event_class_code =
849: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
850: AND zxdist.trx_id = pd.po_release_id))),
851: --Bug 10305728 start
852: last_update_date = sysdate,
853: last_updated_by = fnd_global.user_id,

Line 936: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

932: UPDATE po_line_locations_all pll
933: SET pll.taxable_flag =
934: DECODE((SELECT COUNT(1) FROM zx_lines zl
935: WHERE zl.trx_line_id = pll.line_location_id
936: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
937: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
938: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
939: AND zl.trx_id = pll.po_header_id)
940: OR

Line 937: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

933: SET pll.taxable_flag =
934: DECODE((SELECT COUNT(1) FROM zx_lines zl
935: WHERE zl.trx_line_id = pll.line_location_id
936: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
937: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
938: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
939: AND zl.trx_id = pll.po_header_id)
940: OR
941: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

Line 938: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

934: DECODE((SELECT COUNT(1) FROM zx_lines zl
935: WHERE zl.trx_line_id = pll.line_location_id
936: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
937: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
938: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
939: AND zl.trx_id = pll.po_header_id)
940: OR
941: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
942: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

Line 941: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

937: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
938: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
939: AND zl.trx_id = pll.po_header_id)
940: OR
941: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
942: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
943: AND zl.trx_id = pll.po_release_id))),
944: 0, 'N',
945: 'Y'

Line 942: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

938: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
939: AND zl.trx_id = pll.po_header_id)
940: OR
941: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
942: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
943: AND zl.trx_id = pll.po_release_id))),
944: 0, 'N',
945: 'Y'
946: )

Line 956: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, PO_CONSTANTS_SV.PO,

952: -- Pour all errors in po_session_gt into global tax error record
953: SELECT
954: psgt.char3 --error_level
955: ,decode(psgt.char1,--document_type_code
956: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, PO_CONSTANTS_SV.PO,
957: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE, PO_CONSTANTS_SV.RELEASE
958: )
959: ,psgt.index_num1 --document_id
960: ,psgt.char4 --document_num

Line 957: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE, PO_CONSTANTS_SV.RELEASE

953: SELECT
954: psgt.char3 --error_level
955: ,decode(psgt.char1,--document_type_code
956: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, PO_CONSTANTS_SV.PO,
957: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE, PO_CONSTANTS_SV.RELEASE
958: )
959: ,psgt.index_num1 --document_id
960: ,psgt.char4 --document_num
961: ,null --line_id

Line 1000: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, PO_CONSTANTS_SV.PO,

996:
997: SELECT
998: psgt.char3 --error_level
999: ,decode(psgt.char1,--document_type_code
1000: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, PO_CONSTANTS_SV.PO,
1001: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE, PO_CONSTANTS_SV.RELEASE
1002: )
1003: ,psgt.index_num1 --document_id
1004: ,psgt.char4 --document_num

Line 1001: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE, PO_CONSTANTS_SV.RELEASE

997: SELECT
998: psgt.char3 --error_level
999: ,decode(psgt.char1,--document_type_code
1000: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, PO_CONSTANTS_SV.PO,
1001: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE, PO_CONSTANTS_SV.RELEASE
1002: )
1003: ,psgt.index_num1 --document_id
1004: ,psgt.char4 --document_num
1005: ,null --line_id

Line 1400: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,

1396: -- Read validation errors from zx_validation_errors_gt into the global
1397: -- error record defined in the spec
1398: SELECT
1399: 'VALIDATE' --error_level,
1400: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,
1401: ,p_requisition_header_id --document_id,
1402: ,prh.segment1 --document_num,
1403: ,zxvegt.trx_line_id --line_id,
1404: ,prl.line_num --line_num,

Line 1511: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,

1507: -- Read validation errors from zx_errors_gt into the global
1508: -- error record defined in the spec
1509: SELECT
1510: 'CALCULATE_TAX' --error_level,
1511: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,
1512: ,p_requisition_header_id --document_id,
1513: ,prh.segment1 --document_num,
1514: ,zxegt.trx_line_id --line_id,
1515: ,prl.line_num --line_num,

Line 1571: SET event_type_code = PO_CONSTANTS_SV.REQ_DISTRIBUTED;

1567: IF (l_count <> 0) THEN
1568: d_progress := 230;
1569: -- Update event_type_code on zx headers as required by determine_recovery API
1570: UPDATE zx_trx_headers_gt
1571: SET event_type_code = PO_CONSTANTS_SV.REQ_DISTRIBUTED;
1572:
1573: d_progress := 240;
1574:
1575: -- Log table parameters

Line 1612: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,

1608: -- error record defined in the spec
1609: d_progress := 260;
1610: SELECT
1611: 'DETERMINE_RECOVERY' --error_level,
1612: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,
1613: ,p_requisition_header_id --document_id,
1614: ,prh.segment1 --document_num,
1615: ,zxegt.trx_line_id --line_id,
1616: ,prl.line_num --line_num,

Line 1656: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

1652: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1653: FROM zx_rec_nrec_dist_gt zxdist
1654: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1655: AND zxdist.recoverable_flag = 'Y'
1656: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1657: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1658: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1659: ,prd.nonrecoverable_tax =
1660: (SELECT SUM(zxdist.rec_nrec_tax_amt)

Line 1657: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

1653: FROM zx_rec_nrec_dist_gt zxdist
1654: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1655: AND zxdist.recoverable_flag = 'Y'
1656: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1657: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1658: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1659: ,prd.nonrecoverable_tax =
1660: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1661: FROM zx_rec_nrec_dist_gt zxdist

Line 1658: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)

1654: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1655: AND zxdist.recoverable_flag = 'Y'
1656: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1657: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1658: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1659: ,prd.nonrecoverable_tax =
1660: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1661: FROM zx_rec_nrec_dist_gt zxdist
1662: WHERE zxdist.trx_line_dist_id = prd.distribution_id

Line 1664: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

1660: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1661: FROM zx_rec_nrec_dist_gt zxdist
1662: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1663: AND zxdist.recoverable_flag = 'N'
1664: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1665: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1666: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1667: WHERE prd.distribution_id IN
1668: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

Line 1665: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

1661: FROM zx_rec_nrec_dist_gt zxdist
1662: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1663: AND zxdist.recoverable_flag = 'N'
1664: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1665: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1666: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1667: WHERE prd.distribution_id IN
1668: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1669:

Line 1666: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)

1662: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1663: AND zxdist.recoverable_flag = 'N'
1664: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1665: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1666: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1667: WHERE prd.distribution_id IN
1668: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1669:
1670: END IF; -- IF (l_count <> 0)

Line 1688: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;

1684:
1685: d_progress := 310;
1686: -- Call global_document_update API to delete all data for this requistion
1687: l_trx_rec.internal_organization_id := l_org_id;
1688: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;
1689: l_trx_rec.entity_code := PO_CONSTANTS_SV.REQ_ENTITY_CODE;
1690: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
1691: l_trx_rec.event_type_code := PO_CONSTANTS_SV.REQ_DELETED;
1692: l_trx_rec.trx_id := p_requisition_header_id;

Line 1689: l_trx_rec.entity_code := PO_CONSTANTS_SV.REQ_ENTITY_CODE;

1685: d_progress := 310;
1686: -- Call global_document_update API to delete all data for this requistion
1687: l_trx_rec.internal_organization_id := l_org_id;
1688: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;
1689: l_trx_rec.entity_code := PO_CONSTANTS_SV.REQ_ENTITY_CODE;
1690: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
1691: l_trx_rec.event_type_code := PO_CONSTANTS_SV.REQ_DELETED;
1692: l_trx_rec.trx_id := p_requisition_header_id;
1693: l_trx_rec.application_doc_status := null;

Line 1690: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;

1686: -- Call global_document_update API to delete all data for this requistion
1687: l_trx_rec.internal_organization_id := l_org_id;
1688: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;
1689: l_trx_rec.entity_code := PO_CONSTANTS_SV.REQ_ENTITY_CODE;
1690: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
1691: l_trx_rec.event_type_code := PO_CONSTANTS_SV.REQ_DELETED;
1692: l_trx_rec.trx_id := p_requisition_header_id;
1693: l_trx_rec.application_doc_status := null;
1694:

Line 1691: l_trx_rec.event_type_code := PO_CONSTANTS_SV.REQ_DELETED;

1687: l_trx_rec.internal_organization_id := l_org_id;
1688: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;
1689: l_trx_rec.entity_code := PO_CONSTANTS_SV.REQ_ENTITY_CODE;
1690: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
1691: l_trx_rec.event_type_code := PO_CONSTANTS_SV.REQ_DELETED;
1692: l_trx_rec.trx_id := p_requisition_header_id;
1693: l_trx_rec.application_doc_status := null;
1694:
1695: d_progress := 320;

Line 1932: ,PO_CONSTANTS_SV.PO --document_type_code,

1928: -- Read validation errors from zx_errors_gt into the global
1929: -- error record defined in the spec
1930: SELECT
1931: 'DETERMINE_RECOVERY' --error_level,
1932: ,PO_CONSTANTS_SV.PO --document_type_code,
1933: ,p_po_header_id --document_id,
1934: ,ph.segment1 --document_num,
1935: ,null --line_id,
1936: ,null --line_num,

Line 1974: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

1970: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1971: FROM zx_rec_nrec_dist zxdist
1972: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1973: AND zxdist.recoverable_flag = 'Y'
1974: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1975: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1976: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1977: ,pd.nonrecoverable_tax =
1978: (SELECT SUM(zxdist.rec_nrec_tax_amt)

Line 1975: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

1971: FROM zx_rec_nrec_dist zxdist
1972: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1973: AND zxdist.recoverable_flag = 'Y'
1974: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1975: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1976: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1977: ,pd.nonrecoverable_tax =
1978: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1979: FROM zx_rec_nrec_dist zxdist

Line 1976: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)

1972: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1973: AND zxdist.recoverable_flag = 'Y'
1974: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1975: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1976: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1977: ,pd.nonrecoverable_tax =
1978: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1979: FROM zx_rec_nrec_dist zxdist
1980: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id

Line 1982: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

1978: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1979: FROM zx_rec_nrec_dist zxdist
1980: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1981: AND zxdist.recoverable_flag = 'N'
1982: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1983: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1984: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE),
1985: --Bug 10305728 start
1986: last_update_date = sysdate,

Line 1983: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

1979: FROM zx_rec_nrec_dist zxdist
1980: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1981: AND zxdist.recoverable_flag = 'N'
1982: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1983: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1984: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE),
1985: --Bug 10305728 start
1986: last_update_date = sysdate,
1987: last_updated_by = fnd_global.user_id,

Line 1984: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE),

1980: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1981: AND zxdist.recoverable_flag = 'N'
1982: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1983: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1984: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE),
1985: --Bug 10305728 start
1986: last_update_date = sysdate,
1987: last_updated_by = fnd_global.user_id,
1988: last_update_login = fnd_global.login_id

Line 1998: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

1994: UPDATE po_line_locations_all pll
1995: SET pll.taxable_flag =
1996: DECODE((SELECT COUNT(1) FROM zx_lines zl
1997: WHERE zl.trx_line_id = pll.line_location_id
1998: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1999: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2000: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2001: AND zl.trx_id = pll.po_header_id)
2002: OR

Line 1999: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

1995: SET pll.taxable_flag =
1996: DECODE((SELECT COUNT(1) FROM zx_lines zl
1997: WHERE zl.trx_line_id = pll.line_location_id
1998: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1999: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2000: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2001: AND zl.trx_id = pll.po_header_id)
2002: OR
2003: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

Line 2000: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

1996: DECODE((SELECT COUNT(1) FROM zx_lines zl
1997: WHERE zl.trx_line_id = pll.line_location_id
1998: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1999: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2000: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2001: AND zl.trx_id = pll.po_header_id)
2002: OR
2003: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2004: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

Line 2003: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

1999: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2000: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2001: AND zl.trx_id = pll.po_header_id)
2002: OR
2003: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2004: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
2005: AND zl.trx_id = pll.po_release_id))),
2006: 0, 'N',
2007: 'Y'

Line 2004: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

2000: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2001: AND zl.trx_id = pll.po_header_id)
2002: OR
2003: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2004: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
2005: AND zl.trx_id = pll.po_release_id))),
2006: 0, 'N',
2007: 'Y'
2008: ),

Line 2166: ,PO_CONSTANTS_SV.PO --document_type_code,

2162: -- Read validation errors from zx_errors_gt into the global
2163: -- error record defined in the spec
2164: SELECT
2165: 'DETERMINE_RECOVERY' --error_level,
2166: ,PO_CONSTANTS_SV.PO --document_type_code,
2167: ,p_po_release_id --document_id,
2168: ,ph.segment1 --document_num,
2169: ,null --line_id,
2170: ,null --line_num,

Line 2209: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

2205: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2206: FROM zx_rec_nrec_dist zxdist
2207: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2208: AND zxdist.recoverable_flag = 'Y'
2209: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2210: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2211: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2212: ,pd.nonrecoverable_tax =
2213: (SELECT SUM(zxdist.rec_nrec_tax_amt)

Line 2210: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

2206: FROM zx_rec_nrec_dist zxdist
2207: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2208: AND zxdist.recoverable_flag = 'Y'
2209: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2210: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2211: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2212: ,pd.nonrecoverable_tax =
2213: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2214: FROM zx_rec_nrec_dist zxdist

Line 2211: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)

2207: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2208: AND zxdist.recoverable_flag = 'Y'
2209: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2210: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2211: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2212: ,pd.nonrecoverable_tax =
2213: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2214: FROM zx_rec_nrec_dist zxdist
2215: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id

Line 2217: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

2213: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2214: FROM zx_rec_nrec_dist zxdist
2215: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2216: AND zxdist.recoverable_flag = 'N'
2217: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2218: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2219: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2220: WHERE pd.po_distribution_id IN
2221: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

Line 2218: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

2214: FROM zx_rec_nrec_dist zxdist
2215: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2216: AND zxdist.recoverable_flag = 'N'
2217: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2218: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2219: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2220: WHERE pd.po_distribution_id IN
2221: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2222:

Line 2219: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)

2215: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2216: AND zxdist.recoverable_flag = 'N'
2217: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2218: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2219: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2220: WHERE pd.po_distribution_id IN
2221: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2222:
2223: /* Bug 6157632 Start */

Line 2228: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

2224: UPDATE po_line_locations_all pll
2225: SET pll.taxable_flag =
2226: DECODE((SELECT COUNT(1) FROM zx_lines zl
2227: WHERE zl.trx_line_id = pll.line_location_id
2228: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2229: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2230: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2231: AND zl.trx_id = pll.po_header_id)
2232: OR

Line 2229: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

2225: SET pll.taxable_flag =
2226: DECODE((SELECT COUNT(1) FROM zx_lines zl
2227: WHERE zl.trx_line_id = pll.line_location_id
2228: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2229: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2230: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2231: AND zl.trx_id = pll.po_header_id)
2232: OR
2233: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

Line 2230: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

2226: DECODE((SELECT COUNT(1) FROM zx_lines zl
2227: WHERE zl.trx_line_id = pll.line_location_id
2228: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2229: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2230: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2231: AND zl.trx_id = pll.po_header_id)
2232: OR
2233: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2234: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

Line 2233: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

2229: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2230: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2231: AND zl.trx_id = pll.po_header_id)
2232: OR
2233: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2234: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
2235: AND zl.trx_id = pll.po_release_id))),
2236: 0, 'N',
2237: 'Y'

Line 2234: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

2230: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2231: AND zl.trx_id = pll.po_header_id)
2232: OR
2233: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2234: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
2235: AND zl.trx_id = pll.po_release_id))),
2236: 0, 'N',
2237: 'Y'
2238: )

Line 2389: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,

2385: -- Read validation errors from zx_errors_gt into the global
2386: -- error record defined in the spec
2387: SELECT
2388: 'DETERMINE_RECOVERY' --error_level,
2389: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,
2390: ,p_requisition_header_id --document_id,
2391: ,prh.segment1 --document_num,
2392: ,zxegt.trx_line_id --line_id,
2393: ,prl.line_num --line_num,

Line 2431: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

2427: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2428: FROM zx_rec_nrec_dist_gt zxdist
2429: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2430: AND zxdist.recoverable_flag = 'Y'
2431: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2432: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2433: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2434: ,prd.nonrecoverable_tax =
2435: (SELECT SUM(zxdist.rec_nrec_tax_amt)

Line 2432: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

2428: FROM zx_rec_nrec_dist_gt zxdist
2429: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2430: AND zxdist.recoverable_flag = 'Y'
2431: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2432: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2433: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2434: ,prd.nonrecoverable_tax =
2435: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2436: FROM zx_rec_nrec_dist_gt zxdist

Line 2433: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)

2429: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2430: AND zxdist.recoverable_flag = 'Y'
2431: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2432: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2433: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2434: ,prd.nonrecoverable_tax =
2435: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2436: FROM zx_rec_nrec_dist_gt zxdist
2437: WHERE zxdist.trx_line_dist_id = prd.distribution_id

Line 2439: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

2435: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2436: FROM zx_rec_nrec_dist_gt zxdist
2437: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2438: AND zxdist.recoverable_flag = 'N'
2439: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2440: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2441: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2442: WHERE prd.distribution_id IN
2443: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

Line 2440: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

2436: FROM zx_rec_nrec_dist_gt zxdist
2437: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2438: AND zxdist.recoverable_flag = 'N'
2439: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2440: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2441: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2442: WHERE prd.distribution_id IN
2443: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2444:

Line 2441: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)

2437: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2438: AND zxdist.recoverable_flag = 'N'
2439: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2440: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2441: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2442: WHERE prd.distribution_id IN
2443: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2444:
2445: END IF; -- IF (l_count <> 0)

Line 2533: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id

2529: ,rndg_ship_from_party_site_id
2530: )
2531: SELECT
2532: ph.org_id --internal_organization_id
2533: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2534: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2535: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2536: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2537: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,

Line 2534: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code

2530: )
2531: SELECT
2532: ph.org_id --internal_organization_id
2533: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2534: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2535: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2536: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2537: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,
2538: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,

Line 2535: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code

2531: SELECT
2532: ph.org_id --internal_organization_id
2533: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2534: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2535: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2536: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2537: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,
2538: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,
2539: PO_CONSTANTS_SV.PO_ADJUSTED) --for null and 'UPDATE'

Line 2537: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,

2533: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2534: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2535: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2536: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2537: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,
2538: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,
2539: PO_CONSTANTS_SV.PO_ADJUSTED) --for null and 'UPDATE'
2540: ,ph.po_header_id --trx_id
2541: ,sysdate --trx_date

Line 2538: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,

2534: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2535: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2536: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2537: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,
2538: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,
2539: PO_CONSTANTS_SV.PO_ADJUSTED) --for null and 'UPDATE'
2540: ,ph.po_header_id --trx_id
2541: ,sysdate --trx_date
2542: ,ph.revision_num --trx_doc_revision

Line 2539: PO_CONSTANTS_SV.PO_ADJUSTED) --for null and 'UPDATE'

2535: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2536: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2537: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,
2538: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,
2539: PO_CONSTANTS_SV.PO_ADJUSTED) --for null and 'UPDATE'
2540: ,ph.po_header_id --trx_id
2541: ,sysdate --trx_date
2542: ,ph.revision_num --trx_doc_revision
2543: ,(SELECT set_of_books_id --ledger_id

Line 2585: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID

2581: -- Note that the po_header_id is of current document being processed,
2582: -- not of any source document. Get the first row obtained from join
2583: -- with zx_lines_det_factors because that table is denormalized
2584: AND zxldet.trx_id(+) = ph.po_header_id
2585: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2586: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
2587: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2588: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
2589: AND rownum = 1;

Line 2586: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE

2582: -- not of any source document. Get the first row obtained from join
2583: -- with zx_lines_det_factors because that table is denormalized
2584: AND zxldet.trx_id(+) = ph.po_header_id
2585: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2586: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
2587: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2588: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
2589: AND rownum = 1;
2590:

Line 2587: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

2583: -- with zx_lines_det_factors because that table is denormalized
2584: AND zxldet.trx_id(+) = ph.po_header_id
2585: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2586: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
2587: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2588: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
2589: AND rownum = 1;
2590:
2591: END populate_zx_headers_with_po;

Line 2588: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE

2584: AND zxldet.trx_id(+) = ph.po_header_id
2585: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2586: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
2587: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2588: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
2589: AND rownum = 1;
2590:
2591: END populate_zx_headers_with_po;
2592:

Line 2648: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id

2644: ,rndg_ship_from_party_site_id
2645: )
2646: SELECT
2647: ph.org_id --internal_organization_id
2648: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2649: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2650: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2651: ,PO_CONSTANTS_SV.PO_REDISTRIBUTED --event_type_code
2652: ,ph.po_header_id --trx_id

Line 2649: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code

2645: )
2646: SELECT
2647: ph.org_id --internal_organization_id
2648: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2649: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2650: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2651: ,PO_CONSTANTS_SV.PO_REDISTRIBUTED --event_type_code
2652: ,ph.po_header_id --trx_id
2653: ,sysdate --trx_date

Line 2650: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code

2646: SELECT
2647: ph.org_id --internal_organization_id
2648: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2649: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2650: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2651: ,PO_CONSTANTS_SV.PO_REDISTRIBUTED --event_type_code
2652: ,ph.po_header_id --trx_id
2653: ,sysdate --trx_date
2654: ,ph.revision_num --trx_doc_revision

Line 2651: ,PO_CONSTANTS_SV.PO_REDISTRIBUTED --event_type_code

2647: ph.org_id --internal_organization_id
2648: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2649: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2650: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2651: ,PO_CONSTANTS_SV.PO_REDISTRIBUTED --event_type_code
2652: ,ph.po_header_id --trx_id
2653: ,sysdate --trx_date
2654: ,ph.revision_num --trx_doc_revision
2655: ,(SELECT set_of_books_id --ledger_id

Line 2750: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id

2746: ,rndg_ship_from_party_site_id
2747: )
2748: SELECT
2749: pr.org_id --internal_organization_id
2750: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2751: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2752: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2753: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2754: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,

Line 2751: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code

2747: )
2748: SELECT
2749: pr.org_id --internal_organization_id
2750: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2751: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2752: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2753: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2754: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,
2755: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,

Line 2752: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code

2748: SELECT
2749: pr.org_id --internal_organization_id
2750: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2751: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2752: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2753: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2754: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,
2755: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,
2756: PO_CONSTANTS_SV.REL_ADJUSTED) -- for null and 'UPDATE'

Line 2754: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,

2750: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2751: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2752: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2753: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2754: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,
2755: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,
2756: PO_CONSTANTS_SV.REL_ADJUSTED) -- for null and 'UPDATE'
2757: ,pr.po_release_id --trx_id
2758: ,sysdate --trx_date

Line 2755: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,

2751: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2752: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2753: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2754: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,
2755: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,
2756: PO_CONSTANTS_SV.REL_ADJUSTED) -- for null and 'UPDATE'
2757: ,pr.po_release_id --trx_id
2758: ,sysdate --trx_date
2759: ,pr.revision_num --trx_doc_revision

Line 2756: PO_CONSTANTS_SV.REL_ADJUSTED) -- for null and 'UPDATE'

2752: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2753: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2754: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,
2755: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,
2756: PO_CONSTANTS_SV.REL_ADJUSTED) -- for null and 'UPDATE'
2757: ,pr.po_release_id --trx_id
2758: ,sysdate --trx_date
2759: ,pr.revision_num --trx_doc_revision
2760: ,(select set_of_books_id --ledger_id

Line 2801: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

2797: -- ELSE simply copy from existing release header (ie. in case of a
2798: -- shipment split or regular blanket/scheduled release create/update
2799: LEFT OUTER JOIN zx_lines_det_factors zxldet
2800: ON ((pr.po_header_id = zxldet.trx_id
2801: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2802: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2803: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
2804: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
2805: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED

Line 2802: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code

2798: -- shipment split or regular blanket/scheduled release create/update
2799: LEFT OUTER JOIN zx_lines_det_factors zxldet
2800: ON ((pr.po_header_id = zxldet.trx_id
2801: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2802: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2803: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
2804: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
2805: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED
2806: AND pr.tax_attribute_update_code = 'CREATE')

Line 2803: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code

2799: LEFT OUTER JOIN zx_lines_det_factors zxldet
2800: ON ((pr.po_header_id = zxldet.trx_id
2801: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2802: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2803: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
2804: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
2805: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED
2806: AND pr.tax_attribute_update_code = 'CREATE')
2807: OR

Line 2804: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type

2800: ON ((pr.po_header_id = zxldet.trx_id
2801: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2802: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2803: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
2804: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
2805: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED
2806: AND pr.tax_attribute_update_code = 'CREATE')
2807: OR
2808: (pr.po_release_id = zxldet.trx_id

Line 2805: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED

2801: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2802: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2803: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
2804: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
2805: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED
2806: AND pr.tax_attribute_update_code = 'CREATE')
2807: OR
2808: (pr.po_release_id = zxldet.trx_id
2809: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

Line 2809: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

2805: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED
2806: AND pr.tax_attribute_update_code = 'CREATE')
2807: OR
2808: (pr.po_release_id = zxldet.trx_id
2809: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2810: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
2811: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
2812: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type)
2813: )

Line 2810: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code

2806: AND pr.tax_attribute_update_code = 'CREATE')
2807: OR
2808: (pr.po_release_id = zxldet.trx_id
2809: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2810: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
2811: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
2812: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type)
2813: )
2814: WHERE pr.po_release_id = p_po_release_id_tbl(i)

Line 2811: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code

2807: OR
2808: (pr.po_release_id = zxldet.trx_id
2809: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2810: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
2811: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
2812: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type)
2813: )
2814: WHERE pr.po_release_id = p_po_release_id_tbl(i)
2815: AND pr.po_header_id = ph.po_header_id

Line 2812: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type)

2808: (pr.po_release_id = zxldet.trx_id
2809: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2810: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
2811: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
2812: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type)
2813: )
2814: WHERE pr.po_release_id = p_po_release_id_tbl(i)
2815: AND pr.po_header_id = ph.po_header_id
2816: AND fc.currency_code = ph.currency_code

Line 2876: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id

2872: ,rndg_ship_from_party_site_id
2873: )
2874: SELECT
2875: pr.org_id --internal_organization_id
2876: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2877: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2878: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2879: ,PO_CONSTANTS_SV.REL_REDISTRIBUTED --event_type_code
2880: ,pr.po_release_id --trx_id

Line 2877: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code

2873: )
2874: SELECT
2875: pr.org_id --internal_organization_id
2876: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2877: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2878: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2879: ,PO_CONSTANTS_SV.REL_REDISTRIBUTED --event_type_code
2880: ,pr.po_release_id --trx_id
2881: ,sysdate --trx_date

Line 2878: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code

2874: SELECT
2875: pr.org_id --internal_organization_id
2876: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2877: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2878: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2879: ,PO_CONSTANTS_SV.REL_REDISTRIBUTED --event_type_code
2880: ,pr.po_release_id --trx_id
2881: ,sysdate --trx_date
2882: ,pr.revision_num --trx_doc_revision

Line 2879: ,PO_CONSTANTS_SV.REL_REDISTRIBUTED --event_type_code

2875: pr.org_id --internal_organization_id
2876: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2877: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2878: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2879: ,PO_CONSTANTS_SV.REL_REDISTRIBUTED --event_type_code
2880: ,pr.po_release_id --trx_id
2881: ,sysdate --trx_date
2882: ,pr.revision_num --trx_doc_revision
2883: ,(select set_of_books_id --ledger_id

Line 2967: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id

2963: ,icx_session_id
2964: )
2965: SELECT
2966: prh.org_id --internal_organization_id
2967: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2968: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
2969: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
2970: ,DECODE(p_calling_program, --event_type_code
2971: --If calling determine_recovery from ATI page flow

Line 2968: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code

2964: )
2965: SELECT
2966: prh.org_id --internal_organization_id
2967: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2968: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
2969: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
2970: ,DECODE(p_calling_program, --event_type_code
2971: --If calling determine_recovery from ATI page flow
2972: 'DETERMINE_RECOVERY_REQ', PO_CONSTANTS_SV.REQ_DISTRIBUTED,

Line 2969: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code

2965: SELECT
2966: prh.org_id --internal_organization_id
2967: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2968: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
2969: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
2970: ,DECODE(p_calling_program, --event_type_code
2971: --If calling determine_recovery from ATI page flow
2972: 'DETERMINE_RECOVERY_REQ', PO_CONSTANTS_SV.REQ_DISTRIBUTED,
2973: --Regular UI flow

Line 2972: 'DETERMINE_RECOVERY_REQ', PO_CONSTANTS_SV.REQ_DISTRIBUTED,

2968: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
2969: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
2970: ,DECODE(p_calling_program, --event_type_code
2971: --If calling determine_recovery from ATI page flow
2972: 'DETERMINE_RECOVERY_REQ', PO_CONSTANTS_SV.REQ_DISTRIBUTED,
2973: --Regular UI flow
2974: PO_CONSTANTS_SV.REQ_CREATED)
2975: ,prh.requisition_header_id --trx_id
2976: ,sysdate --trx_date

Line 2974: PO_CONSTANTS_SV.REQ_CREATED)

2970: ,DECODE(p_calling_program, --event_type_code
2971: --If calling determine_recovery from ATI page flow
2972: 'DETERMINE_RECOVERY_REQ', PO_CONSTANTS_SV.REQ_DISTRIBUTED,
2973: --Regular UI flow
2974: PO_CONSTANTS_SV.REQ_CREATED)
2975: ,prh.requisition_header_id --trx_id
2976: ,sysdate --trx_date
2977: ,(select set_of_books_id --ledger_id
2978: from financials_system_params_all where org_id=prh.org_id)

Line 2994: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID

2990: -- Note that the req_header_id is of current document being processed,
2991: -- not of any source document. Get the first row obtained from join
2992: -- with zx_lines_det_factors because that table is denormalized
2993: AND zxldet.trx_id(+) = prh.requisition_header_id
2994: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2995: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2996: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
2997: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
2998: AND rownum = 1;

Line 2995: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE

2991: -- not of any source document. Get the first row obtained from join
2992: -- with zx_lines_det_factors because that table is denormalized
2993: AND zxldet.trx_id(+) = prh.requisition_header_id
2994: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2995: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2996: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
2997: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
2998: AND rownum = 1;
2999:

Line 2996: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE

2992: -- with zx_lines_det_factors because that table is denormalized
2993: AND zxldet.trx_id(+) = prh.requisition_header_id
2994: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2995: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2996: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
2997: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
2998: AND rownum = 1;
2999:
3000: END populate_zx_headers_with_req;

Line 2997: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE

2993: AND zxldet.trx_id(+) = prh.requisition_header_id
2994: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2995: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2996: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
2997: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
2998: AND rownum = 1;
2999:
3000: END populate_zx_headers_with_req;
3001:

Line 3103: PO_CONSTANTS_SV.APPLICATION_ID --application_id

3099: ,user_upd_det_factors_flag --Bug 5632300
3100: ,defaulting_attribute1 --Bug#6902111
3101: )
3102: SELECT
3103: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3104: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3105: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3106: ,ph.po_header_id --trx_id
3107: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

Line 3104: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code

3100: ,defaulting_attribute1 --Bug#6902111
3101: )
3102: SELECT
3103: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3104: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3105: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3106: ,ph.po_header_id --trx_id
3107: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
3108: ,pll.line_location_id --trx_line_id

Line 3105: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code

3101: )
3102: SELECT
3103: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3104: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3105: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3106: ,ph.po_header_id --trx_id
3107: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
3108: ,pll.line_location_id --trx_line_id
3109: ,pll.tax_attribute_update_code --line_level_action

Line 3107: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

3103: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3104: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3105: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3106: ,ph.po_header_id --trx_id
3107: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
3108: ,pll.line_location_id --trx_line_id
3109: ,pll.tax_attribute_update_code --line_level_action
3110: ,DECODE(pll.shipment_type,--line_class
3111: 'PREPAYMENT', DECODE(pll.payment_type,

Line 3217: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,

3213: -- Tax attributes when the attributes are overridden in requisition.
3214: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
3215: -- and 'PORELGEB'
3216: ,DECODE(p_calling_program, --source_application_id
3217: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3218: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3219: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3220: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3221: null)

Line 3218: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,

3214: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
3215: -- and 'PORELGEB'
3216: ,DECODE(p_calling_program, --source_application_id
3217: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3218: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3219: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3220: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3221: null)
3222: ,DECODE(p_calling_program, --source_entity_code

Line 3219: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,

3215: -- and 'PORELGEB'
3216: ,DECODE(p_calling_program, --source_application_id
3217: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3218: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3219: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3220: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3221: null)
3222: ,DECODE(p_calling_program, --source_entity_code
3223: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,

Line 3220: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,

3216: ,DECODE(p_calling_program, --source_application_id
3217: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3218: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3219: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3220: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3221: null)
3222: ,DECODE(p_calling_program, --source_entity_code
3223: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3224: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

Line 3223: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,

3219: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3220: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3221: null)
3222: ,DECODE(p_calling_program, --source_entity_code
3223: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3224: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3225: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3226: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3227: null)

Line 3224: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3220: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3221: null)
3222: ,DECODE(p_calling_program, --source_entity_code
3223: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3224: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3225: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3226: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3227: null)
3228: ,DECODE(p_calling_program, --source_event_class_code

Line 3225: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3221: null)
3222: ,DECODE(p_calling_program, --source_entity_code
3223: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3224: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3225: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3226: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3227: null)
3228: ,DECODE(p_calling_program, --source_event_class_code
3229: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

Line 3226: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3222: ,DECODE(p_calling_program, --source_entity_code
3223: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3224: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3225: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3226: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3227: null)
3228: ,DECODE(p_calling_program, --source_event_class_code
3229: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3230: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

Line 3229: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

3225: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3226: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3227: null)
3228: ,DECODE(p_calling_program, --source_event_class_code
3229: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3230: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3231: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3232: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3233: null)

Line 3230: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3226: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3227: null)
3228: ,DECODE(p_calling_program, --source_event_class_code
3229: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3230: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3231: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3232: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3233: null)
3234: ,DECODE(p_calling_program, -- source_trx_id

Line 3231: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3227: null)
3228: ,DECODE(p_calling_program, --source_event_class_code
3229: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3230: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3231: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3232: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3233: null)
3234: ,DECODE(p_calling_program, -- source_trx_id
3235: 'COPY_DOCUMENT', (SELECT source_shipment.po_header_id --source_trx_id

Line 3232: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3228: ,DECODE(p_calling_program, --source_event_class_code
3229: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3230: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3231: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3232: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3233: null)
3234: ,DECODE(p_calling_program, -- source_trx_id
3235: 'COPY_DOCUMENT', (SELECT source_shipment.po_header_id --source_trx_id
3236: FROM po_line_locations_all source_shipment

Line 3275: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

3271: WHERE prl.line_location_id = pll.line_location_id
3272: AND p_calling_program = 'PORELGEB'),
3273: null)
3274: ,DECODE(p_calling_program, --source_trx_level_type
3275: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3276: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3277: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3278: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3279: null)

Line 3276: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3272: AND p_calling_program = 'PORELGEB'),
3273: null)
3274: ,DECODE(p_calling_program, --source_trx_level_type
3275: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3276: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3277: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3278: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3279: null)
3280: ,pll.price_override --unit_price

Line 3277: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3273: null)
3274: ,DECODE(p_calling_program, --source_trx_level_type
3275: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3276: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3277: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3278: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3279: null)
3280: ,pll.price_override --unit_price
3281: ,null --ref_doc_trx_level_type

Line 3278: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3274: ,DECODE(p_calling_program, --source_trx_level_type
3275: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3276: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3277: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3278: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3279: null)
3280: ,pll.price_override --unit_price
3281: ,null --ref_doc_trx_level_type
3282: -- Bug 5025018. Updated tax attribute mappings

Line 3318: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID

3314: -- entail bringing the source_header_id for the shipment being currently
3315: -- processed. Join with trx_line_id itself is unique because the document
3316: -- type has been classified with event_class_code and line_location_id
3317: -- will always be unique whether PO shipment or Release shipment
3318: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3319: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3320: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3321: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3322: AND zxldet.trx_line_id(+) = pll.original_shipment_id

Line 3319: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE

3315: -- processed. Join with trx_line_id itself is unique because the document
3316: -- type has been classified with event_class_code and line_location_id
3317: -- will always be unique whether PO shipment or Release shipment
3318: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3319: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3320: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3321: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3322: AND zxldet.trx_line_id(+) = pll.original_shipment_id
3323: -- Join with vendor tables to get party and party site information

Line 3320: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

3316: -- type has been classified with event_class_code and line_location_id
3317: -- will always be unique whether PO shipment or Release shipment
3318: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3319: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3320: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3321: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3322: AND zxldet.trx_line_id(+) = pll.original_shipment_id
3323: -- Join with vendor tables to get party and party site information
3324: AND pv.vendor_id(+) = ph.vendor_id

Line 3321: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE

3317: -- will always be unique whether PO shipment or Release shipment
3318: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3319: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3320: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3321: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3322: AND zxldet.trx_line_id(+) = pll.original_shipment_id
3323: -- Join with vendor tables to get party and party site information
3324: AND pv.vendor_id(+) = ph.vendor_id
3325: AND pvs.vendor_site_id(+) = ph.vendor_site_id

Line 3431: PO_CONSTANTS_SV.APPLICATION_ID --application_id

3427: ,ship_to_party_id
3428: ,defaulting_attribute1 --Bug#6902111
3429: )
3430: SELECT
3431: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3432: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3433: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3434: ,pr.po_release_id --trx_id
3435: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

Line 3432: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code

3428: ,defaulting_attribute1 --Bug#6902111
3429: )
3430: SELECT
3431: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3432: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3433: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3434: ,pr.po_release_id --trx_id
3435: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
3436: ,pll.line_location_id --trx_line_id

Line 3433: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code

3429: )
3430: SELECT
3431: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3432: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3433: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3434: ,pr.po_release_id --trx_id
3435: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
3436: ,pll.line_location_id --trx_line_id
3437: ,pll.tax_attribute_update_code --line_level_action

Line 3435: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

3431: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3432: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3433: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3434: ,pr.po_release_id --trx_id
3435: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
3436: ,pll.line_location_id --trx_line_id
3437: ,pll.tax_attribute_update_code --line_level_action
3438: ,DECODE(pll.shipment_type,--line_class
3439: 'PREPAYMENT', DECODE(pll.payment_type,

Line 3486: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.APPLICATION_ID,

3482: msib.expense_account
3483: )
3484: -- If scheduled release, pass Planned PO as a reference
3485: ,DECODE(pr.release_type, --ref_doc_application_id
3486: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.APPLICATION_ID,
3487: null)
3488: ,DECODE(pr.release_type, --ref_doc_entity_code
3489: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,
3490: null)

Line 3489: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,

3485: ,DECODE(pr.release_type, --ref_doc_application_id
3486: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.APPLICATION_ID,
3487: null)
3488: ,DECODE(pr.release_type, --ref_doc_entity_code
3489: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,
3490: null)
3491: ,DECODE(pr.release_type, --ref_doc_event_class_code
3492: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3493: null)

Line 3492: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

3488: ,DECODE(pr.release_type, --ref_doc_entity_code
3489: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,
3490: null)
3491: ,DECODE(pr.release_type, --ref_doc_event_class_code
3492: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3493: null)
3494: ,DECODE(pr.release_type, --ref_doc_trx_id
3495: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,
3496: null)

Line 3495: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,

3491: ,DECODE(pr.release_type, --ref_doc_event_class_code
3492: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3493: null)
3494: ,DECODE(pr.release_type, --ref_doc_trx_id
3495: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,
3496: null)
3497: ,DECODE(pr.release_type, --ref_doc_line_id
3498: PO_CONSTANTS_SV.SCHEDULED, pll.po_line_id,
3499: null)

Line 3498: PO_CONSTANTS_SV.SCHEDULED, pll.po_line_id,

3494: ,DECODE(pr.release_type, --ref_doc_trx_id
3495: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,
3496: null)
3497: ,DECODE(pr.release_type, --ref_doc_line_id
3498: PO_CONSTANTS_SV.SCHEDULED, pll.po_line_id,
3499: null)
3500: ,pl.line_num --line_trx_user_key1
3501: ,PO_LOCATIONS_S.get_location_code(pll.ship_to_location_id) --line_trx_user_key2
3502: ,DECODE(pll.payment_type, --trx_line_number

Line 3531: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,

3527: -- Tax attributes when the attributes are overridden in requisition.
3528: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
3529: -- and 'PORELGEB'
3530: ,DECODE(p_calling_program, --source_application_id
3531: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3532: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
3533: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
3534: null)
3535: ,DECODE(p_calling_program, --source_entity_code

Line 3532: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,

3528: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
3529: -- and 'PORELGEB'
3530: ,DECODE(p_calling_program, --source_application_id
3531: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3532: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
3533: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
3534: null)
3535: ,DECODE(p_calling_program, --source_entity_code
3536: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

Line 3533: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,

3529: -- and 'PORELGEB'
3530: ,DECODE(p_calling_program, --source_application_id
3531: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3532: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
3533: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
3534: null)
3535: ,DECODE(p_calling_program, --source_entity_code
3536: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3537: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

Line 3536: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3532: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
3533: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
3534: null)
3535: ,DECODE(p_calling_program, --source_entity_code
3536: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3537: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3538: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3539: null)
3540: ,DECODE(p_calling_program, --source_event_class_code

Line 3537: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3533: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
3534: null)
3535: ,DECODE(p_calling_program, --source_entity_code
3536: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3537: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3538: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3539: null)
3540: ,DECODE(p_calling_program, --source_event_class_code
3541: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

Line 3538: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3534: null)
3535: ,DECODE(p_calling_program, --source_entity_code
3536: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3537: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3538: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3539: null)
3540: ,DECODE(p_calling_program, --source_event_class_code
3541: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3542: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

Line 3541: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3537: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3538: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3539: null)
3540: ,DECODE(p_calling_program, --source_event_class_code
3541: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3542: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3543: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3544: null)
3545: ,DECODE(p_calling_program, -- source_trx_id

Line 3542: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3538: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3539: null)
3540: ,DECODE(p_calling_program, --source_event_class_code
3541: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3542: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3543: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3544: null)
3545: ,DECODE(p_calling_program, -- source_trx_id
3546: 'POXBWVRP_PO', (SELECT requisition_header_id FROM

Line 3543: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3539: null)
3540: ,DECODE(p_calling_program, --source_event_class_code
3541: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3542: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3543: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3544: null)
3545: ,DECODE(p_calling_program, -- source_trx_id
3546: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3547: po_requisition_lines_all

Line 3580: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3576: WHERE prl.line_location_id = pll.line_location_id
3577: AND p_calling_program = 'PORELGEB'),
3578: null)
3579: ,DECODE(p_calling_program, --source_trx_level_type
3580: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3581: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3582: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3583: null)
3584: ,pll.price_override --unit_price

Line 3581: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3577: AND p_calling_program = 'PORELGEB'),
3578: null)
3579: ,DECODE(p_calling_program, --source_trx_level_type
3580: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3581: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3582: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3583: null)
3584: ,pll.price_override --unit_price
3585: ,DECODE(pr.release_type, --ref_doc_trx_level_type

Line 3582: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3578: null)
3579: ,DECODE(p_calling_program, --source_trx_level_type
3580: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3581: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3582: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3583: null)
3584: ,pll.price_override --unit_price
3585: ,DECODE(pr.release_type, --ref_doc_trx_level_type
3586: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

Line 3586: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

3582: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3583: null)
3584: ,pll.price_override --unit_price
3585: ,DECODE(pr.release_type, --ref_doc_trx_level_type
3586: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3587: null)
3588: -- Bug 5025018. Updated tax attribute mappings
3589: ,DECODE(pr.release_type, --ref_doc_line_quantity
3590: PO_CONSTANTS_SV.SCHEDULED, pll.quantity,

Line 3590: PO_CONSTANTS_SV.SCHEDULED, pll.quantity,

3586: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3587: null)
3588: -- Bug 5025018. Updated tax attribute mappings
3589: ,DECODE(pr.release_type, --ref_doc_line_quantity
3590: PO_CONSTANTS_SV.SCHEDULED, pll.quantity,
3591: null)
3592: ,pov.vendor_id --ship_third_pty_acct_id
3593: ,pov.vendor_id --bill_third_pty_acct_id
3594: ,pvs.vendor_site_id --ship_third_pty_acct_site_id

Line 3620: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

3616: -- because the document type has been classified with
3617: -- event_class_code and line_location_id will always be unique
3618: -- whether PO shipment or Release shipment
3619: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
3620: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3621: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
3622: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
3623: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
3624: AND pll.original_shipment_id = zxldet.trx_line_id

Line 3621: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code

3617: -- event_class_code and line_location_id will always be unique
3618: -- whether PO shipment or Release shipment
3619: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
3620: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3621: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
3622: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
3623: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
3624: AND pll.original_shipment_id = zxldet.trx_line_id
3625: AND pll.original_shipment_id IS NOT NULL)

Line 3622: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code

3618: -- whether PO shipment or Release shipment
3619: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
3620: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3621: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
3622: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
3623: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
3624: AND pll.original_shipment_id = zxldet.trx_line_id
3625: AND pll.original_shipment_id IS NOT NULL)
3626: OR

Line 3623: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type

3619: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
3620: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3621: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
3622: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
3623: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
3624: AND pll.original_shipment_id = zxldet.trx_line_id
3625: AND pll.original_shipment_id IS NOT NULL)
3626: OR
3627: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

Line 3627: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

3623: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
3624: AND pll.original_shipment_id = zxldet.trx_line_id
3625: AND pll.original_shipment_id IS NOT NULL)
3626: OR
3627: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3628: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
3629: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
3630: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
3631: AND pll.source_shipment_id = zxldet.trx_line_id

Line 3628: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code

3624: AND pll.original_shipment_id = zxldet.trx_line_id
3625: AND pll.original_shipment_id IS NOT NULL)
3626: OR
3627: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3628: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
3629: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
3630: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
3631: AND pll.source_shipment_id = zxldet.trx_line_id
3632: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED

Line 3629: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code

3625: AND pll.original_shipment_id IS NOT NULL)
3626: OR
3627: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3628: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
3629: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
3630: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
3631: AND pll.source_shipment_id = zxldet.trx_line_id
3632: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED
3633: AND pll.tax_attribute_update_code = 'CREATE'

Line 3630: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type

3626: OR
3627: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3628: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
3629: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
3630: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
3631: AND pll.source_shipment_id = zxldet.trx_line_id
3632: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED
3633: AND pll.tax_attribute_update_code = 'CREATE'
3634: AND pll.original_shipment_id IS NULL)

Line 3632: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED

3628: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
3629: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
3630: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
3631: AND pll.source_shipment_id = zxldet.trx_line_id
3632: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED
3633: AND pll.tax_attribute_update_code = 'CREATE'
3634: AND pll.original_shipment_id IS NULL)
3635: )
3636: WHERE pr.po_release_id = pll.po_release_id

Line 3763: PO_CONSTANTS_SV.APPLICATION_ID --application_id

3759: ,user_upd_det_factors_flag --Bug 5632300
3760: ,defaulting_attribute1 --Bug#6902111
3761: )
3762: SELECT
3763: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3764: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3765: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3766: ,ph.po_header_id --trx_id
3767: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

Line 3764: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code

3760: ,defaulting_attribute1 --Bug#6902111
3761: )
3762: SELECT
3763: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3764: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3765: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3766: ,ph.po_header_id --trx_id
3767: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
3768: ,pll.line_location_id --trx_line_id

Line 3765: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code

3761: )
3762: SELECT
3763: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3764: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3765: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3766: ,ph.po_header_id --trx_id
3767: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
3768: ,pll.line_location_id --trx_line_id
3769: ,pll.tax_attribute_update_code --line_level_action

Line 3767: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

3763: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3764: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3765: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3766: ,ph.po_header_id --trx_id
3767: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
3768: ,pll.line_location_id --trx_line_id
3769: ,pll.tax_attribute_update_code --line_level_action
3770: ,DECODE(pll.shipment_type,--line_class
3771: 'PREPAYMENT', DECODE(pll.payment_type,

Line 3877: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,

3873: -- Tax attributes when the attributes are overridden in requisition.
3874: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
3875: -- and 'PORELGEB'
3876: ,DECODE(p_calling_program, --source_application_id
3877: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3878: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3879: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3880: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3881: null)

Line 3878: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,

3874: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
3875: -- and 'PORELGEB'
3876: ,DECODE(p_calling_program, --source_application_id
3877: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3878: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3879: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3880: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3881: null)
3882: ,DECODE(p_calling_program, --source_entity_code

Line 3879: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,

3875: -- and 'PORELGEB'
3876: ,DECODE(p_calling_program, --source_application_id
3877: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3878: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3879: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3880: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3881: null)
3882: ,DECODE(p_calling_program, --source_entity_code
3883: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,

Line 3880: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,

3876: ,DECODE(p_calling_program, --source_application_id
3877: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3878: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3879: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3880: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3881: null)
3882: ,DECODE(p_calling_program, --source_entity_code
3883: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3884: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

Line 3883: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,

3879: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3880: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3881: null)
3882: ,DECODE(p_calling_program, --source_entity_code
3883: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3884: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3885: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3886: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3887: null)

Line 3884: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3880: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3881: null)
3882: ,DECODE(p_calling_program, --source_entity_code
3883: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3884: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3885: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3886: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3887: null)
3888: ,DECODE(p_calling_program, --source_event_class_code

Line 3885: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3881: null)
3882: ,DECODE(p_calling_program, --source_entity_code
3883: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3884: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3885: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3886: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3887: null)
3888: ,DECODE(p_calling_program, --source_event_class_code
3889: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

Line 3886: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3882: ,DECODE(p_calling_program, --source_entity_code
3883: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3884: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3885: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3886: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3887: null)
3888: ,DECODE(p_calling_program, --source_event_class_code
3889: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3890: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

Line 3889: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

3885: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3886: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3887: null)
3888: ,DECODE(p_calling_program, --source_event_class_code
3889: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3890: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3891: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3892: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3893: null)

Line 3890: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3886: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3887: null)
3888: ,DECODE(p_calling_program, --source_event_class_code
3889: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3890: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3891: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3892: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3893: null)
3894: ,DECODE(p_calling_program, -- source_trx_id

Line 3891: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3887: null)
3888: ,DECODE(p_calling_program, --source_event_class_code
3889: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3890: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3891: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3892: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3893: null)
3894: ,DECODE(p_calling_program, -- source_trx_id
3895: 'COPY_DOCUMENT', (SELECT source_shipment.po_header_id --source_trx_id

Line 3892: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3888: ,DECODE(p_calling_program, --source_event_class_code
3889: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3890: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3891: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3892: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3893: null)
3894: ,DECODE(p_calling_program, -- source_trx_id
3895: 'COPY_DOCUMENT', (SELECT source_shipment.po_header_id --source_trx_id
3896: FROM po_line_locations_all source_shipment

Line 3935: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

3931: WHERE prl.line_location_id = pll.line_location_id
3932: AND p_calling_program = 'PORELGEB'),
3933: null)
3934: ,DECODE(p_calling_program, --source_trx_level_type
3935: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3936: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3937: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3938: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3939: null)

Line 3936: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3932: AND p_calling_program = 'PORELGEB'),
3933: null)
3934: ,DECODE(p_calling_program, --source_trx_level_type
3935: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3936: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3937: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3938: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3939: null)
3940: ,pll.price_override --unit_price

Line 3937: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3933: null)
3934: ,DECODE(p_calling_program, --source_trx_level_type
3935: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3936: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3937: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3938: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3939: null)
3940: ,pll.price_override --unit_price
3941: ,null --ref_doc_trx_level_type

Line 3938: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3934: ,DECODE(p_calling_program, --source_trx_level_type
3935: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3936: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3937: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3938: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3939: null)
3940: ,pll.price_override --unit_price
3941: ,null --ref_doc_trx_level_type
3942: -- Bug 5025018. Updated tax attribute mappings

Line 3973: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID

3969: -- entail bringing the source_header_id for the shipment being currently
3970: -- processed. Join with trx_line_id itself is unique because the document
3971: -- type has been classified with event_class_code and line_location_id
3972: -- will always be unique whether PO shipment or Release shipment
3973: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3974: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3975: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3976: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3977: AND zxldet.trx_line_id(+) = pll.line_location_id

Line 3974: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE

3970: -- processed. Join with trx_line_id itself is unique because the document
3971: -- type has been classified with event_class_code and line_location_id
3972: -- will always be unique whether PO shipment or Release shipment
3973: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3974: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3975: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3976: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3977: AND zxldet.trx_line_id(+) = pll.line_location_id
3978: AND zxldet.trx_id(+) = p_po_header_id_tbl(i) --bug:14028744

Line 3975: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

3971: -- type has been classified with event_class_code and line_location_id
3972: -- will always be unique whether PO shipment or Release shipment
3973: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3974: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3975: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3976: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3977: AND zxldet.trx_line_id(+) = pll.line_location_id
3978: AND zxldet.trx_id(+) = p_po_header_id_tbl(i) --bug:14028744
3979: -- Bug 11665348: For received/billed PO shipments.

Line 3976: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE

3972: -- will always be unique whether PO shipment or Release shipment
3973: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3974: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3975: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3976: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3977: AND zxldet.trx_line_id(+) = pll.line_location_id
3978: AND zxldet.trx_id(+) = p_po_header_id_tbl(i) --bug:14028744
3979: -- Bug 11665348: For received/billed PO shipments.
3980: -- Join with vendor tables to get party and party site information

Line 4087: PO_CONSTANTS_SV.APPLICATION_ID --application_id

4083: ,ship_to_party_id
4084: ,defaulting_attribute1 --Bug#6902111
4085: )
4086: SELECT
4087: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4088: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4089: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4090: ,pr.po_release_id --trx_id
4091: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

Line 4088: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code

4084: ,defaulting_attribute1 --Bug#6902111
4085: )
4086: SELECT
4087: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4088: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4089: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4090: ,pr.po_release_id --trx_id
4091: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
4092: ,pll.line_location_id --trx_line_id

Line 4089: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code

4085: )
4086: SELECT
4087: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4088: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4089: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4090: ,pr.po_release_id --trx_id
4091: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
4092: ,pll.line_location_id --trx_line_id
4093: ,pll.tax_attribute_update_code --line_level_action

Line 4091: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

4087: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4088: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4089: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4090: ,pr.po_release_id --trx_id
4091: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
4092: ,pll.line_location_id --trx_line_id
4093: ,pll.tax_attribute_update_code --line_level_action
4094: ,DECODE(pll.shipment_type,--line_class
4095: 'PREPAYMENT', DECODE(pll.payment_type,

Line 4142: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.APPLICATION_ID,

4138: msib.expense_account
4139: )
4140: -- If scheduled release, pass Planned PO as a reference
4141: ,DECODE(pr.release_type, --ref_doc_application_id
4142: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.APPLICATION_ID,
4143: null)
4144: ,DECODE(pr.release_type, --ref_doc_entity_code
4145: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,
4146: null)

Line 4145: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,

4141: ,DECODE(pr.release_type, --ref_doc_application_id
4142: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.APPLICATION_ID,
4143: null)
4144: ,DECODE(pr.release_type, --ref_doc_entity_code
4145: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,
4146: null)
4147: ,DECODE(pr.release_type, --ref_doc_event_class_code
4148: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
4149: null)

Line 4148: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

4144: ,DECODE(pr.release_type, --ref_doc_entity_code
4145: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,
4146: null)
4147: ,DECODE(pr.release_type, --ref_doc_event_class_code
4148: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
4149: null)
4150: ,DECODE(pr.release_type, --ref_doc_trx_id
4151: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,
4152: null)

Line 4151: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,

4147: ,DECODE(pr.release_type, --ref_doc_event_class_code
4148: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
4149: null)
4150: ,DECODE(pr.release_type, --ref_doc_trx_id
4151: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,
4152: null)
4153: ,DECODE(pr.release_type, --ref_doc_line_id
4154: PO_CONSTANTS_SV.SCHEDULED, pll.po_line_id,
4155: null)

Line 4154: PO_CONSTANTS_SV.SCHEDULED, pll.po_line_id,

4150: ,DECODE(pr.release_type, --ref_doc_trx_id
4151: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,
4152: null)
4153: ,DECODE(pr.release_type, --ref_doc_line_id
4154: PO_CONSTANTS_SV.SCHEDULED, pll.po_line_id,
4155: null)
4156: ,pl.line_num --line_trx_user_key1
4157: ,PO_LOCATIONS_S.get_location_code(pll.ship_to_location_id) --line_trx_user_key2
4158: ,DECODE(pll.payment_type, --trx_line_number

Line 4187: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,

4183: -- Tax attributes when the attributes are overridden in requisition.
4184: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
4185: -- and 'PORELGEB'
4186: ,DECODE(p_calling_program, --source_application_id
4187: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
4188: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
4189: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
4190: null)
4191: ,DECODE(p_calling_program, --source_entity_code

Line 4188: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,

4184: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
4185: -- and 'PORELGEB'
4186: ,DECODE(p_calling_program, --source_application_id
4187: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
4188: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
4189: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
4190: null)
4191: ,DECODE(p_calling_program, --source_entity_code
4192: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

Line 4189: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,

4185: -- and 'PORELGEB'
4186: ,DECODE(p_calling_program, --source_application_id
4187: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
4188: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
4189: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
4190: null)
4191: ,DECODE(p_calling_program, --source_entity_code
4192: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4193: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

Line 4192: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

4188: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
4189: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
4190: null)
4191: ,DECODE(p_calling_program, --source_entity_code
4192: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4193: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4194: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4195: null)
4196: ,DECODE(p_calling_program, --source_event_class_code

Line 4193: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

4189: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
4190: null)
4191: ,DECODE(p_calling_program, --source_entity_code
4192: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4193: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4194: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4195: null)
4196: ,DECODE(p_calling_program, --source_event_class_code
4197: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

Line 4194: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

4190: null)
4191: ,DECODE(p_calling_program, --source_entity_code
4192: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4193: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4194: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4195: null)
4196: ,DECODE(p_calling_program, --source_event_class_code
4197: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
4198: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

Line 4197: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

4193: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4194: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4195: null)
4196: ,DECODE(p_calling_program, --source_event_class_code
4197: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
4198: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
4199: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
4200: null)
4201: ,DECODE(p_calling_program, -- source_trx_id

Line 4198: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

4194: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
4195: null)
4196: ,DECODE(p_calling_program, --source_event_class_code
4197: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
4198: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
4199: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
4200: null)
4201: ,DECODE(p_calling_program, -- source_trx_id
4202: 'POXBWVRP_PO', (SELECT requisition_header_id FROM

Line 4199: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

4195: null)
4196: ,DECODE(p_calling_program, --source_event_class_code
4197: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
4198: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
4199: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
4200: null)
4201: ,DECODE(p_calling_program, -- source_trx_id
4202: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
4203: po_requisition_lines_all

Line 4236: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

4232: WHERE prl.line_location_id = pll.line_location_id
4233: AND p_calling_program = 'PORELGEB'),
4234: null)
4235: ,DECODE(p_calling_program, --source_trx_level_type
4236: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
4237: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
4238: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
4239: null)
4240: ,pll.price_override --unit_price

Line 4237: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

4233: AND p_calling_program = 'PORELGEB'),
4234: null)
4235: ,DECODE(p_calling_program, --source_trx_level_type
4236: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
4237: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
4238: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
4239: null)
4240: ,pll.price_override --unit_price
4241: ,DECODE(pr.release_type, --ref_doc_trx_level_type

Line 4238: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

4234: null)
4235: ,DECODE(p_calling_program, --source_trx_level_type
4236: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
4237: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
4238: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
4239: null)
4240: ,pll.price_override --unit_price
4241: ,DECODE(pr.release_type, --ref_doc_trx_level_type
4242: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

Line 4242: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

4238: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
4239: null)
4240: ,pll.price_override --unit_price
4241: ,DECODE(pr.release_type, --ref_doc_trx_level_type
4242: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
4243: null)
4244: -- Bug 5025018. Updated tax attribute mappings
4245: ,DECODE(pr.release_type, --ref_doc_line_quantity
4246: PO_CONSTANTS_SV.SCHEDULED, pll.quantity,

Line 4246: PO_CONSTANTS_SV.SCHEDULED, pll.quantity,

4242: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
4243: null)
4244: -- Bug 5025018. Updated tax attribute mappings
4245: ,DECODE(pr.release_type, --ref_doc_line_quantity
4246: PO_CONSTANTS_SV.SCHEDULED, pll.quantity,
4247: null)
4248: ,pov.vendor_id --ship_third_pty_acct_id
4249: ,pov.vendor_id --bill_third_pty_acct_id
4250: ,pvs.vendor_site_id --ship_third_pty_acct_site_id

Line 4271: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

4267: ,po_line_locations_all pll
4268: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4269: -- Bug#12622509: The performance of the SQL is very bad, as FULL TABLE
4270: -- SCAN is performed on the table zx_lines_det_factors.
4271: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4272: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4273: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4274: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
4275: AND pll.line_location_id = zxldet.trx_line_id)

Line 4272: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code

4268: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4269: -- Bug#12622509: The performance of the SQL is very bad, as FULL TABLE
4270: -- SCAN is performed on the table zx_lines_det_factors.
4271: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4272: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4273: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4274: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
4275: AND pll.line_location_id = zxldet.trx_line_id)
4276: -- Bug 11665348: For received/billed PO shipments

Line 4273: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code

4269: -- Bug#12622509: The performance of the SQL is very bad, as FULL TABLE
4270: -- SCAN is performed on the table zx_lines_det_factors.
4271: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4272: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4273: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4274: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
4275: AND pll.line_location_id = zxldet.trx_line_id)
4276: -- Bug 11665348: For received/billed PO shipments
4277: /* -- Conditions for getting Additional Tax Attributes

Line 4274: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type

4270: -- SCAN is performed on the table zx_lines_det_factors.
4271: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4272: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4273: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4274: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
4275: AND pll.line_location_id = zxldet.trx_line_id)
4276: -- Bug 11665348: For received/billed PO shipments
4277: /* -- Conditions for getting Additional Tax Attributes
4278: -- Do not put a condition on zxldet.trx_id here because that would

Line 4285: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

4281: -- because the document type has been classified with
4282: -- event_class_code and line_location_id will always be unique
4283: -- whether PO shipment or Release shipment
4284: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4285: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4286: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4287: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4288: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
4289: AND pll.original_shipment_id = zxldet.trx_line_id

Line 4286: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code

4282: -- event_class_code and line_location_id will always be unique
4283: -- whether PO shipment or Release shipment
4284: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4285: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4286: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4287: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4288: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
4289: AND pll.original_shipment_id = zxldet.trx_line_id
4290: AND pll.original_shipment_id IS NOT NULL)

Line 4287: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code

4283: -- whether PO shipment or Release shipment
4284: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4285: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4286: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4287: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4288: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
4289: AND pll.original_shipment_id = zxldet.trx_line_id
4290: AND pll.original_shipment_id IS NOT NULL)
4291: OR

Line 4288: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type

4284: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4285: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4286: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4287: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4288: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
4289: AND pll.original_shipment_id = zxldet.trx_line_id
4290: AND pll.original_shipment_id IS NOT NULL)
4291: OR
4292: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

Line 4292: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

4288: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
4289: AND pll.original_shipment_id = zxldet.trx_line_id
4290: AND pll.original_shipment_id IS NOT NULL)
4291: OR
4292: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4293: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
4294: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
4295: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
4296: AND pll.source_shipment_id = zxldet.trx_line_id

Line 4293: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code

4289: AND pll.original_shipment_id = zxldet.trx_line_id
4290: AND pll.original_shipment_id IS NOT NULL)
4291: OR
4292: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4293: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
4294: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
4295: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
4296: AND pll.source_shipment_id = zxldet.trx_line_id
4297: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED

Line 4294: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code

4290: AND pll.original_shipment_id IS NOT NULL)
4291: OR
4292: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4293: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
4294: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
4295: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
4296: AND pll.source_shipment_id = zxldet.trx_line_id
4297: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED
4298: AND pll.tax_attribute_update_code = 'CREATE'

Line 4295: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type

4291: OR
4292: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4293: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
4294: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
4295: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
4296: AND pll.source_shipment_id = zxldet.trx_line_id
4297: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED
4298: AND pll.tax_attribute_update_code = 'CREATE'
4299: AND pll.original_shipment_id IS NULL)

Line 4297: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED

4293: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
4294: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
4295: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
4296: AND pll.source_shipment_id = zxldet.trx_line_id
4297: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED
4298: AND pll.tax_attribute_update_code = 'CREATE'
4299: AND pll.original_shipment_id IS NULL)
4300: ) */
4301: WHERE pr.po_release_id = pll.po_release_id

Line 4431: PO_CONSTANTS_SV.APPLICATION_ID --application_id

4427: ,user_upd_det_factors_flag --Bug 5632300
4428: ,defaulting_attribute1 --Bug#6902111
4429: )
4430: SELECT
4431: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4432: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
4433: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
4434: ,prl.requisition_header_id --trx_id
4435: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type

Line 4432: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code

4428: ,defaulting_attribute1 --Bug#6902111
4429: )
4430: SELECT
4431: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4432: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
4433: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
4434: ,prl.requisition_header_id --trx_id
4435: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type
4436: ,prl.requisition_line_id --trx_line_id

Line 4433: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code

4429: )
4430: SELECT
4431: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4432: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
4433: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
4434: ,prl.requisition_header_id --trx_id
4435: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type
4436: ,prl.requisition_line_id --trx_line_id
4437: ,'INVOICE' --line_class

Line 4435: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type

4431: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4432: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
4433: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
4434: ,prl.requisition_header_id --trx_id
4435: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type
4436: ,prl.requisition_line_id --trx_line_id
4437: ,'INVOICE' --line_class
4438: ,nvl(prl.tax_attribute_update_code,'UPDATE') --line_level_action
4439: ,'ITEM' --trx_line_type

Line 4561: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID

4557: -- entail bringing the source_header_id for the shipment being currently
4558: -- processed. Join with trx_line_id itself is unique because the document
4559: -- type has been classified with event_class_code and requisition_line_id
4560: -- will always be unique
4561: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
4562: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
4563: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
4564: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
4565: AND zxldet.trx_line_id(+) = prl.parent_req_line_id

Line 4562: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE

4558: -- processed. Join with trx_line_id itself is unique because the document
4559: -- type has been classified with event_class_code and requisition_line_id
4560: -- will always be unique
4561: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
4562: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
4563: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
4564: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
4565: AND zxldet.trx_line_id(+) = prl.parent_req_line_id
4566: -- Join with vendor tables to get party and party site information

Line 4563: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE

4559: -- type has been classified with event_class_code and requisition_line_id
4560: -- will always be unique
4561: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
4562: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
4563: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
4564: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
4565: AND zxldet.trx_line_id(+) = prl.parent_req_line_id
4566: -- Join with vendor tables to get party and party site information
4567: AND pv.vendor_id(+) = prl.vendor_id

Line 4564: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE

4560: -- will always be unique
4561: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
4562: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
4563: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
4564: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
4565: AND zxldet.trx_line_id(+) = prl.parent_req_line_id
4566: -- Join with vendor tables to get party and party site information
4567: AND pv.vendor_id(+) = prl.vendor_id
4568: AND pvs.vendor_site_id(+) = prl.vendor_site_id

Line 4642: PO_CONSTANTS_SV.APPLICATION_ID --application_id

4638: ,currency_exchange_rate
4639: ,overriding_recovery_rate
4640: )
4641: SELECT
4642: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4643: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
4644: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
4645: ,pd1.po_header_id --trx_id
4646: ,pll.line_location_id --trx_line_id

Line 4643: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code

4639: ,overriding_recovery_rate
4640: )
4641: SELECT
4642: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4643: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
4644: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
4645: ,pd1.po_header_id --trx_id
4646: ,pll.line_location_id --trx_line_id
4647: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

Line 4644: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code

4640: )
4641: SELECT
4642: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4643: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
4644: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
4645: ,pd1.po_header_id --trx_id
4646: ,pll.line_location_id --trx_line_id
4647: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
4648: ,pd1.po_distribution_id --trx_line_dist_id

Line 4647: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

4643: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
4644: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
4645: ,pd1.po_header_id --trx_id
4646: ,pll.line_location_id --trx_line_id
4647: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
4648: ,pd1.po_distribution_id --trx_line_dist_id
4649: ,NVL(pd1.tax_attribute_update_code, 'NO_ACTION') --dist_level_action
4650: ,sysdate --trx_line_dist_date
4651: ,pd1.distribution_num --item_dist_number

Line 4681: WHERE event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);

4677: OR pll.tax_attribute_update_code IS NOT NULL
4678: )
4679: AND pd1.po_header_id IN
4680: (SELECT trx_id FROM zx_trx_headers_gt
4681: WHERE event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
4682:
4683: END populate_zx_dists_with_po;
4684:
4685:

Line 4734: PO_CONSTANTS_SV.APPLICATION_ID --application_id

4730: ,currency_exchange_rate
4731: ,overriding_recovery_rate
4732: )
4733: SELECT
4734: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4735: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
4736: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
4737: ,pd.po_header_id --trx_id
4738: ,pll.line_location_id --trx_line_id

Line 4735: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code

4731: ,overriding_recovery_rate
4732: )
4733: SELECT
4734: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4735: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
4736: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
4737: ,pd.po_header_id --trx_id
4738: ,pll.line_location_id --trx_line_id
4739: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

Line 4736: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code

4732: )
4733: SELECT
4734: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4735: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
4736: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
4737: ,pd.po_header_id --trx_id
4738: ,pll.line_location_id --trx_line_id
4739: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
4740: ,pd.po_distribution_id --trx_line_dist_id

Line 4739: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

4735: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
4736: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
4737: ,pd.po_header_id --trx_id
4738: ,pll.line_location_id --trx_line_id
4739: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
4740: ,pd.po_distribution_id --trx_line_dist_id
4741: ,'NO_ACTION' --dist_level_action
4742: ,sysdate --trx_line_dist_date
4743: ,pd.distribution_num --item_dist_number

Line 4839: PO_CONSTANTS_SV.APPLICATION_ID --application_id

4835: ,currency_exchange_rate
4836: ,overriding_recovery_rate
4837: )
4838: SELECT
4839: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4840: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4841: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4842: ,pd1.po_release_id --trx_id
4843: ,pll.line_location_id --trx_line_id

Line 4840: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code

4836: ,overriding_recovery_rate
4837: )
4838: SELECT
4839: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4840: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4841: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4842: ,pd1.po_release_id --trx_id
4843: ,pll.line_location_id --trx_line_id
4844: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

Line 4841: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code

4837: )
4838: SELECT
4839: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4840: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4841: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4842: ,pd1.po_release_id --trx_id
4843: ,pll.line_location_id --trx_line_id
4844: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
4845: ,pd1.po_distribution_id --trx_line_dist_id

Line 4844: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

4840: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4841: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4842: ,pd1.po_release_id --trx_id
4843: ,pll.line_location_id --trx_line_id
4844: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
4845: ,pd1.po_distribution_id --trx_line_dist_id
4846: ,nvl(pd1.tax_attribute_update_code, 'NO_ACTION') --dist_level_action
4847: ,sysdate --trx_line_dist_date
4848: ,pd1.distribution_num --item_dist_number

Line 4878: WHERE event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE);

4874: OR pll.tax_attribute_update_code IS NOT NULL
4875: )
4876: AND pd1.po_release_id IN
4877: (SELECT trx_id FROM zx_trx_headers_gt
4878: WHERE event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE);
4879:
4880: END populate_zx_dists_with_rel;
4881:
4882:

Line 4931: PO_CONSTANTS_SV.APPLICATION_ID --application_id

4927: ,currency_exchange_rate
4928: ,overriding_recovery_rate
4929: )
4930: SELECT
4931: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4932: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4933: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4934: ,pd.po_release_id --trx_id
4935: ,pll.line_location_id --trx_line_id

Line 4932: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code

4928: ,overriding_recovery_rate
4929: )
4930: SELECT
4931: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4932: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4933: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4934: ,pd.po_release_id --trx_id
4935: ,pll.line_location_id --trx_line_id
4936: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

Line 4933: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code

4929: )
4930: SELECT
4931: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4932: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4933: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4934: ,pd.po_release_id --trx_id
4935: ,pll.line_location_id --trx_line_id
4936: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
4937: ,pd.po_distribution_id --trx_line_dist_id

Line 4936: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

4932: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4933: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4934: ,pd.po_release_id --trx_id
4935: ,pll.line_location_id --trx_line_id
4936: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
4937: ,pd.po_distribution_id --trx_line_dist_id
4938: ,'NO_ACTION' --dist_level_action
4939: ,sysdate --trx_line_dist_date
4940: ,pd.distribution_num --item_dist_number

Line 5021: PO_CONSTANTS_SV.APPLICATION_ID --application_id

5017: ,account_ccid
5018: ,historical_flag
5019: ,overriding_recovery_rate)
5020: SELECT
5021: PO_CONSTANTS_SV.APPLICATION_ID --application_id
5022: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
5023: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
5024: ,prl.requisition_header_id --trx_id
5025: ,prl.requisition_line_id --trx_line_id

Line 5022: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code

5018: ,historical_flag
5019: ,overriding_recovery_rate)
5020: SELECT
5021: PO_CONSTANTS_SV.APPLICATION_ID --application_id
5022: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
5023: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
5024: ,prl.requisition_header_id --trx_id
5025: ,prl.requisition_line_id --trx_line_id
5026: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type

Line 5023: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code

5019: ,overriding_recovery_rate)
5020: SELECT
5021: PO_CONSTANTS_SV.APPLICATION_ID --application_id
5022: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
5023: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
5024: ,prl.requisition_header_id --trx_id
5025: ,prl.requisition_line_id --trx_line_id
5026: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type
5027: ,prd.distribution_id --trx_line_dist_id

Line 5026: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type

5022: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
5023: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
5024: ,prl.requisition_header_id --trx_id
5025: ,prl.requisition_line_id --trx_line_id
5026: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type
5027: ,prd.distribution_id --trx_line_dist_id
5028: ,'CREATE' --dist_level_action
5029: ,sysdate --trx_line_dist_date
5030: ,prd.distribution_num --item_dist_number

Line 5462: PO_CONSTANTS_SV.APPLICATION_ID, --application_id

5458: line_amt,
5459: line_amt_includes_tax_flag
5460: )
5461: SELECT
5462: PO_CONSTANTS_SV.APPLICATION_ID, --application_id
5463: PO_CONSTANTS_SV.PO_ENTITY_CODE, --entity_code
5464: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, --event_class_code
5465: p_po_header_id, --trx_id
5466: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE, --trx_level_type

Line 5463: PO_CONSTANTS_SV.PO_ENTITY_CODE, --entity_code

5459: line_amt_includes_tax_flag
5460: )
5461: SELECT
5462: PO_CONSTANTS_SV.APPLICATION_ID, --application_id
5463: PO_CONSTANTS_SV.PO_ENTITY_CODE, --entity_code
5464: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, --event_class_code
5465: p_po_header_id, --trx_id
5466: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE, --trx_level_type
5467: p_del_shipment_table(i), --trx_line_id

Line 5464: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, --event_class_code

5460: )
5461: SELECT
5462: PO_CONSTANTS_SV.APPLICATION_ID, --application_id
5463: PO_CONSTANTS_SV.PO_ENTITY_CODE, --entity_code
5464: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, --event_class_code
5465: p_po_header_id, --trx_id
5466: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE, --trx_level_type
5467: p_del_shipment_table(i), --trx_line_id
5468: 'DELETE', --line_level_action

Line 5466: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE, --trx_level_type

5462: PO_CONSTANTS_SV.APPLICATION_ID, --application_id
5463: PO_CONSTANTS_SV.PO_ENTITY_CODE, --entity_code
5464: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, --event_class_code
5465: p_po_header_id, --trx_id
5466: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE, --trx_level_type
5467: p_del_shipment_table(i), --trx_line_id
5468: 'DELETE', --line_level_action
5469: -1,
5470: 'N'

Line 5481: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

5477: -- Restrict to only rows that have corresponding tax lines
5478: -- Since this is called from OA, so conditions are only for SPO
5479: WHERE zl.trx_id = p_po_header_id
5480: AND zl.trx_line_id = p_del_shipment_table(i)
5481: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
5482: AND zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
5483: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
5484: AND zl.trx_level_type = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
5485: );

Line 5482: AND zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

5478: -- Since this is called from OA, so conditions are only for SPO
5479: WHERE zl.trx_id = p_po_header_id
5480: AND zl.trx_line_id = p_del_shipment_table(i)
5481: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
5482: AND zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
5483: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
5484: AND zl.trx_level_type = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
5485: );
5486:

Line 5483: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

5479: WHERE zl.trx_id = p_po_header_id
5480: AND zl.trx_line_id = p_del_shipment_table(i)
5481: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
5482: AND zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
5483: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
5484: AND zl.trx_level_type = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
5485: );
5486:
5487: d_progress := 20;

Line 5484: AND zl.trx_level_type = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE

5480: AND zl.trx_line_id = p_del_shipment_table(i)
5481: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
5482: AND zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
5483: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
5484: AND zl.trx_level_type = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
5485: );
5486:
5487: d_progress := 20;
5488: IF (PO_LOG.d_proc) THEN

Line 6739: IF p_document_type = PO_CONSTANTS_SV.PO THEN

6735: initialize_zx_gt_tables(); -- Wipe ZX GT tables clean
6736: initialize_global_error_record();
6737:
6738: d_progress := 0;
6739: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6740: d_progress := 10;
6741: IF p_shipment_id <> 0 THEN
6742: d_progress := 20;
6743:

Line 6763: PO_CONSTANTS_SV.APPLICATION_ID,

6759: rounding_ship_from_party_id
6760: )
6761: SELECT
6762: ph.org_id,
6763: PO_CONSTANTS_SV.APPLICATION_ID,
6764: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6765: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6766: PO_CONSTANTS_SV.PO_ADJUSTED,
6767: ph.po_header_id,

Line 6764: PO_CONSTANTS_SV.PO_ENTITY_CODE,

6760: )
6761: SELECT
6762: ph.org_id,
6763: PO_CONSTANTS_SV.APPLICATION_ID,
6764: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6765: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6766: PO_CONSTANTS_SV.PO_ADJUSTED,
6767: ph.po_header_id,
6768: sysdate, -- dummy value

Line 6765: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

6761: SELECT
6762: ph.org_id,
6763: PO_CONSTANTS_SV.APPLICATION_ID,
6764: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6765: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6766: PO_CONSTANTS_SV.PO_ADJUSTED,
6767: ph.po_header_id,
6768: sysdate, -- dummy value
6769: PO_CORE_S.get_default_legal_entity_id(ph.org_id),

Line 6766: PO_CONSTANTS_SV.PO_ADJUSTED,

6762: ph.org_id,
6763: PO_CONSTANTS_SV.APPLICATION_ID,
6764: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6765: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6766: PO_CONSTANTS_SV.PO_ADJUSTED,
6767: ph.po_header_id,
6768: sysdate, -- dummy value
6769: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
6770: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

Line 6790: PO_CONSTANTS_SV.APPLICATION_ID,

6786: line_amt
6787: )
6788: VALUES
6789: (
6790: PO_CONSTANTS_SV.APPLICATION_ID,
6791: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6792: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6793: p_document_id,
6794: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

Line 6791: PO_CONSTANTS_SV.PO_ENTITY_CODE,

6787: )
6788: VALUES
6789: (
6790: PO_CONSTANTS_SV.APPLICATION_ID,
6791: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6792: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6793: p_document_id,
6794: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
6795: p_shipment_id,

Line 6792: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

6788: VALUES
6789: (
6790: PO_CONSTANTS_SV.APPLICATION_ID,
6791: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6792: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6793: p_document_id,
6794: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
6795: p_shipment_id,
6796: 'CANCEL',

Line 6794: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

6790: PO_CONSTANTS_SV.APPLICATION_ID,
6791: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6792: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6793: p_document_id,
6794: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
6795: p_shipment_id,
6796: 'CANCEL',
6797: 'N', -- dummy value
6798: 0 -- dummy value

Line 6844: PO_CONSTANTS_SV.APPLICATION_ID,

6840: rounding_ship_from_party_id
6841: )
6842: SELECT
6843: ph.org_id,
6844: PO_CONSTANTS_SV.APPLICATION_ID,
6845: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6846: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6847: PO_CONSTANTS_SV.PO_ADJUSTED,
6848: ph.po_header_id,

Line 6845: PO_CONSTANTS_SV.PO_ENTITY_CODE,

6841: )
6842: SELECT
6843: ph.org_id,
6844: PO_CONSTANTS_SV.APPLICATION_ID,
6845: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6846: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6847: PO_CONSTANTS_SV.PO_ADJUSTED,
6848: ph.po_header_id,
6849: sysdate, -- dummy value

Line 6846: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

6842: SELECT
6843: ph.org_id,
6844: PO_CONSTANTS_SV.APPLICATION_ID,
6845: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6846: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6847: PO_CONSTANTS_SV.PO_ADJUSTED,
6848: ph.po_header_id,
6849: sysdate, -- dummy value
6850: PO_CORE_S.get_default_legal_entity_id(ph.org_id),

Line 6847: PO_CONSTANTS_SV.PO_ADJUSTED,

6843: ph.org_id,
6844: PO_CONSTANTS_SV.APPLICATION_ID,
6845: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6846: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6847: PO_CONSTANTS_SV.PO_ADJUSTED,
6848: ph.po_header_id,
6849: sysdate, -- dummy value
6850: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
6851: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

Line 6870: PO_CONSTANTS_SV.APPLICATION_ID,

6866: line_amt_includes_tax_flag,
6867: line_amt
6868: )
6869: SELECT
6870: PO_CONSTANTS_SV.APPLICATION_ID,
6871: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6872: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6873: pll.po_header_id,
6874: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

Line 6871: PO_CONSTANTS_SV.PO_ENTITY_CODE,

6867: line_amt
6868: )
6869: SELECT
6870: PO_CONSTANTS_SV.APPLICATION_ID,
6871: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6872: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6873: pll.po_header_id,
6874: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
6875: pll.line_location_id,

Line 6872: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

6868: )
6869: SELECT
6870: PO_CONSTANTS_SV.APPLICATION_ID,
6871: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6872: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6873: pll.po_header_id,
6874: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
6875: pll.line_location_id,
6876: 'CANCEL', --line_level_action

Line 6874: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

6870: PO_CONSTANTS_SV.APPLICATION_ID,
6871: PO_CONSTANTS_SV.PO_ENTITY_CODE,
6872: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
6873: pll.po_header_id,
6874: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
6875: pll.line_location_id,
6876: 'CANCEL', --line_level_action
6877: 'N', -- dummy value
6878: 0 -- dummy value

Line 6931: p_document_type => PO_CONSTANTS_SV.PO,

6927: x_return_status => x_return_status,
6928: x_msg_count => x_msg_count,
6929: x_msg_data => x_msg_data,
6930: p_org_id => l_org_id,
6931: p_document_type => PO_CONSTANTS_SV.PO,
6932: p_document_id => p_document_id,
6933: p_event_type_code => PO_CONSTANTS_SV.PO_CANCELLED);
6934:
6935: d_progress := 150;

Line 6933: p_event_type_code => PO_CONSTANTS_SV.PO_CANCELLED);

6929: x_msg_data => x_msg_data,
6930: p_org_id => l_org_id,
6931: p_document_type => PO_CONSTANTS_SV.PO,
6932: p_document_id => p_document_id,
6933: p_event_type_code => PO_CONSTANTS_SV.PO_CANCELLED);
6934:
6935: d_progress := 150;
6936: IF (PO_LOG.d_stmt) THEN
6937: PO_LOG.stmt(d_module_base,d_progress,'After Calling PO_TAX_INTERFACE_PVT.global_document_update');

Line 6943: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

6939: PO_LOG.stmt(d_module_base,d_progress,'x_msg_count', x_msg_count);
6940: PO_LOG.stmt(d_module_base,d_progress,'x_msg_data', x_msg_data);
6941: END IF;
6942: END IF; --IF p_shipment_id IS NOT NULL
6943: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6944: d_progress := 160;
6945: IF p_shipment_id <> 0 THEN
6946: d_progress := 170;
6947: INSERT INTO zx_trx_headers_gt

Line 6961: PO_CONSTANTS_SV.APPLICATION_ID,

6957: rounding_ship_from_party_id
6958: )
6959: SELECT
6960: pr.org_id, -- dummy value
6961: PO_CONSTANTS_SV.APPLICATION_ID,
6962: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6963: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6964: PO_CONSTANTS_SV.REL_ADJUSTED,
6965: pr.po_release_id,

Line 6962: PO_CONSTANTS_SV.REL_ENTITY_CODE,

6958: )
6959: SELECT
6960: pr.org_id, -- dummy value
6961: PO_CONSTANTS_SV.APPLICATION_ID,
6962: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6963: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6964: PO_CONSTANTS_SV.REL_ADJUSTED,
6965: pr.po_release_id,
6966: sysdate, -- dummy value

Line 6963: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,

6959: SELECT
6960: pr.org_id, -- dummy value
6961: PO_CONSTANTS_SV.APPLICATION_ID,
6962: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6963: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6964: PO_CONSTANTS_SV.REL_ADJUSTED,
6965: pr.po_release_id,
6966: sysdate, -- dummy value
6967: PO_CORE_S.get_default_legal_entity_id(pr.org_id),

Line 6964: PO_CONSTANTS_SV.REL_ADJUSTED,

6960: pr.org_id, -- dummy value
6961: PO_CONSTANTS_SV.APPLICATION_ID,
6962: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6963: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6964: PO_CONSTANTS_SV.REL_ADJUSTED,
6965: pr.po_release_id,
6966: sysdate, -- dummy value
6967: PO_CORE_S.get_default_legal_entity_id(pr.org_id),
6968: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

Line 6989: PO_CONSTANTS_SV.APPLICATION_ID,

6985: line_amt
6986: )
6987: VALUES
6988: (
6989: PO_CONSTANTS_SV.APPLICATION_ID,
6990: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6991: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6992: p_document_id,
6993: PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE,

Line 6990: PO_CONSTANTS_SV.REL_ENTITY_CODE,

6986: )
6987: VALUES
6988: (
6989: PO_CONSTANTS_SV.APPLICATION_ID,
6990: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6991: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6992: p_document_id,
6993: PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE,
6994: p_shipment_id,

Line 6991: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,

6987: VALUES
6988: (
6989: PO_CONSTANTS_SV.APPLICATION_ID,
6990: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6991: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6992: p_document_id,
6993: PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE,
6994: p_shipment_id,
6995: 'CANCEL',

Line 6993: PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE,

6989: PO_CONSTANTS_SV.APPLICATION_ID,
6990: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6991: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6992: p_document_id,
6993: PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE,
6994: p_shipment_id,
6995: 'CANCEL',
6996: 'N', -- dummy value
6997: 0 -- dummy value

Line 7050: p_document_type => PO_CONSTANTS_SV.RELEASE,

7046: x_return_status => x_return_status,
7047: x_msg_count => x_msg_count,
7048: x_msg_data => x_msg_data,
7049: p_org_id => l_org_id,
7050: p_document_type => PO_CONSTANTS_SV.RELEASE,
7051: p_document_id => p_document_id,
7052: p_event_type_code => PO_CONSTANTS_SV.REL_CANCELLED);
7053:
7054: d_progress := 250;

Line 7052: p_event_type_code => PO_CONSTANTS_SV.REL_CANCELLED);

7048: x_msg_data => x_msg_data,
7049: p_org_id => l_org_id,
7050: p_document_type => PO_CONSTANTS_SV.RELEASE,
7051: p_document_id => p_document_id,
7052: p_event_type_code => PO_CONSTANTS_SV.REL_CANCELLED);
7053:
7054: d_progress := 250;
7055: IF (PO_LOG.d_stmt) THEN
7056: PO_LOG.stmt(d_module_base,d_progress,'After Calling PO_TAX_INTERFACE_PVT.global_document_update');

Line 7063: END IF; --IF p_document_type = PO_CONSTANTS_SV.PO

7059: PO_LOG.stmt(d_module_base,d_progress,'x_msg_data', x_msg_data);
7060: END IF;
7061:
7062: END IF; --IF p_shipment_id IS NOT NULL
7063: END IF; --IF p_document_type = PO_CONSTANTS_SV.PO
7064:
7065: d_progress := 260;
7066: IF (PO_LOG.d_proc) THEN
7067: PO_LOG.proc_end(d_module_base);

Line 7114: -- document level action code taken from PO_CONSTANTS_SV

7110: -- 'PO' or 'RELEASE'
7111: --p_document_id
7112: -- po_header_id or po_release_id of the document
7113: --p_event_type_code
7114: -- document level action code taken from PO_CONSTANTS_SV
7115: --OUT:
7116: --x_return_status
7117: -- Standard API specification parameter
7118: --x_msg_count

Line 7155: IF p_document_type = PO_CONSTANTS_SV.PO THEN

7151: PO_LOG.proc_begin(d_module_base, 'p_event_type_code', p_event_type_code);
7152: END IF;
7153:
7154: d_progress := 0;
7155: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7156: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
7157: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
7158: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7159: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;

Line 7156: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;

7152: END IF;
7153:
7154: d_progress := 0;
7155: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7156: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
7157: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
7158: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7159: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;
7160: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;

Line 7157: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;

7153:
7154: d_progress := 0;
7155: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7156: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
7157: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
7158: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7159: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;
7160: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;
7161: END IF;

Line 7158: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

7154: d_progress := 0;
7155: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7156: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
7157: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
7158: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7159: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;
7160: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;
7161: END IF;
7162:

Line 7159: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;

7155: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7156: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
7157: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
7158: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7159: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;
7160: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;
7161: END IF;
7162:
7163: d_progress := 10;

Line 7160: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;

7156: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
7157: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
7158: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7159: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;
7160: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;
7161: END IF;
7162:
7163: d_progress := 10;
7164: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;

Line 7164: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;

7160: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;
7161: END IF;
7162:
7163: d_progress := 10;
7164: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;
7165: l_trx_rec.internal_organization_id := p_org_id;
7166: l_trx_rec.event_type_code := p_event_type_code;
7167: l_trx_rec.trx_id := p_document_id;
7168: l_trx_rec.application_doc_status := null;

Line 7269: IF p_document_type = PO_CONSTANTS_SV.PO THEN

7265: -- By default return status is SUCCESS if no exception occurs
7266: x_return_status := FND_API.G_RET_STS_SUCCESS;
7267:
7268: d_progress := 10;
7269: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7270: SELECT ph.authorization_status
7271: INTO l_authorization_status
7272: FROM po_headers_all ph
7273: WHERE ph.po_header_id = p_document_id;

Line 7274: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

7270: SELECT ph.authorization_status
7271: INTO l_authorization_status
7272: FROM po_headers_all ph
7273: WHERE ph.po_header_id = p_document_id;
7274: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7275: SELECT pr.authorization_status
7276: INTO l_authorization_status
7277: FROM po_releases_all pr
7278: WHERE pr.po_release_id = p_document_id;

Line 7285: IF l_authorization_status = PO_CONSTANTS_SV.PRE_APPROVED THEN

7281: IF PO_LOG.d_stmt THEN
7282: PO_LOG.stmt(d_module_base,d_progress,'l_authorization_status='||l_authorization_status);
7283: END IF;
7284:
7285: IF l_authorization_status = PO_CONSTANTS_SV.PRE_APPROVED THEN
7286:
7287: d_progress := 20;
7288: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7289: UPDATE po_headers_all ph

Line 7288: IF p_document_type = PO_CONSTANTS_SV.PO THEN

7284:
7285: IF l_authorization_status = PO_CONSTANTS_SV.PRE_APPROVED THEN
7286:
7287: d_progress := 20;
7288: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7289: UPDATE po_headers_all ph
7290: SET ph.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
7291: ph.approved_flag = 'N'
7292: WHERE ph.po_header_id = p_document_id;

Line 7290: SET ph.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,

7286:
7287: d_progress := 20;
7288: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7289: UPDATE po_headers_all ph
7290: SET ph.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
7291: ph.approved_flag = 'N'
7292: WHERE ph.po_header_id = p_document_id;
7293: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7294: UPDATE po_releases_all pr

Line 7293: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

7289: UPDATE po_headers_all ph
7290: SET ph.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
7291: ph.approved_flag = 'N'
7292: WHERE ph.po_header_id = p_document_id;
7293: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7294: UPDATE po_releases_all pr
7295: SET pr.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
7296: pr.approved_flag = 'N'
7297: WHERE pr.po_release_id = p_document_id;

Line 7295: SET pr.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,

7291: ph.approved_flag = 'N'
7292: WHERE ph.po_header_id = p_document_id;
7293: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7294: UPDATE po_releases_all pr
7295: SET pr.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
7296: pr.approved_flag = 'N'
7297: WHERE pr.po_release_id = p_document_id;
7298: END IF;
7299:

Line 7300: ELSIF l_authorization_status = PO_CONSTANTS_SV.APPROVED THEN

7296: pr.approved_flag = 'N'
7297: WHERE pr.po_release_id = p_document_id;
7298: END IF;
7299:
7300: ELSIF l_authorization_status = PO_CONSTANTS_SV.APPROVED THEN
7301:
7302: d_progress := 30;
7303: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7304: UPDATE po_headers_all ph

Line 7303: IF p_document_type = PO_CONSTANTS_SV.PO THEN

7299:
7300: ELSIF l_authorization_status = PO_CONSTANTS_SV.APPROVED THEN
7301:
7302: d_progress := 30;
7303: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7304: UPDATE po_headers_all ph
7305: SET ph.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
7306: ph.approved_flag = 'R'
7307: WHERE ph.po_header_id = p_document_id;

Line 7305: SET ph.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,

7301:
7302: d_progress := 30;
7303: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7304: UPDATE po_headers_all ph
7305: SET ph.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
7306: ph.approved_flag = 'R'
7307: WHERE ph.po_header_id = p_document_id;
7308: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7309: UPDATE po_releases_all pr

Line 7308: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

7304: UPDATE po_headers_all ph
7305: SET ph.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
7306: ph.approved_flag = 'R'
7307: WHERE ph.po_header_id = p_document_id;
7308: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7309: UPDATE po_releases_all pr
7310: SET pr.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
7311: pr.approved_flag = 'R'
7312: WHERE pr.po_release_id = p_document_id;

Line 7310: SET pr.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,

7306: ph.approved_flag = 'R'
7307: WHERE ph.po_header_id = p_document_id;
7308: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7309: UPDATE po_releases_all pr
7310: SET pr.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
7311: pr.approved_flag = 'R'
7312: WHERE pr.po_release_id = p_document_id;
7313: END IF;
7314: