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.PA_MC_UPG dependencies on PA_PLSQL_DATATYPES

Line 63: G_EI_Array PA_PLSQL_DATATYPES.IdTabTyp ;

59: G_Login_ID Number;
60: G_InterCompany_Project Boolean;
61: G_Prvdr_Recvr_Flag Varchar2(1) := 'R';
62: j Integer;
63: G_EI_Array PA_PLSQL_DATATYPES.IdTabTyp ;
64: Null_G_EI_Array PA_PLSQL_DATATYPES.IdTabTyp ;/* Added for bug 1683582 */
65: G_Future_Record_Found Boolean;
66: --*
67: G_Conversion_Opt Varchar2(1);

Line 64: Null_G_EI_Array PA_PLSQL_DATATYPES.IdTabTyp ;/* Added for bug 1683582 */

60: G_InterCompany_Project Boolean;
61: G_Prvdr_Recvr_Flag Varchar2(1) := 'R';
62: j Integer;
63: G_EI_Array PA_PLSQL_DATATYPES.IdTabTyp ;
64: Null_G_EI_Array PA_PLSQL_DATATYPES.IdTabTyp ;/* Added for bug 1683582 */
65: G_Future_Record_Found Boolean;
66: --*
67: G_Conversion_Opt Varchar2(1);
68: --*

Line 1163: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;

1159: END Submit_Report;
1160: --------------------------------------------------------------
1161: PROCEDURE Insert_CCDL
1162: IS
1163: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;
1164: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1165: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1166: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1167: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;

Line 1164: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;

1160: --------------------------------------------------------------
1161: PROCEDURE Insert_CCDL
1162: IS
1163: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;
1164: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1165: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1166: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1167: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1168: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;

Line 1165: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;

1161: PROCEDURE Insert_CCDL
1162: IS
1163: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;
1164: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1165: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1166: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1167: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1168: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1169: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;

Line 1166: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;

1162: IS
1163: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;
1164: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1165: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1166: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1167: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1168: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1169: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1170: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1167: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;

1163: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;
1164: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1165: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1166: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1167: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1168: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1169: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1170: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1171: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;

Line 1168: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;

1164: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1165: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1166: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1167: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1168: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1169: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1170: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1171: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1172: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 1169: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;

1165: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1166: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1167: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1168: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1169: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1170: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1171: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1172: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1173: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 1170: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

1166: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1167: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1168: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1169: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1170: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1171: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1172: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1173: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1174: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;

Line 1171: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;

1167: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1168: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1169: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1170: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1171: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1172: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1173: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1174: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1175: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;

Line 1172: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;

1168: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1169: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1170: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1171: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1172: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1173: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1174: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1175: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1176: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;

Line 1173: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

1169: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1170: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1171: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1172: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1173: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1174: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1175: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1176: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;
1177: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;

Line 1174: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;

1170: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1171: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1172: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1173: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1174: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1175: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1176: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;
1177: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;
1178: v_old_stack Varchar2(650);

Line 1175: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;

1171: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1172: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1173: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1174: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1175: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1176: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;
1177: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;
1178: v_old_stack Varchar2(650);
1179: i Integer;

Line 1176: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;

1172: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1173: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1174: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1175: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1176: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;
1177: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;
1178: v_old_stack Varchar2(650);
1179: i Integer;
1180: l_use_debug_flag Boolean;

Line 1177: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;

1173: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1174: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1175: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1176: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;
1177: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;
1178: v_old_stack Varchar2(650);
1179: i Integer;
1180: l_use_debug_flag Boolean;
1181:

Line 1240: l_EI_Date PA_PLSQL_DATATYPES.DateTabTyp;

1236: IS
1237:
1238: I Integer;
1239: v_old_stack Varchar2(650);
1240: l_EI_Date PA_PLSQL_DATATYPES.DateTabTyp;
1241:
1242:
1243: INV_REC PA_INVOICE_DETAIL_PKG.inv_rec_tab;
1244:

Line 1352: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;

1348: v_old_stack Varchar2(2000);
1349:
1350: /** Create the array element to store the CDL records to be inserted **/
1351:
1352: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1353: l_line_num PA_PLSQL_DATATYPES.IdTabTyp;
1354: l_line_type PA_PLSQL_DATATYPES.Char1TabTyp;
1355: l_transfer_status_code PA_PLSQL_DATATYPES.Char1TabTyp;
1356: l_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 1353: l_line_num PA_PLSQL_DATATYPES.IdTabTyp;

