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 1980: ,fnd_global.user_id created_by

1976: ,pmc.ci_id ci_id
1977: ,pmc.ci_plan_version_id ci_plan_version_id
1978: ,1 record_version_number
1979: ,sysdate creation_date
1980: ,fnd_global.user_id created_by
1981: ,fnd_global.login_id last_update_login
1982: ,fnd_global.user_id last_updated_by
1983: ,sysdate last_update_date
1984: ,'COPIED' inclusion_method_code

Line 1981: ,fnd_global.login_id last_update_login

1977: ,pmc.ci_plan_version_id ci_plan_version_id
1978: ,1 record_version_number
1979: ,sysdate creation_date
1980: ,fnd_global.user_id created_by
1981: ,fnd_global.login_id last_update_login
1982: ,fnd_global.user_id last_updated_by
1983: ,sysdate last_update_date
1984: ,'COPIED' inclusion_method_code
1985: ,pmc.included_by_person_id included_by_person_id

Line 1982: ,fnd_global.user_id last_updated_by

1978: ,1 record_version_number
1979: ,sysdate creation_date
1980: ,fnd_global.user_id created_by
1981: ,fnd_global.login_id last_update_login
1982: ,fnd_global.user_id last_updated_by
1983: ,sysdate last_update_date
1984: ,'COPIED' inclusion_method_code
1985: ,pmc.included_by_person_id included_by_person_id
1986: ,pmc.version_type version_type

Line 2109: ,fnd_global.user_id

2105: ,pmc.ci_id
2106: ,pmc.ci_plan_version_id
2107: ,1
2108: ,sysdate
2109: ,fnd_global.user_id
2110: ,fnd_global.login_id
2111: ,fnd_global.user_id
2112: ,sysdate
2113: ,'COPIED'

Line 2110: ,fnd_global.login_id

2106: ,pmc.ci_plan_version_id
2107: ,1
2108: ,sysdate
2109: ,fnd_global.user_id
2110: ,fnd_global.login_id
2111: ,fnd_global.user_id
2112: ,sysdate
2113: ,'COPIED'
2114: ,pmc.included_by_person_id

Line 2111: ,fnd_global.user_id

2107: ,1
2108: ,sysdate
2109: ,fnd_global.user_id
2110: ,fnd_global.login_id
2111: ,fnd_global.user_id
2112: ,sysdate
2113: ,'COPIED'
2114: ,pmc.included_by_person_id
2115: ,pmc.version_type

Line 4026: , fnd_global.user_id

4022: , 'N'
4023: , 'N'
4024: , 'N'
4025: , sysdate
4026: , fnd_global.user_id
4027: , sysdate
4028: , fnd_global.user_id
4029: , fnd_global.login_id
4030: , NULL

Line 4028: , fnd_global.user_id

4024: , 'N'
4025: , sysdate
4026: , fnd_global.user_id
4027: , sysdate
4028: , fnd_global.user_id
4029: , fnd_global.login_id
4030: , NULL
4031: , NULL
4032: , NULL

Line 4029: , fnd_global.login_id

4025: , sysdate
4026: , fnd_global.user_id
4027: , sysdate
4028: , fnd_global.user_id
4029: , fnd_global.login_id
4030: , NULL
4031: , NULL
4032: , NULL
4033: , NULL);

Line 5350: ,fnd_global.user_id -- LAST_UPDATED_BY

5346: ,L_targ_task_id_tbl(kk) -- TASK_ID
5347: ,L_targ_rlm_id_tbl(kk) -- RESOURCE_LIST_MEMBER_ID
5348: ,L_TARG_CBS_ELEM_ID_TBL(kk) -- CBS_ELEMENT_ID --bug#16200605
5349: ,sysdate -- LAST_UPDATE_DATE
5350: ,fnd_global.user_id -- LAST_UPDATED_BY
5351: ,sysdate -- CREATION_DATE
5352: ,fnd_global.user_id -- CREATED_BY
5353: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5354: ,l_targ_unit_of_measure_tbl(kk) -- UNIT_OF_MEASURE

Line 5352: ,fnd_global.user_id -- CREATED_BY

