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 79: AND zxlgt.application_id = PO_CONSTANTS_SV.APPLICATION_ID

75: SELECT zxlgt.trx_line_id
76: FROM zx_transaction_lines_gt zxlgt
77: WHERE p_requisition_header_id=zxlgt.trx_id
78: AND p_requisition_header_id NOT IN (SELECT trx_id FROM zx_errors_gt zxegt)
79: AND zxlgt.application_id = PO_CONSTANTS_SV.APPLICATION_ID
80: AND zxlgt.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
81: AND zxlgt.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
82:
83:

Line 80: AND zxlgt.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

76: FROM zx_transaction_lines_gt zxlgt
77: WHERE p_requisition_header_id=zxlgt.trx_id
78: AND p_requisition_header_id NOT IN (SELECT trx_id FROM zx_errors_gt zxegt)
79: AND zxlgt.application_id = PO_CONSTANTS_SV.APPLICATION_ID
80: AND zxlgt.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
81: AND zxlgt.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
82:
83:
84: -----------------------------------------------------------------------------

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

77: WHERE p_requisition_header_id=zxlgt.trx_id
78: AND p_requisition_header_id NOT IN (SELECT trx_id FROM zx_errors_gt zxegt)
79: AND zxlgt.application_id = PO_CONSTANTS_SV.APPLICATION_ID
80: AND zxlgt.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
81: AND zxlgt.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
82:
83:
84: -----------------------------------------------------------------------------
85: --Start of Comments

Line 331: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

327: ,zxvegt.message_text
328: ,'VALIDATE'
329: ,ph.segment1
330: FROM zx_validation_errors_gt zxvegt, po_headers_all ph
331: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
332: AND zxvegt.trx_id = ph.po_header_id;
333:
334: d_progress := 150;
335: INSERT INTO po_session_gt(

Line 356: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

352: ,'VALIDATE'
353: ,ph.segment1
354: FROM zx_validation_errors_gt zxvegt, po_headers_all ph,
355: po_releases_all pr
356: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
357: AND zxvegt.trx_id = pr.po_release_id
358: AND pr.po_header_id = ph.po_header_id;
359:
360: BEGIN

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

376: -- Delete data from zx gt tables for which defaulting/redefaulting failed
377: DELETE FROM zx_trx_headers_gt
378: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
379: WHERE psgt.key = l_po_session_gt_key
380: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
381: d_progress := 170;
382: DELETE FROM zx_transaction_lines_gt
383: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
384: WHERE psgt.key = l_po_session_gt_key

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

381: d_progress := 170;
382: DELETE FROM zx_transaction_lines_gt
383: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
384: WHERE psgt.key = l_po_session_gt_key
385: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
386:
387: ELSIF (p_calling_program <> 'COPY_DOCUMENT') THEN
388: d_progress := 180;
389: -- This API cannot handle the presence of COPY_AND_CREATE line level

Line 484: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

480: ,zxegt.message_text
481: ,'CALCULATE_TAX'
482: ,ph.segment1
483: FROM zx_errors_gt zxegt, po_headers_all ph
484: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
485: AND zxegt.trx_id = ph.po_header_id;
486:
487: d_progress := 240;
488: INSERT INTO po_session_gt(

Line 508: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

504: ,zxegt.message_text
505: ,'CALCULATE_TAX'
506: ,ph.segment1
507: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
508: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
509: AND zxegt.trx_id = pr.po_release_id
510: AND pr.po_header_id = ph.po_header_id;
511:
512: BEGIN

Line 532: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

528: -- Delete data from zx gt tables for which defaulting/redefaulting failed
529: DELETE FROM zx_trx_headers_gt
530: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
531: WHERE psgt.key = l_po_session_gt_key
532: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
533: AND psgt.char3 = 'CALCULATE_TAX');
534: d_progress := 260;
535: DELETE FROM zx_trx_headers_gt
536: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

Line 538: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

534: d_progress := 260;
535: DELETE FROM zx_trx_headers_gt
536: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
537: WHERE psgt.key = l_po_session_gt_key
538: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
539: AND psgt.char3 = 'CALCULATE_TAX');
540: d_progress := 270;
541: DELETE FROM zx_transaction_lines_gt
542: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

Line 544: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

540: d_progress := 270;
541: DELETE FROM zx_transaction_lines_gt
542: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
543: WHERE psgt.key = l_po_session_gt_key
544: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
545: AND psgt.char3 = 'CALCULATE_TAX');
546: d_progress := 280;
547: DELETE FROM zx_transaction_lines_gt
548: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

Line 550: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

546: d_progress := 280;
547: DELETE FROM zx_transaction_lines_gt
548: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
549: WHERE psgt.key = l_po_session_gt_key
550: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
551: AND psgt.char3 = 'CALCULATE_TAX');
552:
553: END IF; -- IF (l_count <> 0)
554:

Line 584: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

580: -- tax_attribute_update_code = 'CREATE'
581: UPDATE zx_trx_headers_gt zxhgt
582: SET zxhgt.event_type_code =
583: DECODE(zxhgt.event_class_code,
584: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
585: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
586: FROM DUAL
587: WHERE EXISTS
588: (SELECT 'Y'

Line 595: PO_CONSTANTS_SV.PO_REDISTRIBUTED,

591: AND (pd.tax_attribute_update_code <> 'CREATE'
592: OR pd.tax_attribute_update_code IS NULL)
593: )
594: ),
595: PO_CONSTANTS_SV.PO_REDISTRIBUTED,
596: PO_CONSTANTS_SV.PO_DISTRIBUTED
597: ),
598: --Release
599: NVL2((SELECT 'EXISTING DISTRIBUTIONS'

Line 596: PO_CONSTANTS_SV.PO_DISTRIBUTED

592: OR pd.tax_attribute_update_code IS NULL)
593: )
594: ),
595: PO_CONSTANTS_SV.PO_REDISTRIBUTED,
596: PO_CONSTANTS_SV.PO_DISTRIBUTED
597: ),
598: --Release
599: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
600: FROM DUAL

Line 609: PO_CONSTANTS_SV.REL_REDISTRIBUTED,

605: AND (pd.tax_attribute_update_code <> 'CREATE'
606: OR pd.tax_attribute_update_code IS NULL)
607: )
608: ),
609: PO_CONSTANTS_SV.REL_REDISTRIBUTED,
610: PO_CONSTANTS_SV.REL_DISTRIBUTED
611: )
612: );
613:

Line 610: PO_CONSTANTS_SV.REL_DISTRIBUTED

606: OR pd.tax_attribute_update_code IS NULL)
607: )
608: ),
609: PO_CONSTANTS_SV.REL_REDISTRIBUTED,
610: PO_CONSTANTS_SV.REL_DISTRIBUTED
611: )
612: );
613:
614: d_progress := 330;

Line 668: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

664: ,zxegt.message_text
665: ,'DETERMINE_RECOVERY'
666: ,ph.segment1
667: FROM zx_errors_gt zxegt, po_headers_all ph
668: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
669: AND zxegt.trx_id = ph.po_header_id;
670:
671: d_progress := 360;
672: INSERT INTO po_session_gt(

Line 692: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

688: ,zxegt.message_text
689: ,'DETERMINE_RECOVERY'
690: ,ph.segment1
691: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
692: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
693: AND zxegt.trx_id = pr.po_release_id
694: AND pr.po_header_id = ph.po_header_id;
695:
696: d_progress := 370;

Line 722: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

718: d_progress := 380;
719: DELETE FROM zx_itm_distributions_gt
720: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
721: WHERE psgt.key = l_po_session_gt_key
722: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
723: AND psgt.char3 = 'DETERMINE_RECOVERY');
724: d_progress := 390;
725: DELETE FROM zx_itm_distributions_gt
726: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

Line 728: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

724: d_progress := 390;
725: DELETE FROM zx_itm_distributions_gt
726: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
727: WHERE psgt.key = l_po_session_gt_key
728: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
729: AND psgt.char3 = 'DETERMINE_RECOVERY');
730:
731: d_progress := 400;
732: -- Update the distributions that errored out and yet have a tauc of null

Line 758: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

754: (SELECT SUM(zxdist.rec_nrec_tax_amt)
755: FROM zx_rec_nrec_dist zxdist
756: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
757: AND zxdist.recoverable_flag = 'Y'
758: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
759: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
760: AND zxdist.event_class_code =
761: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
762: AND zxdist.trx_id = pd.po_header_id)

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

755: FROM zx_rec_nrec_dist zxdist
756: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
757: AND zxdist.recoverable_flag = 'Y'
758: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
759: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
760: AND zxdist.event_class_code =
761: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
762: AND zxdist.trx_id = pd.po_header_id)
763: OR

Line 761: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

757: AND zxdist.recoverable_flag = 'Y'
758: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
759: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
760: AND zxdist.event_class_code =
761: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
762: AND zxdist.trx_id = pd.po_header_id)
763: OR
764: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
765: AND zxdist.event_class_code =

Line 764: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

760: AND zxdist.event_class_code =
761: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
762: AND zxdist.trx_id = pd.po_header_id)
763: OR
764: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
765: AND zxdist.event_class_code =
766: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
767: AND zxdist.trx_id = pd.po_release_id)))
768: ,pd.nonrecoverable_tax =

Line 766: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

762: AND zxdist.trx_id = pd.po_header_id)
763: OR
764: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
765: AND zxdist.event_class_code =
766: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
767: AND zxdist.trx_id = pd.po_release_id)))
768: ,pd.nonrecoverable_tax =
769: (SELECT SUM(zxdist.rec_nrec_tax_amt)
770: FROM zx_rec_nrec_dist zxdist

Line 773: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

769: (SELECT SUM(zxdist.rec_nrec_tax_amt)
770: FROM zx_rec_nrec_dist zxdist
771: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
772: AND zxdist.recoverable_flag = 'N'
773: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
774: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
775: AND zxdist.event_class_code =
776: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
777: AND zxdist.trx_id = pd.po_header_id)

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

770: FROM zx_rec_nrec_dist zxdist
771: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
772: AND zxdist.recoverable_flag = 'N'
773: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
774: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
775: AND zxdist.event_class_code =
776: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
777: AND zxdist.trx_id = pd.po_header_id)
778: OR

Line 776: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

772: AND zxdist.recoverable_flag = 'N'
773: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
774: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
775: AND zxdist.event_class_code =
776: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
777: AND zxdist.trx_id = pd.po_header_id)
778: OR
779: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
780: AND zxdist.event_class_code =

Line 779: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

775: AND zxdist.event_class_code =
776: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
777: AND zxdist.trx_id = pd.po_header_id)
778: OR
779: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
780: AND zxdist.event_class_code =
781: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
782: AND zxdist.trx_id = pd.po_release_id)))
783: WHERE pd.po_distribution_id IN

Line 781: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

777: AND zxdist.trx_id = pd.po_header_id)
778: OR
779: (zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
780: AND zxdist.event_class_code =
781: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
782: AND zxdist.trx_id = pd.po_release_id)))
783: WHERE pd.po_distribution_id IN
784: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
785:

Line 863: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