1349:
1350: /** Create the array element to store the CDL records to be inserted **/
1351:
1352: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1353: l_line_num PA_PLSQL_DATATYPES.IdTabTyp;
1354: l_line_type PA_PLSQL_DATATYPES.Char1TabTyp;
1355: l_transfer_status_code PA_PLSQL_DATATYPES.Char1TabTyp;
1356: l_quantity PA_PLSQL_DATATYPES.NumTabTyp;
1357: l_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1354: l_line_type PA_PLSQL_DATATYPES.Char1TabTyp;

1350: /** Create the array element to store the CDL records to be inserted **/
1351:
1352: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1353: l_line_num PA_PLSQL_DATATYPES.IdTabTyp;
1354: l_line_type PA_PLSQL_DATATYPES.Char1TabTyp;
1355: l_transfer_status_code PA_PLSQL_DATATYPES.Char1TabTyp;
1356: l_quantity PA_PLSQL_DATATYPES.NumTabTyp;
1357: l_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1358: l_transferred_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 1355: l_transfer_status_code PA_PLSQL_DATATYPES.Char1TabTyp;

1351:
1352: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1353: l_line_num PA_PLSQL_DATATYPES.IdTabTyp;
1354: l_line_type PA_PLSQL_DATATYPES.Char1TabTyp;
1355: l_transfer_status_code PA_PLSQL_DATATYPES.Char1TabTyp;
1356: l_quantity PA_PLSQL_DATATYPES.NumTabTyp;
1357: l_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1358: l_transferred_date PA_PLSQL_DATATYPES.DateTabTyp;
1359: l_transfer_rejection_reason PA_PLSQL_DATATYPES.Char250TabTyp;

Line 1356: l_quantity PA_PLSQL_DATATYPES.NumTabTyp;

1352: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1353: l_line_num PA_PLSQL_DATATYPES.IdTabTyp;
1354: l_line_type PA_PLSQL_DATATYPES.Char1TabTyp;
1355: l_transfer_status_code PA_PLSQL_DATATYPES.Char1TabTyp;
1356: l_quantity PA_PLSQL_DATATYPES.NumTabTyp;
1357: l_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1358: l_transferred_date PA_PLSQL_DATATYPES.DateTabTyp;
1359: l_transfer_rejection_reason PA_PLSQL_DATATYPES.Char250TabTyp;
1360: l_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 1357: l_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

1353: l_line_num PA_PLSQL_DATATYPES.IdTabTyp;
1354: l_line_type PA_PLSQL_DATATYPES.Char1TabTyp;
1355: l_transfer_status_code PA_PLSQL_DATATYPES.Char1TabTyp;
1356: l_quantity PA_PLSQL_DATATYPES.NumTabTyp;
1357: l_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1358: l_transferred_date PA_PLSQL_DATATYPES.DateTabTyp;
1359: l_transfer_rejection_reason PA_PLSQL_DATATYPES.Char250TabTyp;
1360: l_amount PA_PLSQL_DATATYPES.NumTabTyp;
1361: l_batch_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1358: l_transferred_date PA_PLSQL_DATATYPES.DateTabTyp;

1354: l_line_type PA_PLSQL_DATATYPES.Char1TabTyp;
1355: l_transfer_status_code PA_PLSQL_DATATYPES.Char1TabTyp;
1356: l_quantity PA_PLSQL_DATATYPES.NumTabTyp;
1357: l_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1358: l_transferred_date PA_PLSQL_DATATYPES.DateTabTyp;
1359: l_transfer_rejection_reason PA_PLSQL_DATATYPES.Char250TabTyp;
1360: l_amount PA_PLSQL_DATATYPES.NumTabTyp;
1361: l_batch_name PA_PLSQL_DATATYPES.Char30TabTyp;
1362: l_burdened_cost PA_PLSQL_DATATYPES.NumTabTyp;

Line 1359: l_transfer_rejection_reason PA_PLSQL_DATATYPES.Char250TabTyp;

1355: l_transfer_status_code PA_PLSQL_DATATYPES.Char1TabTyp;
1356: l_quantity PA_PLSQL_DATATYPES.NumTabTyp;
1357: l_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1358: l_transferred_date PA_PLSQL_DATATYPES.DateTabTyp;
1359: l_transfer_rejection_reason PA_PLSQL_DATATYPES.Char250TabTyp;
1360: l_amount PA_PLSQL_DATATYPES.NumTabTyp;
1361: l_batch_name PA_PLSQL_DATATYPES.Char30TabTyp;
1362: l_burdened_cost PA_PLSQL_DATATYPES.NumTabTyp;
1363: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;

