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_FP_GEN_FCST_AMT_PUB1 dependencies on PA_BUDGET_LINES

Line 54: pa_budget_lines bl

50: CURSOR rev_only_nrb_txns_csr IS
51: SELECT bl.resource_assignment_id,
52: bl.txn_currency_code
53: FROM pa_resource_assignments ra,
54: pa_budget_lines bl
55: WHERE ra.budget_version_id = p_budget_version_id
56: AND ra.project_id = p_project_id
57: AND ra.rate_based_flag = 'N'
58: AND bl.resource_assignment_id = ra.resource_assignment_id

Line 96: FROM pa_budget_lines bl

92: AND ra.rate_based_flag = 'N'
93: AND rbc.resource_assignment_id = ra.resource_assignment_id
94: AND NOT EXISTS
95: ( SELECT null
96: FROM pa_budget_lines bl
97: WHERE bl.resource_assignment_id = rbc.resource_assignment_id
98: AND bl.txn_currency_code = rbc.txn_currency_code
99: AND nvl(bl.quantity,0) <> nvl(bl.init_quantity,0) )
100: AND ( rbc.txn_raw_cost_rate_override is not null OR

Line 477: * PA_BUDGET_LINES table for the given (source resource assignment, txn currency code)

473:
474:
475: /**
476: * This procedure populates the PA_FP_GEN_RATE_TMP table with values from the
477: * PA_BUDGET_LINES table for the given (source resource assignment, txn currency code)
478: * parameter combination.
479: *
480: * The target resource assignment id is currently unused.
481: */

Line 483: (P_SOURCE_RES_ASG_ID IN PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE,

479: *
480: * The target resource assignment id is currently unused.
481: */
482: PROCEDURE POPULATE_GEN_RATE
483: (P_SOURCE_RES_ASG_ID IN PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE,
484: P_TARGET_RES_ASG_ID IN PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE,
485: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
486: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
487: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 484: P_TARGET_RES_ASG_ID IN PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE,

480: * The target resource assignment id is currently unused.
481: */
482: PROCEDURE POPULATE_GEN_RATE
483: (P_SOURCE_RES_ASG_ID IN PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE,
484: P_TARGET_RES_ASG_ID IN PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE,
485: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
486: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
487: X_MSG_COUNT OUT NOCOPY NUMBER,
488: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 485: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,

481: */
482: PROCEDURE POPULATE_GEN_RATE
483: (P_SOURCE_RES_ASG_ID IN PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE,
484: P_TARGET_RES_ASG_ID IN PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE,
485: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
486: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
487: X_MSG_COUNT OUT NOCOPY NUMBER,
488: X_MSG_DATA OUT NOCOPY VARCHAR2)
489: IS

Line 494: CURSOR bl_rates_cur (c_res_asg_id PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE) IS

490: l_package_name VARCHAR2(30) := 'PA_FP_GEN_FCST_AMT_PUB1';
491: l_procedure_name VARCHAR2(30) := 'POPULATE_GEN_RATE';
492: l_module_name VARCHAR2(100);
493:
494: CURSOR bl_rates_cur (c_res_asg_id PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID%TYPE) IS
495: SELECT bl.period_name,
496: NVL(bl.txn_cost_rate_override,bl.txn_standard_cost_rate),
497: NVL(bl.burden_cost_rate_override,bl.burden_cost_rate),
498: NVL(bl.txn_bill_rate_override,bl.txn_standard_bill_rate)

Line 499: FROM pa_budget_lines bl

495: SELECT bl.period_name,
496: NVL(bl.txn_cost_rate_override,bl.txn_standard_cost_rate),
497: NVL(bl.burden_cost_rate_override,bl.burden_cost_rate),
498: NVL(bl.txn_bill_rate_override,bl.txn_standard_bill_rate)
499: FROM pa_budget_lines bl
500: WHERE bl.resource_assignment_id = c_res_asg_id
501: AND bl.txn_currency_code = p_txn_currency_code;
502:
503: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1069: FROM pa_budget_lines bl

1065: AND ra.task_id = P_TASK_ID
1066: AND ( ra.transaction_source_code IS NOT NULL
1067: OR ( ra.transaction_source_code IS NULL
1068: AND NOT EXISTS ( SELECT 1
1069: FROM pa_budget_lines bl
1070: WHERE bl.resource_assignment_id =
1071: ra.resource_assignment_id
1072: AND bl.start_date > p_actuals_thru_date
1073: AND rownum < 2 )))

Line 1086: FROM pa_budget_lines bl

1082: ra.budget_version_id = P_BUDGET_VERSION_ID
1083: AND ( ra.transaction_source_code IS NOT NULL
1084: OR ( ra.transaction_source_code IS NULL
1085: AND NOT EXISTS ( SELECT 1
1086: FROM pa_budget_lines bl
1087: WHERE bl.resource_assignment_id =
1088: ra.resource_assignment_id
1089: AND bl.start_date > p_actuals_thru_date
1090: AND rownum < 2 )));

Line 1105: FROM pa_budget_lines bl

1101: AND ra.task_id = P_TASK_ID
1102: AND ( ra.transaction_source_code IS NOT NULL
1103: OR ( ra.transaction_source_code IS NULL
1104: AND NOT EXISTS ( SELECT 1
1105: FROM pa_budget_lines bl
1106: WHERE bl.resource_assignment_id =
1107: ra.resource_assignment_id
1108: AND NVL(quantity,0) <> NVL(init_quantity,0)
1109: AND rownum < 2 )))

Line 1122: FROM pa_budget_lines bl

1118: ra.budget_version_id = P_BUDGET_VERSION_ID
1119: AND ( ra.transaction_source_code IS NOT NULL
1120: OR ( ra.transaction_source_code IS NULL
1121: AND NOT EXISTS ( SELECT 1
1122: FROM pa_budget_lines bl
1123: WHERE bl.resource_assignment_id =
1124: ra.resource_assignment_id
1125: AND NVL(quantity,0) <> NVL(init_quantity,0)
1126: AND rownum < 2 )));

Line 1144: FROM pa_budget_lines bl

1140: ra.resource_list_member_id = tmp.res_list_member_id
1141: AND ( ra.transaction_source_code IS NOT NULL
1142: OR ( ra.transaction_source_code IS NULL
1143: AND NOT EXISTS ( SELECT 1
1144: FROM pa_budget_lines bl
1145: WHERE bl.resource_assignment_id =
1146: ra.resource_assignment_id
1147: AND bl.start_date > p_actuals_thru_date
1148: AND rownum < 2 )));

Line 1166: FROM pa_budget_lines bl

1162: ra.resource_list_member_id = tmp.res_list_member_id
1163: AND ( ra.transaction_source_code IS NOT NULL
1164: OR ( ra.transaction_source_code IS NULL
1165: AND NOT EXISTS ( SELECT 1
1166: FROM pa_budget_lines bl
1167: WHERE bl.resource_assignment_id =
1168: ra.resource_assignment_id
1169: AND NVL(quantity,0) <> NVL(init_quantity,0)
1170: AND rownum < 2 )));

Line 1191: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

1187:
1188: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1189: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1190: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1191: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1192: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1193: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1194:
1195: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;

Line 1340: FROM PA_BUDGET_LINES

1336: END IF;
1337: FOR i IN 1..l_res_asg_id_tab.count LOOP
1338: SELECT COUNT(DISTINCT txn_currency_code)
1339: INTO l_currency_count
1340: FROM PA_BUDGET_LINES
1341: WHERE resource_assignment_id = l_res_asg_id_tab(i)
1342: AND start_date BETWEEN l_actual_from_date AND l_actual_to_date;
1343: IF l_currency_count <>0 THEN
1344: /* If we have actual txn amounts in only one currency then the ETC amount

Line 1350: FROM PA_BUDGET_LINES

1346: IF l_currency_count = 1 THEN
1347: l_currency_flag := 'TC';
1348: SELECT DISTINCT txn_currency_code
1349: INTO l_currency_code
1350: FROM PA_BUDGET_LINES
1351: WHERE resource_assignment_id = l_res_asg_id_tab(i)
1352: AND start_date BETWEEN l_actual_from_date AND l_actual_to_date;
1353: /* If we have actual txn amounts in more than one currency then the ETC amount
1354: will be generated in PC by taking the average amount from PC amount. */

Line 3288: DELETE FROM pa_budget_lines bl

3284: -- 2. Commitments mapped to a line with negative quantity
3285: -- 3. Billing events mapped to a revenue-only line with negative
3286: -- (internal) quantity
3287:
3288: DELETE FROM pa_budget_lines bl
3289: WHERE nvl(bl.quantity,0) = 0
3290: AND bl.budget_version_id = p_budget_version_id
3291: AND bl.init_quantity is null
3292: AND bl.txn_init_raw_cost is null

Line 3690: P_MSG => 'Before calling PA_BUDGET_LINES_UTILS.' ||

3686: AND ra.transaction_source_code IS NOT NULL;
3687:
3688: IF p_pa_debug_mode = 'Y' THEN
3689: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3690: P_MSG => 'Before calling PA_BUDGET_LINES_UTILS.' ||
3691: 'POPULATE_DISPLAY_QTY',
3692: --P_CALLED_MODE => p_called_mode,
3693: P_MODULE_NAME => l_module_name);
3694: END IF;

Line 3695: PA_BUDGET_LINES_UTILS.POPULATE_DISPLAY_QTY

3691: 'POPULATE_DISPLAY_QTY',
3692: --P_CALLED_MODE => p_called_mode,
3693: P_MODULE_NAME => l_module_name);
3694: END IF;
3695: PA_BUDGET_LINES_UTILS.POPULATE_DISPLAY_QTY
3696: ( P_BUDGET_VERSION_ID => p_budget_version_id,
3697: P_CONTEXT => 'FINANCIAL',
3698: P_USE_TEMP_TABLE_FLAG => 'Y',
3699: X_RETURN_STATUS => x_return_status );

Line 3702: P_MSG => 'After calling PA_BUDGET_LINES_UTILS.' ||

3698: P_USE_TEMP_TABLE_FLAG => 'Y',
3699: X_RETURN_STATUS => x_return_status );
3700: IF p_pa_debug_mode = 'Y' THEN
3701: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3702: P_MSG => 'After calling PA_BUDGET_LINES_UTILS.' ||
3703: 'POPULATE_DISPLAY_QTY: '||x_return_status,
3704: --P_CALLED_MODE => p_called_mode,
3705: P_MODULE_NAME => l_module_name);
3706: END IF;