859: UPDATE po_line_locations_all pll
860: SET pll.taxable_flag =
861: DECODE((SELECT COUNT(1) FROM zx_lines zl
862: WHERE zl.trx_line_id = pll.line_location_id
863: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
864: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
865: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
866: AND zl.trx_id = pll.po_header_id)
867: OR

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

860: SET pll.taxable_flag =
861: DECODE((SELECT COUNT(1) FROM zx_lines zl
862: WHERE zl.trx_line_id = pll.line_location_id
863: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
864: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
865: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
866: AND zl.trx_id = pll.po_header_id)
867: OR
868: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

Line 865: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

861: DECODE((SELECT COUNT(1) FROM zx_lines zl
862: WHERE zl.trx_line_id = pll.line_location_id
863: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
864: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
865: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
866: AND zl.trx_id = pll.po_header_id)
867: OR
868: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
869: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

Line 868: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

864: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
865: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
866: AND zl.trx_id = pll.po_header_id)
867: OR
868: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
869: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
870: AND zl.trx_id = pll.po_release_id))),
871: 0, 'N',
872: 'Y'

Line 869: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

865: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
866: AND zl.trx_id = pll.po_header_id)
867: OR
868: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
869: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
870: AND zl.trx_id = pll.po_release_id))),
871: 0, 'N',
872: 'Y'
873: )

Line 883: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, PO_CONSTANTS_SV.PO,

879: -- Pour all errors in po_session_gt into global tax error record
880: SELECT
881: psgt.char3 --error_level
882: ,decode(psgt.char1,--document_type_code
883: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, PO_CONSTANTS_SV.PO,
884: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE, PO_CONSTANTS_SV.RELEASE
885: )
886: ,psgt.index_num1 --document_id
887: ,psgt.char4 --document_num

Line 884: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE, PO_CONSTANTS_SV.RELEASE

880: SELECT
881: psgt.char3 --error_level
882: ,decode(psgt.char1,--document_type_code
883: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, PO_CONSTANTS_SV.PO,
884: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE, PO_CONSTANTS_SV.RELEASE
885: )
886: ,psgt.index_num1 --document_id
887: ,psgt.char4 --document_num
888: ,null --line_id

Line 1231: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,

1227: -- Read validation errors from zx_validation_errors_gt into the global
1228: -- error record defined in the spec
1229: SELECT
1230: 'VALIDATE' --error_level,
1231: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,
1232: ,p_requisition_header_id --document_id,
1233: ,prh.segment1 --document_num,
1234: ,zxvegt.trx_line_id --line_id,
1235: ,prl.line_num --line_num,

Line 1342: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,

1338: -- Read validation errors from zx_errors_gt into the global
1339: -- error record defined in the spec
1340: SELECT
1341: 'CALCULATE_TAX' --error_level,
1342: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,
1343: ,p_requisition_header_id --document_id,
1344: ,prh.segment1 --document_num,
1345: ,zxegt.trx_line_id --line_id,
1346: ,prl.line_num --line_num,

Line 1402: SET event_type_code = PO_CONSTANTS_SV.REQ_DISTRIBUTED;

1398: IF (l_count <> 0) THEN
1399: d_progress := 230;
1400: -- Update event_type_code on zx headers as required by determine_recovery API
1401: UPDATE zx_trx_headers_gt
1402: SET event_type_code = PO_CONSTANTS_SV.REQ_DISTRIBUTED;
1403:
1404: d_progress := 240;
1405:
1406: -- Log table parameters

Line 1443: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,

1439: -- error record defined in the spec
1440: d_progress := 260;
1441: SELECT
1442: 'DETERMINE_RECOVERY' --error_level,
1443: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,
1444: ,p_requisition_header_id --document_id,
1445: ,prh.segment1 --document_num,
1446: ,zxegt.trx_line_id --line_id,
1447: ,prl.line_num --line_num,

Line 1487: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

1483: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1484: FROM zx_rec_nrec_dist_gt zxdist
1485: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1486: AND zxdist.recoverable_flag = 'Y'
1487: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1488: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1489: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1490: ,prd.nonrecoverable_tax =
1491: (SELECT SUM(zxdist.rec_nrec_tax_amt)

Line 1488: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

1484: FROM zx_rec_nrec_dist_gt zxdist
1485: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1486: AND zxdist.recoverable_flag = 'Y'
1487: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1488: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1489: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1490: ,prd.nonrecoverable_tax =
1491: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1492: FROM zx_rec_nrec_dist_gt zxdist

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

1485: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1486: AND zxdist.recoverable_flag = 'Y'
1487: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1488: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1489: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1490: ,prd.nonrecoverable_tax =
1491: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1492: FROM zx_rec_nrec_dist_gt zxdist
1493: WHERE zxdist.trx_line_dist_id = prd.distribution_id

Line 1495: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

1491: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1492: FROM zx_rec_nrec_dist_gt zxdist
1493: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1494: AND zxdist.recoverable_flag = 'N'
1495: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1496: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1497: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1498: WHERE prd.distribution_id IN
1499: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

Line 1496: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

1492: FROM zx_rec_nrec_dist_gt zxdist
1493: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1494: AND zxdist.recoverable_flag = 'N'
1495: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1496: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1497: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1498: WHERE prd.distribution_id IN
1499: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1500:

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

1493: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1494: AND zxdist.recoverable_flag = 'N'
1495: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1496: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1497: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1498: WHERE prd.distribution_id IN
1499: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1500:
1501: END IF; -- IF (l_count <> 0)

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

1515:
1516: d_progress := 310;
1517: -- Call global_document_update API to delete all data for this requistion
1518: l_trx_rec.internal_organization_id := l_org_id;
1519: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;
1520: l_trx_rec.entity_code := PO_CONSTANTS_SV.REQ_ENTITY_CODE;
1521: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
1522: l_trx_rec.event_type_code := PO_CONSTANTS_SV.REQ_DELETED;
1523: l_trx_rec.trx_id := p_requisition_header_id;

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

1516: d_progress := 310;
1517: -- Call global_document_update API to delete all data for this requistion
1518: l_trx_rec.internal_organization_id := l_org_id;
1519: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;
1520: l_trx_rec.entity_code := PO_CONSTANTS_SV.REQ_ENTITY_CODE;
1521: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
1522: l_trx_rec.event_type_code := PO_CONSTANTS_SV.REQ_DELETED;
1523: l_trx_rec.trx_id := p_requisition_header_id;
1524: l_trx_rec.application_doc_status := null;

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

1517: -- Call global_document_update API to delete all data for this requistion
1518: l_trx_rec.internal_organization_id := l_org_id;
1519: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;
1520: l_trx_rec.entity_code := PO_CONSTANTS_SV.REQ_ENTITY_CODE;
1521: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
1522: l_trx_rec.event_type_code := PO_CONSTANTS_SV.REQ_DELETED;
1523: l_trx_rec.trx_id := p_requisition_header_id;
1524: l_trx_rec.application_doc_status := null;
1525:

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

1518: l_trx_rec.internal_organization_id := l_org_id;
1519: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;
1520: l_trx_rec.entity_code := PO_CONSTANTS_SV.REQ_ENTITY_CODE;
1521: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
1522: l_trx_rec.event_type_code := PO_CONSTANTS_SV.REQ_DELETED;
1523: l_trx_rec.trx_id := p_requisition_header_id;
1524: l_trx_rec.application_doc_status := null;
1525:
1526: d_progress := 320;

Line 1763: ,PO_CONSTANTS_SV.PO --document_type_code,

1759: -- Read validation errors from zx_errors_gt into the global
1760: -- error record defined in the spec
1761: SELECT
1762: 'DETERMINE_RECOVERY' --error_level,
1763: ,PO_CONSTANTS_SV.PO --document_type_code,
1764: ,p_po_header_id --document_id,
1765: ,ph.segment1 --document_num,
1766: ,null --line_id,
1767: ,null --line_num,

Line 1805: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

1801: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1802: FROM zx_rec_nrec_dist zxdist
1803: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1804: AND zxdist.recoverable_flag = 'Y'
1805: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1806: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1807: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1808: ,pd.nonrecoverable_tax =
1809: (SELECT SUM(zxdist.rec_nrec_tax_amt)

Line 1806: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

1802: FROM zx_rec_nrec_dist zxdist
1803: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1804: AND zxdist.recoverable_flag = 'Y'
1805: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1806: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1807: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1808: ,pd.nonrecoverable_tax =
1809: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1810: FROM zx_rec_nrec_dist zxdist

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

1803: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1804: AND zxdist.recoverable_flag = 'Y'
1805: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1806: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1807: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1808: ,pd.nonrecoverable_tax =
1809: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1810: FROM zx_rec_nrec_dist zxdist
1811: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id

Line 1813: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

1809: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1810: FROM zx_rec_nrec_dist zxdist
1811: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1812: AND zxdist.recoverable_flag = 'N'
1813: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1814: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1815: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1816: WHERE pd.po_distribution_id IN
1817: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

Line 1814: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

1810: FROM zx_rec_nrec_dist zxdist
1811: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1812: AND zxdist.recoverable_flag = 'N'
1813: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1814: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1815: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1816: WHERE pd.po_distribution_id IN
1817: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1818:

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

1811: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1812: AND zxdist.recoverable_flag = 'N'
1813: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1814: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1815: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1816: WHERE pd.po_distribution_id IN
1817: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1818:
1819: /* Bug 6157632 Start */

Line 1824: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

1820: UPDATE po_line_locations_all pll
1821: SET pll.taxable_flag =
1822: DECODE((SELECT COUNT(1) FROM zx_lines zl
1823: WHERE zl.trx_line_id = pll.line_location_id
1824: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1825: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1826: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
1827: AND zl.trx_id = pll.po_header_id)
1828: OR

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

1821: SET pll.taxable_flag =
1822: DECODE((SELECT COUNT(1) FROM zx_lines zl
1823: WHERE zl.trx_line_id = pll.line_location_id
1824: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1825: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1826: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
1827: AND zl.trx_id = pll.po_header_id)
1828: OR
1829: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

Line 1826: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

1822: DECODE((SELECT COUNT(1) FROM zx_lines zl
1823: WHERE zl.trx_line_id = pll.line_location_id
1824: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1825: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1826: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
1827: AND zl.trx_id = pll.po_header_id)
1828: OR
1829: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
1830: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

Line 1829: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

1825: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1826: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
1827: AND zl.trx_id = pll.po_header_id)
1828: OR
1829: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
1830: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
1831: AND zl.trx_id = pll.po_release_id))),
1832: 0, 'N',
1833: 'Y'

Line 1830: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

1826: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
1827: AND zl.trx_id = pll.po_header_id)
1828: OR
1829: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
1830: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
1831: AND zl.trx_id = pll.po_release_id))),
1832: 0, 'N',
1833: 'Y'
1834: )

Line 1981: ,PO_CONSTANTS_SV.PO --document_type_code,

1977: -- Read validation errors from zx_errors_gt into the global
1978: -- error record defined in the spec
1979: SELECT
1980: 'DETERMINE_RECOVERY' --error_level,
1981: ,PO_CONSTANTS_SV.PO --document_type_code,
1982: ,p_po_release_id --document_id,
1983: ,ph.segment1 --document_num,
1984: ,null --line_id,
1985: ,null --line_num,

Line 2024: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

