eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on PO_TBL_NUMBER

Line 329: , p_origin_seq_num_tbl IN po_tbl_number

325: PROCEDURE update_encumbrance_gt(
326: p_action IN VARCHAR2
327: , p_distribution_type IN VARCHAR2
328: , p_main_or_backing IN VARCHAR2
329: , p_origin_seq_num_tbl IN po_tbl_number
330: , p_backing_dist_id_tbl IN po_tbl_number
331: , p_ap_budget_account_id IN NUMBER
332: , x_count OUT NOCOPY NUMBER
333: );

Line 330: , p_backing_dist_id_tbl IN po_tbl_number

326: p_action IN VARCHAR2
327: , p_distribution_type IN VARCHAR2
328: , p_main_or_backing IN VARCHAR2
329: , p_origin_seq_num_tbl IN po_tbl_number
330: , p_backing_dist_id_tbl IN po_tbl_number
331: , p_ap_budget_account_id IN NUMBER
332: , x_count OUT NOCOPY NUMBER
333: );
334:

Line 342: , x_dist_id_tbl OUT NOCOPY po_tbl_number

338:
339: PROCEDURE filter_backing_distributions(
340: p_action IN VARCHAR2
341: , p_distribution_type IN VARCHAR2
342: , x_dist_id_tbl OUT NOCOPY po_tbl_number
343: , x_origin_seq_num_tbl OUT NOCOPY po_tbl_number
344: );
345:
346: PROCEDURE check_doc_state(

Line 343: , x_origin_seq_num_tbl OUT NOCOPY po_tbl_number

339: PROCEDURE filter_backing_distributions(
340: p_action IN VARCHAR2
341: , p_distribution_type IN VARCHAR2
342: , x_dist_id_tbl OUT NOCOPY po_tbl_number
343: , x_origin_seq_num_tbl OUT NOCOPY po_tbl_number
344: );
345:
346: PROCEDURE check_doc_state(
347: p_action IN VARCHAR2

Line 351: , p_doc_level_id_tbl IN po_tbl_number

347: p_action IN VARCHAR2
348: , p_doc_type IN VARCHAR2
349: , p_doc_subtype IN VARCHAR2
350: , p_doc_level IN VARCHAR2
351: , p_doc_level_id_tbl IN po_tbl_number
352: , x_valid_state_flag OUT NOCOPY VARCHAR2
353: );
354:
355: PROCEDURE get_period_info(

Line 439: , p_pa_sequence_num_tbl IN po_tbl_number

435: , p_end_row IN NUMBER
436: , p_running_total IN NUMBER
437: , p_amt_to_enc_func IN NUMBER
438: , p_unencumbered_amt IN NUMBER
439: , p_pa_sequence_num_tbl IN po_tbl_number
440: , p_pa_multiplier_tbl IN po_tbl_number
441: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number
442: , x_changed_amounts_flag OUT NOCOPY VARCHAR2
443: );

Line 440: , p_pa_multiplier_tbl IN po_tbl_number

436: , p_running_total IN NUMBER
437: , p_amt_to_enc_func IN NUMBER
438: , p_unencumbered_amt IN NUMBER
439: , p_pa_sequence_num_tbl IN po_tbl_number
440: , p_pa_multiplier_tbl IN po_tbl_number
441: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number
442: , x_changed_amounts_flag OUT NOCOPY VARCHAR2
443: );
444:

Line 441: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number

437: , p_amt_to_enc_func IN NUMBER
438: , p_unencumbered_amt IN NUMBER
439: , p_pa_sequence_num_tbl IN po_tbl_number
440: , p_pa_multiplier_tbl IN po_tbl_number
441: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number
442: , x_changed_amounts_flag OUT NOCOPY VARCHAR2
443: );
444:
445: --

Line 1066: l_doc_level_id_tbl po_tbl_number;

1062: l_api_name CONSTANT VARCHAR2(30) := 'GET_DISTRIBUTIONS';
1063: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1064: l_progress VARCHAR2(3) := '000';
1065:
1066: l_doc_level_id_tbl po_tbl_number;
1067: l_origin_seq_num_tbl po_tbl_number;
1068:
1069: l_return_status VARCHAR2(1);
1070: l_doc_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

Line 1067: l_origin_seq_num_tbl po_tbl_number;

1063: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1064: l_progress VARCHAR2(3) := '000';
1065:
1066: l_doc_level_id_tbl po_tbl_number;
1067: l_origin_seq_num_tbl po_tbl_number;
1068:
1069: l_return_status VARCHAR2(1);
1070: l_doc_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1071: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

