APPS.PV_PG_ENRQ_INIT_SOURCES_PKG dependencies on PV_PG_ENRQ_INIT_SOURCES

Line 1: PACKAGE BODY PV_Pg_Enrq_Init_Sources_PKG as

1: PACKAGE BODY PV_Pg_Enrq_Init_Sources_PKG as
2: /* $Header: pvxtpeib.pls 115.2 2002/12/10 20:36:23 jkylee ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_Pg_Enrq_Init_Sources_PKG

2: /* $Header: pvxtpeib.pls 115.2 2002/12/10 20:36:23 jkylee ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_Pg_Enrq_Init_Sources_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Pg_Enrq_Init_Sources_PKG';

16: -- End of Comments
17: -- ===============================================================
18:
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Pg_Enrq_Init_Sources_PKG';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxtpeib.pls';
22:
23:
24:

Line 64: INSERT INTO pv_pg_enrq_init_sources(

60:
61: px_object_version_number := nvl(px_object_version_number, 1);
62:
63:
64: INSERT INTO pv_pg_enrq_init_sources(
65: initiation_source_id,
66: object_version_number,
67: enrl_request_id,
68: prev_membership_id,

Line 116: Update pv_pg_enrq_init_sources

112: p_last_update_login NUMBER)
113:
114: IS
115: BEGIN
116: Update pv_pg_enrq_init_sources
117: SET
118: initiation_source_id = DECODE( p_initiation_source_id, null, initiation_source_id, FND_API.G_MISS_NUM, null, p_initiation_source_id),
119: object_version_number = nvl(p_object_version_number,0) + 1 ,
120: enrl_request_id = DECODE( p_enrl_request_id, null, enrl_request_id, FND_API.G_MISS_NUM, null, p_enrl_request_id),

Line 157: DELETE FROM pv_pg_enrq_init_sources

153: p_initiation_source_id NUMBER,
154: p_object_version_number NUMBER)
155: IS
156: BEGIN
157: DELETE FROM pv_pg_enrq_init_sources
158: WHERE initiation_source_id = p_initiation_source_id
159: AND object_version_number = p_object_version_number;
160: If (SQL%NOTFOUND) then
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 187: FROM pv_pg_enrq_init_sources

183: p_object_version_number NUMBER)
184: IS
185: CURSOR C IS
186: SELECT *
187: FROM pv_pg_enrq_init_sources
188: WHERE initiation_source_id = p_initiation_source_id
189: AND object_version_number = p_object_version_number
190: FOR UPDATE OF initiation_source_id NOWAIT;
191: Recinfo C%ROWTYPE;

Line 206: END PV_Pg_Enrq_Init_Sources_PKG;

202: END Lock_Row;
203:
204:
205:
206: END PV_Pg_Enrq_Init_Sources_PKG;