2020: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2021: FROM zx_rec_nrec_dist zxdist
2022: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2023: AND zxdist.recoverable_flag = 'Y'
2024: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2025: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2026: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2027: ,pd.nonrecoverable_tax =
2028: (SELECT SUM(zxdist.rec_nrec_tax_amt)

Line 2025: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

2021: FROM zx_rec_nrec_dist zxdist
2022: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2023: AND zxdist.recoverable_flag = 'Y'
2024: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2025: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2026: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2027: ,pd.nonrecoverable_tax =
2028: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2029: FROM zx_rec_nrec_dist zxdist

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

2022: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2023: AND zxdist.recoverable_flag = 'Y'
2024: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2025: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2026: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2027: ,pd.nonrecoverable_tax =
2028: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2029: FROM zx_rec_nrec_dist zxdist
2030: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id

Line 2032: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

2028: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2029: FROM zx_rec_nrec_dist zxdist
2030: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2031: AND zxdist.recoverable_flag = 'N'
2032: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2033: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2034: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2035: WHERE pd.po_distribution_id IN
2036: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

Line 2033: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

2029: FROM zx_rec_nrec_dist zxdist
2030: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2031: AND zxdist.recoverable_flag = 'N'
2032: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2033: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2034: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2035: WHERE pd.po_distribution_id IN
2036: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2037:

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

2030: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2031: AND zxdist.recoverable_flag = 'N'
2032: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2033: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2034: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2035: WHERE pd.po_distribution_id IN
2036: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2037:
2038: /* Bug 6157632 Start */

Line 2043: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

2039: UPDATE po_line_locations_all pll
2040: SET pll.taxable_flag =
2041: DECODE((SELECT COUNT(1) FROM zx_lines zl
2042: WHERE zl.trx_line_id = pll.line_location_id
2043: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2044: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2045: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2046: AND zl.trx_id = pll.po_header_id)
2047: OR

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

2040: SET pll.taxable_flag =
2041: DECODE((SELECT COUNT(1) FROM zx_lines zl
2042: WHERE zl.trx_line_id = pll.line_location_id
2043: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2044: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2045: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2046: AND zl.trx_id = pll.po_header_id)
2047: OR
2048: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

Line 2045: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

2041: DECODE((SELECT COUNT(1) FROM zx_lines zl
2042: WHERE zl.trx_line_id = pll.line_location_id
2043: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2044: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2045: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2046: AND zl.trx_id = pll.po_header_id)
2047: OR
2048: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2049: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

Line 2048: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

2044: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2045: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2046: AND zl.trx_id = pll.po_header_id)
2047: OR
2048: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2049: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
2050: AND zl.trx_id = pll.po_release_id))),
2051: 0, 'N',
2052: 'Y'

Line 2049: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE

2045: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2046: AND zl.trx_id = pll.po_header_id)
2047: OR
2048: (zl.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2049: AND zl.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
2050: AND zl.trx_id = pll.po_release_id))),
2051: 0, 'N',
2052: 'Y'
2053: )

Line 2204: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,

2200: -- Read validation errors from zx_errors_gt into the global
2201: -- error record defined in the spec
2202: SELECT
2203: 'DETERMINE_RECOVERY' --error_level,
2204: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,
2205: ,p_requisition_header_id --document_id,
2206: ,prh.segment1 --document_num,
2207: ,zxegt.trx_line_id --line_id,
2208: ,prl.line_num --line_num,

Line 2246: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

2242: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2243: FROM zx_rec_nrec_dist_gt zxdist
2244: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2245: AND zxdist.recoverable_flag = 'Y'
2246: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2247: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2248: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2249: ,prd.nonrecoverable_tax =
2250: (SELECT SUM(zxdist.rec_nrec_tax_amt)

Line 2247: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

2243: FROM zx_rec_nrec_dist_gt zxdist
2244: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2245: AND zxdist.recoverable_flag = 'Y'
2246: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2247: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2248: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2249: ,prd.nonrecoverable_tax =
2250: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2251: FROM zx_rec_nrec_dist_gt zxdist

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

2244: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2245: AND zxdist.recoverable_flag = 'Y'
2246: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2247: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2248: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2249: ,prd.nonrecoverable_tax =
2250: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2251: FROM zx_rec_nrec_dist_gt zxdist
2252: WHERE zxdist.trx_line_dist_id = prd.distribution_id

Line 2254: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID

2250: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2251: FROM zx_rec_nrec_dist_gt zxdist
2252: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2253: AND zxdist.recoverable_flag = 'N'
2254: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2255: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2256: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2257: WHERE prd.distribution_id IN
2258: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

Line 2255: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

2251: FROM zx_rec_nrec_dist_gt zxdist
2252: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2253: AND zxdist.recoverable_flag = 'N'
2254: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2255: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2256: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2257: WHERE prd.distribution_id IN
2258: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2259:

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

2252: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2253: AND zxdist.recoverable_flag = 'N'
2254: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2255: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2256: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2257: WHERE prd.distribution_id IN
2258: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2259:
2260: END IF; -- IF (l_count <> 0)

Line 2348: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id

2344: ,rndg_ship_from_party_site_id
2345: )
2346: SELECT
2347: ph.org_id --internal_organization_id
2348: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2349: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2350: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2351: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2352: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,

Line 2349: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code

2345: )
2346: SELECT
2347: ph.org_id --internal_organization_id
2348: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2349: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2350: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2351: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2352: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,
2353: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,

Line 2350: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code

2346: SELECT
2347: ph.org_id --internal_organization_id
2348: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2349: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2350: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2351: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2352: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,
2353: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,
2354: PO_CONSTANTS_SV.PO_ADJUSTED) --for null and 'UPDATE'

Line 2352: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,

2348: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2349: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2350: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2351: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2352: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,
2353: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,
2354: PO_CONSTANTS_SV.PO_ADJUSTED) --for null and 'UPDATE'
2355: ,ph.po_header_id --trx_id
2356: ,sysdate --trx_date

Line 2353: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,

2349: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2350: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2351: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2352: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,
2353: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,
2354: PO_CONSTANTS_SV.PO_ADJUSTED) --for null and 'UPDATE'
2355: ,ph.po_header_id --trx_id
2356: ,sysdate --trx_date
2357: ,ph.revision_num --trx_doc_revision

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

2350: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2351: ,DECODE(ph.tax_attribute_update_code, --event_type_code
2352: 'CREATE', PO_CONSTANTS_SV.PO_CREATED,
2353: 'COPY_AND_CREATE', PO_CONSTANTS_SV.PO_CREATED,
2354: PO_CONSTANTS_SV.PO_ADJUSTED) --for null and 'UPDATE'
2355: ,ph.po_header_id --trx_id
2356: ,sysdate --trx_date
2357: ,ph.revision_num --trx_doc_revision
2358: ,(SELECT set_of_books_id --ledger_id

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

2396: -- Note that the po_header_id is of current document being processed,
2397: -- not of any source document. Get the first row obtained from join
2398: -- with zx_lines_det_factors because that table is denormalized
2399: AND zxldet.trx_id(+) = ph.po_header_id
2400: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2401: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
2402: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2403: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
2404: AND rownum = 1;

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

2397: -- not of any source document. Get the first row obtained from join
2398: -- with zx_lines_det_factors because that table is denormalized
2399: AND zxldet.trx_id(+) = ph.po_header_id
2400: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2401: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
2402: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2403: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
2404: AND rownum = 1;
2405:

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

2398: -- with zx_lines_det_factors because that table is denormalized
2399: AND zxldet.trx_id(+) = ph.po_header_id
2400: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2401: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
2402: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2403: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
2404: AND rownum = 1;
2405:
2406: END populate_zx_headers_with_po;

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

2399: AND zxldet.trx_id(+) = ph.po_header_id
2400: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2401: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
2402: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
2403: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
2404: AND rownum = 1;
2405:
2406: END populate_zx_headers_with_po;
2407:

Line 2463: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id

2459: ,rndg_ship_from_party_site_id
2460: )
2461: SELECT
2462: ph.org_id --internal_organization_id
2463: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2464: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2465: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2466: ,PO_CONSTANTS_SV.PO_REDISTRIBUTED --event_type_code
2467: ,ph.po_header_id --trx_id

Line 2464: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code

2460: )
2461: SELECT
2462: ph.org_id --internal_organization_id
2463: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2464: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2465: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2466: ,PO_CONSTANTS_SV.PO_REDISTRIBUTED --event_type_code
2467: ,ph.po_header_id --trx_id
2468: ,sysdate --trx_date

Line 2465: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code

2461: SELECT
2462: ph.org_id --internal_organization_id
2463: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2464: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2465: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2466: ,PO_CONSTANTS_SV.PO_REDISTRIBUTED --event_type_code
2467: ,ph.po_header_id --trx_id
2468: ,sysdate --trx_date
2469: ,ph.revision_num --trx_doc_revision

Line 2466: ,PO_CONSTANTS_SV.PO_REDISTRIBUTED --event_type_code

2462: ph.org_id --internal_organization_id
2463: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2464: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2465: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2466: ,PO_CONSTANTS_SV.PO_REDISTRIBUTED --event_type_code
2467: ,ph.po_header_id --trx_id
2468: ,sysdate --trx_date
2469: ,ph.revision_num --trx_doc_revision
2470: ,(SELECT set_of_books_id --ledger_id

Line 2565: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id

2561: ,rndg_ship_from_party_site_id
2562: )
2563: SELECT
2564: pr.org_id --internal_organization_id
2565: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2566: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2567: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2568: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2569: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,

Line 2566: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code

2562: )
2563: SELECT
2564: pr.org_id --internal_organization_id
2565: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2566: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2567: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2568: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2569: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,
2570: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,

Line 2567: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code

2563: SELECT
2564: pr.org_id --internal_organization_id
2565: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2566: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2567: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2568: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2569: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,
2570: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,
2571: PO_CONSTANTS_SV.REL_ADJUSTED) -- for null and 'UPDATE'

Line 2569: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,

2565: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2566: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2567: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2568: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2569: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,
2570: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,
2571: PO_CONSTANTS_SV.REL_ADJUSTED) -- for null and 'UPDATE'
2572: ,pr.po_release_id --trx_id
2573: ,sysdate --trx_date

Line 2570: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,

2566: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2567: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2568: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2569: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,
2570: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,
2571: PO_CONSTANTS_SV.REL_ADJUSTED) -- for null and 'UPDATE'
2572: ,pr.po_release_id --trx_id
2573: ,sysdate --trx_date
2574: ,pr.revision_num --trx_doc_revision

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