5348: ,L_TARG_CBS_ELEM_ID_TBL(kk) -- CBS_ELEMENT_ID --bug#16200605
5349: ,sysdate -- LAST_UPDATE_DATE
5350: ,fnd_global.user_id -- LAST_UPDATED_BY
5351: ,sysdate -- CREATION_DATE
5352: ,fnd_global.user_id -- CREATED_BY
5353: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5354: ,l_targ_unit_of_measure_tbl(kk) -- UNIT_OF_MEASURE
5355: ,NULL -- TRACK_AS_LABOR_FLAG
5356: ,NULL -- STANDARD_BILL_RATE

Line 5353: ,fnd_global.login_id -- LAST_UPDATE_LOGIN

5349: ,sysdate -- LAST_UPDATE_DATE
5350: ,fnd_global.user_id -- LAST_UPDATED_BY
5351: ,sysdate -- CREATION_DATE
5352: ,fnd_global.user_id -- CREATED_BY
5353: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5354: ,l_targ_unit_of_measure_tbl(kk) -- UNIT_OF_MEASURE
5355: ,NULL -- TRACK_AS_LABOR_FLAG
5356: ,NULL -- STANDARD_BILL_RATE
5357: ,NULL -- AVERAGE_BILL_RATE

Line 5502: LAST_UPDATED_BY = fnd_global.user_id,

5498: FROM pa_budget_lines pbl
5499: WHERE pbl.resource_assignment_id = pra.resource_assignment_id),
5500: RATE_BASED_FLAG = l_targ_RATE_BASED_FLAG_tbl(kk), -- bug 4171006
5501: LAST_UPDATE_DATE = sysdate,
5502: LAST_UPDATED_BY = fnd_global.user_id,
5503: LAST_UPDATE_LOGIN = fnd_global.login_id,
5504: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
5505: WHERE l_ra_dml_code_tbl (kk)= 'UPDATE' -- Bug 3662136
5506: AND resource_assignment_id=l_targ_ra_id_tbl(kk)

Line 5503: LAST_UPDATE_LOGIN = fnd_global.login_id,

5499: WHERE pbl.resource_assignment_id = pra.resource_assignment_id),
5500: RATE_BASED_FLAG = l_targ_RATE_BASED_FLAG_tbl(kk), -- bug 4171006
5501: LAST_UPDATE_DATE = sysdate,
5502: LAST_UPDATED_BY = fnd_global.user_id,
5503: LAST_UPDATE_LOGIN = fnd_global.login_id,
5504: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
5505: WHERE l_ra_dml_code_tbl (kk)= 'UPDATE' -- Bug 3662136
5506: AND resource_assignment_id=l_targ_ra_id_tbl(kk)
5507: RETURNING

Line 5530: LAST_UPDATED_BY = fnd_global.user_id,

5526: UNIT_OF_MEASURE = l_targ_unit_of_measure_tbl(kk), -- bug 4171006
5527: TRANSACTION_SOURCE_CODE = null,
5528: RATE_BASED_FLAG = l_targ_RATE_BASED_FLAG_tbl(kk), -- bug 4171006
5529: LAST_UPDATE_DATE = sysdate,
5530: LAST_UPDATED_BY = fnd_global.user_id,
5531: LAST_UPDATE_LOGIN = fnd_global.login_id,
5532: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
5533: WHERE l_ra_dml_code_tbl (kk)= 'UPDATE' -- Bug 3662136
5534: AND resource_assignment_id=l_targ_ra_id_tbl(kk)

Line 5531: LAST_UPDATE_LOGIN = fnd_global.login_id,

5527: TRANSACTION_SOURCE_CODE = null,
5528: RATE_BASED_FLAG = l_targ_RATE_BASED_FLAG_tbl(kk), -- bug 4171006
5529: LAST_UPDATE_DATE = sysdate,
5530: LAST_UPDATED_BY = fnd_global.user_id,
5531: LAST_UPDATE_LOGIN = fnd_global.login_id,
5532: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
5533: WHERE l_ra_dml_code_tbl (kk)= 'UPDATE' -- Bug 3662136
5534: AND resource_assignment_id=l_targ_ra_id_tbl(kk)
5535: RETURNING

Line 6180: fnd_global.user_id last_updated_by,

