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 326: , p_origin_seq_num_tbl IN po_tbl_number

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

Line 327: , p_backing_dist_id_tbl IN po_tbl_number

323: p_action IN VARCHAR2
324: , p_distribution_type IN VARCHAR2
325: , p_main_or_backing IN VARCHAR2
326: , p_origin_seq_num_tbl IN po_tbl_number
327: , p_backing_dist_id_tbl IN po_tbl_number
328: , p_ap_budget_account_id IN NUMBER
329: , x_count OUT NOCOPY NUMBER
330: );
331:

Line 339: , x_dist_id_tbl OUT NOCOPY po_tbl_number

335:
336: PROCEDURE filter_backing_distributions(
337: p_action IN VARCHAR2
338: , p_distribution_type IN VARCHAR2
339: , x_dist_id_tbl OUT NOCOPY po_tbl_number
340: , x_origin_seq_num_tbl OUT NOCOPY po_tbl_number
341: );
342:
343: PROCEDURE check_doc_state(

Line 340: , x_origin_seq_num_tbl OUT NOCOPY po_tbl_number

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

Line 348: , p_doc_level_id_tbl IN po_tbl_number

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

Line 436: , p_pa_sequence_num_tbl IN po_tbl_number

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

Line 437: , p_pa_multiplier_tbl IN po_tbl_number

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

Line 438: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number

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

Line 1063: l_doc_level_id_tbl po_tbl_number;

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

Line 1064: l_origin_seq_num_tbl po_tbl_number;

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

Line 1192: l_doc_level_id_tbl := po_tbl_number( p_doc_level_id );

1188: END IF;
1189:
1190: l_check_only_flag := p_check_only_flag;
1191:
1192: l_doc_level_id_tbl := po_tbl_number( p_doc_level_id );
1193:
1194: l_doc_level := p_doc_level;
1195:
1196: ELSE

Line 1543: , p_origin_seq_num_tbl IN po_tbl_number

1539: PROCEDURE update_encumbrance_gt(
1540: p_action IN VARCHAR2
1541: , p_distribution_type IN VARCHAR2
1542: , p_main_or_backing IN VARCHAR2
1543: , p_origin_seq_num_tbl IN po_tbl_number
1544: , p_backing_dist_id_tbl IN po_tbl_number
1545: , p_ap_budget_account_id IN NUMBER
1546: , x_count OUT NOCOPY NUMBER
1547: )

Line 1544: , p_backing_dist_id_tbl IN po_tbl_number

1540: p_action IN VARCHAR2
1541: , p_distribution_type IN VARCHAR2
1542: , p_main_or_backing IN VARCHAR2
1543: , p_origin_seq_num_tbl IN po_tbl_number
1544: , p_backing_dist_id_tbl IN po_tbl_number
1545: , p_ap_budget_account_id IN NUMBER
1546: , x_count OUT NOCOPY NUMBER
1547: )
1548: IS

Line 1843: l_distribution_id_tbl po_tbl_number;

1839: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_BACKING_DISTRIBUTIONS';
1840: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1841: l_progress VARCHAR2(3) := '000';
1842:
1843: l_distribution_id_tbl po_tbl_number;
1844:
1845: l_doc_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1846: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
1847:

Line 1999: , x_dist_id_tbl OUT NOCOPY po_tbl_number

1995: -------------------------------------------------------------------------------
1996: PROCEDURE filter_backing_distributions(
1997: p_action IN VARCHAR2
1998: , p_distribution_type IN VARCHAR2
1999: , x_dist_id_tbl OUT NOCOPY po_tbl_number
2000: , x_origin_seq_num_tbl OUT NOCOPY po_tbl_number
2001: )
2002: IS
2003:

Line 2000: , x_origin_seq_num_tbl OUT NOCOPY po_tbl_number

