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_CI_MERGE dependencies on FND_GLOBAL

Line 96: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

92: )
93: IS
94: -- Local Variable Declaration
95:
96: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
97: l_created_by NUMBER := FND_GLOBAL.USER_ID;
98: l_creation_date DATE := SYSDATE;
99: l_last_update_date DATE := l_creation_date;
100: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line 97: l_created_by NUMBER := FND_GLOBAL.USER_ID;

93: IS
94: -- Local Variable Declaration
95:
96: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
97: l_created_by NUMBER := FND_GLOBAL.USER_ID;
98: l_creation_date DATE := SYSDATE;
99: l_last_update_date DATE := l_creation_date;
100: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
101:

Line 100: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

96: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
97: l_created_by NUMBER := FND_GLOBAL.USER_ID;
98: l_creation_date DATE := SYSDATE;
99: l_last_update_date DATE := l_creation_date;
100: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
101:
102: l_s_ci_id pa_budget_versions.ci_id%TYPE;
103: l_included_by NUMBER := 0;
104: l_party_id NUMBER := 0;

Line 230: l_included_by := FND_GLOBAL.USER_ID;

226:
227: IF p_included_by IS NOT NULL THEN
228: l_included_by := p_included_by;
229: ELSE
230: l_included_by := FND_GLOBAL.USER_ID;
231: END IF;
232:
233: BEGIN
234: SELECT hp.party_id

Line 414: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

410: )
411: IS
412: -- Local Variable Declaration
413:
414: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
415: l_last_update_date DATE := SYSDATE;
416: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
417:
418: l_debug_mode VARCHAR2(30);

Line 416: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

412: -- Local Variable Declaration
413:
414: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
415: l_last_update_date DATE := SYSDATE;
416: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
417:
418: l_debug_mode VARCHAR2(30);
419:
420: l_target_ver_type pa_budget_versions.version_type%TYPE;

Line 697: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

693: )
694: IS
695: -- Local Variable Declaration
696:
697: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
698: l_last_update_date DATE := SYSDATE;
699: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
700:
701: l_party_id NUMBER := 0;

Line 699: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

695: -- Local Variable Declaration
696:
697: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
698: l_last_update_date DATE := SYSDATE;
699: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
700:
701: l_party_id NUMBER := 0;
702: l_implemented_by NUMBER := 0;
703: l_impact_type_code VARCHAR2(30);

Line 757: l_implemented_by := FND_GLOBAL.USER_ID;

753:
754: IF p_implemented_by IS NOT NULL THEN
755: l_implemented_by := p_implemented_by;
756: ELSE
757: l_implemented_by := FND_GLOBAL.USER_ID;
758: END IF;
759:
760: BEGIN
761: SELECT hp.party_id

Line 2624: ,fnd_global.user_id created_by

2620: ,pmc.ci_id ci_id
2621: ,pmc.ci_plan_version_id ci_plan_version_id
2622: ,1 record_version_number
2623: ,sysdate creation_date
2624: ,fnd_global.user_id created_by
2625: ,fnd_global.login_id last_update_login
2626: ,fnd_global.user_id last_updated_by
2627: ,sysdate last_update_date
2628: ,'COPIED' inclusion_method_code

Line 2625: ,fnd_global.login_id last_update_login

2621: ,pmc.ci_plan_version_id ci_plan_version_id
2622: ,1 record_version_number
2623: ,sysdate creation_date
2624: ,fnd_global.user_id created_by
2625: ,fnd_global.login_id last_update_login
2626: ,fnd_global.user_id last_updated_by
2627: ,sysdate last_update_date
2628: ,'COPIED' inclusion_method_code
2629: ,pmc.included_by_person_id included_by_person_id

Line 2626: ,fnd_global.user_id last_updated_by

2622: ,1 record_version_number
2623: ,sysdate creation_date
2624: ,fnd_global.user_id created_by
2625: ,fnd_global.login_id last_update_login
2626: ,fnd_global.user_id last_updated_by
2627: ,sysdate last_update_date
2628: ,'COPIED' inclusion_method_code
2629: ,pmc.included_by_person_id included_by_person_id
2630: ,pmc.version_type version_type