Line 1360: l_amount PA_PLSQL_DATATYPES.NumTabTyp;

1356: l_quantity PA_PLSQL_DATATYPES.NumTabTyp;
1357: l_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1358: l_transferred_date PA_PLSQL_DATATYPES.DateTabTyp;
1359: l_transfer_rejection_reason PA_PLSQL_DATATYPES.Char250TabTyp;
1360: l_amount PA_PLSQL_DATATYPES.NumTabTyp;
1361: l_batch_name PA_PLSQL_DATATYPES.Char30TabTyp;
1362: l_burdened_cost PA_PLSQL_DATATYPES.NumTabTyp;
1363: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1364: l_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 1361: l_batch_name PA_PLSQL_DATATYPES.Char30TabTyp;

1357: l_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1358: l_transferred_date PA_PLSQL_DATATYPES.DateTabTyp;
1359: l_transfer_rejection_reason PA_PLSQL_DATATYPES.Char250TabTyp;
1360: l_amount PA_PLSQL_DATATYPES.NumTabTyp;
1361: l_batch_name PA_PLSQL_DATATYPES.Char30TabTyp;
1362: l_burdened_cost PA_PLSQL_DATATYPES.NumTabTyp;
1363: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1364: l_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1365: l_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 1362: l_burdened_cost PA_PLSQL_DATATYPES.NumTabTyp;

1358: l_transferred_date PA_PLSQL_DATATYPES.DateTabTyp;
1359: l_transfer_rejection_reason PA_PLSQL_DATATYPES.Char250TabTyp;
1360: l_amount PA_PLSQL_DATATYPES.NumTabTyp;
1361: l_batch_name PA_PLSQL_DATATYPES.Char30TabTyp;
1362: l_burdened_cost PA_PLSQL_DATATYPES.NumTabTyp;
1363: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1364: l_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1365: l_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1366: k Integer;

Line 1363: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;

1359: l_transfer_rejection_reason PA_PLSQL_DATATYPES.Char250TabTyp;
1360: l_amount PA_PLSQL_DATATYPES.NumTabTyp;
1361: l_batch_name PA_PLSQL_DATATYPES.Char30TabTyp;
1362: l_burdened_cost PA_PLSQL_DATATYPES.NumTabTyp;
1363: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1364: l_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1365: l_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1366: k Integer;
1367:

Line 1364: l_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

1360: l_amount PA_PLSQL_DATATYPES.NumTabTyp;
1361: l_batch_name PA_PLSQL_DATATYPES.Char30TabTyp;
1362: l_burdened_cost PA_PLSQL_DATATYPES.NumTabTyp;
1363: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1364: l_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1365: l_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1366: k Integer;
1367:
1368: Cursor C_CC_CDL

Line 1365: l_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;

1361: l_batch_name PA_PLSQL_DATATYPES.Char30TabTyp;
1362: l_burdened_cost PA_PLSQL_DATATYPES.NumTabTyp;
1363: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1364: l_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1365: l_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1366: k Integer;
1367:
1368: Cursor C_CC_CDL
1369: IS

Line 1438: l_raw_cost PA_PLSQL_DATATYPES.NumTabtyp;

1434: -------------------------------------------------------------------------------
1435: PROCEDURE insert_CC_exp_items( x_Project_ID IN Number,
1436: x_Rep_SOB_ID IN Number)
1437: IS
1438: l_raw_cost PA_PLSQL_DATATYPES.NumTabtyp;
1439: l_Quantity PA_PLSQL_DATATYPES.NumTabTyp;
1440: l_burdened_cost PA_PLSQL_DATATYPES.NumTabtyp;
1441: l_raw_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1442: l_accrued_revenue PA_PLSQL_DATATYPES.NumTabTyp;

Line 1439: l_Quantity PA_PLSQL_DATATYPES.NumTabTyp;

1435: PROCEDURE insert_CC_exp_items( x_Project_ID IN Number,
1436: x_Rep_SOB_ID IN Number)
1437: IS
1438: l_raw_cost PA_PLSQL_DATATYPES.NumTabtyp;
1439: l_Quantity PA_PLSQL_DATATYPES.NumTabTyp;
1440: l_burdened_cost PA_PLSQL_DATATYPES.NumTabtyp;
1441: l_raw_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1442: l_accrued_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1443: l_adjusted_revenue PA_PLSQL_DATATYPES.NumTabTyp;