1996: PROCEDURE filter_backing_distributions(
1997: p_action IN VARCHAR2
1998: , p_distribution_type IN VARCHAR2
1999: , x_dist_id_tbl OUT NOCOPY po_tbl_number
2000: , x_origin_seq_num_tbl OUT NOCOPY po_tbl_number
2001: )
2002: IS
2003:
2004: l_api_name CONSTANT VARCHAR2(30) := 'FILTER_BACKING_DISTRIBUTIONS';

Line 2623: l_count_tbl po_tbl_number;

2619: -- bug 3435714
2620: l_doc_level VARCHAR2(30);
2621: l_doc_level_tbl po_tbl_varchar30;
2622: l_dist_type_tbl po_tbl_varchar30;
2623: l_count_tbl po_tbl_number;
2624: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2625: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2626: l_doc_level_id_tbl po_tbl_number;
2627: l_id_tbl po_tbl_number;

Line 2626: l_doc_level_id_tbl po_tbl_number;

2622: l_dist_type_tbl po_tbl_varchar30;
2623: l_count_tbl po_tbl_number;
2624: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2625: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2626: l_doc_level_id_tbl po_tbl_number;
2627: l_id_tbl po_tbl_number;
2628: l_doc_id NUMBER;
2629: l_multiple_docs_flag VARCHAR2(1);
2630:

Line 2627: l_id_tbl po_tbl_number;

2623: l_count_tbl po_tbl_number;
2624: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2625: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2626: l_doc_level_id_tbl po_tbl_number;
2627: l_id_tbl po_tbl_number;
2628: l_doc_id NUMBER;
2629: l_multiple_docs_flag VARCHAR2(1);
2630:
2631: l_sub_check_action VARCHAR2(4000);

Line 2752: l_doc_level_id_tbl := po_tbl_number( p_doc_level_id );

2748:
2749: IF (p_use_enc_gt_flag = g_parameter_NO) THEN
2750: l_progress := 'a00';
2751: l_doc_level := p_doc_level;
2752: l_doc_level_id_tbl := po_tbl_number( p_doc_level_id );
2753: END IF;
2754:
2755: l_progress := 'a10';
2756:

Line 3095: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )

3091:
3092: PO_CORE_S.get_document_ids(
3093: p_doc_type => p_doc_type
3094: , p_doc_level => p_doc_level
3095: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
3096: , x_doc_id_tbl => l_id_tbl
3097: );
3098:
3099: l_progress := '330';

Line 3112: , p_doc_level_id_tbl => po_tbl_number( l_doc_id )

3108:
3109: PO_LOCKS.lock_headers(
3110: p_doc_type => p_doc_type
3111: , p_doc_level => g_doc_level_HEADER
3112: , p_doc_level_id_tbl => po_tbl_number( l_doc_id )
3113: );
3114:
3115: l_progress := '350';
3116:

Line 3228: l_doc_level_id_tbl := po_tbl_number( l_doc_id );

3224: -- While locking the doc header, we already retrieved the doc id.
3225: -- Reserve submission checks are only defined at the header level.
3226:
3227: l_doc_level := g_doc_level_HEADER;
3228: l_doc_level_id_tbl := po_tbl_number( l_doc_id );
3229:
3230: ELSIF ( p_action = g_action_UNRESERVE
3231: AND p_doc_type IN (g_doc_type_PO, g_doc_type_RELEASE)
3232: ) THEN

Line 3462: , p_doc_level_id_tbl IN po_tbl_number

3458: p_action IN VARCHAR2
3459: , p_doc_type IN VARCHAR2
3460: , p_doc_subtype IN VARCHAR2
3461: , p_doc_level IN VARCHAR2
3462: , p_doc_level_id_tbl IN po_tbl_number
3463: , x_valid_state_flag OUT NOCOPY VARCHAR2
3464: )
3465: IS
3466:

Line 3477: l_empty_tbl po_tbl_number := NULL;

3473: l_status_rec PO_STATUS_REC_TYPE;
3474: l_msg_count NUMBER;
3475: l_msg_data VARCHAR2(4000);
3476:
3477: l_empty_tbl po_tbl_number := NULL;
3478: l_header_id_tbl po_tbl_number := NULL;
3479: l_release_id_tbl po_tbl_number := NULL;
3480: l_line_id_tbl po_tbl_number := NULL;
3481: l_line_location_id_tbl po_tbl_number := NULL;

