APPS.PV_PG_ENRL_REQUESTS_PKG dependencies on PV_PG_ENRL_REQUESTS

Line 1: PACKAGE BODY PV_Pg_Enrl_Requests_PKG as

1: PACKAGE BODY PV_Pg_Enrl_Requests_PKG as
2: /* $Header: pvxtperb.pls 120.5 2006/01/25 15:42:17 ktsao ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_Pg_Enrl_Requests_PKG

2: /* $Header: pvxtperb.pls 120.5 2006/01/25 15:42:17 ktsao ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_Pg_Enrl_Requests_PKG
7: -- Purpose
8: --
9: -- History
10: -- 29-AUG-2003 ktsao Modified for column name change: transactional_curr_code to trans_curr_code

Line 11: -- 26-SEP-2003 pukken Added dependent_program_id column in pv_pg_enrl_requests record

7: -- Purpose
8: --
9: -- History
10: -- 29-AUG-2003 ktsao Modified for column name change: transactional_curr_code to trans_curr_code
11: -- 26-SEP-2003 pukken Added dependent_program_id column in pv_pg_enrl_requests record
12: -- 20-APR-2005 ktsao Modified forR12.
13: -- 05-JUL-2005 kvattiku Added trxn_extension_id column in pv_pg_enrl_requests record
14: --
15: -- NOTE

Line 13: -- 05-JUL-2005 kvattiku Added trxn_extension_id column in pv_pg_enrl_requests record

9: -- History
10: -- 29-AUG-2003 ktsao Modified for column name change: transactional_curr_code to trans_curr_code
11: -- 26-SEP-2003 pukken Added dependent_program_id column in pv_pg_enrl_requests record
12: -- 20-APR-2005 ktsao Modified forR12.
13: -- 05-JUL-2005 kvattiku Added trxn_extension_id column in pv_pg_enrl_requests record
14: --
15: -- NOTE
16: --
17: -- This Api is generated with Latest version of

Line 24: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Pg_Enrl_Requests_PKG';

20: -- End of Comments
21: -- ===============================================================
22:
23:
24: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Pg_Enrl_Requests_PKG';
25: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxtperb.pls';
26:
27:
28:

Line 98: INSERT INTO pv_pg_enrl_requests(

94:
95: px_object_version_number := nvl(px_object_version_number, 1);
96:
97:
98: INSERT INTO pv_pg_enrl_requests(
99: enrl_request_id,
100: object_version_number,
101: program_id,
102: partner_id,

Line 253: Update pv_pg_enrl_requests

249: )
250:
251: IS
252: BEGIN
253: Update pv_pg_enrl_requests
254: SET
255: enrl_request_id = DECODE( p_enrl_request_id, null, enrl_request_id, FND_API.G_MISS_NUM, null, p_enrl_request_id),
256: object_version_number = nvl(p_object_version_number,0) + 1 ,
257: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),

Line 328: DELETE FROM pv_pg_enrl_requests

324: p_enrl_request_id NUMBER,
325: p_object_version_number NUMBER)
326: IS
327: BEGIN
328: DELETE FROM pv_pg_enrl_requests
329: WHERE enrl_request_id = p_enrl_request_id
330: AND object_version_number = p_object_version_number;
331: If (SQL%NOTFOUND) then
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 358: FROM pv_pg_enrl_requests

354: p_object_version_number NUMBER)
355: IS
356: CURSOR C IS
357: SELECT *
358: FROM pv_pg_enrl_requests
359: WHERE enrl_request_id = p_enrl_request_id
360: AND object_version_number = p_object_version_number
361: FOR UPDATE OF enrl_request_id NOWAIT;
362: Recinfo C%ROWTYPE;

Line 377: END PV_Pg_Enrl_Requests_PKG;

373: END Lock_Row;
374:
375:
376:
377: END PV_Pg_Enrl_Requests_PKG;