APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_TBL_NUMBER

Line 1514: , p_before_dist_ids_tbl IN po_tbl_number

1510: --End of Comments
1511: -------------------------------------------------------------------------------
1512: PROCEDURE do_req_split(
1513: x_return_status OUT NOCOPY VARCHAR2
1514: , p_before_dist_ids_tbl IN po_tbl_number
1515: , p_after_dist_ids_tbl IN po_tbl_number
1516: , p_employee_id IN NUMBER
1517: , p_override_funds IN VARCHAR2
1518: , p_override_date IN DATE

Line 1515: , p_after_dist_ids_tbl IN po_tbl_number

1511: -------------------------------------------------------------------------------
1512: PROCEDURE do_req_split(
1513: x_return_status OUT NOCOPY VARCHAR2
1514: , p_before_dist_ids_tbl IN po_tbl_number
1515: , p_after_dist_ids_tbl IN po_tbl_number
1516: , p_employee_id IN NUMBER
1517: , p_override_funds IN VARCHAR2
1518: , p_override_date IN DATE
1519: , x_po_return_code OUT NOCOPY VARCHAR2

Line 2722: , p_agreement_id_tbl IN PO_TBL_NUMBER

2718: --End of Comments
2719: -------------------------------------------------------------------------------
2720: PROCEDURE is_agreement_encumbered(
2721: x_return_status OUT NOCOPY VARCHAR2
2722: , p_agreement_id_tbl IN PO_TBL_NUMBER
2723: , x_agreement_encumbered_tbl OUT NOCOPY PO_TBL_VARCHAR1
2724: )
2725: IS
2726:

Line 2732: l_sequence_tbl PO_TBL_NUMBER; -- bug3546894

2728: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
2729: l_progress VARCHAR2(3) := '000';
2730: l_procedure_id NUMBER;
2731:
2732: l_sequence_tbl PO_TBL_NUMBER; -- bug3546894
2733:
2734: BEGIN
2735:
2736: IF g_debug_stmt THEN

Line 2937: , p_agreement_id_tbl => po_tbl_number(p_agreement_id)

2933: END IF;
2934:
2935: is_agreement_encumbered(
2936: x_return_status => x_return_status
2937: , p_agreement_id_tbl => po_tbl_number(p_agreement_id)
2938: , x_agreement_encumbered_tbl => l_agreement_encumbered_tbl
2939: );
2940:
2941: l_progress := '020';

Line 3124: l_doc_id_tbl po_tbl_number;

3120: l_do_state_check VARCHAR2(1);
3121:
3122: -- bug 3518116
3123: l_action VARCHAR2(30);
3124: l_doc_id_tbl po_tbl_number;
3125: --
3126: l_po_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3127: l_req_document_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%type;
3128: l_rel_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;

Line 3135: l_distribution_id_tbl PO_TBL_NUMBER;

3131:
3132: /* bug#6069405 start*/
3133:
3134: l_distribution_type_tbl po_tbl_varchar30;
3135: l_distribution_id_tbl PO_TBL_NUMBER;
3136: l_nonrecoverable_tax_tbl PO_TBL_NUMBER;
3137: l_distribution_cnt NUMBER;
3138:
3139: /* bug#6069405 end*/

Line 3136: l_nonrecoverable_tax_tbl PO_TBL_NUMBER;

3132: /* bug#6069405 start*/
3133:
3134: l_distribution_type_tbl po_tbl_varchar30;
3135: l_distribution_id_tbl PO_TBL_NUMBER;
3136: l_nonrecoverable_tax_tbl PO_TBL_NUMBER;
3137: l_distribution_cnt NUMBER;
3138:
3139: /* bug#6069405 end*/
3140: BEGIN

Line 3737: l_doc_id_tbl := po_tbl_number(l_document_id);

3733: ;
3734:
3735: l_progress := '845';
3736:
3737: l_doc_id_tbl := po_tbl_number(l_document_id);
3738:
3739: END IF;
3740:
3741: l_progress := '850';

Line 4343: , p_doc_level_id_tbl IN po_tbl_number

4339: PROCEDURE populate_encumbrance_gt(
4340: x_return_status OUT NOCOPY VARCHAR2
4341: , p_doc_type IN VARCHAR2
4342: , p_doc_level IN VARCHAR2
4343: , p_doc_level_id_tbl IN po_tbl_number
4344: , p_adjustment_status_tbl IN po_tbl_varchar5
4345: , p_check_only_flag IN VARCHAR2
4346: )
4347: IS

Line 4352: l_dist_id_tbl po_tbl_number;

4348:
4349: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'POPULATE_ENCUMBRANCE_GT';
4350: l_progress VARCHAR2(3) := '000';
4351:
4352: l_dist_id_tbl po_tbl_number;
4353: l_dist_id_key NUMBER;
4354:
4355: BEGIN
4356:

Line 4757: , p_doc_level_id_tbl IN po_tbl_number

4753: x_return_status OUT NOCOPY VARCHAR2
4754: , p_doc_type IN VARCHAR2
4755: , p_doc_subtype IN VARCHAR2
4756: , p_doc_level IN VARCHAR2
4757: , p_doc_level_id_tbl IN po_tbl_number
4758: )
4759: IS
4760:
4761: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_ENC_GT_ACTION_IDS';