APPS.PAY_RECORDED_REQUESTS_PKG dependencies on PAY_RECORDED_REQUESTS

Line 1: PACKAGE BODY PAY_RECORDED_REQUESTS_PKG AS

1: PACKAGE BODY PAY_RECORDED_REQUESTS_PKG AS
2: /* $Header: pyrecreq.pkb 115.5 2004/08/05 08:25:34 jford noship $ */
3:
4: g_package varchar2(33) := ' pay_recorded_requests_pkg.'; -- Global package name
5: --

Line 4: g_package varchar2(33) := ' pay_recorded_requests_pkg.'; -- Global package name

1: PACKAGE BODY PAY_RECORDED_REQUESTS_PKG AS
2: /* $Header: pyrecreq.pkb 115.5 2004/08/05 08:25:34 jford noship $ */
3:
4: g_package varchar2(33) := ' pay_recorded_requests_pkg.'; -- Global package name
5: --
6:
7: -- ----------------------------------------------------------------------------
8: -- Name: insert_recorded_request

Line 64: ,p_lookup_type => 'PAY_RECORDED_REQUESTS'

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: )
67: then
68: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 70: fnd_message.set_token('LOOKUP_TYPE', 'PAY_RECORDED_REQUESTS');

66: )
67: then
68: hr_utility.set_location(' Leaving:'||l_proc, 20);
69: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
70: fnd_message.set_token('LOOKUP_TYPE', 'PAY_RECORDED_REQUESTS');
71: fnd_message.set_token('VALUE', p_process);
72: fnd_message.raise_error;
73: end if;
74:

Line 75: INSERT INTO pay_recorded_requests(recorded_request_id,

71: fnd_message.set_token('VALUE', p_process);
72: fnd_message.raise_error;
73: end if;
74:
75: INSERT INTO pay_recorded_requests(recorded_request_id,
76: recorded_date,
77: attribute_category,
78: attribute1 ,
79: attribute2 ,

Line 98: VALUES (pay_recorded_requests_s.NEXTVAL,

94: attribute17,
95: attribute18,
96: attribute19,
97: attribute20 )
98: VALUES (pay_recorded_requests_s.NEXTVAL,
99: p_recorded_date,
100: p_process,
101: p_attribute1 ,
102: p_attribute2 ,

Line 176: FROM pay_recorded_requests

172:
173: cursor csr_process_run IS
174:
175: SELECT recorded_date
176: FROM pay_recorded_requests
177: WHERE attribute_category = p_process
178: and attribute1 = p_attribute1
179: and nvl(attribute2,'X') = nvl(p_attribute2,'X')
180: and nvl(attribute3,'X') = nvl(p_attribute3,'X')

Line 277: FROM pay_recorded_requests

273:
274: cursor csr_process_run IS
275:
276: SELECT recorded_date
277: FROM pay_recorded_requests
278: WHERE attribute_category = p_process
279: and attribute1 = p_attribute1
280: and nvl(attribute2,'X') = nvl(p_attribute2,'X')
281: and nvl(attribute3,'X') = nvl(p_attribute3,'X')

Line 374: FROM pay_recorded_requests

370: as
371:
372: cursor csr_process_run IS
373: SELECT recorded_date
374: FROM pay_recorded_requests
375: WHERE attribute_category = p_process
376: and attribute1 = p_attribute1
377: and nvl(attribute2,'X') = nvl(p_attribute2,'X')
378: and nvl(attribute3,'X') = nvl(p_attribute3,'X')

Line 440: UPDATE pay_recorded_requests

436: p_attribute19,
437: p_attribute20 );
438: ELSE
439: -- Update to store new date
440: UPDATE pay_recorded_requests
441: SET recorded_date = p_recorded_date
442: WHERE attribute_category = p_process
443: and attribute1 = p_attribute1
444: and nvl(attribute2,'X') = nvl(p_attribute2,'X')

Line 472: END PAY_RECORDED_REQUESTS_PKG;

468:
469: END set_recorded_date;
470:
471:
472: END PAY_RECORDED_REQUESTS_PKG;