APPS.POR_UTIL_PKG dependencies on PO_ENCUMBRANCE_GT

Line 2754: -- API to truncate the PO interface table PO_ENCUMBRANCE_GT

2750:
2751: --Begin Encumbrance APIs
2752: ------------------------
2753:
2754: -- API to truncate the PO interface table PO_ENCUMBRANCE_GT
2755: PROCEDURE truncate_po_encumbrance_gt IS
2756:
2757: l_progress VARCHAR2(4) := '000';
2758: BEGIN

Line 2755: PROCEDURE truncate_po_encumbrance_gt IS

2751: --Begin Encumbrance APIs
2752: ------------------------
2753:
2754: -- API to truncate the PO interface table PO_ENCUMBRANCE_GT
2755: PROCEDURE truncate_po_encumbrance_gt IS
2756:
2757: l_progress VARCHAR2(4) := '000';
2758: BEGIN
2759:

Line 2760: DELETE from po_encumbrance_gt;

2756:
2757: l_progress VARCHAR2(4) := '000';
2758: BEGIN
2759:
2760: DELETE from po_encumbrance_gt;
2761:
2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: RAISE_APPLICATION_ERROR(-20000,

Line 2765: 'Exception at POR_UTIL_PKG.truncate_po_encumbrance_gt ' || l_progress ||

2761:
2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: RAISE_APPLICATION_ERROR(-20000,
2765: 'Exception at POR_UTIL_PKG.truncate_po_encumbrance_gt ' || l_progress ||
2766: 'SQLERRM:' || SQLERRM);
2767:
2768: END truncate_po_encumbrance_gt;
2769:

Line 2768: END truncate_po_encumbrance_gt;

2764: RAISE_APPLICATION_ERROR(-20000,
2765: 'Exception at POR_UTIL_PKG.truncate_po_encumbrance_gt ' || l_progress ||
2766: 'SQLERRM:' || SQLERRM);
2767:
2768: END truncate_po_encumbrance_gt;
2769:
2770: -- API to populate the distribution data into POs interface table
2771: -- PO_ENCUMBRANCE_GT
2772: PROCEDURE populate_po_encumbrance_gt(

Line 2771: -- PO_ENCUMBRANCE_GT

2767:
2768: END truncate_po_encumbrance_gt;
2769:
2770: -- API to populate the distribution data into POs interface table
2771: -- PO_ENCUMBRANCE_GT
2772: PROCEDURE populate_po_encumbrance_gt(
2773: p_dist_data IN ICX_ENC_IN_TYPE) IS
2774:
2775: l_progress VARCHAR2(4) := '000';

Line 2772: PROCEDURE populate_po_encumbrance_gt(

2768: END truncate_po_encumbrance_gt;
2769:
2770: -- API to populate the distribution data into POs interface table
2771: -- PO_ENCUMBRANCE_GT
2772: PROCEDURE populate_po_encumbrance_gt(
2773: p_dist_data IN ICX_ENC_IN_TYPE) IS
2774:
2775: l_progress VARCHAR2(4) := '000';
2776: l_header_id ICX_TBL_NUMBER;

Line 2788: INSERT INTO po_encumbrance_gt(

2784:
2785: l_header_id := p_dist_data.requisition_header_id;
2786:
2787: FORALL i in 1..l_header_id.count
2788: INSERT INTO po_encumbrance_gt(
2789: adjustment_status,
2790: distribution_type,
2791: header_id,
2792: line_id,

Line 2884: 'Exception at POR_UTIL_PKG.populate_po_encumbrance_gt ' || l_progress ||

2880:
2881: EXCEPTION
2882: WHEN OTHERS THEN
2883: RAISE_APPLICATION_ERROR(-20000,
2884: 'Exception at POR_UTIL_PKG.populate_po_encumbrance_gt ' || l_progress ||
2885: 'SQLERRM:' || SQLERRM);
2886:
2887: END populate_po_encumbrance_gt;
2888:

Line 2887: END populate_po_encumbrance_gt;

2883: RAISE_APPLICATION_ERROR(-20000,
2884: 'Exception at POR_UTIL_PKG.populate_po_encumbrance_gt ' || l_progress ||
2885: 'SQLERRM:' || SQLERRM);
2886:
2887: END populate_po_encumbrance_gt;
2888:
2889: -- API to check if the funds can be reserved on the requisition
2890: -- called during preparer checkout
2891: PROCEDURE check_reserve(

Line 2913: truncate_po_encumbrance_gt;

2909:
2910: BEGIN
2911:
2912: -- first truncate the PO global temporary table
2913: truncate_po_encumbrance_gt;
2914:
2915: l_progress := '010';
2916:
2917: -- insert into the PO global temporary table

Line 2918: -- PO_ENCUMBRANCE_GT

2914:
2915: l_progress := '010';
2916:
2917: -- insert into the PO global temporary table
2918: -- PO_ENCUMBRANCE_GT
2919: populate_po_encumbrance_gt(p_dist_data);
2920:
2921: l_progress := '020';
2922:

Line 2919: populate_po_encumbrance_gt(p_dist_data);

2915: l_progress := '010';
2916:
2917: -- insert into the PO global temporary table
2918: -- PO_ENCUMBRANCE_GT
2919: populate_po_encumbrance_gt(p_dist_data);
2920:
2921: l_progress := '020';
2922:
2923: -- now call the PO check_reserve API

Line 2976: truncate_po_encumbrance_gt;

2972:
2973: BEGIN
2974:
2975: -- first truncate the PO global temporary table
2976: truncate_po_encumbrance_gt;
2977:
2978: l_progress := '010';
2979:
2980: -- now insert the old values into the temp table using

Line 2997: -- PO_ENCUMBRANCE_GT

2993:
2994: l_progress := '020';
2995:
2996: -- insert into the PO global temporary table
2997: -- PO_ENCUMBRANCE_GT
2998: populate_po_encumbrance_gt(p_dist_data);
2999:
3000: l_progress := '030';
3001:

Line 2998: populate_po_encumbrance_gt(p_dist_data);

2994: l_progress := '020';
2995:
2996: -- insert into the PO global temporary table
2997: -- PO_ENCUMBRANCE_GT
2998: populate_po_encumbrance_gt(p_dist_data);
2999:
3000: l_progress := '030';
3001:
3002: -- now call the PO check_adjust API