Line 2753: ,fnd_global.user_id

2749: ,pmc.ci_id
2750: ,pmc.ci_plan_version_id
2751: ,1
2752: ,sysdate
2753: ,fnd_global.user_id
2754: ,fnd_global.login_id
2755: ,fnd_global.user_id
2756: ,sysdate
2757: ,'COPIED'

Line 2754: ,fnd_global.login_id

2750: ,pmc.ci_plan_version_id
2751: ,1
2752: ,sysdate
2753: ,fnd_global.user_id
2754: ,fnd_global.login_id
2755: ,fnd_global.user_id
2756: ,sysdate
2757: ,'COPIED'
2758: ,pmc.included_by_person_id

Line 2755: ,fnd_global.user_id

2751: ,1
2752: ,sysdate
2753: ,fnd_global.user_id
2754: ,fnd_global.login_id
2755: ,fnd_global.user_id
2756: ,sysdate
2757: ,'COPIED'
2758: ,pmc.included_by_person_id
2759: ,pmc.version_type

Line 4645: , fnd_global.user_id

4641: , 'N'
4642: , 'N'
4643: , 'N'
4644: , sysdate
4645: , fnd_global.user_id
4646: , sysdate
4647: , fnd_global.user_id
4648: , fnd_global.login_id
4649: , NULL

Line 4647: , fnd_global.user_id

4643: , 'N'
4644: , sysdate
4645: , fnd_global.user_id
4646: , sysdate
4647: , fnd_global.user_id
4648: , fnd_global.login_id
4649: , NULL
4650: , NULL
4651: , NULL

Line 4648: , fnd_global.login_id

4644: , sysdate
4645: , fnd_global.user_id
4646: , sysdate
4647: , fnd_global.user_id
4648: , fnd_global.login_id
4649: , NULL
4650: , NULL
4651: , NULL
4652: , NULL);

Line 5956: ,fnd_global.user_id -- LAST_UPDATED_BY

5952: ,l_project_id -- PROJECT_ID
5953: ,L_targ_task_id_tbl(kk) -- TASK_ID
5954: ,L_targ_rlm_id_tbl(kk) -- RESOURCE_LIST_MEMBER_ID
5955: ,sysdate -- LAST_UPDATE_DATE
5956: ,fnd_global.user_id -- LAST_UPDATED_BY
5957: ,sysdate -- CREATION_DATE
5958: ,fnd_global.user_id -- CREATED_BY
5959: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5960: ,l_targ_unit_of_measure_tbl(kk) -- UNIT_OF_MEASURE

Line 5958: ,fnd_global.user_id -- CREATED_BY

5954: ,L_targ_rlm_id_tbl(kk) -- RESOURCE_LIST_MEMBER_ID
5955: ,sysdate -- LAST_UPDATE_DATE
5956: ,fnd_global.user_id -- LAST_UPDATED_BY
5957: ,sysdate -- CREATION_DATE
5958: ,fnd_global.user_id -- CREATED_BY
5959: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5960: ,l_targ_unit_of_measure_tbl(kk) -- UNIT_OF_MEASURE
5961: ,NULL -- TRACK_AS_LABOR_FLAG
5962: ,NULL -- STANDARD_BILL_RATE

Line 5959: ,fnd_global.login_id -- LAST_UPDATE_LOGIN

5955: ,sysdate -- LAST_UPDATE_DATE
5956: ,fnd_global.user_id -- LAST_UPDATED_BY
5957: ,sysdate -- CREATION_DATE
5958: ,fnd_global.user_id -- CREATED_BY
5959: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5960: ,l_targ_unit_of_measure_tbl(kk) -- UNIT_OF_MEASURE
5961: ,NULL -- TRACK_AS_LABOR_FLAG
5962: ,NULL -- STANDARD_BILL_RATE
5963: ,NULL -- AVERAGE_BILL_RATE

