APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_TBL_NUMBER

Line 1554: , p_before_dist_ids_tbl IN po_tbl_number

1550: --End of Comments
1551: -------------------------------------------------------------------------------
1552: PROCEDURE do_req_split(
1553: x_return_status OUT NOCOPY VARCHAR2
1554: , p_before_dist_ids_tbl IN po_tbl_number
1555: , p_after_dist_ids_tbl IN po_tbl_number
1556: , p_employee_id IN NUMBER
1557: , p_override_funds IN VARCHAR2
1558: , p_override_date IN DATE

Line 1555: , p_after_dist_ids_tbl IN po_tbl_number

1551: -------------------------------------------------------------------------------
1552: PROCEDURE do_req_split(
1553: x_return_status OUT NOCOPY VARCHAR2
1554: , p_before_dist_ids_tbl IN po_tbl_number
1555: , p_after_dist_ids_tbl IN po_tbl_number
1556: , p_employee_id IN NUMBER
1557: , p_override_funds IN VARCHAR2
1558: , p_override_date IN DATE
1559: , x_po_return_code OUT NOCOPY VARCHAR2

Line 2762: , p_agreement_id_tbl IN PO_TBL_NUMBER

2758: --End of Comments
2759: -------------------------------------------------------------------------------
2760: PROCEDURE is_agreement_encumbered(
2761: x_return_status OUT NOCOPY VARCHAR2
2762: , p_agreement_id_tbl IN PO_TBL_NUMBER
2763: , x_agreement_encumbered_tbl OUT NOCOPY PO_TBL_VARCHAR1
2764: )
2765: IS
2766:

Line 2772: l_sequence_tbl PO_TBL_NUMBER; -- bug3546894

2768: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
2769: l_progress VARCHAR2(3) := '000';
2770: l_procedure_id NUMBER;
2771:
2772: l_sequence_tbl PO_TBL_NUMBER; -- bug3546894
2773:
2774: BEGIN
2775:
2776: IF g_debug_stmt THEN

Line 2977: , p_agreement_id_tbl => po_tbl_number(p_agreement_id)

2973: END IF;
2974:
2975: is_agreement_encumbered(
2976: x_return_status => x_return_status
2977: , p_agreement_id_tbl => po_tbl_number(p_agreement_id)
2978: , x_agreement_encumbered_tbl => l_agreement_encumbered_tbl
2979: );
2980:
2981: l_progress := '020';

Line 3164: l_doc_id_tbl po_tbl_number;

3160: l_do_state_check VARCHAR2(1);
3161:
3162: -- bug 3518116
3163: l_action VARCHAR2(30);
3164: l_doc_id_tbl po_tbl_number;
3165: --
3166: l_po_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3167: l_req_document_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%type;
3168: l_rel_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;

Line 3178: l_distribution_id_tbl PO_TBL_NUMBER;

3174:
3175: /* bug#6069405 start*/
3176:
3177: l_distribution_type_tbl po_tbl_varchar30;
3178: l_distribution_id_tbl PO_TBL_NUMBER;
3179: l_nonrecoverable_tax_tbl PO_TBL_NUMBER;
3180: l_distribution_cnt NUMBER;
3181: /*12405805*/
3182: l_old_pkt_id NUMBER;

Line 3179: l_nonrecoverable_tax_tbl PO_TBL_NUMBER;

3175: /* bug#6069405 start*/
3176:
3177: l_distribution_type_tbl po_tbl_varchar30;
3178: l_distribution_id_tbl PO_TBL_NUMBER;
3179: l_nonrecoverable_tax_tbl PO_TBL_NUMBER;
3180: l_distribution_cnt NUMBER;
3181: /*12405805*/
3182: l_old_pkt_id NUMBER;
3183: l_exec_gl_call_ret_code VARCHAR2(1);

Line 3885: l_doc_id_tbl := po_tbl_number(l_document_id);

3881: ;
3882:
3883: l_progress := '845';
3884:
3885: l_doc_id_tbl := po_tbl_number(l_document_id);
3886:
3887: END IF;
3888:
3889: l_progress := '850';

Line 4543: , p_doc_level_id_tbl IN po_tbl_number

4539: PROCEDURE populate_encumbrance_gt(
4540: x_return_status OUT NOCOPY VARCHAR2
4541: , p_doc_type IN VARCHAR2
4542: , p_doc_level IN VARCHAR2
4543: , p_doc_level_id_tbl IN po_tbl_number
4544: , p_adjustment_status_tbl IN po_tbl_varchar5
4545: , p_check_only_flag IN VARCHAR2
4546: )
4547: IS

Line 4552: l_dist_id_tbl po_tbl_number;

4548:
4549: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'POPULATE_ENCUMBRANCE_GT';
4550: l_progress VARCHAR2(3) := '000';
4551:
4552: l_dist_id_tbl po_tbl_number;
4553: l_dist_id_key NUMBER;
4554:
4555: BEGIN
4556:

Line 5004: , p_doc_level_id_tbl IN po_tbl_number

5000: x_return_status OUT NOCOPY VARCHAR2
5001: , p_doc_type IN VARCHAR2
5002: , p_doc_subtype IN VARCHAR2
5003: , p_doc_level IN VARCHAR2
5004: , p_doc_level_id_tbl IN po_tbl_number
5005: )
5006: IS
5007:
5008: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_ENC_GT_ACTION_IDS';

Line 5528: l_dist_id_tbl PO_TBL_NUMBER;

5524: IS
5525: l_log_head CONSTANT VARCHAR2(100) := g_log_head
5526: ||'POPULATE_ENC_GT_WITH_DRAFT';
5527: l_progress VARCHAR2(3) := '000';
5528: l_dist_id_tbl PO_TBL_NUMBER;
5529: l_dist_id_key NUMBER;
5530:
5531: CURSOR get_dist_ids IS
5532: SELECT po_distribution_id