Line 3729: pa_budget_lines bl,

3725: rbc.txn_raw_cost_rate_override,
3726: rbc.txn_burden_cost_rate_override,
3727: rbc.txn_bill_rate_override
3728: FROM pa_resource_assignments ra,
3729: pa_budget_lines bl,
3730: pa_resource_asgn_curr rbc
3731: WHERE ra.budget_version_id = p_budget_version_id
3732: AND ra.project_id = p_project_id
3733: AND ra.transaction_source_code IS NOT NULL

Line 3779: P_MSG => 'Before calling PA_BUDGET_LINES_UTILS.' ||

3775: -- Populate the display quantity for all resources in the version.
3776:
3777: IF p_pa_debug_mode = 'Y' THEN
3778: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3779: P_MSG => 'Before calling PA_BUDGET_LINES_UTILS.' ||
3780: 'POPULATE_DISPLAY_QTY',
3781: --P_CALLED_MODE => p_called_mode,
3782: P_MODULE_NAME => l_module_name);
3783: END IF;

Line 3784: PA_BUDGET_LINES_UTILS.POPULATE_DISPLAY_QTY

3780: 'POPULATE_DISPLAY_QTY',
3781: --P_CALLED_MODE => p_called_mode,
3782: P_MODULE_NAME => l_module_name);
3783: END IF;
3784: PA_BUDGET_LINES_UTILS.POPULATE_DISPLAY_QTY
3785: ( P_BUDGET_VERSION_ID => p_budget_version_id,
3786: P_CONTEXT => 'FINANCIAL',
3787: P_USE_TEMP_TABLE_FLAG => 'N',
3788: X_RETURN_STATUS => x_return_status );