Line 6106: LAST_UPDATED_BY = fnd_global.user_id,

6102: FROM pa_budget_lines pbl
6103: WHERE pbl.resource_assignment_id = pra.resource_assignment_id),
6104: RATE_BASED_FLAG = l_targ_RATE_BASED_FLAG_tbl(kk), -- bug 4171006
6105: LAST_UPDATE_DATE = sysdate,
6106: LAST_UPDATED_BY = fnd_global.user_id,
6107: LAST_UPDATE_LOGIN = fnd_global.login_id,
6108: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
6109: WHERE l_ra_dml_code_tbl (kk)= 'UPDATE' -- Bug 3662136
6110: AND resource_assignment_id=l_targ_ra_id_tbl(kk)

Line 6107: LAST_UPDATE_LOGIN = fnd_global.login_id,

6103: WHERE pbl.resource_assignment_id = pra.resource_assignment_id),
6104: RATE_BASED_FLAG = l_targ_RATE_BASED_FLAG_tbl(kk), -- bug 4171006
6105: LAST_UPDATE_DATE = sysdate,
6106: LAST_UPDATED_BY = fnd_global.user_id,
6107: LAST_UPDATE_LOGIN = fnd_global.login_id,
6108: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
6109: WHERE l_ra_dml_code_tbl (kk)= 'UPDATE' -- Bug 3662136
6110: AND resource_assignment_id=l_targ_ra_id_tbl(kk)
6111: RETURNING

Line 6132: LAST_UPDATED_BY = fnd_global.user_id,

6128: UNIT_OF_MEASURE = l_targ_unit_of_measure_tbl(kk), -- bug 4171006
6129: TRANSACTION_SOURCE_CODE = null,
6130: RATE_BASED_FLAG = l_targ_RATE_BASED_FLAG_tbl(kk), -- bug 4171006
6131: LAST_UPDATE_DATE = sysdate,
6132: LAST_UPDATED_BY = fnd_global.user_id,
6133: LAST_UPDATE_LOGIN = fnd_global.login_id,
6134: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
6135: WHERE l_ra_dml_code_tbl (kk)= 'UPDATE' -- Bug 3662136
6136: AND resource_assignment_id=l_targ_ra_id_tbl(kk)

Line 6133: LAST_UPDATE_LOGIN = fnd_global.login_id,

6129: TRANSACTION_SOURCE_CODE = null,
6130: RATE_BASED_FLAG = l_targ_RATE_BASED_FLAG_tbl(kk), -- bug 4171006
6131: LAST_UPDATE_DATE = sysdate,
6132: LAST_UPDATED_BY = fnd_global.user_id,
6133: LAST_UPDATE_LOGIN = fnd_global.login_id,
6134: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
6135: WHERE l_ra_dml_code_tbl (kk)= 'UPDATE' -- Bug 3662136
6136: AND resource_assignment_id=l_targ_ra_id_tbl(kk)
6137: RETURNING

Line 6780: fnd_global.user_id last_updated_by,