Line 1195: l_doc_level_id_tbl := po_tbl_number( p_doc_level_id );

1191: END IF;
1192:
1193: l_check_only_flag := p_check_only_flag;
1194:
1195: l_doc_level_id_tbl := po_tbl_number( p_doc_level_id );
1196:
1197: l_doc_level := p_doc_level;
1198:
1199: ELSE

Line 1575: , p_origin_seq_num_tbl IN po_tbl_number

1571: PROCEDURE update_encumbrance_gt(
1572: p_action IN VARCHAR2
1573: , p_distribution_type IN VARCHAR2
1574: , p_main_or_backing IN VARCHAR2
1575: , p_origin_seq_num_tbl IN po_tbl_number
1576: , p_backing_dist_id_tbl IN po_tbl_number
1577: , p_ap_budget_account_id IN NUMBER
1578: , x_count OUT NOCOPY NUMBER
1579: )

Line 1576: , p_backing_dist_id_tbl IN po_tbl_number

1572: p_action IN VARCHAR2
1573: , p_distribution_type IN VARCHAR2
1574: , p_main_or_backing IN VARCHAR2
1575: , p_origin_seq_num_tbl IN po_tbl_number
1576: , p_backing_dist_id_tbl IN po_tbl_number
1577: , p_ap_budget_account_id IN NUMBER
1578: , x_count OUT NOCOPY NUMBER
1579: )
1580: IS

Line 1881: l_distribution_id_tbl po_tbl_number;

1877: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_BACKING_DISTRIBUTIONS';
1878: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1879: l_progress VARCHAR2(3) := '000';
1880:
1881: l_distribution_id_tbl po_tbl_number;
1882:
1883: l_doc_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1884: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
1885:

Line 2037: , x_dist_id_tbl OUT NOCOPY po_tbl_number

2033: -------------------------------------------------------------------------------
2034: PROCEDURE filter_backing_distributions(
2035: p_action IN VARCHAR2
2036: , p_distribution_type IN VARCHAR2
2037: , x_dist_id_tbl OUT NOCOPY po_tbl_number
2038: , x_origin_seq_num_tbl OUT NOCOPY po_tbl_number
2039: )
2040: IS
2041:

Line 2038: , x_origin_seq_num_tbl OUT NOCOPY po_tbl_number

2034: PROCEDURE filter_backing_distributions(
2035: p_action IN VARCHAR2
2036: , p_distribution_type IN VARCHAR2
2037: , x_dist_id_tbl OUT NOCOPY po_tbl_number
2038: , x_origin_seq_num_tbl OUT NOCOPY po_tbl_number
2039: )
2040: IS
2041:
2042: l_api_name CONSTANT VARCHAR2(30) := 'FILTER_BACKING_DISTRIBUTIONS';

Line 2661: l_count_tbl po_tbl_number;

2657: -- bug 3435714
2658: l_doc_level VARCHAR2(30);
2659: l_doc_level_tbl po_tbl_varchar30;
2660: l_dist_type_tbl po_tbl_varchar30;
2661: l_count_tbl po_tbl_number;
2662: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2663: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2664: l_doc_level_id_tbl po_tbl_number;
2665: l_id_tbl po_tbl_number;

Line 2664: l_doc_level_id_tbl po_tbl_number;

2660: l_dist_type_tbl po_tbl_varchar30;
2661: l_count_tbl po_tbl_number;
2662: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2663: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2664: l_doc_level_id_tbl po_tbl_number;
2665: l_id_tbl po_tbl_number;
2666: l_doc_id NUMBER;
2667: l_multiple_docs_flag VARCHAR2(1);
2668:

Line 2665: l_id_tbl po_tbl_number;

2661: l_count_tbl po_tbl_number;
2662: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2663: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2664: l_doc_level_id_tbl po_tbl_number;
2665: l_id_tbl po_tbl_number;
2666: l_doc_id NUMBER;
2667: l_multiple_docs_flag VARCHAR2(1);
2668:
2669: l_sub_check_action VARCHAR2(4000);

Line 2790: l_doc_level_id_tbl := po_tbl_number( p_doc_level_id );

2786:
2787: IF (p_use_enc_gt_flag = g_parameter_NO) THEN
2788: l_progress := 'a00';
2789: l_doc_level := p_doc_level;
2790: l_doc_level_id_tbl := po_tbl_number( p_doc_level_id );
2791: END IF;
2792:
2793: l_progress := 'a10';
2794:

Line 3133: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )

3129:
3130: PO_CORE_S.get_document_ids(
3131: p_doc_type => p_doc_type
3132: , p_doc_level => p_doc_level
3133: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
3134: , x_doc_id_tbl => l_id_tbl
3135: );
3136:
3137: l_progress := '330';

Line 3150: , p_doc_level_id_tbl => po_tbl_number( l_doc_id )

3146:
3147: PO_LOCKS.lock_headers(
3148: p_doc_type => p_doc_type
3149: , p_doc_level => g_doc_level_HEADER
3150: , p_doc_level_id_tbl => po_tbl_number( l_doc_id )
3151: );
3152:
3153: l_progress := '350';
3154:

Line 3266: l_doc_level_id_tbl := po_tbl_number( l_doc_id );

3262: -- While locking the doc header, we already retrieved the doc id.
3263: -- Reserve submission checks are only defined at the header level.
3264:
3265: l_doc_level := g_doc_level_HEADER;
3266: l_doc_level_id_tbl := po_tbl_number( l_doc_id );
3267:
3268: ELSIF ( p_action = g_action_UNRESERVE
3269: AND p_doc_type IN (g_doc_type_PO, g_doc_type_RELEASE)
3270: ) THEN

Line 3504: , p_doc_level_id_tbl IN po_tbl_number

3500: p_action IN VARCHAR2
3501: , p_doc_type IN VARCHAR2
3502: , p_doc_subtype IN VARCHAR2
3503: , p_doc_level IN VARCHAR2
3504: , p_doc_level_id_tbl IN po_tbl_number
3505: , x_valid_state_flag OUT NOCOPY VARCHAR2
3506: )
3507: IS
3508:

Line 3519: l_empty_tbl po_tbl_number := NULL;

3515: l_status_rec PO_STATUS_REC_TYPE;
3516: l_msg_count NUMBER;
3517: l_msg_data VARCHAR2(4000);
3518:
3519: l_empty_tbl po_tbl_number := NULL;
3520: l_header_id_tbl po_tbl_number := NULL;
3521: l_release_id_tbl po_tbl_number := NULL;
3522: l_line_id_tbl po_tbl_number := NULL;
3523: l_line_location_id_tbl po_tbl_number := NULL;

Line 3520: l_header_id_tbl po_tbl_number := NULL;

3516: l_msg_count NUMBER;
3517: l_msg_data VARCHAR2(4000);
3518:
3519: l_empty_tbl po_tbl_number := NULL;
3520: l_header_id_tbl po_tbl_number := NULL;
3521: l_release_id_tbl po_tbl_number := NULL;
3522: l_line_id_tbl po_tbl_number := NULL;
3523: l_line_location_id_tbl po_tbl_number := NULL;
3524: l_distribution_id_tbl po_tbl_number := NULL;

Line 3521: l_release_id_tbl po_tbl_number := NULL;

3517: l_msg_data VARCHAR2(4000);
3518:
3519: l_empty_tbl po_tbl_number := NULL;
3520: l_header_id_tbl po_tbl_number := NULL;
3521: l_release_id_tbl po_tbl_number := NULL;
3522: l_line_id_tbl po_tbl_number := NULL;
3523: l_line_location_id_tbl po_tbl_number := NULL;
3524: l_distribution_id_tbl po_tbl_number := NULL;
3525:

Line 3522: l_line_id_tbl po_tbl_number := NULL;

3518:
3519: l_empty_tbl po_tbl_number := NULL;
3520: l_header_id_tbl po_tbl_number := NULL;
3521: l_release_id_tbl po_tbl_number := NULL;
3522: l_line_id_tbl po_tbl_number := NULL;
3523: l_line_location_id_tbl po_tbl_number := NULL;
3524: l_distribution_id_tbl po_tbl_number := NULL;
3525:
3526: l_doc_id_tbl po_tbl_number;

Line 3523: l_line_location_id_tbl po_tbl_number := NULL;

3519: l_empty_tbl po_tbl_number := NULL;
3520: l_header_id_tbl po_tbl_number := NULL;
3521: l_release_id_tbl po_tbl_number := NULL;
3522: l_line_id_tbl po_tbl_number := NULL;
3523: l_line_location_id_tbl po_tbl_number := NULL;
3524: l_distribution_id_tbl po_tbl_number := NULL;
3525:
3526: l_doc_id_tbl po_tbl_number;
3527:

Line 3524: l_distribution_id_tbl po_tbl_number := NULL;

3520: l_header_id_tbl po_tbl_number := NULL;
3521: l_release_id_tbl po_tbl_number := NULL;
3522: l_line_id_tbl po_tbl_number := NULL;
3523: l_line_location_id_tbl po_tbl_number := NULL;
3524: l_distribution_id_tbl po_tbl_number := NULL;
3525:
3526: l_doc_id_tbl po_tbl_number;
3527:
3528: l_mode VARCHAR2(30);

Line 3526: l_doc_id_tbl po_tbl_number;

3522: l_line_id_tbl po_tbl_number := NULL;
3523: l_line_location_id_tbl po_tbl_number := NULL;
3524: l_distribution_id_tbl po_tbl_number := NULL;
3525:
3526: l_doc_id_tbl po_tbl_number;
3527:
3528: l_mode VARCHAR2(30);
3529:
3530: BEGIN

Line 3628: l_empty_tbl := po_tbl_number();

3624: -- Initialize all of the unset id tables.
3625:
3626: l_progress := '120';
3627:
3628: l_empty_tbl := po_tbl_number();
3629: l_empty_tbl.EXTEND(p_doc_level_id_tbl.COUNT);
3630:
3631: l_progress := '130';
3632:

Line 6144: l_sequence_num_tbl PO_TBL_NUMBER;

6140: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
6141: l_progress VARCHAR2(3) := '000';
6142:
6143: ----
6144: l_sequence_num_tbl PO_TBL_NUMBER;
6145: l_enc_amt_tbl PO_TBL_NUMBER;
6146: ----
6147:
6148: BEGIN

Line 6145: l_enc_amt_tbl PO_TBL_NUMBER;

6141: l_progress VARCHAR2(3) := '000';
6142:
6143: ----
6144: l_sequence_num_tbl PO_TBL_NUMBER;
6145: l_enc_amt_tbl PO_TBL_NUMBER;
6146: ----
6147:
6148: BEGIN
6149:

Line 6544: l_sequence_num_tbl PO_TBL_NUMBER;

6540: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
6541: l_progress VARCHAR2(3) := '000';
6542:
6543: l_return_status VARCHAR2(1);
6544: l_sequence_num_tbl PO_TBL_NUMBER;
6545: l_amount_to_round_tbl PO_TBL_NUMBER;
6546: l_exchange_rate_tbl PO_TBL_NUMBER;
6547: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6548: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;

Line 6545: l_amount_to_round_tbl PO_TBL_NUMBER;

6541: l_progress VARCHAR2(3) := '000';
6542:
6543: l_return_status VARCHAR2(1);
6544: l_sequence_num_tbl PO_TBL_NUMBER;
6545: l_amount_to_round_tbl PO_TBL_NUMBER;
6546: l_exchange_rate_tbl PO_TBL_NUMBER;
6547: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6548: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6549: l_cur_precision_func_tbl PO_TBL_NUMBER;

Line 6546: l_exchange_rate_tbl PO_TBL_NUMBER;

6542:
6543: l_return_status VARCHAR2(1);
6544: l_sequence_num_tbl PO_TBL_NUMBER;
6545: l_amount_to_round_tbl PO_TBL_NUMBER;
6546: l_exchange_rate_tbl PO_TBL_NUMBER;
6547: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6548: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6549: l_cur_precision_func_tbl PO_TBL_NUMBER;
6550: l_min_acct_unit_func_tbl PO_TBL_NUMBER;

Line 6547: l_cur_precision_foreign_tbl PO_TBL_NUMBER;

6543: l_return_status VARCHAR2(1);
6544: l_sequence_num_tbl PO_TBL_NUMBER;
6545: l_amount_to_round_tbl PO_TBL_NUMBER;
6546: l_exchange_rate_tbl PO_TBL_NUMBER;
6547: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6548: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6549: l_cur_precision_func_tbl PO_TBL_NUMBER;
6550: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6551: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671

Line 6548: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;

6544: l_sequence_num_tbl PO_TBL_NUMBER;
6545: l_amount_to_round_tbl PO_TBL_NUMBER;
6546: l_exchange_rate_tbl PO_TBL_NUMBER;
6547: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6548: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6549: l_cur_precision_func_tbl PO_TBL_NUMBER;
6550: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6551: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671
6552: l_amount_result_tbl PO_TBL_NUMBER;