Line 3478: l_header_id_tbl po_tbl_number := NULL;

3474: l_msg_count NUMBER;
3475: l_msg_data VARCHAR2(4000);
3476:
3477: l_empty_tbl po_tbl_number := NULL;
3478: l_header_id_tbl po_tbl_number := NULL;
3479: l_release_id_tbl po_tbl_number := NULL;
3480: l_line_id_tbl po_tbl_number := NULL;
3481: l_line_location_id_tbl po_tbl_number := NULL;
3482: l_distribution_id_tbl po_tbl_number := NULL;

Line 3479: l_release_id_tbl po_tbl_number := NULL;

3475: l_msg_data VARCHAR2(4000);
3476:
3477: l_empty_tbl po_tbl_number := NULL;
3478: l_header_id_tbl po_tbl_number := NULL;
3479: l_release_id_tbl po_tbl_number := NULL;
3480: l_line_id_tbl po_tbl_number := NULL;
3481: l_line_location_id_tbl po_tbl_number := NULL;
3482: l_distribution_id_tbl po_tbl_number := NULL;
3483:

Line 3480: l_line_id_tbl po_tbl_number := NULL;

3476:
3477: l_empty_tbl po_tbl_number := NULL;
3478: l_header_id_tbl po_tbl_number := NULL;
3479: l_release_id_tbl po_tbl_number := NULL;
3480: l_line_id_tbl po_tbl_number := NULL;
3481: l_line_location_id_tbl po_tbl_number := NULL;
3482: l_distribution_id_tbl po_tbl_number := NULL;
3483:
3484: l_doc_id_tbl po_tbl_number;

Line 3481: l_line_location_id_tbl po_tbl_number := NULL;

3477: l_empty_tbl po_tbl_number := NULL;
3478: l_header_id_tbl po_tbl_number := NULL;
3479: l_release_id_tbl po_tbl_number := NULL;
3480: l_line_id_tbl po_tbl_number := NULL;
3481: l_line_location_id_tbl po_tbl_number := NULL;
3482: l_distribution_id_tbl po_tbl_number := NULL;
3483:
3484: l_doc_id_tbl po_tbl_number;
3485:

Line 3482: l_distribution_id_tbl po_tbl_number := NULL;

3478: l_header_id_tbl po_tbl_number := NULL;
3479: l_release_id_tbl po_tbl_number := NULL;
3480: l_line_id_tbl po_tbl_number := NULL;
3481: l_line_location_id_tbl po_tbl_number := NULL;
3482: l_distribution_id_tbl po_tbl_number := NULL;
3483:
3484: l_doc_id_tbl po_tbl_number;
3485:
3486: l_mode VARCHAR2(30);

Line 3484: l_doc_id_tbl po_tbl_number;

3480: l_line_id_tbl po_tbl_number := NULL;
3481: l_line_location_id_tbl po_tbl_number := NULL;
3482: l_distribution_id_tbl po_tbl_number := NULL;
3483:
3484: l_doc_id_tbl po_tbl_number;
3485:
3486: l_mode VARCHAR2(30);
3487:
3488: BEGIN

Line 3586: l_empty_tbl := po_tbl_number();

3582: -- Initialize all of the unset id tables.
3583:
3584: l_progress := '120';
3585:
3586: l_empty_tbl := po_tbl_number();
3587: l_empty_tbl.EXTEND(p_doc_level_id_tbl.COUNT);
3588:
3589: l_progress := '130';
3590:

Line 6167: l_sequence_num_tbl PO_TBL_NUMBER;

6163: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
6164: l_progress VARCHAR2(3) := '000';
6165:
6166: l_return_status VARCHAR2(1);
6167: l_sequence_num_tbl PO_TBL_NUMBER;
6168: l_amount_to_round_tbl PO_TBL_NUMBER;
6169: l_exchange_rate_tbl PO_TBL_NUMBER;
6170: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6171: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;