6776: FROM
6777: --The entire SELECT is moved to the sub query in FROM clause as nextval would not work with group by
6778: (SELECT get_mapped_ra_id(get_task_id(l_targ_plan_level_code,pras.task_id), pras.resource_list_member_id) resource_assignment_id,
6779: sysdate last_update_date,
6780: fnd_global.user_id last_updated_by,
6781: sysdate creation_date,
6782: fnd_global.user_id created_by,
6783: fnd_global.login_id last_update_login,
6784: NULL period_name,

Line 6782: fnd_global.user_id created_by,

6778: (SELECT get_mapped_ra_id(get_task_id(l_targ_plan_level_code,pras.task_id), pras.resource_list_member_id) resource_assignment_id,
6779: sysdate last_update_date,
6780: fnd_global.user_id last_updated_by,
6781: sysdate creation_date,
6782: fnd_global.user_id created_by,
6783: fnd_global.login_id last_update_login,
6784: NULL period_name,
6785: decode(l_cost_impl_flag,
6786: 'Y',sum(pbls.quantity),

Line 6783: fnd_global.login_id last_update_login,

6779: sysdate last_update_date,
6780: fnd_global.user_id last_updated_by,
6781: sysdate creation_date,
6782: fnd_global.user_id created_by,
6783: fnd_global.login_id last_update_login,
6784: NULL period_name,
6785: decode(l_cost_impl_flag,
6786: 'Y',sum(pbls.quantity),
6787: decode(l_rev_impl_flag,

Line 7186: fnd_global.user_id last_updated_by,

7182: FROM
7183: --The entier SELECT is moved to the sub query in FROM clause as nextval would not work with group by
7184: (SELECT pa_fp_ci_merge.get_mapped_ra_id(pa_fp_ci_merge.get_task_id(l_targ_plan_level_code,pras.task_id), rlmap.resource_list_member_id) resource_assignment_id,
7185: sysdate last_update_date,
7186: fnd_global.user_id last_updated_by,
7187: sysdate creation_date,
7188: fnd_global.user_id created_by,
7189: fnd_global.login_id last_update_login,
7190: NULL period_name,

Line 7188: fnd_global.user_id created_by,

7184: (SELECT pa_fp_ci_merge.get_mapped_ra_id(pa_fp_ci_merge.get_task_id(l_targ_plan_level_code,pras.task_id), rlmap.resource_list_member_id) resource_assignment_id,
7185: sysdate last_update_date,
7186: fnd_global.user_id last_updated_by,
7187: sysdate creation_date,
7188: fnd_global.user_id created_by,
7189: fnd_global.login_id last_update_login,
7190: NULL period_name,
7191: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',
7192: decode(l_impl_qty_tbl(j),'Y', sum(pbls.quantity) * l_partial_factor,null),null)) quantity,

Line 7189: fnd_global.login_id last_update_login,

7185: sysdate last_update_date,
7186: fnd_global.user_id last_updated_by,
7187: sysdate creation_date,
7188: fnd_global.user_id created_by,
7189: fnd_global.login_id last_update_login,
7190: NULL period_name,
7191: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',
7192: decode(l_impl_qty_tbl(j),'Y', sum(pbls.quantity) * l_partial_factor,null),null)) quantity,
7193: sum(Decode(l_cost_impl_flag ,'Y', pbls.raw_cost,null)) raw_cost,

Line 7592: fnd_global.user_id last_updated_by,

7588: pbl.pfc_cur_conv_rejection_code
7589: FROM(SELECT get_mapped_ra_id(get_task_id(l_targ_plan_level_code,pras.task_id), pras.resource_list_member_id) resource_assignment_id,
7590: pbls.start_date start_date,
7591: sysdate last_update_date,
7592: fnd_global.user_id last_updated_by,
7593: sysdate creation_date,
7594: fnd_global.user_id created_by,
7595: fnd_global.login_id last_update_login,
7596: pbls.end_date end_date,

Line 7594: fnd_global.user_id created_by,

7590: pbls.start_date start_date,
7591: sysdate last_update_date,
7592: fnd_global.user_id last_updated_by,
7593: sysdate creation_date,
7594: fnd_global.user_id created_by,
7595: fnd_global.login_id last_update_login,
7596: pbls.end_date end_date,
7597: pbls.period_name period_name,
7598: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',

Line 7595: fnd_global.login_id last_update_login,

7591: sysdate last_update_date,
7592: fnd_global.user_id last_updated_by,
7593: sysdate creation_date,
7594: fnd_global.user_id created_by,
7595: fnd_global.login_id last_update_login,
7596: pbls.end_date end_date,
7597: pbls.period_name period_name,
7598: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',
7599: decode(l_impl_qty_tbl(j),'Y', sum(pbls.quantity) * l_partial_factor,null),null)) quantity,

Line 7998: fnd_global.user_id last_updated_by,

7994: pbl.pfc_cur_conv_rejection_code
7995: FROM(SELECT get_mapped_ra_id(get_task_id(l_targ_plan_level_code,rlmap.task_id), rlmap.resource_list_member_id) resource_assignment_id,
7996: pbls.start_date start_date,
7997: sysdate last_update_date,
7998: fnd_global.user_id last_updated_by,
7999: sysdate creation_date,
8000: fnd_global.user_id created_by,
8001: fnd_global.login_id last_update_login,
8002: pbls.end_date end_date,

Line 8000: fnd_global.user_id created_by,

7996: pbls.start_date start_date,
7997: sysdate last_update_date,
7998: fnd_global.user_id last_updated_by,
7999: sysdate creation_date,
8000: fnd_global.user_id created_by,
8001: fnd_global.login_id last_update_login,
8002: pbls.end_date end_date,
8003: pbls.period_name period_name,
8004: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',

Line 8001: fnd_global.login_id last_update_login,

7997: sysdate last_update_date,
7998: fnd_global.user_id last_updated_by,
7999: sysdate creation_date,
8000: fnd_global.user_id created_by,
8001: fnd_global.login_id last_update_login,
8002: pbls.end_date end_date,
8003: pbls.period_name period_name,
8004: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',
8005: decode(l_impl_qty_tbl(j),'Y', sum(pbls.quantity) * l_partial_factor,null),null)) quantity,

Line 9559: fnd_global.user_id,

9555: )
9556: SELECT l_bl_RESOURCE_ASIGNMENT_ID_tbl(kk),
9557: l_bl_START_DATE_tbl(kk),
9558: sysdate,
9559: fnd_global.user_id,
9560: sysdate,
9561: fnd_global.user_id,
9562: fnd_global.login_id,
9563: l_bl_END_DATE_tbl(kk),