Line 1440: l_burdened_cost PA_PLSQL_DATATYPES.NumTabtyp;

1436: x_Rep_SOB_ID IN Number)
1437: IS
1438: l_raw_cost PA_PLSQL_DATATYPES.NumTabtyp;
1439: l_Quantity PA_PLSQL_DATATYPES.NumTabTyp;
1440: l_burdened_cost PA_PLSQL_DATATYPES.NumTabtyp;
1441: l_raw_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1442: l_accrued_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1443: l_adjusted_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1444: l_forecast_revenue PA_PLSQL_DATATYPES.NumTabTyp;

Line 1441: l_raw_revenue PA_PLSQL_DATATYPES.NumTabTyp;

1437: IS
1438: l_raw_cost PA_PLSQL_DATATYPES.NumTabtyp;
1439: l_Quantity PA_PLSQL_DATATYPES.NumTabTyp;
1440: l_burdened_cost PA_PLSQL_DATATYPES.NumTabtyp;
1441: l_raw_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1442: l_accrued_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1443: l_adjusted_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1444: l_forecast_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1445: l_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 1442: l_accrued_revenue PA_PLSQL_DATATYPES.NumTabTyp;

1438: l_raw_cost PA_PLSQL_DATATYPES.NumTabtyp;
1439: l_Quantity PA_PLSQL_DATATYPES.NumTabTyp;
1440: l_burdened_cost PA_PLSQL_DATATYPES.NumTabtyp;
1441: l_raw_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1442: l_accrued_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1443: l_adjusted_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1444: l_forecast_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1445: l_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
1446: l_net_zero_adjustment_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 1443: l_adjusted_revenue PA_PLSQL_DATATYPES.NumTabTyp;

1439: l_Quantity PA_PLSQL_DATATYPES.NumTabTyp;
1440: l_burdened_cost PA_PLSQL_DATATYPES.NumTabtyp;
1441: l_raw_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1442: l_accrued_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1443: l_adjusted_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1444: l_forecast_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1445: l_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
1446: l_net_zero_adjustment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1447: l_transferred_from_exp_item_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 1444: l_forecast_revenue PA_PLSQL_DATATYPES.NumTabTyp;

1440: l_burdened_cost PA_PLSQL_DATATYPES.NumTabtyp;
1441: l_raw_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1442: l_accrued_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1443: l_adjusted_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1444: l_forecast_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1445: l_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
1446: l_net_zero_adjustment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1447: l_transferred_from_exp_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1448: l_transfer_price PA_PLSQL_DATATYPES.NumTabtyp;

Line 1445: l_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

1441: l_raw_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1442: l_accrued_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1443: l_adjusted_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1444: l_forecast_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1445: l_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
1446: l_net_zero_adjustment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1447: l_transferred_from_exp_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1448: l_transfer_price PA_PLSQL_DATATYPES.NumTabtyp;
1449: l_cost_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 1446: l_net_zero_adjustment_flag PA_PLSQL_DATATYPES.Char1TabTyp;

1442: l_accrued_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1443: l_adjusted_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1444: l_forecast_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1445: l_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
1446: l_net_zero_adjustment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1447: l_transferred_from_exp_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1448: l_transfer_price PA_PLSQL_DATATYPES.NumTabtyp;
1449: l_cost_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1450: l_rev_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 1447: l_transferred_from_exp_item_id PA_PLSQL_DATATYPES.IdTabTyp;

1443: l_adjusted_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1444: l_forecast_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1445: l_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
1446: l_net_zero_adjustment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1447: l_transferred_from_exp_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1448: l_transfer_price PA_PLSQL_DATATYPES.NumTabtyp;
1449: l_cost_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1450: l_rev_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1451: l_cost_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 1448: l_transfer_price PA_PLSQL_DATATYPES.NumTabtyp;

1444: l_forecast_revenue PA_PLSQL_DATATYPES.NumTabTyp;
1445: l_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
1446: l_net_zero_adjustment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1447: l_transferred_from_exp_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1448: l_transfer_price PA_PLSQL_DATATYPES.NumTabtyp;
1449: l_cost_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1450: l_rev_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1451: l_cost_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1452: l_cost_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1449: l_cost_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