Line 6168: l_amount_to_round_tbl PO_TBL_NUMBER;

6164: l_progress VARCHAR2(3) := '000';
6165:
6166: l_return_status VARCHAR2(1);
6167: l_sequence_num_tbl PO_TBL_NUMBER;
6168: l_amount_to_round_tbl PO_TBL_NUMBER;
6169: l_exchange_rate_tbl PO_TBL_NUMBER;
6170: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6171: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6172: l_cur_precision_func_tbl PO_TBL_NUMBER;

Line 6169: l_exchange_rate_tbl PO_TBL_NUMBER;

6165:
6166: l_return_status VARCHAR2(1);
6167: l_sequence_num_tbl PO_TBL_NUMBER;
6168: l_amount_to_round_tbl PO_TBL_NUMBER;
6169: l_exchange_rate_tbl PO_TBL_NUMBER;
6170: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6171: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6172: l_cur_precision_func_tbl PO_TBL_NUMBER;
6173: l_min_acct_unit_func_tbl PO_TBL_NUMBER;

Line 6170: l_cur_precision_foreign_tbl PO_TBL_NUMBER;

6166: l_return_status VARCHAR2(1);
6167: l_sequence_num_tbl PO_TBL_NUMBER;
6168: l_amount_to_round_tbl PO_TBL_NUMBER;
6169: l_exchange_rate_tbl PO_TBL_NUMBER;
6170: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6171: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6172: l_cur_precision_func_tbl PO_TBL_NUMBER;
6173: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6174: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671

Line 6171: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;

6167: l_sequence_num_tbl PO_TBL_NUMBER;
6168: l_amount_to_round_tbl PO_TBL_NUMBER;
6169: l_exchange_rate_tbl PO_TBL_NUMBER;
6170: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6171: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6172: l_cur_precision_func_tbl PO_TBL_NUMBER;
6173: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6174: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671
6175: l_amount_result_tbl PO_TBL_NUMBER;

Line 6172: l_cur_precision_func_tbl PO_TBL_NUMBER;

6168: l_amount_to_round_tbl PO_TBL_NUMBER;
6169: l_exchange_rate_tbl PO_TBL_NUMBER;
6170: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6171: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6172: l_cur_precision_func_tbl PO_TBL_NUMBER;
6173: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6174: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671
6175: l_amount_result_tbl PO_TBL_NUMBER;
6176:

Line 6173: l_min_acct_unit_func_tbl PO_TBL_NUMBER;

6169: l_exchange_rate_tbl PO_TBL_NUMBER;
6170: l_cur_precision_foreign_tbl PO_TBL_NUMBER;
6171: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6172: l_cur_precision_func_tbl PO_TBL_NUMBER;
6173: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6174: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671
6175: l_amount_result_tbl PO_TBL_NUMBER;
6176:
6177: l_origin_sequence_num_tbl PO_TBL_NUMBER; -- bug 3480949

Line 6175: l_amount_result_tbl PO_TBL_NUMBER;

6171: l_min_acct_unit_foreign_tbl PO_TBL_NUMBER;
6172: l_cur_precision_func_tbl PO_TBL_NUMBER;
6173: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6174: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671
6175: l_amount_result_tbl PO_TBL_NUMBER;
6176:
6177: l_origin_sequence_num_tbl PO_TBL_NUMBER; -- bug 3480949
6178:
6179: BEGIN

Line 6177: l_origin_sequence_num_tbl PO_TBL_NUMBER; -- bug 3480949

6173: l_min_acct_unit_func_tbl PO_TBL_NUMBER;
6174: l_round_only_flag_tbl PO_TBL_VARCHAR1; --bug 3568671
6175: l_amount_result_tbl PO_TBL_NUMBER;
6176:
6177: l_origin_sequence_num_tbl PO_TBL_NUMBER; -- bug 3480949
6178:
6179: BEGIN
6180:
6181: IF g_debug_stmt THEN