2567: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2568: ,DECODE(pr.tax_attribute_update_code, --event_type_code
2569: 'CREATE', PO_CONSTANTS_SV.REL_CREATED,
2570: 'COPY_AND_CREATE', PO_CONSTANTS_SV.REL_CREATED,
2571: PO_CONSTANTS_SV.REL_ADJUSTED) -- for null and 'UPDATE'
2572: ,pr.po_release_id --trx_id
2573: ,sysdate --trx_date
2574: ,pr.revision_num --trx_doc_revision
2575: ,(select set_of_books_id --ledger_id

Line 2616: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

2612: -- ELSE simply copy from existing release header (ie. in case of a
2613: -- shipment split or regular blanket/scheduled release create/update
2614: LEFT OUTER JOIN zx_lines_det_factors zxldet
2615: ON ((pr.po_header_id = zxldet.trx_id
2616: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2617: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2618: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
2619: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
2620: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED

Line 2617: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code

2613: -- shipment split or regular blanket/scheduled release create/update
2614: LEFT OUTER JOIN zx_lines_det_factors zxldet
2615: ON ((pr.po_header_id = zxldet.trx_id
2616: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2617: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2618: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
2619: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
2620: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED
2621: AND pr.tax_attribute_update_code = 'CREATE')

Line 2618: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code

2614: LEFT OUTER JOIN zx_lines_det_factors zxldet
2615: ON ((pr.po_header_id = zxldet.trx_id
2616: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2617: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2618: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
2619: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
2620: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED
2621: AND pr.tax_attribute_update_code = 'CREATE')
2622: OR

Line 2619: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type

2615: ON ((pr.po_header_id = zxldet.trx_id
2616: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2617: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2618: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
2619: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
2620: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED
2621: AND pr.tax_attribute_update_code = 'CREATE')
2622: OR
2623: (pr.po_release_id = zxldet.trx_id

Line 2620: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED

2616: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2617: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2618: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
2619: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
2620: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED
2621: AND pr.tax_attribute_update_code = 'CREATE')
2622: OR
2623: (pr.po_release_id = zxldet.trx_id
2624: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

Line 2624: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

2620: AND pr.release_type = PO_CONSTANTS_SV.SCHEDULED
2621: AND pr.tax_attribute_update_code = 'CREATE')
2622: OR
2623: (pr.po_release_id = zxldet.trx_id
2624: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2625: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
2626: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
2627: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type)
2628: )

Line 2625: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code

2621: AND pr.tax_attribute_update_code = 'CREATE')
2622: OR
2623: (pr.po_release_id = zxldet.trx_id
2624: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2625: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
2626: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
2627: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type)
2628: )
2629: WHERE pr.po_release_id = p_po_release_id_tbl(i)

Line 2626: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code

2622: OR
2623: (pr.po_release_id = zxldet.trx_id
2624: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2625: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
2626: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
2627: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type)
2628: )
2629: WHERE pr.po_release_id = p_po_release_id_tbl(i)
2630: AND pr.po_header_id = ph.po_header_id

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

2623: (pr.po_release_id = zxldet.trx_id
2624: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2625: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
2626: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
2627: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type)
2628: )
2629: WHERE pr.po_release_id = p_po_release_id_tbl(i)
2630: AND pr.po_header_id = ph.po_header_id
2631: AND fc.currency_code = ph.currency_code

Line 2691: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id

2687: ,rndg_ship_from_party_site_id
2688: )
2689: SELECT
2690: pr.org_id --internal_organization_id
2691: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2692: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2693: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2694: ,PO_CONSTANTS_SV.REL_REDISTRIBUTED --event_type_code
2695: ,pr.po_release_id --trx_id

Line 2692: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code

2688: )
2689: SELECT
2690: pr.org_id --internal_organization_id
2691: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2692: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2693: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2694: ,PO_CONSTANTS_SV.REL_REDISTRIBUTED --event_type_code
2695: ,pr.po_release_id --trx_id
2696: ,sysdate --trx_date

Line 2693: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code

2689: SELECT
2690: pr.org_id --internal_organization_id
2691: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2692: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2693: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2694: ,PO_CONSTANTS_SV.REL_REDISTRIBUTED --event_type_code
2695: ,pr.po_release_id --trx_id
2696: ,sysdate --trx_date
2697: ,pr.revision_num --trx_doc_revision

Line 2694: ,PO_CONSTANTS_SV.REL_REDISTRIBUTED --event_type_code

2690: pr.org_id --internal_organization_id
2691: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2692: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
2693: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
2694: ,PO_CONSTANTS_SV.REL_REDISTRIBUTED --event_type_code
2695: ,pr.po_release_id --trx_id
2696: ,sysdate --trx_date
2697: ,pr.revision_num --trx_doc_revision
2698: ,(select set_of_books_id --ledger_id

Line 2782: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id

2778: ,icx_session_id
2779: )
2780: SELECT
2781: prh.org_id --internal_organization_id
2782: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2783: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
2784: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
2785: ,DECODE(p_calling_program, --event_type_code
2786: --If calling determine_recovery from ATI page flow

Line 2783: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code

2779: )
2780: SELECT
2781: prh.org_id --internal_organization_id
2782: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2783: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
2784: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
2785: ,DECODE(p_calling_program, --event_type_code
2786: --If calling determine_recovery from ATI page flow
2787: 'DETERMINE_RECOVERY_REQ', PO_CONSTANTS_SV.REQ_DISTRIBUTED,

Line 2784: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code

2780: SELECT
2781: prh.org_id --internal_organization_id
2782: ,PO_CONSTANTS_SV.APPLICATION_ID --application_id
2783: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
2784: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
2785: ,DECODE(p_calling_program, --event_type_code
2786: --If calling determine_recovery from ATI page flow
2787: 'DETERMINE_RECOVERY_REQ', PO_CONSTANTS_SV.REQ_DISTRIBUTED,
2788: --Regular UI flow

Line 2787: 'DETERMINE_RECOVERY_REQ', PO_CONSTANTS_SV.REQ_DISTRIBUTED,

2783: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
2784: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
2785: ,DECODE(p_calling_program, --event_type_code
2786: --If calling determine_recovery from ATI page flow
2787: 'DETERMINE_RECOVERY_REQ', PO_CONSTANTS_SV.REQ_DISTRIBUTED,
2788: --Regular UI flow
2789: PO_CONSTANTS_SV.REQ_CREATED)
2790: ,prh.requisition_header_id --trx_id
2791: ,sysdate --trx_date

Line 2789: PO_CONSTANTS_SV.REQ_CREATED)

2785: ,DECODE(p_calling_program, --event_type_code
2786: --If calling determine_recovery from ATI page flow
2787: 'DETERMINE_RECOVERY_REQ', PO_CONSTANTS_SV.REQ_DISTRIBUTED,
2788: --Regular UI flow
2789: PO_CONSTANTS_SV.REQ_CREATED)
2790: ,prh.requisition_header_id --trx_id
2791: ,sysdate --trx_date
2792: ,(select set_of_books_id --ledger_id
2793: from financials_system_params_all where org_id=prh.org_id)

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

2805: -- Note that the req_header_id is of current document being processed,
2806: -- not of any source document. Get the first row obtained from join
2807: -- with zx_lines_det_factors because that table is denormalized
2808: AND zxldet.trx_id(+) = prh.requisition_header_id
2809: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2810: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2811: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
2812: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
2813: AND rownum = 1;

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

2806: -- not of any source document. Get the first row obtained from join
2807: -- with zx_lines_det_factors because that table is denormalized
2808: AND zxldet.trx_id(+) = prh.requisition_header_id
2809: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2810: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2811: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
2812: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
2813: AND rownum = 1;
2814:

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

2807: -- with zx_lines_det_factors because that table is denormalized
2808: AND zxldet.trx_id(+) = prh.requisition_header_id
2809: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2810: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2811: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
2812: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
2813: AND rownum = 1;
2814:
2815: END populate_zx_headers_with_req;

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

2808: AND zxldet.trx_id(+) = prh.requisition_header_id
2809: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2810: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2811: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
2812: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
2813: AND rownum = 1;
2814:
2815: END populate_zx_headers_with_req;
2816:

Line 2912: PO_CONSTANTS_SV.APPLICATION_ID --application_id

2908: ,user_upd_det_factors_flag --Bug 5632300
2909: ,defaulting_attribute1 --Bug#6902111
2910: )
2911: SELECT
2912: PO_CONSTANTS_SV.APPLICATION_ID --application_id
2913: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2914: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2915: ,ph.po_header_id --trx_id
2916: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

Line 2913: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code

2909: ,defaulting_attribute1 --Bug#6902111
2910: )
2911: SELECT
2912: PO_CONSTANTS_SV.APPLICATION_ID --application_id
2913: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2914: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2915: ,ph.po_header_id --trx_id
2916: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
2917: ,pll.line_location_id --trx_line_id

Line 2914: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code

2910: )
2911: SELECT
2912: PO_CONSTANTS_SV.APPLICATION_ID --application_id
2913: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2914: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2915: ,ph.po_header_id --trx_id
2916: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
2917: ,pll.line_location_id --trx_line_id
2918: ,pll.tax_attribute_update_code --line_level_action

Line 2916: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

