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 2618: l_cmt_line_id pa_commitment_txns.cmt_line_id%type;

2614: message_string varchar2(200);
2615:
2616: prev_bcc_rec pa_cmt_burden_summary_v%rowtype;
2617: l_attribute1 pa_projects_all.attribute1%type;
2618: l_cmt_line_id pa_commitment_txns.cmt_line_id%type;
2619: l_burden_cost pa_expenditure_items_all.burden_cost%type;
2620: l_txn_ref1 pa_commitment_txns.original_txn_reference1%type;
2621: apps_id number(3) := 275; -- For PA
2622: sob_id number(15);

Line 2620: l_txn_ref1 pa_commitment_txns.original_txn_reference1%type;

2616: prev_bcc_rec pa_cmt_burden_summary_v%rowtype;
2617: l_attribute1 pa_projects_all.attribute1%type;
2618: l_cmt_line_id pa_commitment_txns.cmt_line_id%type;
2619: l_burden_cost pa_expenditure_items_all.burden_cost%type;
2620: l_txn_ref1 pa_commitment_txns.original_txn_reference1%type;
2621: apps_id number(3) := 275; -- For PA
2622: sob_id number(15);
2623: l_gl_period varchar2(15);
2624: l_pa_end_date date;

Line 2628: l_acct_burdened_cost pa_commitment_txns.acct_burdened_cost%type;

2624: l_pa_end_date date;
2625:
2626: /* start bug 2324127 */
2627:
2628: l_acct_burdened_cost pa_commitment_txns.acct_burdened_cost%type;
2629: l_denom_burdened_cost pa_commitment_txns.denom_burdened_cost%type;
2630:
2631: /* end bug 2324127 */
2632:

Line 2629: l_denom_burdened_cost pa_commitment_txns.denom_burdened_cost%type;

2625:
2626: /* start bug 2324127 */
2627:
2628: l_acct_burdened_cost pa_commitment_txns.acct_burdened_cost%type;
2629: l_denom_burdened_cost pa_commitment_txns.denom_burdened_cost%type;
2630:
2631: /* end bug 2324127 */
2632:
2633: /* 4057874 */

Line 2663: from pa_commitment_txns cmt

2659: and pt.org_id = p.org_id /*5368274*/
2660: and pt.burden_amt_display_method in ('D','d')
2661: and p.project_id = nvl(x_project_id,p.project_id) /* bug#2791563 */
2662: and exists ( select 1
2663: from pa_commitment_txns cmt
2664: where nvl(x_project_id,p.project_id) = cmt.project_id /* Bug 3613712 : Perf Issue SQL rep ID : 7938694 FTS on pa_commitment_txns */
2665: --Bug#960813
2666: -- and cmt.line_type = 'R'
2667: and cmt.burden_sum_source_run_id = init_cmt_run_id );

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

2660: and pt.burden_amt_display_method in ('D','d')
2661: and p.project_id = nvl(x_project_id,p.project_id) /* bug#2791563 */
2662: and exists ( select 1
2663: from pa_commitment_txns cmt
2664: where nvl(x_project_id,p.project_id) = cmt.project_id /* Bug 3613712 : Perf Issue SQL rep ID : 7938694 FTS on pa_commitment_txns */
2665: --Bug#960813
2666: -- and cmt.line_type = 'R'
2667: and cmt.burden_sum_source_run_id = init_cmt_run_id );
2668:

Line 2782: update pa_commitment_txns

2778: from pa_projects_all
2779: where project_id = proj_rec.project_id
2780: for update of attribute1 nowait;
2781:
2782: update pa_commitment_txns
2783: set burden_sum_rejection_code = NULL
2784: where project_id = current_project_id
2785: and burden_sum_source_run_id = init_cmt_run_id;
2786:

Line 2796: update pa_commitment_txns

2792: -- Step 2b. Do CMT level validations of the project
2793:
2794: begin
2795: stage := 220; -- updating error transactions
2796: update pa_commitment_txns
2797: set burden_sum_rejection_code = 'BCC_EXP_TYPE_NULL',
2798: burden_sum_source_run_id = current_run_id
2799: where project_id = current_project_id
2800: and (cmt_line_id) in

Line 2802: from pa_commitment_txns cmt

2798: burden_sum_source_run_id = current_run_id
2799: where project_id = current_project_id
2800: and (cmt_line_id) in
2801: (select cmt.cmt_line_id
2802: from pa_commitment_txns cmt
2803: -- Bug#960813
2804: -- where cmt.line_type = 'R'
2805: where cmt.burden_sum_source_run_id = current_run_id
2806: and cmt.project_id = current_project_id

Line 2863: select pa_commitment_txns_s.nextval

2859: -- l_burden_cost is replaced by l_denom_burdened_cost <> 0 for bug 2324127
2860: if l_denom_burdened_cost <> 0 then
2861:
2862: begin
2863: select pa_commitment_txns_s.nextval
2864: into l_cmt_line_id
2865: from dual;
2866:
2867: -- Getting expenditure_item_date as the end_date for that pa period

Line 2872: insert into pa_commitment_txns (

2868: stage := 235; -- Getting expenditure_item_date
2869: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);
2870: -- Getting GL period from the view itself
2871: stage := 240; -- creating transactions
2872: insert into pa_commitment_txns (
2873: cmt_line_id,
2874: project_id,
2875: task_id ,
2876: transaction_source ,

Line 3059: select pa_commitment_txns_s.nextval

3055: -- Checking for l_burden_cost <> 0 rather than l_burden_cost > 0
3056: -- Replaced l_burden_cost by l_denom_burdened_cost for bug#2324127
3057: if l_denom_burdened_cost <> 0 then
3058: begin
3059: select pa_commitment_txns_s.nextval
3060: into l_cmt_line_id
3061: from dual;
3062:
3063: -- Getting expenditure_item_date as the end_date for that pa period

Line 3067: insert into pa_commitment_txns (

3063: -- Getting expenditure_item_date as the end_date for that pa period
3064: stage := 245; -- Getting expenditure_item_date
3065: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);
3066: -- create summarized commitment transaction
3067: insert into pa_commitment_txns (
3068: cmt_line_id,
3069: project_id,
3070: task_id ,
3071: transaction_source ,

Line 3162: update pa_commitment_txns

3158:
3159: -- Update those Commitment transactions which are successfully processed
3160: -- with run id
3161:
3162: update pa_commitment_txns
3163: set burden_sum_source_run_id = current_run_id
3164: where (cmt_line_id) in
3165: ( select cmt_line_id
3166: from pa_commitment_txns cmt

Line 3166: from pa_commitment_txns cmt

3162: update pa_commitment_txns
3163: set burden_sum_source_run_id = current_run_id
3164: where (cmt_line_id) in
3165: ( select cmt_line_id
3166: from pa_commitment_txns cmt
3167: where cmt.burden_sum_rejection_code is NULL
3168: -- Bug#960813
3169: -- and cmt.line_type = 'R'
3170: and cmt.burden_sum_source_run_id = init_cmt_run_id