DBA Data[Home] [Help]

APPS.PA_INTEGRATION_UTILS dependencies on PJI_FM_XBS_ACCUM_INT

Line 54: DELETE FROM pji_fm_xbs_accum_int;

50: l_add_days NUMBER;
51:
52: BEGIN
53:
54: DELETE FROM pji_fm_xbs_accum_int;
55:
56: SELECT Trunc(Max(END_DATE))-1 INTO l_end_date FROM pa_periods_all WHERE status <> 'C';
57: SELECT trunc(trunc(Max(END_DATE) - Sysdate - 1)) into l_add_days FROM pa_periods_all WHERE status <> 'C';
58:

Line 68: INSERT INTO pji_fm_xbs_accum_int

64: p_end_date => sysdate + l_add_days,
65: x_return_status => l_return_status,
66: x_msg_code => l_msg_code) ;
67:
68: INSERT INTO pji_fm_xbs_accum_int
69: (PROJECT_ID,
70: STRUCT_VERSION_ID,
71: PROJECT_ELEMENT_ID,
72: CALENDAR_TYPE,