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_COMMITMENT_TXNS

Line 168: l_vendor_id PA_COMMITMENT_TXNS.vendor_id%type default null;

164: l_nl_resource_orgn_id PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL;
165: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL;
166: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL;
167: l_inventory_item_id PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL;
168: l_vendor_id PA_COMMITMENT_TXNS.vendor_id%type default null;
169: l_bom_labor_resource_id PA_COMMITMENT_TXNS.bom_equipment_resource_id%type default null;
170: l_bom_equipment_resource_id PA_COMMITMENT_TXNS.bom_labor_resource_id%type default null;
171:
172: /* Local variables added for 5980459 */

Line 169: l_bom_labor_resource_id PA_COMMITMENT_TXNS.bom_equipment_resource_id%type default null;

165: l_wip_resource_id PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL;
166: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL;
167: l_inventory_item_id PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL;
168: l_vendor_id PA_COMMITMENT_TXNS.vendor_id%type default null;
169: l_bom_labor_resource_id PA_COMMITMENT_TXNS.bom_equipment_resource_id%type default null;
170: l_bom_equipment_resource_id PA_COMMITMENT_TXNS.bom_labor_resource_id%type default null;
171:
172: /* Local variables added for 5980459 */
173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;

Line 170: l_bom_equipment_resource_id PA_COMMITMENT_TXNS.bom_labor_resource_id%type default null;

166: l_incurred_by_person_id PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL;
167: l_inventory_item_id PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL;
168: l_vendor_id PA_COMMITMENT_TXNS.vendor_id%type default null;
169: l_bom_labor_resource_id PA_COMMITMENT_TXNS.bom_equipment_resource_id%type default null;
170: l_bom_equipment_resource_id PA_COMMITMENT_TXNS.bom_labor_resource_id%type default null;
171:
172: /* Local variables added for 5980459 */
173: l_eiid_tbl PA_PLSQL_DATATYPES.NUMTabTyp;
174: l_task_id_tbl PA_PLSQL_DATATYPES.NUMTabTyp;

Line 2762: l_cmt_line_id pa_commitment_txns.cmt_line_id%type;

2758: message_string varchar2(200);
2759:
2760: prev_bcc_rec pa_cmt_burden_summary_v%rowtype;
2761: l_attribute1 pa_projects_all.attribute1%type;
2762: l_cmt_line_id pa_commitment_txns.cmt_line_id%type;
2763: l_burden_cost pa_expenditure_items_all.burden_cost%type;
2764: l_txn_ref1 pa_commitment_txns.original_txn_reference1%type;
2765: apps_id number(3) := 275; -- For PA
2766: sob_id number(15);

Line 2764: l_txn_ref1 pa_commitment_txns.original_txn_reference1%type;

2760: prev_bcc_rec pa_cmt_burden_summary_v%rowtype;
2761: l_attribute1 pa_projects_all.attribute1%type;
2762: l_cmt_line_id pa_commitment_txns.cmt_line_id%type;
2763: l_burden_cost pa_expenditure_items_all.burden_cost%type;
2764: l_txn_ref1 pa_commitment_txns.original_txn_reference1%type;
2765: apps_id number(3) := 275; -- For PA
2766: sob_id number(15);
2767: l_gl_period varchar2(15);
2768: l_pa_end_date date;

Line 2772: l_acct_burdened_cost pa_commitment_txns.acct_burdened_cost%type;

2768: l_pa_end_date date;
2769:
2770: /* start bug 2324127 */
2771:
2772: l_acct_burdened_cost pa_commitment_txns.acct_burdened_cost%type;
2773: l_denom_burdened_cost pa_commitment_txns.denom_burdened_cost%type;
2774:
2775: /* end bug 2324127 */
2776:

Line 2773: l_denom_burdened_cost pa_commitment_txns.denom_burdened_cost%type;

2769:
2770: /* start bug 2324127 */
2771:
2772: l_acct_burdened_cost pa_commitment_txns.acct_burdened_cost%type;
2773: l_denom_burdened_cost pa_commitment_txns.denom_burdened_cost%type;
2774:
2775: /* end bug 2324127 */
2776:
2777: /* 4057874 */

Line 2807: from pa_commitment_txns cmt

2803: and pt.org_id = p.org_id /*5368274*/
2804: and pt.burden_amt_display_method in ('D','d')
2805: and p.project_id = nvl(x_project_id,p.project_id) /* bug#2791563 */
2806: and exists ( select 1
2807: from pa_commitment_txns cmt
2808: where nvl(x_project_id,p.project_id) = cmt.project_id /* Bug 3613712 : Perf Issue SQL rep ID : 7938694 FTS on pa_commitment_txns */
2809: --Bug#960813
2810: -- and cmt.line_type = 'R'
2811: and cmt.burden_sum_source_run_id = init_cmt_run_id );