Line 3791: P_MSG => 'After calling PA_BUDGET_LINES_UTILS.' ||

3787: P_USE_TEMP_TABLE_FLAG => 'N',
3788: X_RETURN_STATUS => x_return_status );
3789: IF p_pa_debug_mode = 'Y' THEN
3790: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3791: P_MSG => 'After calling PA_BUDGET_LINES_UTILS.' ||
3792: 'POPULATE_DISPLAY_QTY: '||x_return_status,
3793: --P_CALLED_MODE => p_called_mode,
3794: P_MODULE_NAME => l_module_name);
3795: END IF;

Line 3850: FROM pa_budget_lines bl

3846: DELETE FROM pa_resource_assignments ra
3847: WHERE ra.budget_version_id = p_budget_version_id
3848: AND ra.transaction_source_code IS NOT NULL
3849: AND NOT EXISTS (SELECT null
3850: FROM pa_budget_lines bl
3851: WHERE bl.resource_assignment_id = ra.resource_assignment_id)
3852: AND NOT EXISTS (SELECT null
3853: FROM pa_resource_asgn_curr rbc
3854: WHERE rbc.resource_assignment_id = ra.resource_assignment_id);

Line 4170: X_ACT_TXN_CURRENCY_CODE OUT NOCOPY PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,

