DBA Data[Home] [Help]

APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_TBL_VARCHAR30

Line 731: l_action_tbl PO_TBL_VARCHAR30;

727: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
728: d_position NUMBER;
729:
730: l_intf_header_id_tbl PO_TBL_NUMBER;
731: l_action_tbl PO_TBL_VARCHAR30;
732: l_dft_id_tbl PO_TBL_NUMBER;
733: l_po_header_id_tbl PO_TBL_NUMBER;
734:
735: l_dft_to_delete_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 1796: L_LOA_TBL PO_TBL_VARCHAR30;

1792: l_approval_method VARCHAR2(30);
1793: l_need_to_encumber VARCHAR2(1);
1794: l_fund_reserve_result VARCHAR2(1);
1795: l_return_status VARCHAR2(1);
1796: L_LOA_TBL PO_TBL_VARCHAR30;
1797: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
1798: --ACRN proj start
1799: l_charge_acc_tbl po_tbl_number;
1800: l_ACRN_tbl po_tbl_varchar30;

Line 1797: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;

1793: l_need_to_encumber VARCHAR2(1);
1794: l_fund_reserve_result VARCHAR2(1);
1795: l_return_status VARCHAR2(1);
1796: L_LOA_TBL PO_TBL_VARCHAR30;
1797: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
1798: --ACRN proj start
1799: l_charge_acc_tbl po_tbl_number;
1800: l_ACRN_tbl po_tbl_varchar30;
1801:

Line 1800: l_ACRN_tbl po_tbl_varchar30;

1796: L_LOA_TBL PO_TBL_VARCHAR30;
1797: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
1798: --ACRN proj start
1799: l_charge_acc_tbl po_tbl_number;
1800: l_ACRN_tbl po_tbl_varchar30;
1801:
1802: x_ACRN_tbl po_tbl_varchar30;
1803: l_RETURN_MESSAGE PO_TBL_VARCHAR2000;
1804: l_MESSAGE_TOKEN PO_TBL_VARCHAR2000;

Line 1802: x_ACRN_tbl po_tbl_varchar30;

1798: --ACRN proj start
1799: l_charge_acc_tbl po_tbl_number;
1800: l_ACRN_tbl po_tbl_varchar30;
1801:
1802: x_ACRN_tbl po_tbl_varchar30;
1803: l_RETURN_MESSAGE PO_TBL_VARCHAR2000;
1804: l_MESSAGE_TOKEN PO_TBL_VARCHAR2000;
1805: l_is_ACRN_enabled VARCHAR2(1);
1806: -- ACRN proj END

Line 2255: l_ACRN_tbl po_tbl_varchar30;

2251: --ACRN proj
2252: l_int_header_id NUMBER;
2253: l_distribution_id_tbl PO_TBL_NUMBER;
2254: l_charge_acc_tbl po_tbl_number;
2255: l_ACRN_tbl po_tbl_varchar30;
2256: L_LOA_TBL PO_TBL_VARCHAR30;
2257: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
2258: L_REGEN_Y_N VARCHAR2(1);
2259: x_ACRN_tbl po_tbl_varchar30;

Line 2256: L_LOA_TBL PO_TBL_VARCHAR30;

2252: l_int_header_id NUMBER;
2253: l_distribution_id_tbl PO_TBL_NUMBER;
2254: l_charge_acc_tbl po_tbl_number;
2255: l_ACRN_tbl po_tbl_varchar30;
2256: L_LOA_TBL PO_TBL_VARCHAR30;
2257: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
2258: L_REGEN_Y_N VARCHAR2(1);
2259: x_ACRN_tbl po_tbl_varchar30;
2260: l_RETURN_MESSAGE PO_TBL_VARCHAR2000;

Line 2257: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;

2253: l_distribution_id_tbl PO_TBL_NUMBER;
2254: l_charge_acc_tbl po_tbl_number;
2255: l_ACRN_tbl po_tbl_varchar30;
2256: L_LOA_TBL PO_TBL_VARCHAR30;
2257: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
2258: L_REGEN_Y_N VARCHAR2(1);
2259: x_ACRN_tbl po_tbl_varchar30;
2260: l_RETURN_MESSAGE PO_TBL_VARCHAR2000;
2261: l_MESSAGE_TOKEN PO_TBL_VARCHAR2000;

Line 2259: x_ACRN_tbl po_tbl_varchar30;

2255: l_ACRN_tbl po_tbl_varchar30;
2256: L_LOA_TBL PO_TBL_VARCHAR30;
2257: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
2258: L_REGEN_Y_N VARCHAR2(1);
2259: x_ACRN_tbl po_tbl_varchar30;
2260: l_RETURN_MESSAGE PO_TBL_VARCHAR2000;
2261: l_MESSAGE_TOKEN PO_TBL_VARCHAR2000;
2262: l_is_ACRN_enabled VARCHAR2(1);
2263: x_return_status VARCHAR2(1);