APPS.PA_BURDEN_COSTING dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 11: current_run_id pa_cost_distribution_lines_all.burden_sum_source_run_id%TYPE; /*Bug# 2255068*/

7: --End Of Mods(EOM) Bug # 5743708
8:
9: current_project_id pa_projects_all.project_id%type;
10: -- Project id of the project being processed.
11: current_run_id pa_cost_distribution_lines_all.burden_sum_source_run_id%TYPE; /*Bug# 2255068*/
12: -- Run id of the batch being processed.
13: -- 3699045
14: current_sponsored_flag gms_project_types.sponsored_flag%TYPE := 'N' ;
15:

Line 55: FUNCTION get_current_run_id RETURN pa_cost_distribution_lines_all.burden_sum_source_run_id%TYPE

51: BEGIN
52: current_run_id := x_run_id;
53: END set_current_run_id;
54:
55: FUNCTION get_current_run_id RETURN pa_cost_distribution_lines_all.burden_sum_source_run_id%TYPE
56: IS
57: BEGIN
58: return current_run_id;
59: END get_current_run_id;

Line 1104: PA_COST_DISTRIBUTION_LINES_ALL CDL,

1100: ,CDL.PROJECT_EXCHANGE_RATE ,CDL.PROJFUNC_COST_RATE_DATE ,CDL.PROJFUNC_COST_RATE_TYPE
1101: ,CDL.PROJFUNC_COST_EXCHANGE_RATE
1102: ,CDL.CBS_ELEMENT_ID -- Added for CBS enahncement bug 16579913
1103: FROM
1104: PA_COST_DISTRIBUTION_LINES_ALL CDL,
1105: PA_EXPENDITURE_ITEMS EI
1106: WHERE ei.expenditure_item_id = l_eiid_tbl(i)
1107: AND cdl.expenditure_item_id = ei.expenditure_item_id
1108: AND cdl.request_id = x_request_id

Line 2666: and exists (select 1 from pa_cost_distribution_lines_all cdl

2662: Tp_Rule_percentage = decode(tp_ind_compiled_set_id,NULL,decode(cc_bl_distributed_code,'Y',NULL,Tp_Rule_percentage),
2663: Tp_Rule_percentage) /*End of bug 4754024*/
2664: where adjustment_type ='BURDEN_RESUMMARIZE'
2665: and project_id = current_project_id
2666: and exists (select 1 from pa_cost_distribution_lines_all cdl
2667: where cdl.expenditure_item_id = ei.expenditure_item_id
2668: and cdl.request_id = x_request_id
2669: /* and cdl.prev_ind_compiled_set_id is NOT NULL :Commented for bug# 3040724*/
2670: and cdl.burden_sum_source_run_id =current_run_id )

Line 2682: UPDATE pa_cost_distribution_lines_all

2678: /* Modified this sql for bug 5406802*/
2679:
2680: FORALL I IN 1..l_tbl_eiid.count
2681:
2682: UPDATE pa_cost_distribution_lines_all
2683: set prev_ind_compiled_set_id = NULL
2684: where prev_ind_compiled_set_id IS NOT NULL
2685: and project_id = current_project_id
2686: and request_id = x_request_id

Line 3337: PROCEDURE InsBurdenAudit( p_project_id IN pa_cost_distribution_lines_all.project_id%TYPE,

3333: Used the cached expenditure item pl/sql table for populating the audit table
3334: instead opening the cursor from CDL table.
3335: */
3336:
3337: PROCEDURE InsBurdenAudit( p_project_id IN pa_cost_distribution_lines_all.project_id%TYPE,
3338: p_request_id IN NUMBER ,
3339: p_user_id IN number,
3340: x_status IN OUT NOCOPY number )
3341: IS

Line 3381: pa_cost_distribution_lines_all

3377: l_program_id,
3378: l_program_application_id,
3379: p_request_id
3380: FROM
3381: pa_cost_distribution_lines_all
3382: WHERE expenditure_item_id = l_tbl_eiid(i)
3383: AND line_num= l_tbl_cdlln(i)
3384: AND prev_ind_compiled_set_id IS NOT NULL
3385: AND request_id = p_request_id

Line 3467: PA_COST_DISTRIBUTION_LINES_ALL CDL,

3463: ,CDL.PROJECT_EXCHANGE_RATE ,CDL.PROJFUNC_COST_RATE_DATE ,CDL.PROJFUNC_COST_RATE_TYPE
3464: ,CDL.PROJFUNC_COST_EXCHANGE_RATE
3465: ,CDL.CBS_ELEMENT_ID -- Added for CBS enahncement bug 16579913
3466: FROM
3467: PA_COST_DISTRIBUTION_LINES_ALL CDL,
3468: PA_EXPENDITURE_ITEMS EI,
3469: PA_EXPENDITURES_ALL E
3470: WHERE cdl.burden_sum_source_run_id = p_current_run_id
3471: AND cdl.project_id = p_project_id