APPS.ASP_ALERTS_INVOICE dependencies on ASP_PROGRAM_RUN_DATES

Line 79: FROM asp_program_run_dates

75: l_debug_statment number;
76:
77: CURSOR getLastRunDate is
78: SELECT program_ref_date
79: FROM asp_program_run_dates
80: WHERE program_object_code = 'ASPODINV' --'INVOICE'
81: and status_code = 'S'
82: and rownum < 2;
83:

Line 127: delete asp_program_run_dates where PROGRAM_OBJECT_CODE = 'ASPODINV';

123: IF(l_program_ref_date is null) THEN
124: if(l_debug_procedure >= l_debug_runtime) then
125: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_program_ref_date is null');
126: end if;
127: delete asp_program_run_dates where PROGRAM_OBJECT_CODE = 'ASPODINV';
128: insert into asp_program_run_dates(
129: PROGRAM_RUN_ID,
130: PROGRAM_OBJECT_CODE,
131: STATUS_CODE,

Line 128: insert into asp_program_run_dates(

124: if(l_debug_procedure >= l_debug_runtime) then
125: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_program_ref_date is null');
126: end if;
127: delete asp_program_run_dates where PROGRAM_OBJECT_CODE = 'ASPODINV';
128: insert into asp_program_run_dates(
129: PROGRAM_RUN_ID,
130: PROGRAM_OBJECT_CODE,
131: STATUS_CODE,
132: DESCRIPTION,

Line 148: asp_program_run_dates_s.nextval,

144: LAST_UPDATE_DATE,
145: LAST_UPDATED_BY,
146: LAST_UPDATE_LOGIN
147: )values(
148: asp_program_run_dates_s.nextval,
149: 'ASPODINV', --'INVOICE'
150: 'S',
151: null,
152: l_PROGRAM_START_DATE,

Line 207: update asp_program_run_dates

203: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'After opening getDelinquencyDeltaRun');
204: end if;
205:
206: wf_engine.threshold := save_threshold;
207: update asp_program_run_dates
208: set program_ref_date = l_current_run_ref_date
209: where program_object_code = 'ASPODINV' --'INVOICE'
210: and status_code = 'S';
211: commit;