Line 6389: l_multiplier_tbl po_tbl_number;

6385: l_end_row number := 0;
6386: l_changed_amounts_flag varchar2(1) := 'N';
6387:
6388: -- Collections
6389: l_multiplier_tbl po_tbl_number;
6390: l_pa_dist_id_tbl po_tbl_number;
6391: l_pa_sequence_num_tbl po_tbl_number;
6392: l_amt_to_encumber_func_tbl po_tbl_number;
6393: l_unencumbered_amount_tbl po_tbl_number;

Line 6390: l_pa_dist_id_tbl po_tbl_number;

6386: l_changed_amounts_flag varchar2(1) := 'N';
6387:
6388: -- Collections
6389: l_multiplier_tbl po_tbl_number;
6390: l_pa_dist_id_tbl po_tbl_number;
6391: l_pa_sequence_num_tbl po_tbl_number;
6392: l_amt_to_encumber_func_tbl po_tbl_number;
6393: l_unencumbered_amount_tbl po_tbl_number;
6394: l_amount_tbl po_tbl_number;

Line 6391: l_pa_sequence_num_tbl po_tbl_number;

6387:
6388: -- Collections
6389: l_multiplier_tbl po_tbl_number;
6390: l_pa_dist_id_tbl po_tbl_number;
6391: l_pa_sequence_num_tbl po_tbl_number;
6392: l_amt_to_encumber_func_tbl po_tbl_number;
6393: l_unencumbered_amount_tbl po_tbl_number;
6394: l_amount_tbl po_tbl_number;
6395:

Line 6392: l_amt_to_encumber_func_tbl po_tbl_number;

6388: -- Collections
6389: l_multiplier_tbl po_tbl_number;
6390: l_pa_dist_id_tbl po_tbl_number;
6391: l_pa_sequence_num_tbl po_tbl_number;
6392: l_amt_to_encumber_func_tbl po_tbl_number;
6393: l_unencumbered_amount_tbl po_tbl_number;
6394: l_amount_tbl po_tbl_number;
6395:
6396: BEGIN

Line 6393: l_unencumbered_amount_tbl po_tbl_number;

6389: l_multiplier_tbl po_tbl_number;
6390: l_pa_dist_id_tbl po_tbl_number;
6391: l_pa_sequence_num_tbl po_tbl_number;
6392: l_amt_to_encumber_func_tbl po_tbl_number;
6393: l_unencumbered_amount_tbl po_tbl_number;
6394: l_amount_tbl po_tbl_number;
6395:
6396: BEGIN
6397:

Line 6394: l_amount_tbl po_tbl_number;

6390: l_pa_dist_id_tbl po_tbl_number;
6391: l_pa_sequence_num_tbl po_tbl_number;
6392: l_amt_to_encumber_func_tbl po_tbl_number;
6393: l_unencumbered_amount_tbl po_tbl_number;
6394: l_amount_tbl po_tbl_number;
6395:
6396: BEGIN
6397:
6398: l_progress := '000';

Line 6649: , p_pa_sequence_num_tbl IN po_tbl_number

6645: , p_end_row IN NUMBER
6646: , p_running_total IN NUMBER
6647: , p_amt_to_enc_func IN NUMBER
6648: , p_unencumbered_amt IN NUMBER
6649: , p_pa_sequence_num_tbl IN po_tbl_number
6650: , p_pa_multiplier_tbl IN po_tbl_number
6651: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number
6652: , x_changed_amounts_flag OUT NOCOPY VARCHAR2
6653: )

Line 6650: , p_pa_multiplier_tbl IN po_tbl_number

6646: , p_running_total IN NUMBER
6647: , p_amt_to_enc_func IN NUMBER
6648: , p_unencumbered_amt IN NUMBER
6649: , p_pa_sequence_num_tbl IN po_tbl_number
6650: , p_pa_multiplier_tbl IN po_tbl_number
6651: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number
6652: , x_changed_amounts_flag OUT NOCOPY VARCHAR2
6653: )
6654:

Line 6651: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number

6647: , p_amt_to_enc_func IN NUMBER
6648: , p_unencumbered_amt IN NUMBER
6649: , p_pa_sequence_num_tbl IN po_tbl_number
6650: , p_pa_multiplier_tbl IN po_tbl_number
6651: , x_pa_amount_tbl IN OUT NOCOPY po_tbl_number
6652: , x_changed_amounts_flag OUT NOCOPY VARCHAR2
6653: )
6654:
6655: IS

Line 6803: l_req_dist_id_tbl po_tbl_number;

6799: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
6800: l_progress varchar2(3);
6801:
6802: -- Collections
6803: l_req_dist_id_tbl po_tbl_number;
6804: l_max_total_tbl po_tbl_number;
6805: l_req_dist_gtt_total_tbl po_tbl_number;
6806:
6807: BEGIN

Line 6804: l_max_total_tbl po_tbl_number;

6800: l_progress varchar2(3);
6801:
6802: -- Collections
6803: l_req_dist_id_tbl po_tbl_number;
6804: l_max_total_tbl po_tbl_number;
6805: l_req_dist_gtt_total_tbl po_tbl_number;
6806:
6807: BEGIN
6808:

Line 6805: l_req_dist_gtt_total_tbl po_tbl_number;

6801:
6802: -- Collections
6803: l_req_dist_id_tbl po_tbl_number;
6804: l_max_total_tbl po_tbl_number;
6805: l_req_dist_gtt_total_tbl po_tbl_number;
6806:
6807: BEGIN
6808:
6809: l_progress := '000';

Line 6983: l_sequence_num_tbl po_tbl_number;

6979:
6980: l_proc_name CONSTANT VARCHAR2(30) := 'CORRECT_BACKING_REQ_AMOUNTS';
6981: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_proc_name;
6982: l_progress VARCHAR2(3) := '000';
6983: l_sequence_num_tbl po_tbl_number;
6984: l_gtt_amount_tbl po_tbl_number;
6985: l_start_row NUMBER := 0;
6986: l_end_row NUMBER := 0;
6987: l_amount_available NUMBER;

Line 6984: l_gtt_amount_tbl po_tbl_number;

6980: l_proc_name CONSTANT VARCHAR2(30) := 'CORRECT_BACKING_REQ_AMOUNTS';
6981: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_proc_name;
6982: l_progress VARCHAR2(3) := '000';
6983: l_sequence_num_tbl po_tbl_number;
6984: l_gtt_amount_tbl po_tbl_number;
6985: l_start_row NUMBER := 0;
6986: l_end_row NUMBER := 0;
6987: l_amount_available NUMBER;
6988: l_current_amount NUMBER;

Line 7689: l_sequence_num_tbl PO_TBL_NUMBER;

7685: l_api_name CONSTANT varchar2(40) := 'UPDATE_AMOUNTS';
7686: l_progress varchar2(3);
7687:
7688: l_return_status VARCHAR2(1);
7689: l_sequence_num_tbl PO_TBL_NUMBER;
7690: l_amount_to_round_tbl PO_TBL_NUMBER;
7691: l_exchange_rate_tbl PO_TBL_NUMBER;
7692: l_cur_precision_from_tbl PO_TBL_NUMBER;
7693: l_min_acct_unit_from_tbl PO_TBL_NUMBER;

Line 7690: l_amount_to_round_tbl PO_TBL_NUMBER;

7686: l_progress varchar2(3);
7687:
7688: l_return_status VARCHAR2(1);
7689: l_sequence_num_tbl PO_TBL_NUMBER;
7690: l_amount_to_round_tbl PO_TBL_NUMBER;
7691: l_exchange_rate_tbl PO_TBL_NUMBER;
7692: l_cur_precision_from_tbl PO_TBL_NUMBER;
7693: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
7694: l_cur_precision_to_tbl PO_TBL_NUMBER;

