APPS.PA_CAPITALIZED_INTEREST dependencies on PA_IND_RATE_SCH_REVISIONS

Line 57: -- During the start of the compilation process, pa_ind_rate_sch_revisions.complied_flag

53: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
54: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
55: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
56:
57: -- During the start of the compilation process, pa_ind_rate_sch_revisions.complied_flag
58: -- is set to an intermediate value 'I' (IN-PROCESS). Once the compilation process is
59: -- successfully completed, the flag is updated to 'Y'
60:
61: --

Line 65: UPDATE pa_ind_rate_sch_revisions

61: --
62: -- Set the compilation time in the rate schedule revision
63: --
64:
65: UPDATE pa_ind_rate_sch_revisions
66: SET
67: last_update_date = SYSDATE,
68: last_updated_by = l_last_updated_by,
69: last_update_login = l_last_update_login,

Line 123: from pa_ind_rate_sch_revisions

119: END IF;
120:
121: select ind_rate_sch_id
122: into l_ind_rate_sch_id
123: from pa_ind_rate_sch_revisions
124: where ind_rate_sch_revision_id = l_ind_rate_sch_rev_id;
125:
126: --
127: -- Compile rates for all organizations starting from the highest organization

Line 181: UPDATE pa_ind_rate_sch_revisions

177: --
178: -- Set the compilation time in the rate schedule revision
179: --
180:
181: UPDATE pa_ind_rate_sch_revisions
182: SET
183: compiled_flag = 'Y',
184: compiled_date = SYSDATE
185: WHERE

Line 208: UPDATE pa_ind_rate_sch_revisions

204: pa_debug.reset_curr_function;
205: END IF;
206:
207: ROLLBACK;
208: UPDATE pa_ind_rate_sch_revisions
209: SET compiled_flag = 'N'
210: WHERE ind_rate_sch_revision_id = l_ind_rate_sch_rev_id;
211: COMMIT;
212: completion_status := fnd_concurrent.set_completion_status('ERROR', SQLERRM);