2912: PO_CONSTANTS_SV.APPLICATION_ID --application_id
2913: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
2914: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
2915: ,ph.po_header_id --trx_id
2916: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
2917: ,pll.line_location_id --trx_line_id
2918: ,pll.tax_attribute_update_code --line_level_action
2919: ,DECODE(pll.shipment_type,--line_class
2920: 'PREPAYMENT', DECODE(pll.payment_type,

Line 3026: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,

3022: -- Tax attributes when the attributes are overridden in requisition.
3023: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
3024: -- and 'PORELGEB'
3025: ,DECODE(p_calling_program, --source_application_id
3026: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3027: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3028: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3029: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3030: null)

Line 3027: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,

3023: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
3024: -- and 'PORELGEB'
3025: ,DECODE(p_calling_program, --source_application_id
3026: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3027: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3028: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3029: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3030: null)
3031: ,DECODE(p_calling_program, --source_entity_code

Line 3028: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,

3024: -- and 'PORELGEB'
3025: ,DECODE(p_calling_program, --source_application_id
3026: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3027: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3028: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3029: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3030: null)
3031: ,DECODE(p_calling_program, --source_entity_code
3032: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,

Line 3029: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,

3025: ,DECODE(p_calling_program, --source_application_id
3026: 'COPY_DOCUMENT', PO_CONSTANTS_SV.APPLICATION_ID,
3027: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3028: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3029: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3030: null)
3031: ,DECODE(p_calling_program, --source_entity_code
3032: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3033: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

Line 3032: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,

3028: 'AUTOCREATED_DOC_WF' ,PO_CONSTANTS_SV.APPLICATION_ID,
3029: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3030: null)
3031: ,DECODE(p_calling_program, --source_entity_code
3032: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3033: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3034: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3035: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3036: null)

Line 3033: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3029: 'PORELGEB',PO_CONSTANTS_SV.APPLICATION_ID,
3030: null)
3031: ,DECODE(p_calling_program, --source_entity_code
3032: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3033: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3034: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3035: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3036: null)
3037: ,DECODE(p_calling_program, --source_event_class_code

Line 3034: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3030: null)
3031: ,DECODE(p_calling_program, --source_entity_code
3032: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3033: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3034: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3035: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3036: null)
3037: ,DECODE(p_calling_program, --source_event_class_code
3038: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

Line 3035: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3031: ,DECODE(p_calling_program, --source_entity_code
3032: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_ENTITY_CODE,
3033: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3034: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3035: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3036: null)
3037: ,DECODE(p_calling_program, --source_event_class_code
3038: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3039: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

Line 3038: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

3034: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3035: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3036: null)
3037: ,DECODE(p_calling_program, --source_event_class_code
3038: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3039: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3040: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3041: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3042: null)

Line 3039: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3035: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3036: null)
3037: ,DECODE(p_calling_program, --source_event_class_code
3038: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3039: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3040: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3041: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3042: null)
3043: ,DECODE(p_calling_program, -- source_trx_id

Line 3040: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3036: null)
3037: ,DECODE(p_calling_program, --source_event_class_code
3038: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3039: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3040: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3041: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3042: null)
3043: ,DECODE(p_calling_program, -- source_trx_id
3044: 'COPY_DOCUMENT', (SELECT source_shipment.po_header_id --source_trx_id

Line 3041: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3037: ,DECODE(p_calling_program, --source_event_class_code
3038: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3039: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3040: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3041: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3042: null)
3043: ,DECODE(p_calling_program, -- source_trx_id
3044: 'COPY_DOCUMENT', (SELECT source_shipment.po_header_id --source_trx_id
3045: FROM po_line_locations_all source_shipment

Line 3084: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

3080: WHERE prl.line_location_id = pll.line_location_id
3081: AND p_calling_program = 'PORELGEB'),
3082: null)
3083: ,DECODE(p_calling_program, --source_trx_level_type
3084: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3085: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3086: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3087: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3088: null)

Line 3085: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3081: AND p_calling_program = 'PORELGEB'),
3082: null)
3083: ,DECODE(p_calling_program, --source_trx_level_type
3084: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3085: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3086: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3087: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3088: null)
3089: ,pll.price_override --unit_price

Line 3086: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3082: null)
3083: ,DECODE(p_calling_program, --source_trx_level_type
3084: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3085: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3086: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3087: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3088: null)
3089: ,pll.price_override --unit_price
3090: ,null --ref_doc_trx_level_type

Line 3087: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3083: ,DECODE(p_calling_program, --source_trx_level_type
3084: 'COPY_DOCUMENT', PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3085: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3086: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3087: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3088: null)
3089: ,pll.price_override --unit_price
3090: ,null --ref_doc_trx_level_type
3091: -- Bug 5025018. Updated tax attribute mappings

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

3112: -- entail bringing the source_header_id for the shipment being currently
3113: -- processed. Join with trx_line_id itself is unique because the document
3114: -- type has been classified with event_class_code and line_location_id
3115: -- will always be unique whether PO shipment or Release shipment
3116: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3117: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3118: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3119: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3120: AND zxldet.trx_line_id(+) = pll.original_shipment_id

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

3113: -- processed. Join with trx_line_id itself is unique because the document
3114: -- type has been classified with event_class_code and line_location_id
3115: -- will always be unique whether PO shipment or Release shipment
3116: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3117: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3118: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3119: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3120: AND zxldet.trx_line_id(+) = pll.original_shipment_id
3121: -- Join with vendor tables to get party and party site information

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

3114: -- type has been classified with event_class_code and line_location_id
3115: -- will always be unique whether PO shipment or Release shipment
3116: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3117: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3118: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3119: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3120: AND zxldet.trx_line_id(+) = pll.original_shipment_id
3121: -- Join with vendor tables to get party and party site information
3122: AND pv.vendor_id(+) = ph.vendor_id

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

3115: -- will always be unique whether PO shipment or Release shipment
3116: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3117: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
3118: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
3119: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
3120: AND zxldet.trx_line_id(+) = pll.original_shipment_id
3121: -- Join with vendor tables to get party and party site information
3122: AND pv.vendor_id(+) = ph.vendor_id
3123: AND pvs.vendor_site_id(+) = ph.vendor_site_id

Line 3227: PO_CONSTANTS_SV.APPLICATION_ID --application_id

3223: ,ship_to_party_id
3224: ,defaulting_attribute1 --Bug#6902111
3225: )
3226: SELECT
3227: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3228: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3229: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3230: ,pr.po_release_id --trx_id
3231: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

Line 3228: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code

3224: ,defaulting_attribute1 --Bug#6902111
3225: )
3226: SELECT
3227: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3228: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3229: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3230: ,pr.po_release_id --trx_id
3231: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
3232: ,pll.line_location_id --trx_line_id

Line 3229: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code

3225: )
3226: SELECT
3227: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3228: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3229: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3230: ,pr.po_release_id --trx_id
3231: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
3232: ,pll.line_location_id --trx_line_id
3233: ,pll.tax_attribute_update_code --line_level_action

Line 3231: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

3227: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3228: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3229: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3230: ,pr.po_release_id --trx_id
3231: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
3232: ,pll.line_location_id --trx_line_id
3233: ,pll.tax_attribute_update_code --line_level_action
3234: ,DECODE(pll.shipment_type,--line_class
3235: 'PREPAYMENT', DECODE(pll.payment_type,

Line 3282: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.APPLICATION_ID,

3278: msib.expense_account
3279: )
3280: -- If scheduled release, pass Planned PO as a reference
3281: ,DECODE(pr.release_type, --ref_doc_application_id
3282: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.APPLICATION_ID,
3283: null)
3284: ,DECODE(pr.release_type, --ref_doc_entity_code
3285: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,
3286: null)

Line 3285: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,

3281: ,DECODE(pr.release_type, --ref_doc_application_id
3282: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.APPLICATION_ID,
3283: null)
3284: ,DECODE(pr.release_type, --ref_doc_entity_code
3285: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,
3286: null)
3287: ,DECODE(pr.release_type, --ref_doc_event_class_code
3288: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3289: null)

Line 3288: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

3284: ,DECODE(pr.release_type, --ref_doc_entity_code
3285: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_ENTITY_CODE,
3286: null)
3287: ,DECODE(pr.release_type, --ref_doc_event_class_code
3288: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3289: null)
3290: ,DECODE(pr.release_type, --ref_doc_trx_id
3291: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,
3292: null)

Line 3291: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,

3287: ,DECODE(pr.release_type, --ref_doc_event_class_code
3288: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
3289: null)
3290: ,DECODE(pr.release_type, --ref_doc_trx_id
3291: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,
3292: null)
3293: ,DECODE(pr.release_type, --ref_doc_line_id
3294: PO_CONSTANTS_SV.SCHEDULED, pll.po_line_id,
3295: null)

Line 3294: PO_CONSTANTS_SV.SCHEDULED, pll.po_line_id,

3290: ,DECODE(pr.release_type, --ref_doc_trx_id
3291: PO_CONSTANTS_SV.SCHEDULED, pr.po_header_id,
3292: null)
3293: ,DECODE(pr.release_type, --ref_doc_line_id
3294: PO_CONSTANTS_SV.SCHEDULED, pll.po_line_id,
3295: null)
3296: ,pl.line_num --line_trx_user_key1
3297: ,PO_LOCATIONS_S.get_location_code(pll.ship_to_location_id) --line_trx_user_key2
3298: ,DECODE(pll.payment_type, --trx_line_number

Line 3327: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,

3323: -- Tax attributes when the attributes are overridden in requisition.
3324: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
3325: -- and 'PORELGEB'
3326: ,DECODE(p_calling_program, --source_application_id
3327: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3328: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
3329: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
3330: null)
3331: ,DECODE(p_calling_program, --source_entity_code

Line 3328: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,

3324: -- Calling program for autocreate is 'POXBWVRP_PO','AUTOCREATED_DOC_WF'
3325: -- and 'PORELGEB'
3326: ,DECODE(p_calling_program, --source_application_id
3327: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3328: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
3329: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
3330: null)
3331: ,DECODE(p_calling_program, --source_entity_code
3332: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

Line 3329: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,

3325: -- and 'PORELGEB'
3326: ,DECODE(p_calling_program, --source_application_id
3327: 'POXBWVRP_PO', PO_CONSTANTS_SV.APPLICATION_ID,
3328: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
3329: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
3330: null)
3331: ,DECODE(p_calling_program, --source_entity_code
3332: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3333: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

Line 3332: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3328: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.APPLICATION_ID,
3329: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
3330: null)
3331: ,DECODE(p_calling_program, --source_entity_code
3332: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3333: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3334: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3335: null)
3336: ,DECODE(p_calling_program, --source_event_class_code

Line 3333: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3329: 'PORELGEB', PO_CONSTANTS_SV.APPLICATION_ID,
3330: null)
3331: ,DECODE(p_calling_program, --source_entity_code
3332: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3333: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3334: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3335: null)
3336: ,DECODE(p_calling_program, --source_event_class_code
3337: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

Line 3334: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,

3330: null)
3331: ,DECODE(p_calling_program, --source_entity_code
3332: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3333: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3334: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3335: null)
3336: ,DECODE(p_calling_program, --source_event_class_code
3337: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3338: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

Line 3337: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3333: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3334: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3335: null)
3336: ,DECODE(p_calling_program, --source_event_class_code
3337: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3338: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3339: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3340: null)
3341: ,DECODE(p_calling_program, -- source_trx_id

Line 3338: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3334: 'PORELGEB', PO_CONSTANTS_SV.REQ_ENTITY_CODE,
3335: null)
3336: ,DECODE(p_calling_program, --source_event_class_code
3337: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3338: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3339: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3340: null)
3341: ,DECODE(p_calling_program, -- source_trx_id
3342: 'POXBWVRP_PO', (SELECT requisition_header_id FROM

Line 3339: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,

3335: null)
3336: ,DECODE(p_calling_program, --source_event_class_code
3337: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3338: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3339: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3340: null)
3341: ,DECODE(p_calling_program, -- source_trx_id
3342: 'POXBWVRP_PO', (SELECT requisition_header_id FROM
3343: po_requisition_lines_all

Line 3376: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3372: WHERE prl.line_location_id = pll.line_location_id
3373: AND p_calling_program = 'PORELGEB'),
3374: null)
3375: ,DECODE(p_calling_program, --source_trx_level_type
3376: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3377: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3378: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3379: null)
3380: ,pll.price_override --unit_price

Line 3377: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3373: AND p_calling_program = 'PORELGEB'),
3374: null)
3375: ,DECODE(p_calling_program, --source_trx_level_type
3376: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3377: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3378: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3379: null)
3380: ,pll.price_override --unit_price
3381: ,DECODE(pr.release_type, --ref_doc_trx_level_type

Line 3378: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,

3374: null)
3375: ,DECODE(p_calling_program, --source_trx_level_type
3376: 'POXBWVRP_PO', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3377: 'AUTOCREATED_DOC_WF', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3378: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3379: null)
3380: ,pll.price_override --unit_price
3381: ,DECODE(pr.release_type, --ref_doc_trx_level_type
3382: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

Line 3382: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

3378: 'PORELGEB', PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE ,
3379: null)
3380: ,pll.price_override --unit_price
3381: ,DECODE(pr.release_type, --ref_doc_trx_level_type
3382: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3383: null)
3384: -- Bug 5025018. Updated tax attribute mappings
3385: ,DECODE(pr.release_type, --ref_doc_line_quantity
3386: PO_CONSTANTS_SV.SCHEDULED, pll.quantity,

Line 3386: PO_CONSTANTS_SV.SCHEDULED, pll.quantity,

3382: PO_CONSTANTS_SV.SCHEDULED, PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
3383: null)
3384: -- Bug 5025018. Updated tax attribute mappings
3385: ,DECODE(pr.release_type, --ref_doc_line_quantity
3386: PO_CONSTANTS_SV.SCHEDULED, pll.quantity,
3387: null)
3388: ,pov.vendor_id --ship_third_pty_acct_id
3389: ,pov.vendor_id --bill_third_pty_acct_id
3390: ,pvs.vendor_site_id --ship_third_pty_acct_site_id

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

3412: -- because the document type has been classified with
3413: -- event_class_code and line_location_id will always be unique
3414: -- whether PO shipment or Release shipment
3415: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
3416: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3417: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
3418: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
3419: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
3420: AND pll.original_shipment_id = zxldet.trx_line_id

Line 3417: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code

3413: -- event_class_code and line_location_id will always be unique
3414: -- whether PO shipment or Release shipment
3415: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
3416: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3417: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
3418: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
3419: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
3420: AND pll.original_shipment_id = zxldet.trx_line_id
3421: AND pll.original_shipment_id IS NOT NULL)

Line 3418: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code

3414: -- whether PO shipment or Release shipment
3415: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
3416: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3417: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
3418: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
3419: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
3420: AND pll.original_shipment_id = zxldet.trx_line_id
3421: AND pll.original_shipment_id IS NOT NULL)
3422: OR

Line 3419: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type

3415: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
3416: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3417: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
3418: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
3419: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
3420: AND pll.original_shipment_id = zxldet.trx_line_id
3421: AND pll.original_shipment_id IS NOT NULL)
3422: OR
3423: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

