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:
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:
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 ,
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:
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
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,
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:
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
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,
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:
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
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,
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:
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
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
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:
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;
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;
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:
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
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,
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:
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
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,
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:
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
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
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:
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
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';