6176: FROM
6177: --The entire SELECT is moved to the sub query in FROM clause as nextval would not work with group by
6178: (SELECT get_mapped_ra_id(get_task_id(l_targ_plan_level_code,pras.task_id), pras.resource_list_member_id) resource_assignment_id,
6179: sysdate last_update_date,
6180: fnd_global.user_id last_updated_by,
6181: sysdate creation_date,
6182: fnd_global.user_id created_by,
6183: fnd_global.login_id last_update_login,
6184: NULL period_name,

Line 6182: fnd_global.user_id created_by,

6178: (SELECT get_mapped_ra_id(get_task_id(l_targ_plan_level_code,pras.task_id), pras.resource_list_member_id) resource_assignment_id,
6179: sysdate last_update_date,
6180: fnd_global.user_id last_updated_by,
6181: sysdate creation_date,
6182: fnd_global.user_id created_by,
6183: fnd_global.login_id last_update_login,
6184: NULL period_name,
6185: decode(l_cost_impl_flag,
6186: 'Y',sum(pbls.quantity),

Line 6183: fnd_global.login_id last_update_login,

6179: sysdate last_update_date,
6180: fnd_global.user_id last_updated_by,
6181: sysdate creation_date,
6182: fnd_global.user_id created_by,
6183: fnd_global.login_id last_update_login,
6184: NULL period_name,
6185: decode(l_cost_impl_flag,
6186: 'Y',sum(pbls.quantity),
6187: decode(l_rev_impl_flag,

Line 6586: fnd_global.user_id last_updated_by,

6582: FROM
6583: --The entier SELECT is moved to the sub query in FROM clause as nextval would not work with group by
6584: (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,
6585: sysdate last_update_date,
6586: fnd_global.user_id last_updated_by,
6587: sysdate creation_date,
6588: fnd_global.user_id created_by,
6589: fnd_global.login_id last_update_login,
6590: NULL period_name,

Line 6588: fnd_global.user_id created_by,

6584: (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,
6585: sysdate last_update_date,
6586: fnd_global.user_id last_updated_by,
6587: sysdate creation_date,
6588: fnd_global.user_id created_by,
6589: fnd_global.login_id last_update_login,
6590: NULL period_name,
6591: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',
6592: decode(l_impl_qty_tbl(j),'Y', sum(pbls.quantity) * l_partial_factor,null),null)) quantity,

Line 6589: fnd_global.login_id last_update_login,

6585: sysdate last_update_date,
6586: fnd_global.user_id last_updated_by,
6587: sysdate creation_date,
6588: fnd_global.user_id created_by,
6589: fnd_global.login_id last_update_login,
6590: NULL period_name,
6591: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',
6592: decode(l_impl_qty_tbl(j),'Y', sum(pbls.quantity) * l_partial_factor,null),null)) quantity,
6593: sum(Decode(l_cost_impl_flag ,'Y', pbls.raw_cost,null)) raw_cost,

Line 6992: fnd_global.user_id last_updated_by,

6988: pbl.pfc_cur_conv_rejection_code
6989: 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,
6990: pbls.start_date start_date,
6991: sysdate last_update_date,
6992: fnd_global.user_id last_updated_by,
6993: sysdate creation_date,
6994: fnd_global.user_id created_by,
6995: fnd_global.login_id last_update_login,
6996: pbls.end_date end_date,

Line 6994: fnd_global.user_id created_by,

6990: pbls.start_date start_date,
6991: sysdate last_update_date,
6992: fnd_global.user_id last_updated_by,
6993: sysdate creation_date,
6994: fnd_global.user_id created_by,
6995: fnd_global.login_id last_update_login,
6996: pbls.end_date end_date,
6997: pbls.period_name period_name,
6998: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',

Line 6995: fnd_global.login_id last_update_login,

6991: sysdate last_update_date,
6992: fnd_global.user_id last_updated_by,
6993: sysdate creation_date,
6994: fnd_global.user_id created_by,
6995: fnd_global.login_id last_update_login,
6996: pbls.end_date end_date,
6997: pbls.period_name period_name,
6998: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',
6999: decode(l_impl_qty_tbl(j),'Y', sum(pbls.quantity) * l_partial_factor,null),null)) quantity,

Line 7398: fnd_global.user_id last_updated_by,

7394: pbl.pfc_cur_conv_rejection_code
7395: 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,
7396: pbls.start_date start_date,
7397: sysdate last_update_date,
7398: fnd_global.user_id last_updated_by,
7399: sysdate creation_date,
7400: fnd_global.user_id created_by,
7401: fnd_global.login_id last_update_login,
7402: pbls.end_date end_date,

Line 7400: fnd_global.user_id created_by,

7396: pbls.start_date start_date,
7397: sysdate last_update_date,
7398: fnd_global.user_id last_updated_by,
7399: sysdate creation_date,
7400: fnd_global.user_id created_by,
7401: fnd_global.login_id last_update_login,
7402: pbls.end_date end_date,
7403: pbls.period_name period_name,
7404: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',

Line 7401: fnd_global.login_id last_update_login,

7397: sysdate last_update_date,
7398: fnd_global.user_id last_updated_by,
7399: sysdate creation_date,
7400: fnd_global.user_id created_by,
7401: fnd_global.login_id last_update_login,
7402: pbls.end_date end_date,
7403: pbls.period_name period_name,
7404: decode(l_cost_impl_flag,'Y',sum(pbls.quantity),decode(l_rev_impl_flag,'Y',
7405: decode(l_impl_qty_tbl(j),'Y', sum(pbls.quantity) * l_partial_factor,null),null)) quantity,

Line 8959: fnd_global.user_id,

8955: )
8956: SELECT l_bl_RESOURCE_ASIGNMENT_ID_tbl(kk),
8957: l_bl_START_DATE_tbl(kk),
8958: sysdate,
8959: fnd_global.user_id,
8960: sysdate,
8961: fnd_global.user_id,
8962: fnd_global.login_id,
8963: l_bl_END_DATE_tbl(kk),