4166: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
4167: P_RES_LIST_MEM_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
4168: P_ACTUALS_THRU_DATE IN DATE,
4169: X_ACT_QUANTITY OUT NOCOPY NUMBER,
4170: X_ACT_TXN_CURRENCY_CODE OUT NOCOPY PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
4171: X_ACT_TXN_RAW_COST OUT NOCOPY NUMBER,
4172: X_ACT_TXN_BRDN_COST OUT NOCOPY NUMBER,
4173: X_ACT_PC_RAW_COST OUT NOCOPY NUMBER,
4174: X_ACT_PC_BRDN_COST OUT NOCOPY NUMBER,

Line 4229: FROM pa_budget_lines

4225: l_prj_init_raw_cost_tab,
4226: l_prj_init_brdn_cost_tab,
4227: l_init_raw_cost_tab,
4228: l_init_brdn_cost_tab
4229: FROM pa_budget_lines
4230: WHERE budget_version_id = l_wp_bdgt_ver_id
4231: AND resource_assignment_id = p_src_res_asg_id
4232: AND init_quantity is not null
4233: GROUP BY txn_currency_code;

Line 4252: FROM pa_budget_lines

4248: l_prj_init_raw_cost_tab,
4249: l_prj_init_brdn_cost_tab,
4250: l_init_raw_cost_tab,
4251: l_init_brdn_cost_tab
4252: FROM pa_budget_lines
4253: WHERE budget_version_id = l_wp_bdgt_ver_id
4254: AND resource_assignment_id = p_src_res_asg_id
4255: AND end_date <= p_actuals_thru_date
4256: AND init_quantity is not null

Line 4429: TYPE del_bud_line_rec IS RECORD ( ra_id pa_budget_lines.resource_assignment_id%TYPE

4425:
4426: l_plan_txn_prd_amt_tbl_1_bak PA_FP_FCST_GEN_CLIENT_EXT.l_plan_txn_prd_amt_tbl;
4427: l_upd_bud_line_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_plan_txn_prd_amt_tbl;
4428:
4429: TYPE del_bud_line_rec IS RECORD ( ra_id pa_budget_lines.resource_assignment_id%TYPE
4430: ,txn_curr_code pa_budget_lines.txn_currency_code%TYPE
4431: ,period_name pa_budget_lines.period_name%TYPE);
4432:
4433:

Line 4430: ,txn_curr_code pa_budget_lines.txn_currency_code%TYPE

4426: l_plan_txn_prd_amt_tbl_1_bak PA_FP_FCST_GEN_CLIENT_EXT.l_plan_txn_prd_amt_tbl;
4427: l_upd_bud_line_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_plan_txn_prd_amt_tbl;
4428:
4429: TYPE del_bud_line_rec IS RECORD ( ra_id pa_budget_lines.resource_assignment_id%TYPE
4430: ,txn_curr_code pa_budget_lines.txn_currency_code%TYPE
4431: ,period_name pa_budget_lines.period_name%TYPE);
4432:
4433:
4434: TYPE l_upd_bgt_line_rec IS RECORD

Line 4431: ,period_name pa_budget_lines.period_name%TYPE);

