DBA Data[Home] [Help]

APPS.PAY_RECORDED_REQUESTS_PKG dependencies on HR_API

Line 62: if hr_api.not_exists_in_hr_lookups

58: --
59: -- Validate against hr_lookups,
60: -- to check request/process has been set up to use mechanism.
61: --
62: if hr_api.not_exists_in_hr_lookups
63: (p_effective_date => sysdate
64: ,p_lookup_type => 'PAY_RECORDED_REQUESTS'
65: ,p_lookup_code => p_process
66: )

Line 132: -- hr_api.g_sot is returned.

128: -- Description:
129: -- This procedure returns the date that has been recorded against the request
130: -- identified by the attributes.
131: -- If no record exists (no row in table) then a row is created and the default
132: -- hr_api.g_sot is returned.
133: --
134: -- Prerequisites:
135: -- This is a public procedure which allows code as part of the request to access
136: -- a single recorded date which may be required for future processing.

Line 212: l_recorded_date := hr_api.g_sot;

208: fetch csr_process_run into l_recorded_date;
209:
210: if (csr_process_run%NOTFOUND) then
211: --no row exists so create one
212: l_recorded_date := hr_api.g_sot;
213: insert_recorded_request( p_process ,
214: l_recorded_date,
215: p_attribute1,
216: p_attribute2,

Line 313: l_recorded_date := hr_api.g_sot;

309: fetch csr_process_run into l_recorded_date;
310:
311: if (csr_process_run%NOTFOUND) then
312: --no row exists, in this procedure we're not creating a row
313: l_recorded_date := hr_api.g_sot;
314: end if;
315:
316: close csr_process_run;
317:

Line 410: p_recorded_date_o := nvl(l_recorded_date,hr_api.g_sot);

406: open csr_process_run;
407: fetch csr_process_run into l_recorded_date;
408:
409: -- Return old date in case required by calling code
410: p_recorded_date_o := nvl(l_recorded_date,hr_api.g_sot);
411:
412:
413: IF (csr_process_run%NOTFOUND) then
414: --no row so make one