DBA Data[Home] [Help]

APPS.PSB_POSITION_CONTROL_PVT dependencies on FND_PROFILE

Line 5269: set org_id = FND_PROFILE.VALUE('ORG_ID'),

5265: if p_hr_budget_id is null then
5266: begin
5267:
5268: update PSB_POSITION_EVENTS_ALL
5269: set org_id = FND_PROFILE.VALUE('ORG_ID'),
5270: transfer_to_interface = p_transfer_to_interface,
5271: transfer_to_hrms = p_transfer_to_hrms,
5272: interface_last_update_date = sysdate,
5273: interface_last_updated_by = FND_GLOBAL.USER_ID,

Line 5289: set org_id = FND_PROFILE.VALUE('ORG_ID'),

5285: else
5286: begin
5287:
5288: update PSB_POSITION_EVENTS_ALL
5289: set org_id = FND_PROFILE.VALUE('ORG_ID'),
5290: transfer_to_interface = p_transfer_to_interface,
5291: transfer_to_hrms = p_transfer_to_hrms,
5292: interface_last_update_date = sysdate,
5293: interface_last_updated_by = FND_GLOBAL.USER_ID,

Line 5333: FND_PROFILE.VALUE('ORG_ID'),

5329: hrms_last_update_login)
5330: VALUES (PSB_POSITION_EVENTS_ALL_S.NEXTVAL,
5331: p_event_type,
5332: p_source_id,
5333: FND_PROFILE.VALUE('ORG_ID'),
5334: p_hr_budget_id,
5335: p_from_budget_year_id,
5336: p_to_budget_year_id,
5337: p_transfer_to_interface,

Line 6064: fnd_profile.get('PSB_HRMS_FTE_UPLOAD_OPTION', g_hrms_fte_upload_option);

6060: begin
6061:
6062: /* bug no 3670254 */
6063: -- get the profile value for FTE upload
6064: fnd_profile.get('PSB_HRMS_FTE_UPLOAD_OPTION', g_hrms_fte_upload_option);
6065: g_hrms_fte_upload_option := NVL(g_hrms_fte_upload_option, 'PERIOD');
6066:
6067: IF g_hrms_fte_upload_option = 'ASSIGNMENT' THEN
6068: -- fetch the data extract used for position worksheet