4427: l_upd_bud_line_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_plan_txn_prd_amt_tbl;
4428:
4429: TYPE del_bud_line_rec IS RECORD ( ra_id pa_budget_lines.resource_assignment_id%TYPE
4430: ,txn_curr_code pa_budget_lines.txn_currency_code%TYPE
4431: ,period_name pa_budget_lines.period_name%TYPE);
4432:
4433:
4434: TYPE l_upd_bgt_line_rec IS RECORD
4435: (

Line 4436: ra_id pa_budget_lines.resource_assignment_id%TYPE,

4432:
4433:
4434: TYPE l_upd_bgt_line_rec IS RECORD
4435: (
4436: ra_id pa_budget_lines.resource_assignment_id%TYPE,
4437: txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
4438: period_name pa_budget_lines.period_name%TYPE,
4439: tot_quantity pa_budget_lines.quantity%TYPE, -- this attribute is used to update the total quantity field in pa_budget_lines
4440: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,

Line 4437: txn_curr_code pa_budget_lines.txn_currency_code%TYPE,

4433:
4434: TYPE l_upd_bgt_line_rec IS RECORD
4435: (
4436: ra_id pa_budget_lines.resource_assignment_id%TYPE,
4437: txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
4438: period_name pa_budget_lines.period_name%TYPE,
4439: tot_quantity pa_budget_lines.quantity%TYPE, -- this attribute is used to update the total quantity field in pa_budget_lines
4440: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
4441: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,

Line 4438: period_name pa_budget_lines.period_name%TYPE,

4434: TYPE l_upd_bgt_line_rec IS RECORD
4435: (
4436: ra_id pa_budget_lines.resource_assignment_id%TYPE,
4437: txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
4438: period_name pa_budget_lines.period_name%TYPE,
4439: tot_quantity pa_budget_lines.quantity%TYPE, -- this attribute is used to update the total quantity field in pa_budget_lines
4440: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
4441: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
4442: txn_revenue pa_budget_lines.txn_revenue%TYPE,

Line 4439: tot_quantity pa_budget_lines.quantity%TYPE, -- this attribute is used to update the total quantity field in pa_budget_lines

4435: (
4436: ra_id pa_budget_lines.resource_assignment_id%TYPE,
4437: txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
4438: period_name pa_budget_lines.period_name%TYPE,
4439: tot_quantity pa_budget_lines.quantity%TYPE, -- this attribute is used to update the total quantity field in pa_budget_lines
4440: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
4441: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
4442: txn_revenue pa_budget_lines.txn_revenue%TYPE,
4443: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,

Line 4440: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,

4436: ra_id pa_budget_lines.resource_assignment_id%TYPE,
4437: txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
4438: period_name pa_budget_lines.period_name%TYPE,
4439: tot_quantity pa_budget_lines.quantity%TYPE, -- this attribute is used to update the total quantity field in pa_budget_lines
4440: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
4441: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
4442: txn_revenue pa_budget_lines.txn_revenue%TYPE,
4443: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
4444: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,

Line 4441: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,

4437: txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
4438: period_name pa_budget_lines.period_name%TYPE,
4439: tot_quantity pa_budget_lines.quantity%TYPE, -- this attribute is used to update the total quantity field in pa_budget_lines
4440: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
4441: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
4442: txn_revenue pa_budget_lines.txn_revenue%TYPE,
4443: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
4444: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
4445: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE,

Line 4442: txn_revenue pa_budget_lines.txn_revenue%TYPE,

4438: period_name pa_budget_lines.period_name%TYPE,
4439: tot_quantity pa_budget_lines.quantity%TYPE, -- this attribute is used to update the total quantity field in pa_budget_lines
4440: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
4441: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
4442: txn_revenue pa_budget_lines.txn_revenue%TYPE,
4443: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
4444: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
4445: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE,
4446: disp_quantity pa_budget_lines.display_quantity%TYPE);

Line 4443: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,

4439: tot_quantity pa_budget_lines.quantity%TYPE, -- this attribute is used to update the total quantity field in pa_budget_lines
4440: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
4441: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
4442: txn_revenue pa_budget_lines.txn_revenue%TYPE,
4443: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
4444: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
4445: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE,
4446: disp_quantity pa_budget_lines.display_quantity%TYPE);
4447:

Line 4444: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,

4440: txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE,
4441: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
4442: txn_revenue pa_budget_lines.txn_revenue%TYPE,
4443: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
4444: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
4445: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE,
4446: disp_quantity pa_budget_lines.display_quantity%TYPE);
4447:
4448:

Line 4445: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE,

4441: txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE,
4442: txn_revenue pa_budget_lines.txn_revenue%TYPE,
4443: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
4444: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
4445: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE,
4446: disp_quantity pa_budget_lines.display_quantity%TYPE);
4447:
4448:
4449: TYPE l_ra_id_tbl_prest is TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 4446: disp_quantity pa_budget_lines.display_quantity%TYPE);