Line 9561: fnd_global.user_id,

9557: l_bl_START_DATE_tbl(kk),
9558: sysdate,
9559: fnd_global.user_id,
9560: sysdate,
9561: fnd_global.user_id,
9562: fnd_global.login_id,
9563: l_bl_END_DATE_tbl(kk),
9564: l_bl_PERIOD_NAME_tbl(kk),
9565: Decode(l_bl_rbf_flag_tbl(kk),

Line 9562: fnd_global.login_id,

9558: sysdate,
9559: fnd_global.user_id,
9560: sysdate,
9561: fnd_global.user_id,
9562: fnd_global.login_id,
9563: l_bl_END_DATE_tbl(kk),
9564: l_bl_PERIOD_NAME_tbl(kk),
9565: Decode(l_bl_rbf_flag_tbl(kk),
9566: 'N',Decode(l_target_version_type,

Line 9694: LAST_UPDATED_BY=fnd_global.user_id,

9690: --Fix for bug 3734888. Null handled the pl/sql tbls while updating.
9691: FORALL kk in 1..l_upd_ra_bl_dml_code_tbl.count
9692: UPDATE PA_BUDGET_LINES
9693: SET LAST_UPDATE_DATE=sysdate,
9694: LAST_UPDATED_BY=fnd_global.user_id,
9695: LAST_UPDATE_LOGIN=fnd_global.login_id,
9696: QUANTITY= DECODE(l_bl_rbf_flag_tbl(kk),
9697: 'N',DECODE(l_target_version_type,
9698: 'REVENUE',nvl(TXN_REVENUE,0)+ nvl(l_bl_TXN_REVENUE_tbl(kk),0)

Line 9695: LAST_UPDATE_LOGIN=fnd_global.login_id,

9691: FORALL kk in 1..l_upd_ra_bl_dml_code_tbl.count
9692: UPDATE PA_BUDGET_LINES
9693: SET LAST_UPDATE_DATE=sysdate,
9694: LAST_UPDATED_BY=fnd_global.user_id,
9695: LAST_UPDATE_LOGIN=fnd_global.login_id,
9696: QUANTITY= DECODE(l_bl_rbf_flag_tbl(kk),
9697: 'N',DECODE(l_target_version_type,
9698: 'REVENUE',nvl(TXN_REVENUE,0)+ nvl(l_bl_TXN_REVENUE_tbl(kk),0)
9699: ,nvl(TXN_RAW_COST,0) + nvl(l_bl_TXN_RAW_COST_tbl(kk),0)),

Line 10825: ,last_update_login =fnd_global.login_id

10821: ,impl_equipment_quantity =nvl(impl_equipment_quantity,0)+nvl(l_rev_equip_qty,0)
10822: ,impl_agr_revenue =nvl(impl_agr_revenue,0) + nvl(l_partial_impl_rev_amt,0)
10823: ,record_version_number =record_version_number+1
10824: ,last_update_date =sysdate
10825: ,last_update_login =fnd_global.login_id
10826: ,last_updated_by =fnd_global.user_id
10827: WHERE project_id=l_project_id
10828: AND plan_version_id=p_budget_version_id
10829: AND ci_id=p_ci_id

Line 10826: ,last_updated_by =fnd_global.user_id

10822: ,impl_agr_revenue =nvl(impl_agr_revenue,0) + nvl(l_partial_impl_rev_amt,0)
10823: ,record_version_number =record_version_number+1
10824: ,last_update_date =sysdate
10825: ,last_update_login =fnd_global.login_id
10826: ,last_updated_by =fnd_global.user_id
10827: WHERE project_id=l_project_id
10828: AND plan_version_id=p_budget_version_id
10829: AND ci_id=p_ci_id
10830: AND ci_plan_version_id=l_src_ver_id_tbl(j)

Line 10849: ,last_update_login =fnd_global.login_id

10845: UPDATE pa_budget_versions
10846: SET rev_partially_impl_flag ='N'
10847: ,record_version_number =record_version_number+1
10848: ,last_update_date =sysdate
10849: ,last_update_login =fnd_global.login_id
10850: ,last_updated_by =fnd_global.user_id
10851: WHERE budget_version_id = l_src_ver_id_tbl(j);
10852:
10853: ELSE

Line 10850: ,last_updated_by =fnd_global.user_id

10846: SET rev_partially_impl_flag ='N'
10847: ,record_version_number =record_version_number+1
10848: ,last_update_date =sysdate
10849: ,last_update_login =fnd_global.login_id
10850: ,last_updated_by =fnd_global.user_id
10851: WHERE budget_version_id = l_src_ver_id_tbl(j);
10852:
10853: ELSE
10854:

Line 10860: ,last_update_login =fnd_global.login_id

10856: UPDATE pa_budget_versions
10857: SET rev_partially_impl_flag ='Y'
10858: ,record_version_number =record_version_number+1
10859: ,last_update_date =sysdate
10860: ,last_update_login =fnd_global.login_id
10861: ,last_updated_by =fnd_global.user_id
10862: WHERE budget_version_id = l_src_ver_id_tbl(j)
10863: AND nvl(rev_partially_impl_flag,'N')='N';
10864:

Line 10861: ,last_updated_by =fnd_global.user_id

10857: SET rev_partially_impl_flag ='Y'
10858: ,record_version_number =record_version_number+1
10859: ,last_update_date =sysdate
10860: ,last_update_login =fnd_global.login_id
10861: ,last_updated_by =fnd_global.user_id
10862: WHERE budget_version_id = l_src_ver_id_tbl(j)
10863: AND nvl(rev_partially_impl_flag,'N')='N';
10864:
10865: END IF;

Line 10875: ,p_implemented_by => FND_GLOBAL.USER_ID

10871: l_impact_type_code := 'FINPLAN_' || l_version_type;
10872: pa_fp_ci_merge.FP_CI_UPDATE_IMPACT
10873: (p_ci_id => p_ci_id
10874: ,p_status_code => 'CI_IMPACT_IMPLEMENTED'
10875: ,p_implemented_by => FND_GLOBAL.USER_ID
10876: ,p_impact_type_code => l_impact_type_code
10877: ,p_commit_flag => 'N'
10878: ,p_init_msg_list => 'N'
10879: ,p_record_version_number => null

Line 11812: ,p_user_id => fnd_global.user_id

11808: pa_fin_plan_pvt.lock_unlock_version
11809: ( p_budget_version_id => p_budget_version_id_tbl(i)
11810: ,p_record_version_number => l_record_version_number
11811: ,p_action => 'L'
11812: ,p_user_id => fnd_global.user_id
11813: ,p_person_id => NULL
11814: ,x_return_status => x_return_status
11815: ,x_msg_count => x_msg_count
11816: ,x_msg_data => x_msg_data );

Line 12683: FND_GLOBAL.login_id,

12679: l_ci_plan_ver_id_tbl(i),
12680: 1, -- Bug 3877815: Review comment
12681: l_creation_date_tbl(i),
12682: l_created_by_tbl(i),
12683: FND_GLOBAL.login_id,
12684: FND_GLOBAL.user_id,
12685: SYSDATE,
12686: l_incl_method_code_tbl(i),
12687: l_incl_by_person_id_tbl(i),

Line 12684: FND_GLOBAL.user_id,

12680: 1, -- Bug 3877815: Review comment
12681: l_creation_date_tbl(i),
12682: l_created_by_tbl(i),
12683: FND_GLOBAL.login_id,
12684: FND_GLOBAL.user_id,
12685: SYSDATE,
12686: l_incl_method_code_tbl(i),
12687: l_incl_by_person_id_tbl(i),
12688: l_version_type_tbl(i),

Line 12731: FND_GLOBAL.user_id,

12727: l_ci_id_tbl(i),
12728: l_ci_plan_ver_id_tbl(i),
12729: 1,
12730: SYSDATE,
12731: FND_GLOBAL.user_id,
12732: FND_GLOBAL.login_id,
12733: FND_GLOBAL.user_id,
12734: SYSDATE,
12735: 'AUTOMATIC', -- Bug 3877815: Review comment

Line 12732: FND_GLOBAL.login_id,

12728: l_ci_plan_ver_id_tbl(i),
12729: 1,
12730: SYSDATE,
12731: FND_GLOBAL.user_id,
12732: FND_GLOBAL.login_id,
12733: FND_GLOBAL.user_id,
12734: SYSDATE,
12735: 'AUTOMATIC', -- Bug 3877815: Review comment
12736: l_incl_by_person_id_tbl(i),

Line 12733: FND_GLOBAL.user_id,

12729: 1,
12730: SYSDATE,
12731: FND_GLOBAL.user_id,
12732: FND_GLOBAL.login_id,
12733: FND_GLOBAL.user_id,
12734: SYSDATE,
12735: 'AUTOMATIC', -- Bug 3877815: Review comment
12736: l_incl_by_person_id_tbl(i),
12737: l_version_type_tbl(i),

Line 12799: last_update_login = FND_GLOBAL.login_id,

12795: impl_quantity = (Nvl(impl_quantity,0) + l_rev_ppl_quantity),
12796: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),
12797: impl_agr_revenue = (Nvl(l_implemented_amt,0) + Nvl(l_partial_impl_rev_amt,0)),
12798: record_version_number = (Nvl(record_version_number, 0) + 1),
12799: last_update_login = FND_GLOBAL.login_id,
12800: last_updated_by = FND_GLOBAL.user_id,
12801: last_update_date = SYSDATE
12802: WHERE project_id = l_project_id
12803: AND ci_id = p_ci_id

Line 12800: last_updated_by = FND_GLOBAL.user_id,

12796: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),
12797: impl_agr_revenue = (Nvl(l_implemented_amt,0) + Nvl(l_partial_impl_rev_amt,0)),
12798: record_version_number = (Nvl(record_version_number, 0) + 1),
12799: last_update_login = FND_GLOBAL.login_id,
12800: last_updated_by = FND_GLOBAL.user_id,
12801: last_update_date = SYSDATE
12802: WHERE project_id = l_project_id
12803: AND ci_id = p_ci_id
12804: AND plan_version_id = l_new_cw_version_id

Line 12815: last_update_login = FND_GLOBAL.login_id,

12811: impl_quantity = (Nvl(impl_quantity,0) + l_rev_ppl_quantity),
12812: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),
12813: impl_agr_revenue = (Nvl(l_implemented_amt,0) + Nvl(l_partial_impl_rev_amt,0)),
12814: record_version_number = (Nvl(record_version_number, 0) + 1),
12815: last_update_login = FND_GLOBAL.login_id,
12816: last_updated_by = FND_GLOBAL.user_id,
12817: last_update_date = SYSDATE
12818: WHERE project_id = l_project_id
12819: AND ci_id = p_ci_id

Line 12816: last_updated_by = FND_GLOBAL.user_id,

12812: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),
12813: impl_agr_revenue = (Nvl(l_implemented_amt,0) + Nvl(l_partial_impl_rev_amt,0)),
12814: record_version_number = (Nvl(record_version_number, 0) + 1),
12815: last_update_login = FND_GLOBAL.login_id,
12816: last_updated_by = FND_GLOBAL.user_id,
12817: last_update_date = SYSDATE
12818: WHERE project_id = l_project_id
12819: AND ci_id = p_ci_id
12820: AND plan_version_id = l_baseline_version_id

Line 12913: ,p_implemented_by => FND_GLOBAL.USER_ID

12909:
12910: pa_fp_ci_merge.FP_CI_UPDATE_IMPACT
12911: (p_ci_id => p_ci_id
12912: ,p_status_code => 'CI_IMPACT_IMPLEMENTED'
12913: ,p_implemented_by => FND_GLOBAL.USER_ID
12914: ,p_impact_type_code => 'FINPLAN_REVENUE'
12915: ,p_commit_flag => 'N'
12916: ,p_init_msg_list => 'N'
12917: ,p_record_version_number => null

Line 12953: ,last_update_login = fnd_global.login_id

12949: UPDATE pa_budget_versions
12950: SET rev_partially_impl_flag ='N'
12951: ,record_version_number = record_version_number+1
12952: ,last_update_date = sysdate
12953: ,last_update_login = fnd_global.login_id
12954: ,last_updated_by = fnd_global.user_id
12955: WHERE budget_version_id = p_ci_rev_version_id;
12956:
12957: IF l_debug_mode = 'Y' THEN

Line 12954: ,last_updated_by = fnd_global.user_id

12950: SET rev_partially_impl_flag ='N'
12951: ,record_version_number = record_version_number+1
12952: ,last_update_date = sysdate
12953: ,last_update_login = fnd_global.login_id
12954: ,last_updated_by = fnd_global.user_id
12955: WHERE budget_version_id = p_ci_rev_version_id;
12956:
12957: IF l_debug_mode = 'Y' THEN
12958: pa_debug.g_err_stage:='rev_impl_flag set to N ';

Line 12971: ,last_update_login = fnd_global.login_id

12967: UPDATE pa_budget_versions
12968: SET rev_partially_impl_flag ='Y'
12969: ,record_version_number = record_version_number+1
12970: ,last_update_date = sysdate
12971: ,last_update_login = fnd_global.login_id
12972: ,last_updated_by = fnd_global.user_id
12973: WHERE budget_version_id = p_ci_rev_version_id;
12974:
12975: IF l_debug_mode = 'Y' THEN

Line 12972: ,last_updated_by = fnd_global.user_id

12968: SET rev_partially_impl_flag ='Y'
12969: ,record_version_number = record_version_number+1
12970: ,last_update_date = sysdate
12971: ,last_update_login = fnd_global.login_id
12972: ,last_updated_by = fnd_global.user_id
12973: WHERE budget_version_id = p_ci_rev_version_id;
12974:
12975: IF l_debug_mode = 'Y' THEN
12976: pa_debug.g_err_stage:='rev_impl_flag set to Y ';