1445: l_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
1446: l_net_zero_adjustment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1447: l_transferred_from_exp_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1448: l_transfer_price PA_PLSQL_DATATYPES.NumTabtyp;
1449: l_cost_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1450: l_rev_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1451: l_cost_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1452: l_cost_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1453: l_raw_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;

Line 1450: l_rev_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

1446: l_net_zero_adjustment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1447: l_transferred_from_exp_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1448: l_transfer_price PA_PLSQL_DATATYPES.NumTabtyp;
1449: l_cost_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1450: l_rev_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1451: l_cost_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1452: l_cost_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1453: l_raw_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1454: l_burdened_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;

Line 1451: l_cost_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;

1447: l_transferred_from_exp_item_id PA_PLSQL_DATATYPES.IdTabTyp;
1448: l_transfer_price PA_PLSQL_DATATYPES.NumTabtyp;
1449: l_cost_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1450: l_rev_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1451: l_cost_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1452: l_cost_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1453: l_raw_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1454: l_burdened_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1455: l_bill_rate PA_PLSQL_DATATYPES.NumTabtyp;

Line 1452: l_cost_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

1448: l_transfer_price PA_PLSQL_DATATYPES.NumTabtyp;
1449: l_cost_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1450: l_rev_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1451: l_cost_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1452: l_cost_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1453: l_raw_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1454: l_burdened_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1455: l_bill_rate PA_PLSQL_DATATYPES.NumTabtyp;
1456: l_accrual_rate PA_PLSQL_DATATYPES.NumTabtyp;

Line 1453: l_raw_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;

1449: l_cost_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1450: l_rev_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1451: l_cost_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1452: l_cost_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1453: l_raw_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1454: l_burdened_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1455: l_bill_rate PA_PLSQL_DATATYPES.NumTabtyp;
1456: l_accrual_rate PA_PLSQL_DATATYPES.NumTabtyp;
1457: l_adjusted_rate PA_PLSQL_DATATYPES.NumTabtyp;

Line 1454: l_burdened_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;

1450: l_rev_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1451: l_cost_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1452: l_cost_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1453: l_raw_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1454: l_burdened_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1455: l_bill_rate PA_PLSQL_DATATYPES.NumTabtyp;
1456: l_accrual_rate PA_PLSQL_DATATYPES.NumTabtyp;
1457: l_adjusted_rate PA_PLSQL_DATATYPES.NumTabtyp;
1458: l_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabtyp;

Line 1455: l_bill_rate PA_PLSQL_DATATYPES.NumTabtyp;

1451: l_cost_conversion_date PA_PLSQL_DATATYPES.DateTabTyp;
1452: l_cost_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1453: l_raw_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1454: l_burdened_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1455: l_bill_rate PA_PLSQL_DATATYPES.NumTabtyp;
1456: l_accrual_rate PA_PLSQL_DATATYPES.NumTabtyp;
1457: l_adjusted_rate PA_PLSQL_DATATYPES.NumTabtyp;
1458: l_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabtyp;
1459: l_tp_exchange_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 1456: l_accrual_rate PA_PLSQL_DATATYPES.NumTabtyp;

1452: l_cost_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1453: l_raw_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1454: l_burdened_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1455: l_bill_rate PA_PLSQL_DATATYPES.NumTabtyp;
1456: l_accrual_rate PA_PLSQL_DATATYPES.NumTabtyp;
1457: l_adjusted_rate PA_PLSQL_DATATYPES.NumTabtyp;
1458: l_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabtyp;
1459: l_tp_exchange_date PA_PLSQL_DATATYPES.DateTabTyp;
1460: l_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1457: l_adjusted_rate PA_PLSQL_DATATYPES.NumTabtyp;

1453: l_raw_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1454: l_burdened_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1455: l_bill_rate PA_PLSQL_DATATYPES.NumTabtyp;
1456: l_accrual_rate PA_PLSQL_DATATYPES.NumTabtyp;
1457: l_adjusted_rate PA_PLSQL_DATATYPES.NumTabtyp;
1458: l_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabtyp;
1459: l_tp_exchange_date PA_PLSQL_DATATYPES.DateTabTyp;
1460: l_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1461:

Line 1458: l_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabtyp;

1454: l_burdened_cost_rate PA_PLSQL_DATATYPES.NumTabtyp;
1455: l_bill_rate PA_PLSQL_DATATYPES.NumTabtyp;
1456: l_accrual_rate PA_PLSQL_DATATYPES.NumTabtyp;
1457: l_adjusted_rate PA_PLSQL_DATATYPES.NumTabtyp;
1458: l_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabtyp;
1459: l_tp_exchange_date PA_PLSQL_DATATYPES.DateTabTyp;
1460: l_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1461:
1462: v_Old_Stack VARCHAR2(650);

Line 1459: l_tp_exchange_date PA_PLSQL_DATATYPES.DateTabTyp;

1455: l_bill_rate PA_PLSQL_DATATYPES.NumTabtyp;
1456: l_accrual_rate PA_PLSQL_DATATYPES.NumTabtyp;
1457: l_adjusted_rate PA_PLSQL_DATATYPES.NumTabtyp;
1458: l_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabtyp;
1459: l_tp_exchange_date PA_PLSQL_DATATYPES.DateTabTyp;
1460: l_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1461:
1462: v_Old_Stack VARCHAR2(650);
1463: k Integer;

Line 1460: l_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

1456: l_accrual_rate PA_PLSQL_DATATYPES.NumTabtyp;
1457: l_adjusted_rate PA_PLSQL_DATATYPES.NumTabtyp;
1458: l_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabtyp;
1459: l_tp_exchange_date PA_PLSQL_DATATYPES.DateTabTyp;
1460: l_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1461:
1462: v_Old_Stack VARCHAR2(650);
1463: k Integer;
1464:

Line 1531: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;

1527: END Update_cc_exp_items ;
1528: -------------------------------------------------------------------------------
1529: PROCEDURE Insert_CC_CCDL
1530: IS
1531: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;
1532: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1533: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1534: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1535: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;

Line 1532: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;

1528: -------------------------------------------------------------------------------
1529: PROCEDURE Insert_CC_CCDL
1530: IS
1531: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;
1532: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1533: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1534: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1535: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1536: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;

Line 1533: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;

1529: PROCEDURE Insert_CC_CCDL
1530: IS
1531: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;
1532: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1533: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1534: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1535: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1536: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1537: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;

Line 1534: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;

1530: IS
1531: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;
1532: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1533: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1534: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1535: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1536: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1537: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1538: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1535: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;

1531: l_rep_rsob_id PA_PLSQL_DATATYPES.IDTabTyp;
1532: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1533: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1534: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1535: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1536: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1537: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1538: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1539: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;

Line 1536: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;

1532: l_org_id PA_PLSQL_DATATYPES.IDTabTyp;
1533: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1534: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1535: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1536: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1537: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1538: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1539: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1540: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 1537: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;

1533: l_rcurrency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1534: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1535: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1536: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1537: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1538: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1539: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1540: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1541: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 1538: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

1534: l_cc_dist_line_id PA_PLSQL_DATATYPES.IDTabTyp;
1535: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1536: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1537: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1538: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1539: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1540: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1541: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1542: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;

Line 1539: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;

1535: l_expenditure_item_id PA_PLSQL_DATATYPES.IDTabTyp;
1536: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1537: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1538: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1539: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1540: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1541: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1542: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1543: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;

Line 1540: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;

1536: l_line_num PA_PLSQL_DATATYPES.IDTabTyp;
1537: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1538: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1539: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1540: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1541: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1542: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1543: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1544: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;

Line 1541: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

1537: l_cdl_line_num PA_PLSQL_DATATYPES.NumTabTyp;
1538: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1539: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1540: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1541: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1542: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1543: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1544: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;
1545: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;

Line 1542: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;

1538: l_acct_tp_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
1539: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1540: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1541: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1542: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1543: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1544: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;
1545: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;
1546: v_old_stack Varchar2(650);

Line 1543: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;

1539: l_prvdr_cost_reclass_code PA_PLSQL_DATATYPES.Char240TabTyp;
1540: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1541: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1542: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1543: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1544: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;
1545: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;
1546: v_old_stack Varchar2(650);
1547: i Integer;

Line 1544: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;

1540: l_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
1541: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1542: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1543: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1544: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;
1545: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;
1546: v_old_stack Varchar2(650);
1547: i Integer;
1548: l_use_debug_flag Boolean;

Line 1545: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;

1541: l_acct_tp_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
1542: l_denom_transfer_price PA_PLSQL_DATATYPES.NumTabTyp;
1543: l_denom_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
1544: l_dist_line_id_reversed PA_PLSQL_DATATYPES.IDTabTyp;
1545: l_line_type PA_PLSQL_DATATYPES.Char2TabTyp;
1546: v_old_stack Varchar2(650);
1547: i Integer;
1548: l_use_debug_flag Boolean;
1549: k Integer;