Line 2808: where nvl(x_project_id,p.project_id) = cmt.project_id /* Bug 3613712 : Perf Issue SQL rep ID : 7938694 FTS on pa_commitment_txns */

2804: and pt.burden_amt_display_method in ('D','d')
2805: and p.project_id = nvl(x_project_id,p.project_id) /* bug#2791563 */
2806: and exists ( select 1
2807: from pa_commitment_txns cmt
2808: where nvl(x_project_id,p.project_id) = cmt.project_id /* Bug 3613712 : Perf Issue SQL rep ID : 7938694 FTS on pa_commitment_txns */
2809: --Bug#960813
2810: -- and cmt.line_type = 'R'
2811: and cmt.burden_sum_source_run_id = init_cmt_run_id );
2812:

Line 2926: update pa_commitment_txns

2922: from pa_projects_all
2923: where project_id = proj_rec.project_id
2924: for update of attribute1 nowait;
2925:
2926: update pa_commitment_txns
2927: set burden_sum_rejection_code = NULL
2928: where project_id = current_project_id
2929: and burden_sum_source_run_id = init_cmt_run_id;
2930:

Line 2940: update pa_commitment_txns

2936: -- Step 2b. Do CMT level validations of the project
2937:
2938: begin
2939: stage := 220; -- updating error transactions
2940: update pa_commitment_txns
2941: set burden_sum_rejection_code = 'BCC_EXP_TYPE_NULL',
2942: burden_sum_source_run_id = current_run_id
2943: where project_id = current_project_id
2944: and (cmt_line_id) in

Line 2946: from pa_commitment_txns cmt

2942: burden_sum_source_run_id = current_run_id
2943: where project_id = current_project_id
2944: and (cmt_line_id) in
2945: (select cmt.cmt_line_id
2946: from pa_commitment_txns cmt
2947: -- Bug#960813
2948: -- where cmt.line_type = 'R'
2949: where cmt.burden_sum_source_run_id = current_run_id
2950: and cmt.project_id = current_project_id

Line 3007: select pa_commitment_txns_s.nextval

3003: -- l_burden_cost is replaced by l_denom_burdened_cost <> 0 for bug 2324127
3004: if l_denom_burdened_cost <> 0 then
3005:
3006: begin
3007: select pa_commitment_txns_s.nextval
3008: into l_cmt_line_id
3009: from dual;
3010:
3011: -- Getting expenditure_item_date as the end_date for that pa period

Line 3016: insert into pa_commitment_txns (

3012: stage := 235; -- Getting expenditure_item_date
3013: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);
3014: -- Getting GL period from the view itself
3015: stage := 240; -- creating transactions
3016: insert into pa_commitment_txns (
3017: cmt_line_id,
3018: project_id,
3019: task_id ,
3020: transaction_source ,

Line 3203: select pa_commitment_txns_s.nextval

3199: -- Checking for l_burden_cost <> 0 rather than l_burden_cost > 0
3200: -- Replaced l_burden_cost by l_denom_burdened_cost for bug#2324127
3201: if l_denom_burdened_cost <> 0 then
3202: begin
3203: select pa_commitment_txns_s.nextval
3204: into l_cmt_line_id
3205: from dual;
3206:
3207: -- Getting expenditure_item_date as the end_date for that pa period

Line 3211: insert into pa_commitment_txns (

3207: -- Getting expenditure_item_date as the end_date for that pa period
3208: stage := 245; -- Getting expenditure_item_date
3209: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);
3210: -- create summarized commitment transaction
3211: insert into pa_commitment_txns (
3212: cmt_line_id,
3213: project_id,
3214: task_id ,
3215: transaction_source ,

Line 3306: update pa_commitment_txns

3302:
3303: -- Update those Commitment transactions which are successfully processed
3304: -- with run id
3305:
3306: update pa_commitment_txns
3307: set burden_sum_source_run_id = current_run_id
3308: where (cmt_line_id) in
3309: ( select cmt_line_id
3310: from pa_commitment_txns cmt

Line 3310: from pa_commitment_txns cmt

3306: update pa_commitment_txns
3307: set burden_sum_source_run_id = current_run_id
3308: where (cmt_line_id) in
3309: ( select cmt_line_id
3310: from pa_commitment_txns cmt
3311: where cmt.burden_sum_rejection_code is NULL
3312: -- Bug#960813
3313: -- and cmt.line_type = 'R'
3314: and cmt.burden_sum_source_run_id = init_cmt_run_id