Line 3423: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id

3419: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type
3420: AND pll.original_shipment_id = zxldet.trx_line_id
3421: AND pll.original_shipment_id IS NOT NULL)
3422: OR
3423: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3424: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
3425: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
3426: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
3427: AND pll.source_shipment_id = zxldet.trx_line_id

Line 3424: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code

3420: AND pll.original_shipment_id = zxldet.trx_line_id
3421: AND pll.original_shipment_id IS NOT NULL)
3422: OR
3423: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3424: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
3425: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
3426: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
3427: AND pll.source_shipment_id = zxldet.trx_line_id
3428: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED

Line 3425: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code

3421: AND pll.original_shipment_id IS NOT NULL)
3422: OR
3423: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3424: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
3425: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
3426: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
3427: AND pll.source_shipment_id = zxldet.trx_line_id
3428: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED
3429: AND pll.tax_attribute_update_code = 'CREATE'

Line 3426: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type

3422: OR
3423: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3424: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
3425: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
3426: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
3427: AND pll.source_shipment_id = zxldet.trx_line_id
3428: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED
3429: AND pll.tax_attribute_update_code = 'CREATE'
3430: AND pll.original_shipment_id IS NULL)

Line 3428: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED

3424: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
3425: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code
3426: AND PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE = zxldet.trx_level_type
3427: AND pll.source_shipment_id = zxldet.trx_line_id
3428: AND pll.shipment_type = PO_CONSTANTS_SV.SCHEDULED
3429: AND pll.tax_attribute_update_code = 'CREATE'
3430: AND pll.original_shipment_id IS NULL)
3431: )
3432: WHERE pr.po_release_id = pll.po_release_id

Line 3553: PO_CONSTANTS_SV.APPLICATION_ID --application_id

3549: ,user_upd_det_factors_flag --Bug 5632300
3550: ,defaulting_attribute1 --Bug#6902111
3551: )
3552: SELECT
3553: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3554: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
3555: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
3556: ,prl.requisition_header_id --trx_id
3557: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type

Line 3554: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code

3550: ,defaulting_attribute1 --Bug#6902111
3551: )
3552: SELECT
3553: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3554: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
3555: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
3556: ,prl.requisition_header_id --trx_id
3557: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type
3558: ,prl.requisition_line_id --trx_line_id

Line 3555: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code

3551: )
3552: SELECT
3553: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3554: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
3555: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
3556: ,prl.requisition_header_id --trx_id
3557: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type
3558: ,prl.requisition_line_id --trx_line_id
3559: ,'INVOICE' --line_class

Line 3557: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type

3553: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3554: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
3555: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
3556: ,prl.requisition_header_id --trx_id
3557: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type
3558: ,prl.requisition_line_id --trx_line_id
3559: ,'INVOICE' --line_class
3560: ,nvl(prl.tax_attribute_update_code,'UPDATE') --line_level_action
3561: ,'ITEM' --trx_line_type

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

3673: -- entail bringing the source_header_id for the shipment being currently
3674: -- processed. Join with trx_line_id itself is unique because the document
3675: -- type has been classified with event_class_code and requisition_line_id
3676: -- will always be unique
3677: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3678: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
3679: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
3680: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
3681: AND zxldet.trx_line_id(+) = prl.parent_req_line_id

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

3674: -- processed. Join with trx_line_id itself is unique because the document
3675: -- type has been classified with event_class_code and requisition_line_id
3676: -- will always be unique
3677: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3678: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
3679: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
3680: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
3681: AND zxldet.trx_line_id(+) = prl.parent_req_line_id
3682: -- Join with vendor tables to get party and party site information

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

3675: -- type has been classified with event_class_code and requisition_line_id
3676: -- will always be unique
3677: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3678: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
3679: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
3680: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
3681: AND zxldet.trx_line_id(+) = prl.parent_req_line_id
3682: -- Join with vendor tables to get party and party site information
3683: AND pv.vendor_id(+) = prl.vendor_id

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

3676: -- will always be unique
3677: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
3678: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
3679: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE
3680: AND zxldet.trx_level_type(+) = PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE
3681: AND zxldet.trx_line_id(+) = prl.parent_req_line_id
3682: -- Join with vendor tables to get party and party site information
3683: AND pv.vendor_id(+) = prl.vendor_id
3684: AND pvs.vendor_site_id(+) = prl.vendor_site_id

Line 3758: PO_CONSTANTS_SV.APPLICATION_ID --application_id

3754: ,currency_exchange_rate
3755: ,overriding_recovery_rate
3756: )
3757: SELECT
3758: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3759: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3760: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3761: ,pd1.po_header_id --trx_id
3762: ,pll.line_location_id --trx_line_id

Line 3759: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code

3755: ,overriding_recovery_rate
3756: )
3757: SELECT
3758: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3759: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3760: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3761: ,pd1.po_header_id --trx_id
3762: ,pll.line_location_id --trx_line_id
3763: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

Line 3760: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code

3756: )
3757: SELECT
3758: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3759: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3760: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3761: ,pd1.po_header_id --trx_id
3762: ,pll.line_location_id --trx_line_id
3763: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
3764: ,pd1.po_distribution_id --trx_line_dist_id

Line 3763: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

3759: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3760: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3761: ,pd1.po_header_id --trx_id
3762: ,pll.line_location_id --trx_line_id
3763: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
3764: ,pd1.po_distribution_id --trx_line_dist_id
3765: ,NVL(pd1.tax_attribute_update_code, 'NO_ACTION') --dist_level_action
3766: ,sysdate --trx_line_dist_date
3767: ,pd1.distribution_num --item_dist_number

Line 3797: WHERE event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);

3793: OR pll.tax_attribute_update_code IS NOT NULL
3794: )
3795: AND pd1.po_header_id IN
3796: (SELECT trx_id FROM zx_trx_headers_gt
3797: WHERE event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
3798:
3799: END populate_zx_dists_with_po;
3800:
3801:

Line 3850: PO_CONSTANTS_SV.APPLICATION_ID --application_id

3846: ,currency_exchange_rate
3847: ,overriding_recovery_rate
3848: )
3849: SELECT
3850: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3851: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3852: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3853: ,pd.po_header_id --trx_id
3854: ,pll.line_location_id --trx_line_id

Line 3851: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code

3847: ,overriding_recovery_rate
3848: )
3849: SELECT
3850: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3851: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3852: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3853: ,pd.po_header_id --trx_id
3854: ,pll.line_location_id --trx_line_id
3855: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

Line 3852: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code

3848: )
3849: SELECT
3850: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3851: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3852: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3853: ,pd.po_header_id --trx_id
3854: ,pll.line_location_id --trx_line_id
3855: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
3856: ,pd.po_distribution_id --trx_line_dist_id

Line 3855: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type

3851: ,PO_CONSTANTS_SV.PO_ENTITY_CODE --entity_code
3852: ,PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE --event_class_code
3853: ,pd.po_header_id --trx_id
3854: ,pll.line_location_id --trx_line_id
3855: ,PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE --trx_level_type
3856: ,pd.po_distribution_id --trx_line_dist_id
3857: ,'NO_ACTION' --dist_level_action
3858: ,sysdate --trx_line_dist_date
3859: ,pd.distribution_num --item_dist_number

Line 3946: PO_CONSTANTS_SV.APPLICATION_ID --application_id

3942: ,currency_exchange_rate
3943: ,overriding_recovery_rate
3944: )
3945: SELECT
3946: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3947: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3948: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3949: ,pd1.po_release_id --trx_id
3950: ,pll.line_location_id --trx_line_id

Line 3947: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code

3943: ,overriding_recovery_rate
3944: )
3945: SELECT
3946: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3947: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3948: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3949: ,pd1.po_release_id --trx_id
3950: ,pll.line_location_id --trx_line_id
3951: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

Line 3948: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code

3944: )
3945: SELECT
3946: PO_CONSTANTS_SV.APPLICATION_ID --application_id
3947: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3948: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3949: ,pd1.po_release_id --trx_id
3950: ,pll.line_location_id --trx_line_id
3951: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
3952: ,pd1.po_distribution_id --trx_line_dist_id

Line 3951: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

3947: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
3948: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
3949: ,pd1.po_release_id --trx_id
3950: ,pll.line_location_id --trx_line_id
3951: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
3952: ,pd1.po_distribution_id --trx_line_dist_id
3953: ,nvl(pd1.tax_attribute_update_code, 'NO_ACTION') --dist_level_action
3954: ,sysdate --trx_line_dist_date
3955: ,pd1.distribution_num --item_dist_number

Line 3985: WHERE event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE);

3981: OR pll.tax_attribute_update_code IS NOT NULL
3982: )
3983: AND pd1.po_release_id IN
3984: (SELECT trx_id FROM zx_trx_headers_gt
3985: WHERE event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE);
3986:
3987: END populate_zx_dists_with_rel;
3988:
3989:

Line 4038: PO_CONSTANTS_SV.APPLICATION_ID --application_id

4034: ,currency_exchange_rate
4035: ,overriding_recovery_rate
4036: )
4037: SELECT
4038: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4039: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4040: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4041: ,pd.po_release_id --trx_id
4042: ,pll.line_location_id --trx_line_id

Line 4039: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code

4035: ,overriding_recovery_rate
4036: )
4037: SELECT
4038: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4039: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4040: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4041: ,pd.po_release_id --trx_id
4042: ,pll.line_location_id --trx_line_id
4043: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

Line 4040: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code

4036: )
4037: SELECT
4038: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4039: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4040: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4041: ,pd.po_release_id --trx_id
4042: ,pll.line_location_id --trx_line_id
4043: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
4044: ,pd.po_distribution_id --trx_line_dist_id

Line 4043: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type

4039: ,PO_CONSTANTS_SV.REL_ENTITY_CODE --entity_code
4040: ,PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE --event_class_code
4041: ,pd.po_release_id --trx_id
4042: ,pll.line_location_id --trx_line_id
4043: ,PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE --trx_level_type
4044: ,pd.po_distribution_id --trx_line_dist_id
4045: ,'NO_ACTION' --dist_level_action
4046: ,sysdate --trx_line_dist_date
4047: ,pd.distribution_num --item_dist_number

Line 4128: PO_CONSTANTS_SV.APPLICATION_ID --application_id

4124: ,account_ccid
4125: ,historical_flag
4126: ,overriding_recovery_rate)
4127: SELECT
4128: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4129: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
4130: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
4131: ,prl.requisition_header_id --trx_id
4132: ,prl.requisition_line_id --trx_line_id

