DBA Data[Home] [Help]

APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_TBL_NUMBER

Line 148: (p_uda_lines_tbl IN po_tbl_number,

144: );
145:
146: --CLM PDOI Integration Starts
147: PROCEDURE import_uda_attrs
148: (p_uda_lines_tbl IN po_tbl_number,
149: p_po_header_id IN NUMBER,
150: x_return_status IN OUT NOCOPY VARCHAR2,
151: p_draft_id IN NUMBER
152: );

Line 214: l_uda_lines_tbl po_tbl_number := NULL;

210:
211: --CLM PDOI Integration
212: l_count NUMBER;
213: l_draft_id NUMBER;
214: l_uda_lines_tbl po_tbl_number := NULL;
215: x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
216: l_template_id NUMBER;
217: l_doc_number VARCHAR2(100) := NULL;
218: l_line_template_id NUMBER;

Line 621: l_po_line_id_tbl PO_TBL_NUMBER;

617: d_api_name CONSTANT VARCHAR2(30) := 'remove_notified_draft_lines';
618: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
619: d_position NUMBER;
620:
621: l_po_line_id_tbl PO_TBL_NUMBER;
622: BEGIN
623:
624: d_position := 0;
625: IF (PO_LOG.d_proc) THEN

Line 730: l_intf_header_id_tbl PO_TBL_NUMBER;

726: d_api_name CONSTANT VARCHAR2(30) := 'process_rejected_records';
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:

Line 732: l_dft_id_tbl PO_TBL_NUMBER;

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();
736:

Line 733: l_po_header_id_tbl PO_TBL_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();
736:
737: l_dft_exist_chg_check_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 735: l_dft_to_delete_tbl PO_TBL_NUMBER := 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();
736:
737: l_dft_exist_chg_check_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
738: l_chg_exist_tbl PO_TBL_VARCHAR1;
739:

Line 737: l_dft_exist_chg_check_tbl PO_TBL_NUMBER := 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();
736:
737: l_dft_exist_chg_check_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
738: l_chg_exist_tbl PO_TBL_VARCHAR1;
739:
740: BEGIN
741: d_position := 0;

Line 1799: l_charge_acc_tbl po_tbl_number;

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:
1802: x_ACRN_tbl po_tbl_varchar30;
1803: l_RETURN_MESSAGE PO_TBL_VARCHAR2000;

Line 1812: l_distribution_id_tbl PO_TBL_NUMBER;

1808: -- CLM Partial Funding Changes
1809: l_is_clm VARCHAR2(1);
1810: l_amount_ordered NUMBER := 0;
1811: l_int_header_id NUMBER := 0;
1812: l_distribution_id_tbl PO_TBL_NUMBER;
1813: l_funded_value_tbl PO_TBL_NUMBER;
1814: l_partial_funded_flag_tbl PO_TBL_VARCHAR1;
1815: l_headers_csr PO_PDOI_TYPES.intf_cursor_type;
1816: l_headers PO_PDOI_TYPES.headers_rec_type;

Line 1813: l_funded_value_tbl PO_TBL_NUMBER;

1809: l_is_clm VARCHAR2(1);
1810: l_amount_ordered NUMBER := 0;
1811: l_int_header_id NUMBER := 0;
1812: l_distribution_id_tbl PO_TBL_NUMBER;
1813: l_funded_value_tbl PO_TBL_NUMBER;
1814: l_partial_funded_flag_tbl PO_TBL_VARCHAR1;
1815: l_headers_csr PO_PDOI_TYPES.intf_cursor_type;
1816: l_headers PO_PDOI_TYPES.headers_rec_type;
1817: l_results po_validation_results_type;

Line 2253: l_distribution_id_tbl PO_TBL_NUMBER;

2249: l_update_auth_status VARCHAR2(1);
2250:
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;

Line 2254: l_charge_acc_tbl po_tbl_number;

2250:
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);

Line 4134: PROCEDURE import_uda_attrs (p_uda_lines_tbl IN po_tbl_number,

4130:
4131:
4132:
4133: /*PDOI Integration Prj*/
4134: PROCEDURE import_uda_attrs (p_uda_lines_tbl IN po_tbl_number,
4135: p_po_header_id IN NUMBER,
4136: x_return_status IN OUT NOCOPY VARCHAR2,
4137: p_draft_id IN number)
4138: IS

Line 4458: l_po_line_id_tbl PO_TBL_NUMBER := NULL;

4454: IS
4455: d_api_name CONSTANT VARCHAR2(30) := 'validate_complex_pricing';
4456: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4457: d_position NUMBER := 0;
4458: l_po_line_id_tbl PO_TBL_NUMBER := NULL;
4459: is_pricing_valid VARCHAR2(1) := NULL;
4460: x_results PO_VALIDATION_RESULTS_TYPE;
4461: l_error_count NUMBER :=0;
4462: BEGIN