APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_POSITION_EVENTS_ALL

Line 5268: update PSB_POSITION_EVENTS_ALL

5264:
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,

Line 5288: update PSB_POSITION_EVENTS_ALL

5284: end;
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,

Line 5310: INSERT INTO PSB_POSITION_EVENTS_ALL

5306:
5307: if SQL%NOTFOUND then
5308: begin
5309:
5310: INSERT INTO PSB_POSITION_EVENTS_ALL
5311: (position_event_id,
5312: event_type,
5313: source_id,
5314: org_id,

Line 5330: VALUES (PSB_POSITION_EVENTS_ALL_S.NEXTVAL,

5326: hrms_creation_date,
5327: hrms_last_update_date,
5328: hrms_last_updated_by,
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,

Line 6097: FROM psb_position_events_all

6093: IF p_hr_budget_id IS NOT NULL THEN
6094: FOR li_csr IN ( SELECT 1 new_bud
6095: FROM dual
6096: WHERE EXISTS (SELECT 1
6097: FROM psb_position_events_all
6098: WHERE event_type = 'BP'
6099: AND hr_budget_id = p_hr_budget_id)) LOOP
6100: lp_num_var := li_csr.new_bud;
6101: END LOOP;