Line 4129: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code

4125: ,historical_flag
4126: ,overriding_recovery_rate)
4127: SELECT
4128: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4129: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
4130: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
4131: ,prl.requisition_header_id --trx_id
4132: ,prl.requisition_line_id --trx_line_id
4133: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type

Line 4130: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code

4126: ,overriding_recovery_rate)
4127: SELECT
4128: PO_CONSTANTS_SV.APPLICATION_ID --application_id
4129: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
4130: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
4131: ,prl.requisition_header_id --trx_id
4132: ,prl.requisition_line_id --trx_line_id
4133: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type
4134: ,prd.distribution_id --trx_line_dist_id

Line 4133: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type

4129: ,PO_CONSTANTS_SV.REQ_ENTITY_CODE --entity_code
4130: ,PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE --event_class_code
4131: ,prl.requisition_header_id --trx_id
4132: ,prl.requisition_line_id --trx_line_id
4133: ,PO_CONSTANTS_SV.REQ_TRX_LEVEL_TYPE --trx_level_type
4134: ,prd.distribution_id --trx_line_dist_id
4135: ,'CREATE' --dist_level_action
4136: ,sysdate --trx_line_dist_date
4137: ,prd.distribution_num --item_dist_number

Line 4567: PO_CONSTANTS_SV.APPLICATION_ID, --application_id

4563: line_amt,
4564: line_amt_includes_tax_flag
4565: )
4566: SELECT
4567: PO_CONSTANTS_SV.APPLICATION_ID, --application_id
4568: PO_CONSTANTS_SV.PO_ENTITY_CODE, --entity_code
4569: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, --event_class_code
4570: p_po_header_id, --trx_id
4571: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE, --trx_level_type

Line 4568: PO_CONSTANTS_SV.PO_ENTITY_CODE, --entity_code

4564: line_amt_includes_tax_flag
4565: )
4566: SELECT
4567: PO_CONSTANTS_SV.APPLICATION_ID, --application_id
4568: PO_CONSTANTS_SV.PO_ENTITY_CODE, --entity_code
4569: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, --event_class_code
4570: p_po_header_id, --trx_id
4571: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE, --trx_level_type
4572: p_del_shipment_table(i), --trx_line_id

Line 4569: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, --event_class_code

4565: )
4566: SELECT
4567: PO_CONSTANTS_SV.APPLICATION_ID, --application_id
4568: PO_CONSTANTS_SV.PO_ENTITY_CODE, --entity_code
4569: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, --event_class_code
4570: p_po_header_id, --trx_id
4571: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE, --trx_level_type
4572: p_del_shipment_table(i), --trx_line_id
4573: 'DELETE', --line_level_action

Line 4571: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE, --trx_level_type

4567: PO_CONSTANTS_SV.APPLICATION_ID, --application_id
4568: PO_CONSTANTS_SV.PO_ENTITY_CODE, --entity_code
4569: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, --event_class_code
4570: p_po_header_id, --trx_id
4571: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE, --trx_level_type
4572: p_del_shipment_table(i), --trx_line_id
4573: 'DELETE', --line_level_action
4574: -1,
4575: 'N'

Line 4586: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

4582: -- Restrict to only rows that have corresponding tax lines
4583: -- Since this is called from OA, so conditions are only for SPO
4584: WHERE zl.trx_id = p_po_header_id
4585: AND zl.trx_line_id = p_del_shipment_table(i)
4586: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
4587: AND zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
4588: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
4589: AND zl.trx_level_type = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
4590: );

Line 4587: AND zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

4583: -- Since this is called from OA, so conditions are only for SPO
4584: WHERE zl.trx_id = p_po_header_id
4585: AND zl.trx_line_id = p_del_shipment_table(i)
4586: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
4587: AND zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
4588: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
4589: AND zl.trx_level_type = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
4590: );
4591:

Line 4588: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

4584: WHERE zl.trx_id = p_po_header_id
4585: AND zl.trx_line_id = p_del_shipment_table(i)
4586: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
4587: AND zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
4588: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
4589: AND zl.trx_level_type = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
4590: );
4591:
4592: d_progress := 20;

Line 4589: AND zl.trx_level_type = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE

4585: AND zl.trx_line_id = p_del_shipment_table(i)
4586: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
4587: AND zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
4588: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
4589: AND zl.trx_level_type = PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE
4590: );
4591:
4592: d_progress := 20;
4593: IF (PO_LOG.d_proc) THEN

Line 5837: IF p_document_type = PO_CONSTANTS_SV.PO THEN

5833: PO_LOG.proc_begin(d_module_base, 'p_shipment_id', p_shipment_id);
5834: END IF;
5835:
5836: d_progress := 0;
5837: IF p_document_type = PO_CONSTANTS_SV.PO THEN
5838: d_progress := 10;
5839: IF p_shipment_id <> 0 THEN
5840: d_progress := 20;
5841: INSERT INTO zx_trx_headers_gt

Line 5855: PO_CONSTANTS_SV.APPLICATION_ID,

5851: rounding_ship_from_party_id
5852: )
5853: SELECT
5854: ph.org_id,
5855: PO_CONSTANTS_SV.APPLICATION_ID,
5856: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5857: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5858: PO_CONSTANTS_SV.PO_ADJUSTED,
5859: ph.po_header_id,

Line 5856: PO_CONSTANTS_SV.PO_ENTITY_CODE,

5852: )
5853: SELECT
5854: ph.org_id,
5855: PO_CONSTANTS_SV.APPLICATION_ID,
5856: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5857: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5858: PO_CONSTANTS_SV.PO_ADJUSTED,
5859: ph.po_header_id,
5860: sysdate, -- dummy value

Line 5857: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

5853: SELECT
5854: ph.org_id,
5855: PO_CONSTANTS_SV.APPLICATION_ID,
5856: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5857: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5858: PO_CONSTANTS_SV.PO_ADJUSTED,
5859: ph.po_header_id,
5860: sysdate, -- dummy value
5861: PO_CORE_S.get_default_legal_entity_id(ph.org_id),

Line 5858: PO_CONSTANTS_SV.PO_ADJUSTED,

5854: ph.org_id,
5855: PO_CONSTANTS_SV.APPLICATION_ID,
5856: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5857: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5858: PO_CONSTANTS_SV.PO_ADJUSTED,
5859: ph.po_header_id,
5860: sysdate, -- dummy value
5861: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
5862: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

Line 5882: PO_CONSTANTS_SV.APPLICATION_ID,

5878: line_amt
5879: )
5880: VALUES
5881: (
5882: PO_CONSTANTS_SV.APPLICATION_ID,
5883: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5884: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5885: p_document_id,
5886: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

Line 5883: PO_CONSTANTS_SV.PO_ENTITY_CODE,

5879: )
5880: VALUES
5881: (
5882: PO_CONSTANTS_SV.APPLICATION_ID,
5883: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5884: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5885: p_document_id,
5886: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
5887: p_shipment_id,

Line 5884: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

5880: VALUES
5881: (
5882: PO_CONSTANTS_SV.APPLICATION_ID,
5883: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5884: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5885: p_document_id,
5886: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
5887: p_shipment_id,
5888: 'CANCEL',

Line 5886: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

5882: PO_CONSTANTS_SV.APPLICATION_ID,
5883: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5884: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5885: p_document_id,
5886: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
5887: p_shipment_id,
5888: 'CANCEL',
5889: 'N', -- dummy value
5890: 0 -- dummy value

Line 5936: PO_CONSTANTS_SV.APPLICATION_ID,

5932: rounding_ship_from_party_id
5933: )
5934: SELECT
5935: ph.org_id,
5936: PO_CONSTANTS_SV.APPLICATION_ID,
5937: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5938: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5939: PO_CONSTANTS_SV.PO_ADJUSTED,
5940: ph.po_header_id,

Line 5937: PO_CONSTANTS_SV.PO_ENTITY_CODE,

5933: )
5934: SELECT
5935: ph.org_id,
5936: PO_CONSTANTS_SV.APPLICATION_ID,
5937: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5938: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5939: PO_CONSTANTS_SV.PO_ADJUSTED,
5940: ph.po_header_id,
5941: sysdate, -- dummy value

Line 5938: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

5934: SELECT
5935: ph.org_id,
5936: PO_CONSTANTS_SV.APPLICATION_ID,
5937: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5938: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5939: PO_CONSTANTS_SV.PO_ADJUSTED,
5940: ph.po_header_id,
5941: sysdate, -- dummy value
5942: PO_CORE_S.get_default_legal_entity_id(ph.org_id),

Line 5939: PO_CONSTANTS_SV.PO_ADJUSTED,

5935: ph.org_id,
5936: PO_CONSTANTS_SV.APPLICATION_ID,
5937: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5938: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5939: PO_CONSTANTS_SV.PO_ADJUSTED,
5940: ph.po_header_id,
5941: sysdate, -- dummy value
5942: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
5943: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

Line 5962: PO_CONSTANTS_SV.APPLICATION_ID,

5958: line_amt_includes_tax_flag,
5959: line_amt
5960: )
5961: SELECT
5962: PO_CONSTANTS_SV.APPLICATION_ID,
5963: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5964: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5965: pll.po_header_id,
5966: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

Line 5963: PO_CONSTANTS_SV.PO_ENTITY_CODE,

5959: line_amt
5960: )
5961: SELECT
5962: PO_CONSTANTS_SV.APPLICATION_ID,
5963: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5964: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5965: pll.po_header_id,
5966: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
5967: pll.line_location_id,

Line 5964: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,

5960: )
5961: SELECT
5962: PO_CONSTANTS_SV.APPLICATION_ID,
5963: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5964: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5965: pll.po_header_id,
5966: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
5967: pll.line_location_id,
5968: 'CANCEL', --line_level_action

Line 5966: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,

5962: PO_CONSTANTS_SV.APPLICATION_ID,
5963: PO_CONSTANTS_SV.PO_ENTITY_CODE,
5964: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
5965: pll.po_header_id,
5966: PO_CONSTANTS_SV.PO_TRX_LEVEL_TYPE,
5967: pll.line_location_id,
5968: 'CANCEL', --line_level_action
5969: 'N', -- dummy value
5970: 0 -- dummy value

Line 6023: p_document_type => PO_CONSTANTS_SV.PO,

6019: x_return_status => x_return_status,
6020: x_msg_count => x_msg_count,
6021: x_msg_data => x_msg_data,
6022: p_org_id => l_org_id,
6023: p_document_type => PO_CONSTANTS_SV.PO,
6024: p_document_id => p_document_id,
6025: p_event_type_code => PO_CONSTANTS_SV.PO_CANCELLED);
6026:
6027: d_progress := 150;

Line 6025: p_event_type_code => PO_CONSTANTS_SV.PO_CANCELLED);

6021: x_msg_data => x_msg_data,
6022: p_org_id => l_org_id,
6023: p_document_type => PO_CONSTANTS_SV.PO,
6024: p_document_id => p_document_id,
6025: p_event_type_code => PO_CONSTANTS_SV.PO_CANCELLED);
6026:
6027: d_progress := 150;
6028: IF (PO_LOG.d_stmt) THEN
6029: PO_LOG.stmt(d_module_base,d_progress,'After Calling PO_TAX_INTERFACE_PVT.global_document_update');