Line 8961: fnd_global.user_id,

8957: l_bl_START_DATE_tbl(kk),
8958: sysdate,
8959: fnd_global.user_id,
8960: sysdate,
8961: fnd_global.user_id,
8962: fnd_global.login_id,
8963: l_bl_END_DATE_tbl(kk),
8964: l_bl_PERIOD_NAME_tbl(kk),
8965: Decode(l_bl_rbf_flag_tbl(kk),

Line 8962: fnd_global.login_id,

8958: sysdate,
8959: fnd_global.user_id,
8960: sysdate,
8961: fnd_global.user_id,
8962: fnd_global.login_id,
8963: l_bl_END_DATE_tbl(kk),
8964: l_bl_PERIOD_NAME_tbl(kk),
8965: Decode(l_bl_rbf_flag_tbl(kk),
8966: 'N',Decode(l_target_version_type,

Line 9094: LAST_UPDATED_BY=fnd_global.user_id,

9090: --Fix for bug 3734888. Null handled the pl/sql tbls while updating.
9091: FORALL kk in 1..l_upd_ra_bl_dml_code_tbl.count
9092: UPDATE PA_BUDGET_LINES
9093: SET LAST_UPDATE_DATE=sysdate,
9094: LAST_UPDATED_BY=fnd_global.user_id,
9095: LAST_UPDATE_LOGIN=fnd_global.login_id,
9096: QUANTITY= DECODE(l_bl_rbf_flag_tbl(kk),
9097: 'N',DECODE(l_target_version_type,
9098: 'REVENUE',nvl(TXN_REVENUE,0)+ nvl(l_bl_TXN_REVENUE_tbl(kk),0)

Line 9095: LAST_UPDATE_LOGIN=fnd_global.login_id,

9091: FORALL kk in 1..l_upd_ra_bl_dml_code_tbl.count
9092: UPDATE PA_BUDGET_LINES
9093: SET LAST_UPDATE_DATE=sysdate,
9094: LAST_UPDATED_BY=fnd_global.user_id,
9095: LAST_UPDATE_LOGIN=fnd_global.login_id,
9096: QUANTITY= DECODE(l_bl_rbf_flag_tbl(kk),
9097: 'N',DECODE(l_target_version_type,
9098: 'REVENUE',nvl(TXN_REVENUE,0)+ nvl(l_bl_TXN_REVENUE_tbl(kk),0)
9099: ,nvl(TXN_RAW_COST,0) + nvl(l_bl_TXN_RAW_COST_tbl(kk),0)),

Line 10231: ,last_update_login =fnd_global.login_id

10227: ,impl_equipment_quantity =nvl(impl_equipment_quantity,0)+nvl(l_rev_equip_qty,0)
10228: ,impl_agr_revenue =nvl(impl_agr_revenue,0) + nvl(l_partial_impl_rev_amt,0)
10229: ,record_version_number =record_version_number+1
10230: ,last_update_date =sysdate
10231: ,last_update_login =fnd_global.login_id
10232: ,last_updated_by =fnd_global.user_id
10233: WHERE project_id=l_project_id
10234: AND plan_version_id=p_budget_version_id
10235: AND ci_id=p_ci_id

Line 10232: ,last_updated_by =fnd_global.user_id

10228: ,impl_agr_revenue =nvl(impl_agr_revenue,0) + nvl(l_partial_impl_rev_amt,0)
10229: ,record_version_number =record_version_number+1
10230: ,last_update_date =sysdate
10231: ,last_update_login =fnd_global.login_id
10232: ,last_updated_by =fnd_global.user_id
10233: WHERE project_id=l_project_id
10234: AND plan_version_id=p_budget_version_id
10235: AND ci_id=p_ci_id
10236: AND ci_plan_version_id=l_src_ver_id_tbl(j)

Line 10255: ,last_update_login =fnd_global.login_id

10251: UPDATE pa_budget_versions
10252: SET rev_partially_impl_flag ='N'
10253: ,record_version_number =record_version_number+1
10254: ,last_update_date =sysdate
10255: ,last_update_login =fnd_global.login_id
10256: ,last_updated_by =fnd_global.user_id
10257: WHERE budget_version_id = l_src_ver_id_tbl(j);
10258:
10259: ELSE

Line 10256: ,last_updated_by =fnd_global.user_id

10252: SET rev_partially_impl_flag ='N'
10253: ,record_version_number =record_version_number+1
10254: ,last_update_date =sysdate
10255: ,last_update_login =fnd_global.login_id
10256: ,last_updated_by =fnd_global.user_id
10257: WHERE budget_version_id = l_src_ver_id_tbl(j);
10258:
10259: ELSE
10260:

Line 10266: ,last_update_login =fnd_global.login_id

10262: UPDATE pa_budget_versions
10263: SET rev_partially_impl_flag ='Y'
10264: ,record_version_number =record_version_number+1
10265: ,last_update_date =sysdate
10266: ,last_update_login =fnd_global.login_id
10267: ,last_updated_by =fnd_global.user_id
10268: WHERE budget_version_id = l_src_ver_id_tbl(j)
10269: AND nvl(rev_partially_impl_flag,'N')='N';
10270:

Line 10267: ,last_updated_by =fnd_global.user_id

10263: SET rev_partially_impl_flag ='Y'
10264: ,record_version_number =record_version_number+1
10265: ,last_update_date =sysdate
10266: ,last_update_login =fnd_global.login_id
10267: ,last_updated_by =fnd_global.user_id
10268: WHERE budget_version_id = l_src_ver_id_tbl(j)
10269: AND nvl(rev_partially_impl_flag,'N')='N';
10270:
10271: END IF;

Line 10281: ,p_implemented_by => FND_GLOBAL.USER_ID

10277: l_impact_type_code := 'FINPLAN_' || l_version_type;
10278: pa_fp_ci_merge.FP_CI_UPDATE_IMPACT
10279: (p_ci_id => p_ci_id
10280: ,p_status_code => 'CI_IMPACT_IMPLEMENTED'
10281: ,p_implemented_by => FND_GLOBAL.USER_ID
10282: ,p_impact_type_code => l_impact_type_code
10283: ,p_commit_flag => 'N'
10284: ,p_init_msg_list => 'N'
10285: ,p_record_version_number => null

Line 11249: ,p_user_id => fnd_global.user_id

11245: pa_fin_plan_pvt.lock_unlock_version
11246: ( p_budget_version_id => p_budget_version_id_tbl(i)
11247: ,p_record_version_number => l_record_version_number
11248: ,p_action => 'L'
11249: ,p_user_id => fnd_global.user_id
11250: ,p_person_id => NULL
11251: ,x_return_status => x_return_status
11252: ,x_msg_count => x_msg_count
11253: ,x_msg_data => x_msg_data );

Line 12159: FND_GLOBAL.login_id,

12155: l_ci_plan_ver_id_tbl(i),
12156: 1, -- Bug 3877815: Review comment
12157: l_creation_date_tbl(i),
12158: l_created_by_tbl(i),
12159: FND_GLOBAL.login_id,
12160: FND_GLOBAL.user_id,
12161: SYSDATE,
12162: l_incl_method_code_tbl(i),
12163: l_incl_by_person_id_tbl(i),

Line 12160: FND_GLOBAL.user_id,

12156: 1, -- Bug 3877815: Review comment
12157: l_creation_date_tbl(i),
12158: l_created_by_tbl(i),
12159: FND_GLOBAL.login_id,
12160: FND_GLOBAL.user_id,
12161: SYSDATE,
12162: l_incl_method_code_tbl(i),
12163: l_incl_by_person_id_tbl(i),
12164: l_version_type_tbl(i),

Line 12207: FND_GLOBAL.user_id,

12203: l_ci_id_tbl(i),
12204: l_ci_plan_ver_id_tbl(i),
12205: 1,
12206: SYSDATE,
12207: FND_GLOBAL.user_id,
12208: FND_GLOBAL.login_id,
12209: FND_GLOBAL.user_id,
12210: SYSDATE,
12211: 'AUTOMATIC', -- Bug 3877815: Review comment

Line 12208: FND_GLOBAL.login_id,

12204: l_ci_plan_ver_id_tbl(i),
12205: 1,
12206: SYSDATE,
12207: FND_GLOBAL.user_id,
12208: FND_GLOBAL.login_id,
12209: FND_GLOBAL.user_id,
12210: SYSDATE,
12211: 'AUTOMATIC', -- Bug 3877815: Review comment
12212: l_incl_by_person_id_tbl(i),

Line 12209: FND_GLOBAL.user_id,

12205: 1,
12206: SYSDATE,
12207: FND_GLOBAL.user_id,
12208: FND_GLOBAL.login_id,
12209: FND_GLOBAL.user_id,
12210: SYSDATE,
12211: 'AUTOMATIC', -- Bug 3877815: Review comment
12212: l_incl_by_person_id_tbl(i),
12213: l_version_type_tbl(i),

Line 12275: last_update_login = FND_GLOBAL.login_id,

12271: impl_quantity = (Nvl(impl_quantity,0) + l_rev_ppl_quantity),
12272: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),
12273: impl_agr_revenue = (Nvl(l_implemented_amt,0) + Nvl(l_partial_impl_rev_amt,0)),
12274: record_version_number = (Nvl(record_version_number, 0) + 1),
12275: last_update_login = FND_GLOBAL.login_id,
12276: last_updated_by = FND_GLOBAL.user_id,
12277: last_update_date = SYSDATE
12278: WHERE project_id = l_project_id
12279: AND ci_id = p_ci_id

Line 12276: last_updated_by = FND_GLOBAL.user_id,

12272: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),
12273: impl_agr_revenue = (Nvl(l_implemented_amt,0) + Nvl(l_partial_impl_rev_amt,0)),
12274: record_version_number = (Nvl(record_version_number, 0) + 1),
12275: last_update_login = FND_GLOBAL.login_id,
12276: last_updated_by = FND_GLOBAL.user_id,
12277: last_update_date = SYSDATE
12278: WHERE project_id = l_project_id
12279: AND ci_id = p_ci_id
12280: AND plan_version_id = l_new_cw_version_id

Line 12291: last_update_login = FND_GLOBAL.login_id,

12287: impl_quantity = (Nvl(impl_quantity,0) + l_rev_ppl_quantity),
12288: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),
12289: impl_agr_revenue = (Nvl(l_implemented_amt,0) + Nvl(l_partial_impl_rev_amt,0)),
12290: record_version_number = (Nvl(record_version_number, 0) + 1),
12291: last_update_login = FND_GLOBAL.login_id,
12292: last_updated_by = FND_GLOBAL.user_id,
12293: last_update_date = SYSDATE
12294: WHERE project_id = l_project_id
12295: AND ci_id = p_ci_id

Line 12292: last_updated_by = FND_GLOBAL.user_id,

12288: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),
12289: impl_agr_revenue = (Nvl(l_implemented_amt,0) + Nvl(l_partial_impl_rev_amt,0)),
12290: record_version_number = (Nvl(record_version_number, 0) + 1),
12291: last_update_login = FND_GLOBAL.login_id,
12292: last_updated_by = FND_GLOBAL.user_id,
12293: last_update_date = SYSDATE
12294: WHERE project_id = l_project_id
12295: AND ci_id = p_ci_id
12296: AND plan_version_id = l_baseline_version_id

Line 12389: ,p_implemented_by => FND_GLOBAL.USER_ID

12385:
12386: pa_fp_ci_merge.FP_CI_UPDATE_IMPACT
12387: (p_ci_id => p_ci_id
12388: ,p_status_code => 'CI_IMPACT_IMPLEMENTED'
12389: ,p_implemented_by => FND_GLOBAL.USER_ID
12390: ,p_impact_type_code => 'FINPLAN_REVENUE'
12391: ,p_commit_flag => 'N'
12392: ,p_init_msg_list => 'N'
12393: ,p_record_version_number => null

Line 12429: ,last_update_login = fnd_global.login_id

12425: UPDATE pa_budget_versions
12426: SET rev_partially_impl_flag ='N'
12427: ,record_version_number = record_version_number+1
12428: ,last_update_date = sysdate
12429: ,last_update_login = fnd_global.login_id
12430: ,last_updated_by = fnd_global.user_id
12431: WHERE budget_version_id = p_ci_rev_version_id;
12432:
12433: IF l_debug_mode = 'Y' THEN

Line 12430: ,last_updated_by = fnd_global.user_id

12426: SET rev_partially_impl_flag ='N'
12427: ,record_version_number = record_version_number+1
12428: ,last_update_date = sysdate
12429: ,last_update_login = fnd_global.login_id
12430: ,last_updated_by = fnd_global.user_id
12431: WHERE budget_version_id = p_ci_rev_version_id;
12432:
12433: IF l_debug_mode = 'Y' THEN
12434: pa_debug.g_err_stage:='rev_impl_flag set to N ';

Line 12447: ,last_update_login = fnd_global.login_id

12443: UPDATE pa_budget_versions
12444: SET rev_partially_impl_flag ='Y'
12445: ,record_version_number = record_version_number+1
12446: ,last_update_date = sysdate
12447: ,last_update_login = fnd_global.login_id
12448: ,last_updated_by = fnd_global.user_id
12449: WHERE budget_version_id = p_ci_rev_version_id;
12450:
12451: IF l_debug_mode = 'Y' THEN

Line 12448: ,last_updated_by = fnd_global.user_id

12444: SET rev_partially_impl_flag ='Y'
12445: ,record_version_number = record_version_number+1
12446: ,last_update_date = sysdate
12447: ,last_update_login = fnd_global.login_id
12448: ,last_updated_by = fnd_global.user_id
12449: WHERE budget_version_id = p_ci_rev_version_id;
12450:
12451: IF l_debug_mode = 'Y' THEN
12452: pa_debug.g_err_stage:='rev_impl_flag set to Y ';

Line 12634: PA_MOAC_UTILS.SET_POLICY_CONTEXT('S',fnd_global.org_id);

12630:
12631: -- Bug#13960733 start.
12632: l_context_mode := mo_global.get_access_mode;
12633: if l_context_mode = 'M' then
12634: PA_MOAC_UTILS.SET_POLICY_CONTEXT('S',fnd_global.org_id);
12635: end if;
12636: -- Bug#13960733 end.
12637:
12638: --dbms_output.put_line('M1');

Line 13482: ,p_CREATED_BY => FND_GLOBAL.login_id

13478: ,p_CURRENCY_CODE => supp_from_tbl(i).CURRENCY_CODE
13479: ,p_CHANGE_AMOUNT => supp_from_tbl(i).CHANGE_AMOUNT
13480: ,p_CHANGE_TYPE => supp_from_tbl(i).CHANGE_TYPE
13481: ,p_CHANGE_DESCRIPTION => supp_from_tbl(i).CHANGE_DESCRIPTION
13482: ,p_CREATED_BY => FND_GLOBAL.login_id
13483: ,p_CREATION_DATE => trunc(sysdate)
13484: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
13485: ,p_LAST_UPDATE_DATE => trunc(sysdate)
13486: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

Line 13484: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

13480: ,p_CHANGE_TYPE => supp_from_tbl(i).CHANGE_TYPE
13481: ,p_CHANGE_DESCRIPTION => supp_from_tbl(i).CHANGE_DESCRIPTION
13482: ,p_CREATED_BY => FND_GLOBAL.login_id
13483: ,p_CREATION_DATE => trunc(sysdate)
13484: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
13485: ,p_LAST_UPDATE_DATE => trunc(sysdate)
13486: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
13487: ,p_Task_Id => supp_from_tbl(i).Task_Id
13488: ,p_Resource_List_Mem_Id => supp_from_tbl(i).Resource_List_Member_Id

Line 13486: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

13482: ,p_CREATED_BY => FND_GLOBAL.login_id
13483: ,p_CREATION_DATE => trunc(sysdate)
13484: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
13485: ,p_LAST_UPDATE_DATE => trunc(sysdate)
13486: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
13487: ,p_Task_Id => supp_from_tbl(i).Task_Id
13488: ,p_Resource_List_Mem_Id => supp_from_tbl(i).Resource_List_Member_Id
13489: ,p_From_Date => supp_from_tbl(i).FROM_CHANGE_DATE
13490: ,p_To_Date => supp_from_tbl(i).TO_CHANGE_DATE

Line 13546: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

13542: ,p_CURRENCY_CODE => supp_to_tbl(l_rec_index).currency_code
13543: ,p_CHANGE_AMOUNT => supp_to_tbl(l_rec_index).change_amount
13544: ,p_CHANGE_TYPE => supp_to_tbl(l_rec_index).change_type
13545: ,p_CHANGE_DESCRIPTION => supp_to_tbl(l_rec_index).change_description
13546: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
13547: ,p_LAST_UPDATE_DATE => trunc(sysdate)
13548: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
13549: ,p_Task_Id => supp_to_tbl(l_rec_index).task_id
13550: ,p_Resource_List_Mem_Id => supp_to_tbl(l_rec_index).resource_list_member_id

Line 13548: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

13544: ,p_CHANGE_TYPE => supp_to_tbl(l_rec_index).change_type
13545: ,p_CHANGE_DESCRIPTION => supp_to_tbl(l_rec_index).change_description
13546: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
13547: ,p_LAST_UPDATE_DATE => trunc(sysdate)
13548: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
13549: ,p_Task_Id => supp_to_tbl(l_rec_index).task_id
13550: ,p_Resource_List_Mem_Id => supp_to_tbl(l_rec_index).resource_list_member_id
13551: ,p_From_Date => supp_to_tbl(l_rec_index).from_change_date
13552: ,p_To_Date => supp_to_tbl(l_rec_index).to_change_date

Line 13938: i_PaCiDirCostDetTbl(ins_index).created_by := FND_GLOBAL.USER_ID;

13934: i_PaCiDirCostDetTbl(ins_index).change_description := NULL;
13935: end if;
13936:
13937: i_PaCiDirCostDetTbl(ins_index).creation_date := sysdate;
13938: i_PaCiDirCostDetTbl(ins_index).created_by := FND_GLOBAL.USER_ID;
13939: i_PaCiDirCostDetTbl(ins_index).last_update_date := sysdate;
13940: i_PaCiDirCostDetTbl(ins_index).last_update_by := FND_GLOBAL.USER_ID;
13941: i_PaCiDirCostDetTbl(ins_index).last_update_login := FND_GLOBAL.LOGIN_ID;
13942: end if;

Line 13940: i_PaCiDirCostDetTbl(ins_index).last_update_by := FND_GLOBAL.USER_ID;

13936:
13937: i_PaCiDirCostDetTbl(ins_index).creation_date := sysdate;
13938: i_PaCiDirCostDetTbl(ins_index).created_by := FND_GLOBAL.USER_ID;
13939: i_PaCiDirCostDetTbl(ins_index).last_update_date := sysdate;
13940: i_PaCiDirCostDetTbl(ins_index).last_update_by := FND_GLOBAL.USER_ID;
13941: i_PaCiDirCostDetTbl(ins_index).last_update_login := FND_GLOBAL.LOGIN_ID;
13942: end if;
13943: end loop;
13944:

Line 13941: i_PaCiDirCostDetTbl(ins_index).last_update_login := FND_GLOBAL.LOGIN_ID;

13937: i_PaCiDirCostDetTbl(ins_index).creation_date := sysdate;
13938: i_PaCiDirCostDetTbl(ins_index).created_by := FND_GLOBAL.USER_ID;
13939: i_PaCiDirCostDetTbl(ins_index).last_update_date := sysdate;
13940: i_PaCiDirCostDetTbl(ins_index).last_update_by := FND_GLOBAL.USER_ID;
13941: i_PaCiDirCostDetTbl(ins_index).last_update_login := FND_GLOBAL.LOGIN_ID;
13942: end if;
13943: end loop;
13944:
13945: if ins_index > 0 then