Line 6549: l_cur_precision_func_tbl PO_TBL_NUMBER;

6545: l_amount_to_round_tbl PO_TBL_NUMBER;
6546: l_exchange_rate_tbl PO_TBL_NUMBER;
6547: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6548: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6549: l_cur_precision_func_tbl PO_TBL_NUMBER;
6550: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6551: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671
6552: l_amount_result_tbl PO_TBL_NUMBER;
6553:

Line 6550: l_min_acct_unit_func_tbl PO_TBL_NUMBER;

6546: l_exchange_rate_tbl PO_TBL_NUMBER;
6547: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6548: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6549: l_cur_precision_func_tbl PO_TBL_NUMBER;
6550: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6551: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671
6552: l_amount_result_tbl PO_TBL_NUMBER;
6553:
6554: l_origin_sequence_num_tbl PO_TBL_NUMBER; -- bug 3480949

Line 6552: l_amount_result_tbl PO_TBL_NUMBER;

6548: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6549: l_cur_precision_func_tbl PO_TBL_NUMBER;
6550: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6551: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671
6552: l_amount_result_tbl PO_TBL_NUMBER;
6553:
6554: l_origin_sequence_num_tbl PO_TBL_NUMBER; -- bug 3480949
6555:
6556: BEGIN

Line 6554: l_origin_sequence_num_tbl PO_TBL_NUMBER; -- bug 3480949

6550: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6551: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671
6552: l_amount_result_tbl PO_TBL_NUMBER;
6553:
6554: l_origin_sequence_num_tbl PO_TBL_NUMBER; -- bug 3480949
6555:
6556: BEGIN
6557:
6558: IF g_debug_stmt THEN

Line 6787: l_multiplier_tbl po_tbl_number;

6783: l_end_row number := 0;
6784: l_changed_amounts_flag varchar2(1) := 'N';
6785:
6786: -- Collections
6787: l_multiplier_tbl po_tbl_number;
6788: l_pa_dist_id_tbl po_tbl_number;
6789: l_pa_sequence_num_tbl po_tbl_number;
6790: l_amt_to_encumber_func_tbl po_tbl_number;
6791: l_unencumbered_amount_tbl po_tbl_number;

Line 6788: l_pa_dist_id_tbl po_tbl_number;

6784: l_changed_amounts_flag varchar2(1) := 'N';
6785:
6786: -- Collections
6787: l_multiplier_tbl po_tbl_number;
6788: l_pa_dist_id_tbl po_tbl_number;
6789: l_pa_sequence_num_tbl po_tbl_number;
6790: l_amt_to_encumber_func_tbl po_tbl_number;
6791: l_unencumbered_amount_tbl po_tbl_number;
6792: l_amount_tbl po_tbl_number;

Line 6789: l_pa_sequence_num_tbl po_tbl_number;

6785:
6786: -- Collections
6787: l_multiplier_tbl po_tbl_number;
6788: l_pa_dist_id_tbl po_tbl_number;
6789: l_pa_sequence_num_tbl po_tbl_number;
6790: l_amt_to_encumber_func_tbl po_tbl_number;
6791: l_unencumbered_amount_tbl po_tbl_number;
6792: l_amount_tbl po_tbl_number;
6793:

Line 6790: l_amt_to_encumber_func_tbl po_tbl_number;

6786: -- Collections
6787: l_multiplier_tbl po_tbl_number;
6788: l_pa_dist_id_tbl po_tbl_number;
6789: l_pa_sequence_num_tbl po_tbl_number;
6790: l_amt_to_encumber_func_tbl po_tbl_number;
6791: l_unencumbered_amount_tbl po_tbl_number;
6792: l_amount_tbl po_tbl_number;
6793:
6794: BEGIN

Line 6791: l_unencumbered_amount_tbl po_tbl_number;

6787: l_multiplier_tbl po_tbl_number;
6788: l_pa_dist_id_tbl po_tbl_number;
6789: l_pa_sequence_num_tbl po_tbl_number;
6790: l_amt_to_encumber_func_tbl po_tbl_number;
6791: l_unencumbered_amount_tbl po_tbl_number;
6792: l_amount_tbl po_tbl_number;
6793:
6794: BEGIN
6795:

Line 6792: l_amount_tbl po_tbl_number;

6788: l_pa_dist_id_tbl po_tbl_number;
6789: l_pa_sequence_num_tbl po_tbl_number;
6790: l_amt_to_encumber_func_tbl po_tbl_number;
6791: l_unencumbered_amount_tbl po_tbl_number;
6792: l_amount_tbl po_tbl_number;
6793:
6794: BEGIN
6795:
6796: l_progress := '000';

Line 7047: , p_pa_sequence_num_tbl IN po_tbl_number

7043: , p_end_row IN NUMBER
7044: , p_running_total IN NUMBER
7045: , p_amt_to_enc_func IN NUMBER
7046: , p_unencumbered_amt IN NUMBER
7047: , p_pa_sequence_num_tbl IN po_tbl_number
7048: , p_pa_multiplier_tbl IN po_tbl_number
7049: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number
7050: , x_changed_amounts_flag OUT NOCOPY VARCHAR2
7051: )

Line 7048: , p_pa_multiplier_tbl IN po_tbl_number

7044: , p_running_total IN NUMBER
7045: , p_amt_to_enc_func IN NUMBER
7046: , p_unencumbered_amt IN NUMBER
7047: , p_pa_sequence_num_tbl IN po_tbl_number
7048: , p_pa_multiplier_tbl IN po_tbl_number
7049: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number
7050: , x_changed_amounts_flag OUT NOCOPY VARCHAR2
7051: )
7052:

Line 7049: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number

7045: , p_amt_to_enc_func IN NUMBER
7046: , p_unencumbered_amt IN NUMBER
7047: , p_pa_sequence_num_tbl IN po_tbl_number
7048: , p_pa_multiplier_tbl IN po_tbl_number
7049: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number
7050: , x_changed_amounts_flag OUT NOCOPY VARCHAR2
7051: )
7052:
7053: IS

Line 7201: l_req_dist_id_tbl po_tbl_number;

7197: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
7198: l_progress varchar2(3);
7199:
7200: -- Collections
7201: l_req_dist_id_tbl po_tbl_number;
7202: l_max_total_tbl po_tbl_number;
7203: l_req_dist_gtt_total_tbl po_tbl_number;
7204:
7205: BEGIN

Line 7202: l_max_total_tbl po_tbl_number;

7198: l_progress varchar2(3);
7199:
7200: -- Collections
7201: l_req_dist_id_tbl po_tbl_number;
7202: l_max_total_tbl po_tbl_number;
7203: l_req_dist_gtt_total_tbl po_tbl_number;
7204:
7205: BEGIN
7206:

Line 7203: l_req_dist_gtt_total_tbl po_tbl_number;

7199:
7200: -- Collections
7201: l_req_dist_id_tbl po_tbl_number;
7202: l_max_total_tbl po_tbl_number;
7203: l_req_dist_gtt_total_tbl po_tbl_number;
7204:
7205: BEGIN
7206:
7207: l_progress := '000';

Line 7381: l_sequence_num_tbl po_tbl_number;

7377:
7378: l_proc_name CONSTANT VARCHAR2(30) := 'CORRECT_BACKING_REQ_AMOUNTS';
7379: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_proc_name;
7380: l_progress VARCHAR2(3) := '000';
7381: l_sequence_num_tbl po_tbl_number;
7382: l_gtt_amount_tbl po_tbl_number;
7383: l_start_row NUMBER := 0;
7384: l_end_row NUMBER := 0;
7385: l_amount_available NUMBER;

Line 7382: l_gtt_amount_tbl po_tbl_number;

7378: l_proc_name CONSTANT VARCHAR2(30) := 'CORRECT_BACKING_REQ_AMOUNTS';
7379: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_proc_name;
7380: l_progress VARCHAR2(3) := '000';
7381: l_sequence_num_tbl po_tbl_number;
7382: l_gtt_amount_tbl po_tbl_number;
7383: l_start_row NUMBER := 0;
7384: l_end_row NUMBER := 0;
7385: l_amount_available NUMBER;
7386: l_current_amount NUMBER;

Line 8089: l_sequence_num_tbl PO_TBL_NUMBER;

8085: l_api_name CONSTANT varchar2(40) := 'UPDATE_AMOUNTS';
8086: l_progress varchar2(3);
8087:
8088: l_return_status VARCHAR2(1);
8089: l_sequence_num_tbl PO_TBL_NUMBER;
8090: l_amount_to_round_tbl PO_TBL_NUMBER;
8091: l_exchange_rate_tbl PO_TBL_NUMBER;
8092: l_cur_precision_from_tbl PO_TBL_NUMBER;
8093: l_min_acct_unit_from_tbl PO_TBL_NUMBER;

Line 8090: l_amount_to_round_tbl PO_TBL_NUMBER;

8086: l_progress varchar2(3);
8087:
8088: l_return_status VARCHAR2(1);
8089: l_sequence_num_tbl PO_TBL_NUMBER;
8090: l_amount_to_round_tbl PO_TBL_NUMBER;
8091: l_exchange_rate_tbl PO_TBL_NUMBER;
8092: l_cur_precision_from_tbl PO_TBL_NUMBER;
8093: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
8094: l_cur_precision_to_tbl PO_TBL_NUMBER;

Line 8091: l_exchange_rate_tbl PO_TBL_NUMBER;

8087:
8088: l_return_status VARCHAR2(1);
8089: l_sequence_num_tbl PO_TBL_NUMBER;
8090: l_amount_to_round_tbl PO_TBL_NUMBER;
8091: l_exchange_rate_tbl PO_TBL_NUMBER;
8092: l_cur_precision_from_tbl PO_TBL_NUMBER;
8093: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
8094: l_cur_precision_to_tbl PO_TBL_NUMBER;
8095: l_min_acct_unit_to_tbl PO_TBL_NUMBER;

Line 8092: l_cur_precision_from_tbl PO_TBL_NUMBER;

8088: l_return_status VARCHAR2(1);
8089: l_sequence_num_tbl PO_TBL_NUMBER;
8090: l_amount_to_round_tbl PO_TBL_NUMBER;
8091: l_exchange_rate_tbl PO_TBL_NUMBER;
8092: l_cur_precision_from_tbl PO_TBL_NUMBER;
8093: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
8094: l_cur_precision_to_tbl PO_TBL_NUMBER;
8095: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
8096: l_round_only_flag_tbl PO_TBL_VARCHAR1;

Line 8093: l_min_acct_unit_from_tbl PO_TBL_NUMBER;

8089: l_sequence_num_tbl PO_TBL_NUMBER;
8090: l_amount_to_round_tbl PO_TBL_NUMBER;
8091: l_exchange_rate_tbl PO_TBL_NUMBER;
8092: l_cur_precision_from_tbl PO_TBL_NUMBER;
8093: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
8094: l_cur_precision_to_tbl PO_TBL_NUMBER;
8095: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
8096: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8097: l_amount_result_tbl PO_TBL_NUMBER;

Line 8094: l_cur_precision_to_tbl PO_TBL_NUMBER;

8090: l_amount_to_round_tbl PO_TBL_NUMBER;
8091: l_exchange_rate_tbl PO_TBL_NUMBER;
8092: l_cur_precision_from_tbl PO_TBL_NUMBER;
8093: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
8094: l_cur_precision_to_tbl PO_TBL_NUMBER;
8095: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
8096: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8097: l_amount_result_tbl PO_TBL_NUMBER;
8098: l_origin_sequence_num_tbl PO_TBL_NUMBER;

Line 8095: l_min_acct_unit_to_tbl PO_TBL_NUMBER;

8091: l_exchange_rate_tbl PO_TBL_NUMBER;
8092: l_cur_precision_from_tbl PO_TBL_NUMBER;
8093: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
8094: l_cur_precision_to_tbl PO_TBL_NUMBER;
8095: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
8096: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8097: l_amount_result_tbl PO_TBL_NUMBER;
8098: l_origin_sequence_num_tbl PO_TBL_NUMBER;
8099: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;

Line 8097: l_amount_result_tbl PO_TBL_NUMBER;

8093: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
8094: l_cur_precision_to_tbl PO_TBL_NUMBER;
8095: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
8096: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8097: l_amount_result_tbl PO_TBL_NUMBER;
8098: l_origin_sequence_num_tbl PO_TBL_NUMBER;
8099: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
8100: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
8101: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;

Line 8098: l_origin_sequence_num_tbl PO_TBL_NUMBER;

8094: l_cur_precision_to_tbl PO_TBL_NUMBER;
8095: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
8096: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8097: l_amount_result_tbl PO_TBL_NUMBER;
8098: l_origin_sequence_num_tbl PO_TBL_NUMBER;
8099: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
8100: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
8101: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
8102: BEGIN

Line 8434: l_sequence_num_tbl PO_TBL_NUMBER;

8430: l_api_name CONSTANT VARCHAR2(40) := 'UPDATE_CLM_FINAL_AMOUNTS';
8431: l_log_head CONSTANT VARCHAR2(100) := g_log_head|| l_api_name;
8432: l_progress VARCHAR2(3) := '000';
8433: l_return_status VARCHAR2(1);
8434: l_sequence_num_tbl PO_TBL_NUMBER;
8435: l_amount_to_round_tbl PO_TBL_NUMBER;
8436: l_exchange_rate_tbl PO_TBL_NUMBER;
8437: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
8438: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;

Line 8435: l_amount_to_round_tbl PO_TBL_NUMBER;

8431: l_log_head CONSTANT VARCHAR2(100) := g_log_head|| l_api_name;
8432: l_progress VARCHAR2(3) := '000';
8433: l_return_status VARCHAR2(1);
8434: l_sequence_num_tbl PO_TBL_NUMBER;
8435: l_amount_to_round_tbl PO_TBL_NUMBER;
8436: l_exchange_rate_tbl PO_TBL_NUMBER;
8437: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
8438: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
8439: l_cur_precision_func_tbl PO_TBL_NUMBER;

Line 8436: l_exchange_rate_tbl PO_TBL_NUMBER;

8432: l_progress VARCHAR2(3) := '000';
8433: l_return_status VARCHAR2(1);
8434: l_sequence_num_tbl PO_TBL_NUMBER;
8435: l_amount_to_round_tbl PO_TBL_NUMBER;
8436: l_exchange_rate_tbl PO_TBL_NUMBER;
8437: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
8438: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
8439: l_cur_precision_func_tbl PO_TBL_NUMBER;
8440: l_min_acct_unit_func_tbl PO_TBL_NUMBER;

Line 8437: l_cur_precision_foreign_tbl PO_TBL_NUMBER;

8433: l_return_status VARCHAR2(1);
8434: l_sequence_num_tbl PO_TBL_NUMBER;
8435: l_amount_to_round_tbl PO_TBL_NUMBER;
8436: l_exchange_rate_tbl PO_TBL_NUMBER;
8437: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
8438: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
8439: l_cur_precision_func_tbl PO_TBL_NUMBER;
8440: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
8441: l_round_only_flag_tbl PO_TBL_VARCHAR1;

Line 8438: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;

8434: l_sequence_num_tbl PO_TBL_NUMBER;
8435: l_amount_to_round_tbl PO_TBL_NUMBER;
8436: l_exchange_rate_tbl PO_TBL_NUMBER;
8437: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
8438: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
8439: l_cur_precision_func_tbl PO_TBL_NUMBER;
8440: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
8441: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8442: l_amount_result_tbl PO_TBL_NUMBER;

Line 8439: l_cur_precision_func_tbl PO_TBL_NUMBER;

8435: l_amount_to_round_tbl PO_TBL_NUMBER;
8436: l_exchange_rate_tbl PO_TBL_NUMBER;
8437: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
8438: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
8439: l_cur_precision_func_tbl PO_TBL_NUMBER;
8440: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
8441: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8442: l_amount_result_tbl PO_TBL_NUMBER;
8443: l_origin_sequence_num_tbl PO_TBL_NUMBER;

Line 8440: l_min_acct_unit_func_tbl PO_TBL_NUMBER;

8436: l_exchange_rate_tbl PO_TBL_NUMBER;
8437: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
8438: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
8439: l_cur_precision_func_tbl PO_TBL_NUMBER;
8440: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
8441: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8442: l_amount_result_tbl PO_TBL_NUMBER;
8443: l_origin_sequence_num_tbl PO_TBL_NUMBER;
8444: BEGIN

Line 8442: l_amount_result_tbl PO_TBL_NUMBER;

8438: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
8439: l_cur_precision_func_tbl PO_TBL_NUMBER;
8440: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
8441: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8442: l_amount_result_tbl PO_TBL_NUMBER;
8443: l_origin_sequence_num_tbl PO_TBL_NUMBER;
8444: BEGIN
8445: IF g_debug_stmt THEN
8446: PO_DEBUG.debug_begin(l_log_head);

Line 8443: l_origin_sequence_num_tbl PO_TBL_NUMBER;

8439: l_cur_precision_func_tbl PO_TBL_NUMBER;
8440: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
8441: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8442: l_amount_result_tbl PO_TBL_NUMBER;
8443: l_origin_sequence_num_tbl PO_TBL_NUMBER;
8444: BEGIN
8445: IF g_debug_stmt THEN
8446: PO_DEBUG.debug_begin(l_log_head);
8447: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action', p_action);