Line 6035: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

6031: PO_LOG.stmt(d_module_base,d_progress,'x_msg_count', x_msg_count);
6032: PO_LOG.stmt(d_module_base,d_progress,'x_msg_data', x_msg_data);
6033: END IF;
6034: END IF; --IF p_shipment_id IS NOT NULL
6035: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6036: d_progress := 160;
6037: IF p_shipment_id <> 0 THEN
6038: d_progress := 170;
6039: INSERT INTO zx_trx_headers_gt

Line 6053: PO_CONSTANTS_SV.APPLICATION_ID,

6049: rounding_ship_from_party_id
6050: )
6051: SELECT
6052: pr.org_id, -- dummy value
6053: PO_CONSTANTS_SV.APPLICATION_ID,
6054: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6055: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6056: PO_CONSTANTS_SV.REL_ADJUSTED,
6057: pr.po_release_id,

Line 6054: PO_CONSTANTS_SV.REL_ENTITY_CODE,

6050: )
6051: SELECT
6052: pr.org_id, -- dummy value
6053: PO_CONSTANTS_SV.APPLICATION_ID,
6054: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6055: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6056: PO_CONSTANTS_SV.REL_ADJUSTED,
6057: pr.po_release_id,
6058: sysdate, -- dummy value

Line 6055: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,

6051: SELECT
6052: pr.org_id, -- dummy value
6053: PO_CONSTANTS_SV.APPLICATION_ID,
6054: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6055: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6056: PO_CONSTANTS_SV.REL_ADJUSTED,
6057: pr.po_release_id,
6058: sysdate, -- dummy value
6059: PO_CORE_S.get_default_legal_entity_id(pr.org_id),

Line 6056: PO_CONSTANTS_SV.REL_ADJUSTED,

6052: pr.org_id, -- dummy value
6053: PO_CONSTANTS_SV.APPLICATION_ID,
6054: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6055: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6056: PO_CONSTANTS_SV.REL_ADJUSTED,
6057: pr.po_release_id,
6058: sysdate, -- dummy value
6059: PO_CORE_S.get_default_legal_entity_id(pr.org_id),
6060: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id

Line 6081: PO_CONSTANTS_SV.APPLICATION_ID,

6077: line_amt
6078: )
6079: VALUES
6080: (
6081: PO_CONSTANTS_SV.APPLICATION_ID,
6082: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6083: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6084: p_document_id,
6085: PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE,

Line 6082: PO_CONSTANTS_SV.REL_ENTITY_CODE,

6078: )
6079: VALUES
6080: (
6081: PO_CONSTANTS_SV.APPLICATION_ID,
6082: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6083: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6084: p_document_id,
6085: PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE,
6086: p_shipment_id,

Line 6083: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,

6079: VALUES
6080: (
6081: PO_CONSTANTS_SV.APPLICATION_ID,
6082: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6083: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6084: p_document_id,
6085: PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE,
6086: p_shipment_id,
6087: 'CANCEL',

Line 6085: PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE,

6081: PO_CONSTANTS_SV.APPLICATION_ID,
6082: PO_CONSTANTS_SV.REL_ENTITY_CODE,
6083: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE,
6084: p_document_id,
6085: PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE,
6086: p_shipment_id,
6087: 'CANCEL',
6088: 'N', -- dummy value
6089: 0 -- dummy value

Line 6142: p_document_type => PO_CONSTANTS_SV.RELEASE,

6138: x_return_status => x_return_status,
6139: x_msg_count => x_msg_count,
6140: x_msg_data => x_msg_data,
6141: p_org_id => l_org_id,
6142: p_document_type => PO_CONSTANTS_SV.RELEASE,
6143: p_document_id => p_document_id,
6144: p_event_type_code => PO_CONSTANTS_SV.REL_CANCELLED);
6145:
6146: d_progress := 250;

Line 6144: p_event_type_code => PO_CONSTANTS_SV.REL_CANCELLED);

6140: x_msg_data => x_msg_data,
6141: p_org_id => l_org_id,
6142: p_document_type => PO_CONSTANTS_SV.RELEASE,
6143: p_document_id => p_document_id,
6144: p_event_type_code => PO_CONSTANTS_SV.REL_CANCELLED);
6145:
6146: d_progress := 250;
6147: IF (PO_LOG.d_stmt) THEN
6148: PO_LOG.stmt(d_module_base,d_progress,'After Calling PO_TAX_INTERFACE_PVT.global_document_update');

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

6151: PO_LOG.stmt(d_module_base,d_progress,'x_msg_data', x_msg_data);
6152: END IF;
6153:
6154: END IF; --IF p_shipment_id IS NOT NULL
6155: END IF; --IF p_document_type = PO_CONSTANTS_SV.PO
6156:
6157: d_progress := 260;
6158: IF (PO_LOG.d_proc) THEN
6159: PO_LOG.proc_end(d_module_base);

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

6202: -- 'PO' or 'RELEASE'
6203: --p_document_id
6204: -- po_header_id or po_release_id of the document
6205: --p_event_type_code
6206: -- document level action code taken from PO_CONSTANTS_SV
6207: --OUT:
6208: --x_return_status
6209: -- Standard API specification parameter
6210: --x_msg_count

Line 6247: IF p_document_type = PO_CONSTANTS_SV.PO THEN

6243: PO_LOG.proc_begin(d_module_base, 'p_event_type_code', p_event_type_code);
6244: END IF;
6245:
6246: d_progress := 0;
6247: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6248: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
6249: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
6250: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6251: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;

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

6244: END IF;
6245:
6246: d_progress := 0;
6247: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6248: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
6249: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
6250: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6251: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;
6252: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;

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

6245:
6246: d_progress := 0;
6247: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6248: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
6249: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
6250: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6251: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;
6252: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;
6253: END IF;

Line 6250: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

6246: d_progress := 0;
6247: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6248: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
6249: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
6250: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6251: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;
6252: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;
6253: END IF;
6254:

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

6247: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6248: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
6249: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
6250: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6251: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;
6252: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;
6253: END IF;
6254:
6255: d_progress := 10;

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

6248: l_trx_rec.entity_code := PO_CONSTANTS_SV.PO_ENTITY_CODE;
6249: l_trx_rec.event_class_code := PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE;
6250: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6251: l_trx_rec.entity_code := PO_CONSTANTS_SV.REL_ENTITY_CODE;
6252: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;
6253: END IF;
6254:
6255: d_progress := 10;
6256: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;

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

6252: l_trx_rec.event_class_code := PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE;
6253: END IF;
6254:
6255: d_progress := 10;
6256: l_trx_rec.application_id := PO_CONSTANTS_SV.APPLICATION_ID;
6257: l_trx_rec.internal_organization_id := p_org_id;
6258: l_trx_rec.event_type_code := p_event_type_code;
6259: l_trx_rec.trx_id := p_document_id;
6260: l_trx_rec.application_doc_status := null;

Line 6361: IF p_document_type = PO_CONSTANTS_SV.PO THEN

6357: -- By default return status is SUCCESS if no exception occurs
6358: x_return_status := FND_API.G_RET_STS_SUCCESS;
6359:
6360: d_progress := 10;
6361: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6362: SELECT ph.authorization_status
6363: INTO l_authorization_status
6364: FROM po_headers_all ph
6365: WHERE ph.po_header_id = p_document_id;

Line 6366: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

6362: SELECT ph.authorization_status
6363: INTO l_authorization_status
6364: FROM po_headers_all ph
6365: WHERE ph.po_header_id = p_document_id;
6366: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6367: SELECT pr.authorization_status
6368: INTO l_authorization_status
6369: FROM po_releases_all pr
6370: WHERE pr.po_release_id = p_document_id;

Line 6377: IF l_authorization_status = PO_CONSTANTS_SV.PRE_APPROVED THEN

6373: IF PO_LOG.d_stmt THEN
6374: PO_LOG.stmt(d_module_base,d_progress,'l_authorization_status='||l_authorization_status);
6375: END IF;
6376:
6377: IF l_authorization_status = PO_CONSTANTS_SV.PRE_APPROVED THEN
6378:
6379: d_progress := 20;
6380: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6381: UPDATE po_headers_all ph

Line 6380: IF p_document_type = PO_CONSTANTS_SV.PO THEN

6376:
6377: IF l_authorization_status = PO_CONSTANTS_SV.PRE_APPROVED THEN
6378:
6379: d_progress := 20;
6380: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6381: UPDATE po_headers_all ph
6382: SET ph.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
6383: ph.approved_flag = 'N'
6384: WHERE ph.po_header_id = p_document_id;

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

6378:
6379: d_progress := 20;
6380: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6381: UPDATE po_headers_all ph
6382: SET ph.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
6383: ph.approved_flag = 'N'
6384: WHERE ph.po_header_id = p_document_id;
6385: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6386: UPDATE po_releases_all pr

Line 6385: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

6381: UPDATE po_headers_all ph
6382: SET ph.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
6383: ph.approved_flag = 'N'
6384: WHERE ph.po_header_id = p_document_id;
6385: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6386: UPDATE po_releases_all pr
6387: SET pr.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
6388: pr.approved_flag = 'N'
6389: WHERE pr.po_release_id = p_document_id;

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

6383: ph.approved_flag = 'N'
6384: WHERE ph.po_header_id = p_document_id;
6385: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6386: UPDATE po_releases_all pr
6387: SET pr.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
6388: pr.approved_flag = 'N'
6389: WHERE pr.po_release_id = p_document_id;
6390: END IF;
6391:

Line 6392: ELSIF l_authorization_status = PO_CONSTANTS_SV.APPROVED THEN

6388: pr.approved_flag = 'N'
6389: WHERE pr.po_release_id = p_document_id;
6390: END IF;
6391:
6392: ELSIF l_authorization_status = PO_CONSTANTS_SV.APPROVED THEN
6393:
6394: d_progress := 30;
6395: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6396: UPDATE po_headers_all ph

Line 6395: IF p_document_type = PO_CONSTANTS_SV.PO THEN

6391:
6392: ELSIF l_authorization_status = PO_CONSTANTS_SV.APPROVED THEN
6393:
6394: d_progress := 30;
6395: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6396: UPDATE po_headers_all ph
6397: SET ph.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
6398: ph.approved_flag = 'R'
6399: WHERE ph.po_header_id = p_document_id;

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

6393:
6394: d_progress := 30;
6395: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6396: UPDATE po_headers_all ph
6397: SET ph.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
6398: ph.approved_flag = 'R'
6399: WHERE ph.po_header_id = p_document_id;
6400: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6401: UPDATE po_releases_all pr

Line 6400: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

6396: UPDATE po_headers_all ph
6397: SET ph.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
6398: ph.approved_flag = 'R'
6399: WHERE ph.po_header_id = p_document_id;
6400: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6401: UPDATE po_releases_all pr
6402: SET pr.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
6403: pr.approved_flag = 'R'
6404: WHERE pr.po_release_id = p_document_id;

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

6398: ph.approved_flag = 'R'
6399: WHERE ph.po_header_id = p_document_id;
6400: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6401: UPDATE po_releases_all pr
6402: SET pr.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
6403: pr.approved_flag = 'R'
6404: WHERE pr.po_release_id = p_document_id;
6405: END IF;
6406: