APPS.PO_NEGOTIATIONS_SV1 dependencies on PO_SESSION_GT

Line 759: DELETE FROM po_session_gt WHERE index_char1='PO_NEGOTIATIONS_SV1';

755: END IF;
756: --bug 6131913
757: -- logme('create_negotiation ' || x_progress);
758:
759: DELETE FROM po_session_gt WHERE index_char1='PO_NEGOTIATIONS_SV1';
760:
761:
762:
763: --bug 5841426

Line 767: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, date1)

763: --bug 5841426
764: --Bug 13627281
765: IF(t_neg_lines IS NULL OR t_neg_line_num IS null) then
766: FORALL i IN 1..t_req_lines.Count
767: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, date1)
768: SELECT prl.requisition_line_id,
769: 'PO_NEGOTIATIONS_SV1',
770: prh.segment1,
771: prl.line_num,

Line 781: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, num4, char2, date1)

777: WHERE prh.requisition_header_id = prl.requisition_header_id
778: AND prl.requisition_line_id = t_req_lines(i);
779: else
780: FORALL i IN 1..t_req_lines.Count
781: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, num4, char2, date1)
782: SELECT prl.requisition_line_id,
783: 'PO_NEGOTIATIONS_SV1',
784: prh.segment1,
785: prl.line_num,

Line 863: PO_SESSION_GT psg --

859: l_from_org_id */ --
860: from po_requisition_lines_all rl, --
861: mtl_system_items_kfv msi,
862: per_jobs_vl PJ,
863: PO_SESSION_GT psg --
864: where requisition_line_id = psg.key --
865: and rl.item_id = msi.inventory_item_id(+)
866: and coalesce(msi.organization_id, rl.destination_organization_id,-1) =
867: nvl(rl.destination_organization_id,-1)

Line 2697: DELETE FROM po_session_gt WHERE index_char1='PO_NEGOTIATIONS_SV1';

2693:
2694: END;
2695:
2696: x_progress := '003';
2697: DELETE FROM po_session_gt WHERE index_char1='PO_NEGOTIATIONS_SV1';
2698:
2699:
2700: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, date1)
2701: SELECT prl.requisition_line_id,

Line 2700: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, date1)

2696: x_progress := '003';
2697: DELETE FROM po_session_gt WHERE index_char1='PO_NEGOTIATIONS_SV1';
2698:
2699:
2700: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, date1)
2701: SELECT prl.requisition_line_id,
2702: 'PO_NEGOTIATIONS_SV1',
2703: prh.segment1,
2704: prl.line_num,

Line 2754: PO_SESSION_GT psg --

2750: rl.UDA_TEMPLATE_ID --
2751: from po_requisition_lines_all rl, --
2752: mtl_system_items_kfv msi,
2753: per_jobs_vl PJ,
2754: PO_SESSION_GT psg --
2755: where requisition_line_id = psg.key --
2756: and rl.item_id = msi.inventory_item_id(+)
2757: and coalesce(msi.organization_id, rl.destination_organization_id,-1) =
2758: nvl(rl.destination_organization_id,-1)