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_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 1074: PA_COST_DISTRIBUTION_LINES_ALL CDL,

1070: ,CDL.ACCT_EXCHANGE_RATE ,CDL.PROJECT_RATE_DATE ,CDL.PROJECT_RATE_TYPE
1071: ,CDL.PROJECT_EXCHANGE_RATE ,CDL.PROJFUNC_COST_RATE_DATE ,CDL.PROJFUNC_COST_RATE_TYPE
1072: ,CDL.PROJFUNC_COST_EXCHANGE_RATE
1073: FROM
1074: PA_COST_DISTRIBUTION_LINES_ALL CDL,
1075: PA_EXPENDITURE_ITEMS EI
1076: WHERE ei.expenditure_item_id = l_eiid_tbl(i)
1077: AND cdl.expenditure_item_id = ei.expenditure_item_id
1078: AND cdl.request_id = x_request_id

Line 2522: and exists (select 1 from pa_cost_distribution_lines_all cdl

2518: Tp_Rule_percentage = decode(tp_ind_compiled_set_id,NULL,decode(cc_bl_distributed_code,'Y',NULL,Tp_Rule_percentage),
2519: Tp_Rule_percentage) /*End of bug 4754024*/
2520: where adjustment_type ='BURDEN_RESUMMARIZE'
2521: and project_id = current_project_id
2522: and exists (select 1 from pa_cost_distribution_lines_all cdl
2523: where cdl.expenditure_item_id = ei.expenditure_item_id
2524: and cdl.request_id = x_request_id
2525: /* and cdl.prev_ind_compiled_set_id is NOT NULL :Commented for bug# 3040724*/
2526: and cdl.burden_sum_source_run_id =current_run_id )

Line 2538: UPDATE pa_cost_distribution_lines_all

2534: /* Modified this sql for bug 5406802*/
2535:
2536: FORALL I IN 1..l_tbl_eiid.count
2537:
2538: UPDATE pa_cost_distribution_lines_all
2539: set prev_ind_compiled_set_id = NULL
2540: where prev_ind_compiled_set_id IS NOT NULL
2541: and project_id = current_project_id
2542: and request_id = x_request_id

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

3189: Used the cached expenditure item pl/sql table for populating the audit table
3190: instead opening the cursor from CDL table.
3191: */
3192:
3193: PROCEDURE InsBurdenAudit( p_project_id IN pa_cost_distribution_lines_all.project_id%TYPE,
3194: p_request_id IN NUMBER ,
3195: p_user_id IN number,
3196: x_status IN OUT NOCOPY number )
3197: IS

Line 3237: pa_cost_distribution_lines_all

3233: l_program_id,
3234: l_program_application_id,
3235: p_request_id
3236: FROM
3237: pa_cost_distribution_lines_all
3238: WHERE expenditure_item_id = l_tbl_eiid(i)
3239: AND line_num= l_tbl_cdlln(i)
3240: AND prev_ind_compiled_set_id IS NOT NULL
3241: AND request_id = p_request_id

Line 3318: PA_COST_DISTRIBUTION_LINES_ALL CDL,

3314: ,CDL.ACCT_EXCHANGE_RATE ,CDL.PROJECT_RATE_DATE ,CDL.PROJECT_RATE_TYPE
3315: ,CDL.PROJECT_EXCHANGE_RATE ,CDL.PROJFUNC_COST_RATE_DATE ,CDL.PROJFUNC_COST_RATE_TYPE
3316: ,CDL.PROJFUNC_COST_EXCHANGE_RATE
3317: FROM
3318: PA_COST_DISTRIBUTION_LINES_ALL CDL,
3319: PA_EXPENDITURE_ITEMS EI,
3320: PA_EXPENDITURES_ALL E
3321: WHERE cdl.burden_sum_source_run_id = p_current_run_id
3322: AND cdl.project_id = p_project_id