DBA Data[Home] [Help]

APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on FND_GLOBAL

Line 431: l_last_updated_by := FND_GLOBAL.USER_ID;

427:
428: -- API body
429:
430: l_last_update_date := sysdate;
431: l_last_updated_by := FND_GLOBAL.USER_ID;
432: l_last_update_login := FND_GLOBAL.LOGIN_ID;
433: l_creation_date := sysdate;
434: l_created_by := FND_GLOBAL.USER_ID;
435:

Line 432: l_last_update_login := FND_GLOBAL.LOGIN_ID;

428: -- API body
429:
430: l_last_update_date := sysdate;
431: l_last_updated_by := FND_GLOBAL.USER_ID;
432: l_last_update_login := FND_GLOBAL.LOGIN_ID;
433: l_creation_date := sysdate;
434: l_created_by := FND_GLOBAL.USER_ID;
435:
436:

Line 434: l_created_by := FND_GLOBAL.USER_ID;

430: l_last_update_date := sysdate;
431: l_last_updated_by := FND_GLOBAL.USER_ID;
432: l_last_update_login := FND_GLOBAL.LOGIN_ID;
433: l_creation_date := sysdate;
434: l_created_by := FND_GLOBAL.USER_ID;
435:
436:
437: Check_Reentry
438: (p_api_version => 1.0 ,

Line 1148: l_last_updated_by := FND_GLOBAL.USER_ID;

1144: end if;
1145: p_return_status := FND_API.G_RET_STS_SUCCESS;
1146:
1147: l_last_update_date := sysdate;
1148: l_last_updated_by := FND_GLOBAL.USER_ID;
1149: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1150: l_creation_date := sysdate;
1151: l_created_by := FND_GLOBAL.USER_ID;
1152:

Line 1149: l_last_update_login := FND_GLOBAL.LOGIN_ID;

1145: p_return_status := FND_API.G_RET_STS_SUCCESS;
1146:
1147: l_last_update_date := sysdate;
1148: l_last_updated_by := FND_GLOBAL.USER_ID;
1149: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1150: l_creation_date := sysdate;
1151: l_created_by := FND_GLOBAL.USER_ID;
1152:
1153: Check_Reentry

Line 1151: l_created_by := FND_GLOBAL.USER_ID;

1147: l_last_update_date := sysdate;
1148: l_last_updated_by := FND_GLOBAL.USER_ID;
1149: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1150: l_creation_date := sysdate;
1151: l_created_by := FND_GLOBAL.USER_ID;
1152:
1153: Check_Reentry
1154: (p_api_version => 1.0 ,
1155: p_return_status => l_return_status,

Line 1868: l_last_updated_by := FND_GLOBAL.USER_ID;

1864:
1865: -- API body
1866:
1867: l_last_update_date := sysdate;
1868: l_last_updated_by := FND_GLOBAL.USER_ID;
1869: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
1870: l_creation_date := sysdate;
1871: l_created_by := FND_GLOBAL.USER_ID;
1872:

Line 1869: l_last_update_login :=FND_GLOBAL.LOGIN_ID;

1865: -- API body
1866:
1867: l_last_update_date := sysdate;
1868: l_last_updated_by := FND_GLOBAL.USER_ID;
1869: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
1870: l_creation_date := sysdate;
1871: l_created_by := FND_GLOBAL.USER_ID;
1872:
1873: Check_Reentry

Line 1871: l_created_by := FND_GLOBAL.USER_ID;

1867: l_last_update_date := sysdate;
1868: l_last_updated_by := FND_GLOBAL.USER_ID;
1869: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
1870: l_creation_date := sysdate;
1871: l_created_by := FND_GLOBAL.USER_ID;
1872:
1873: Check_Reentry
1874: (p_api_version => 1.0 ,
1875: p_return_status => l_return_status,

Line 2504: l_last_updated_by := FND_GLOBAL.USER_ID;

2500: l_yes_flag := 'Y';
2501: /* End bug #4924031 */
2502:
2503: l_last_update_date := sysdate;
2504: l_last_updated_by := FND_GLOBAL.USER_ID;
2505: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
2506: l_creation_date := sysdate;
2507: l_created_by := FND_GLOBAL.USER_ID;
2508:

Line 2505: l_last_update_login :=FND_GLOBAL.LOGIN_ID;

2501: /* End bug #4924031 */
2502:
2503: l_last_update_date := sysdate;
2504: l_last_updated_by := FND_GLOBAL.USER_ID;
2505: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
2506: l_creation_date := sysdate;
2507: l_created_by := FND_GLOBAL.USER_ID;
2508:
2509: Check_Reentry

Line 2507: l_created_by := FND_GLOBAL.USER_ID;

2503: l_last_update_date := sysdate;
2504: l_last_updated_by := FND_GLOBAL.USER_ID;
2505: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
2506: l_creation_date := sysdate;
2507: l_created_by := FND_GLOBAL.USER_ID;
2508:
2509: Check_Reentry
2510: (p_api_version => 1.0 ,
2511: p_return_status => l_return_status,

Line 2893: l_last_updated_by := FND_GLOBAL.USER_ID;

2889: p_return_status := FND_API.G_RET_STS_SUCCESS;
2890:
2891: -- API body
2892: l_last_update_date := sysdate;
2893: l_last_updated_by := FND_GLOBAL.USER_ID;
2894: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
2895: l_creation_date := sysdate;
2896: l_created_by := FND_GLOBAL.USER_ID;
2897:

Line 2894: l_last_update_login :=FND_GLOBAL.LOGIN_ID;

2890:
2891: -- API body
2892: l_last_update_date := sysdate;
2893: l_last_updated_by := FND_GLOBAL.USER_ID;
2894: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
2895: l_creation_date := sysdate;
2896: l_created_by := FND_GLOBAL.USER_ID;
2897:
2898: -- To obtain the element_type_id associated to the assignment

Line 2896: l_created_by := FND_GLOBAL.USER_ID;

2892: l_last_update_date := sysdate;
2893: l_last_updated_by := FND_GLOBAL.USER_ID;
2894: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
2895: l_creation_date := sysdate;
2896: l_created_by := FND_GLOBAL.USER_ID;
2897:
2898: -- To obtain the element_type_id associated to the assignment
2899:
2900: For C_Element_Type_Rec in C_Element_Type

Line 3258: l_last_updated_by := FND_GLOBAL.USER_ID;

3254:
3255: begin
3256:
3257: l_last_update_date := sysdate;
3258: l_last_updated_by := FND_GLOBAL.USER_ID;
3259: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
3260: l_creation_date := sysdate;
3261: l_created_by := FND_GLOBAL.USER_ID;
3262:

Line 3259: l_last_update_login :=FND_GLOBAL.LOGIN_ID;

3255: begin
3256:
3257: l_last_update_date := sysdate;
3258: l_last_updated_by := FND_GLOBAL.USER_ID;
3259: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
3260: l_creation_date := sysdate;
3261: l_created_by := FND_GLOBAL.USER_ID;
3262:
3263: l_percent := p_proportion*100;

Line 3261: l_created_by := FND_GLOBAL.USER_ID;

3257: l_last_update_date := sysdate;
3258: l_last_updated_by := FND_GLOBAL.USER_ID;
3259: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
3260: l_creation_date := sysdate;
3261: l_created_by := FND_GLOBAL.USER_ID;
3262:
3263: l_percent := p_proportion*100;
3264: l_segment1 := null;
3265: l_segment2 := null;

Line 3675: l_last_updated_by := FND_GLOBAL.USER_ID;

3671:
3672: -- API body
3673:
3674: l_last_update_date := sysdate;
3675: l_last_updated_by := FND_GLOBAL.USER_ID;
3676: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
3677: l_creation_date := sysdate;
3678: l_created_by := FND_GLOBAL.USER_ID;
3679:

Line 3676: l_last_update_login :=FND_GLOBAL.LOGIN_ID;

3672: -- API body
3673:
3674: l_last_update_date := sysdate;
3675: l_last_updated_by := FND_GLOBAL.USER_ID;
3676: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
3677: l_creation_date := sysdate;
3678: l_created_by := FND_GLOBAL.USER_ID;
3679:
3680: Check_Reentry

Line 3678: l_created_by := FND_GLOBAL.USER_ID;

3674: l_last_update_date := sysdate;
3675: l_last_updated_by := FND_GLOBAL.USER_ID;
3676: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
3677: l_creation_date := sysdate;
3678: l_created_by := FND_GLOBAL.USER_ID;
3679:
3680: Check_Reentry
3681: (p_api_version => 1.0 ,
3682: p_return_status => l_return_status,

Line 4746: l_last_updated_by := FND_GLOBAL.USER_ID;

4742:
4743: -- API body
4744:
4745: l_last_update_date := sysdate;
4746: l_last_updated_by := FND_GLOBAL.USER_ID;
4747: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
4748: l_creation_date := sysdate;
4749: l_created_by := FND_GLOBAL.USER_ID;
4750:

Line 4747: l_last_update_login :=FND_GLOBAL.LOGIN_ID;

4743: -- API body
4744:
4745: l_last_update_date := sysdate;
4746: l_last_updated_by := FND_GLOBAL.USER_ID;
4747: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
4748: l_creation_date := sysdate;
4749: l_created_by := FND_GLOBAL.USER_ID;
4750:
4751: Check_Reentry

Line 4749: l_created_by := FND_GLOBAL.USER_ID;

4745: l_last_update_date := sysdate;
4746: l_last_updated_by := FND_GLOBAL.USER_ID;
4747: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
4748: l_creation_date := sysdate;
4749: l_created_by := FND_GLOBAL.USER_ID;
4750:
4751: Check_Reentry
4752: (p_api_version => 1.0 ,
4753: p_return_status => l_return_status,

Line 6676: l_last_updated_by := FND_GLOBAL.USER_ID;

6672:
6673: p_return_status := FND_API.G_RET_STS_SUCCESS;
6674:
6675: l_last_update_date := sysdate;
6676: l_last_updated_by := FND_GLOBAL.USER_ID;
6677: l_last_update_login := FND_GLOBAL.LOGIN_ID;
6678: l_creation_date := sysdate;
6679: l_created_by := FND_GLOBAL.USER_ID;
6680:

Line 6677: l_last_update_login := FND_GLOBAL.LOGIN_ID;

6673: p_return_status := FND_API.G_RET_STS_SUCCESS;
6674:
6675: l_last_update_date := sysdate;
6676: l_last_updated_by := FND_GLOBAL.USER_ID;
6677: l_last_update_login := FND_GLOBAL.LOGIN_ID;
6678: l_creation_date := sysdate;
6679: l_created_by := FND_GLOBAL.USER_ID;
6680:
6681: if (p_process = 'Positions Interface') then

Line 6679: l_created_by := FND_GLOBAL.USER_ID;

6675: l_last_update_date := sysdate;
6676: l_last_updated_by := FND_GLOBAL.USER_ID;
6677: l_last_update_login := FND_GLOBAL.LOGIN_ID;
6678: l_creation_date := sysdate;
6679: l_created_by := FND_GLOBAL.USER_ID;
6680:
6681: if (p_process = 'Positions Interface') then
6682: l_attribute11 := p_restart_id;
6683: elsif (p_process = 'Salary Interface') then

Line 6919: l_last_updated_by := FND_GLOBAL.USER_ID;

6915:
6916: p_return_status := FND_API.G_RET_STS_SUCCESS;
6917:
6918: l_last_update_date := sysdate;
6919: l_last_updated_by := FND_GLOBAL.USER_ID;
6920: l_last_update_login := FND_GLOBAL.LOGIN_ID;
6921: l_creation_date := sysdate;
6922: l_created_by := FND_GLOBAL.USER_ID;
6923:

Line 6920: l_last_update_login := FND_GLOBAL.LOGIN_ID;

6916: p_return_status := FND_API.G_RET_STS_SUCCESS;
6917:
6918: l_last_update_date := sysdate;
6919: l_last_updated_by := FND_GLOBAL.USER_ID;
6920: l_last_update_login := FND_GLOBAL.LOGIN_ID;
6921: l_creation_date := sysdate;
6922: l_created_by := FND_GLOBAL.USER_ID;
6923:
6924: -- API body

Line 6922: l_created_by := FND_GLOBAL.USER_ID;

6918: l_last_update_date := sysdate;
6919: l_last_updated_by := FND_GLOBAL.USER_ID;
6920: l_last_update_login := FND_GLOBAL.LOGIN_ID;
6921: l_creation_date := sysdate;
6922: l_created_by := FND_GLOBAL.USER_ID;
6923:
6924: -- API body
6925: if (p_process = 'Positions Interface') then
6926: l_sp1_status := 'C';