Line 7691: l_exchange_rate_tbl PO_TBL_NUMBER;

7687:
7688: l_return_status VARCHAR2(1);
7689: l_sequence_num_tbl PO_TBL_NUMBER;
7690: l_amount_to_round_tbl PO_TBL_NUMBER;
7691: l_exchange_rate_tbl PO_TBL_NUMBER;
7692: l_cur_precision_from_tbl PO_TBL_NUMBER;
7693: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
7694: l_cur_precision_to_tbl PO_TBL_NUMBER;
7695: l_min_acct_unit_to_tbl PO_TBL_NUMBER;

Line 7692: l_cur_precision_from_tbl PO_TBL_NUMBER;

7688: l_return_status VARCHAR2(1);
7689: l_sequence_num_tbl PO_TBL_NUMBER;
7690: l_amount_to_round_tbl PO_TBL_NUMBER;
7691: l_exchange_rate_tbl PO_TBL_NUMBER;
7692: l_cur_precision_from_tbl PO_TBL_NUMBER;
7693: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
7694: l_cur_precision_to_tbl PO_TBL_NUMBER;
7695: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
7696: l_round_only_flag_tbl PO_TBL_VARCHAR1;

Line 7693: l_min_acct_unit_from_tbl PO_TBL_NUMBER;

7689: l_sequence_num_tbl PO_TBL_NUMBER;
7690: l_amount_to_round_tbl PO_TBL_NUMBER;
7691: l_exchange_rate_tbl PO_TBL_NUMBER;
7692: l_cur_precision_from_tbl PO_TBL_NUMBER;
7693: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
7694: l_cur_precision_to_tbl PO_TBL_NUMBER;
7695: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
7696: l_round_only_flag_tbl PO_TBL_VARCHAR1;
7697: l_amount_result_tbl PO_TBL_NUMBER;

Line 7694: l_cur_precision_to_tbl PO_TBL_NUMBER;

7690: l_amount_to_round_tbl PO_TBL_NUMBER;
7691: l_exchange_rate_tbl PO_TBL_NUMBER;
7692: l_cur_precision_from_tbl PO_TBL_NUMBER;
7693: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
7694: l_cur_precision_to_tbl PO_TBL_NUMBER;
7695: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
7696: l_round_only_flag_tbl PO_TBL_VARCHAR1;
7697: l_amount_result_tbl PO_TBL_NUMBER;
7698: l_origin_sequence_num_tbl PO_TBL_NUMBER;

Line 7695: l_min_acct_unit_to_tbl PO_TBL_NUMBER;

7691: l_exchange_rate_tbl PO_TBL_NUMBER;
7692: l_cur_precision_from_tbl PO_TBL_NUMBER;
7693: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
7694: l_cur_precision_to_tbl PO_TBL_NUMBER;
7695: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
7696: l_round_only_flag_tbl PO_TBL_VARCHAR1;
7697: l_amount_result_tbl PO_TBL_NUMBER;
7698: l_origin_sequence_num_tbl PO_TBL_NUMBER;
7699: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;

Line 7697: l_amount_result_tbl PO_TBL_NUMBER;

7693: l_min_acct_unit_from_tbl PO_TBL_NUMBER;
7694: l_cur_precision_to_tbl PO_TBL_NUMBER;
7695: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
7696: l_round_only_flag_tbl PO_TBL_VARCHAR1;
7697: l_amount_result_tbl PO_TBL_NUMBER;
7698: l_origin_sequence_num_tbl PO_TBL_NUMBER;
7699: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
7700: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
7701: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;

Line 7698: l_origin_sequence_num_tbl PO_TBL_NUMBER;

7694: l_cur_precision_to_tbl PO_TBL_NUMBER;
7695: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
7696: l_round_only_flag_tbl PO_TBL_VARCHAR1;
7697: l_amount_result_tbl PO_TBL_NUMBER;
7698: l_origin_sequence_num_tbl PO_TBL_NUMBER;
7699: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
7700: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
7701: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
7702: BEGIN