4442: txn_revenue pa_budget_lines.txn_revenue%TYPE,
4443: RAW_COST_RATE pa_budget_lines.txn_standard_cost_rate%TYPE,
4444: BURDENED_COST_RATE pa_budget_lines.burden_cost_rate%TYPE,
4445: REVENUE_BILL_RATE pa_budget_lines.txn_standard_bill_rate%TYPE,
4446: disp_quantity pa_budget_lines.display_quantity%TYPE);
4447:
4448:
4449: TYPE l_ra_id_tbl_prest is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4450: l_ra_id_tbl_present l_ra_id_tbl_prest;

Line 4641: PA_BUDGET_LINES_UTILS.populate_display_qty

4637: p_log_level => 5);
4638: END IF;
4639:
4640: -- debu: testing: calling populate_display_quantity
4641: PA_BUDGET_LINES_UTILS.populate_display_qty
4642: (p_budget_version_id => p_budget_version_id,
4643: p_context => 'FINANCIAL',
4644: x_return_status => X_RETURN_STATUS);
4645:

Line 4649: (p_msg => 'Status after calling PA_BUDGET_LINES_UTILS.populate_display_qty'||X_RETURN_STATUS,

4645:
4646: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4647: IF P_PA_debug_mode = 'Y' THEN
4648: pa_fp_gen_amount_utils.fp_debug
4649: (p_msg => 'Status after calling PA_BUDGET_LINES_UTILS.populate_display_qty'||X_RETURN_STATUS,
4650: p_module_name => l_module_name,
4651: p_log_level => 5);
4652: END IF;
4653: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 4874: FROM pa_budget_lines pbl

4870: ,l_init_quantity_tbl
4871: ,l_init_raw_cost_tbl
4872: ,l_init_burd_cost_tbl
4873: ,l_init_revenue_tbl
4874: FROM pa_budget_lines pbl
4875: WHERE resource_assignment_id = l_ra_id_tbl_1(kk)
4876: AND txn_currency_code = l_txn_currency_code_tbl_1(kk);
4877:
4878: IF p_pa_debug_mode = 'Y' THEN

Line 5538: UPDATE pa_budget_lines

5534: FOR i in l_upd_bgt_line_tbl.first..l_upd_bgt_line_tbl.last
5535: LOOP
5536:
5537:
5538: UPDATE pa_budget_lines
5539: SET txn_raw_cost = l_upd_bgt_line_tbl(i).txn_raw_cost
5540: ,txn_revenue = l_upd_bgt_line_tbl(i).txn_revenue
5541: ,txn_burdened_cost = l_upd_bgt_line_tbl(i).txn_burdened_cost
5542: ,display_quantity = l_upd_bgt_line_tbl(i).disp_quantity

Line 5565: DELETE FROM pa_budget_lines

5561: IF l_del_count > 0 THEN
5562:
5563: FOR i in l_del_bud_line_tbl.first..l_del_bud_line_tbl.last
5564: LOOP
5565: DELETE FROM pa_budget_lines
5566: WHERE
5567: resource_assignment_id = l_del_bud_line_tbl(i).ra_id
5568: AND txn_currency_code = l_del_bud_line_tbl(i).txn_curr_code
5569: AND period_name = NVL(l_del_bud_line_tbl(i).period_name , period_name);