eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PG_ENRQ_INIT_SOURCES_PVT dependencies on PV_PG_ENRQ_INIT_SOURCES

Line 1: PACKAGE BODY Pv_Pg_Enrq_Init_Sources_Pvt AS

1: PACKAGE BODY Pv_Pg_Enrq_Init_Sources_Pvt AS
2: /* $Header: pvxvpeib.pls 120.1 2005/08/26 10:20:52 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_Pg_Enrq_Init_Sources_PVT

2: /* $Header: pvxvpeib.pls 120.1 2005/08/26 10:20:52 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_Pg_Enrq_Init_Sources_PVT
7: -- Purpose
8: --
9: -- History
10: --

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

16: -- End of Comments
17: -- ===============================================================
18:
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Pg_Enrq_Init_Sources_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvpeib.pls';
22:
23: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 97: SELECT pv_pg_enrq_init_sources_s.NEXTVAL

93: l_org_id NUMBER := Fnd_Api.G_MISS_NUM;
94: l_initiation_source_id NUMBER;
95: l_dummy NUMBER;
96: CURSOR c_id IS
97: SELECT pv_pg_enrq_init_sources_s.NEXTVAL
98: FROM dual;
99:
100: CURSOR c_id_exists (l_id IN NUMBER) IS
101: SELECT 1

Line 102: FROM PV_PG_ENRQ_INIT_SOURCES

98: FROM dual;
99:
100: CURSOR c_id_exists (l_id IN NUMBER) IS
101: SELECT 1
102: FROM PV_PG_ENRQ_INIT_SOURCES
103: WHERE initiation_source_id = l_id;
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_pg_init_src_pvt;

Line 197: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Insert_Row)

193:
194: Pvx_Utility_Pvt.debug_message( 'Private API: Calling create table handler');
195: END IF;
196:
197: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Insert_Row)
198: Pv_Pg_Enrq_Init_Sources_Pkg.Insert_Row(
199: px_initiation_source_id => l_initiation_source_id,
200: px_object_version_number => l_object_version_number,
201: p_enrl_request_id => p_enrq_init_sources_rec.enrl_request_id,

Line 198: Pv_Pg_Enrq_Init_Sources_Pkg.Insert_Row(

194: Pvx_Utility_Pvt.debug_message( 'Private API: Calling create table handler');
195: END IF;
196:
197: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Insert_Row)
198: Pv_Pg_Enrq_Init_Sources_Pkg.Insert_Row(
199: px_initiation_source_id => l_initiation_source_id,
200: px_object_version_number => l_object_version_number,
201: p_enrl_request_id => p_enrq_init_sources_rec.enrl_request_id,
202: p_prev_membership_id => p_enrq_init_sources_rec.prev_membership_id,

Line 331: FROM PV_PG_ENRQ_INIT_SOURCES

327:
328:
329: CURSOR c_get_pg_enrq_init_sources(initiation_source_id NUMBER) IS
330: SELECT *
331: FROM PV_PG_ENRQ_INIT_SOURCES
332: WHERE initiation_source_id = p_enrq_init_sources_rec.initiation_source_id;
333: -- Hint: Developer need to provide Where clause
334:
335:

Line 449: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Update_Row)

445:
446: Pvx_Utility_Pvt.debug_message('Private API: Calling update table handler');
447: END IF;
448:
449: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Update_Row)
450: Pv_Pg_Enrq_Init_Sources_Pkg.Update_Row(
451: p_initiation_source_id => p_enrq_init_sources_rec.initiation_source_id,
452: p_object_version_number => p_enrq_init_sources_rec.object_version_number,
453: p_enrl_request_id => p_enrq_init_sources_rec.enrl_request_id,

Line 450: Pv_Pg_Enrq_Init_Sources_Pkg.Update_Row(

446: Pvx_Utility_Pvt.debug_message('Private API: Calling update table handler');
447: END IF;
448:
449: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Update_Row)
450: Pv_Pg_Enrq_Init_Sources_Pkg.Update_Row(
451: p_initiation_source_id => p_enrq_init_sources_rec.initiation_source_id,
452: p_object_version_number => p_enrq_init_sources_rec.object_version_number,
453: p_enrl_request_id => p_enrq_init_sources_rec.enrl_request_id,
454: p_prev_membership_id => p_enrq_init_sources_rec.prev_membership_id,

Line 618: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Delete_Row)

614:
615: Pvx_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
616: END IF;
617:
618: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Delete_Row)
619: Pv_Pg_Enrq_Init_Sources_Pkg.Delete_Row(
620: p_initiation_source_id => p_initiation_source_id,
621: p_object_version_number => p_object_version_number );
622: --

Line 619: Pv_Pg_Enrq_Init_Sources_Pkg.Delete_Row(

615: Pvx_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
616: END IF;
617:
618: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Delete_Row)
619: Pv_Pg_Enrq_Init_Sources_Pkg.Delete_Row(
620: p_initiation_source_id => p_initiation_source_id,
621: p_object_version_number => p_object_version_number );
622: --
623: -- End of API body

Line 773: Pv_Pg_Enrq_Init_Sources_Pkg.Lock_Row(l_initiation_source_id,p_object_version);

769: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
770:
771:
772: ------------------------ lock -------------------------
773: Pv_Pg_Enrq_Init_Sources_Pkg.Lock_Row(l_initiation_source_id,p_object_version);
774:
775:
776: -------------------- finish --------------------------
777: Fnd_Msg_Pub.count_and_get(

Line 842: 'pv_pg_enrq_init_sources',

838: IF p_validation_mode = Jtf_Plsql_Api.g_create
839: AND p_enrq_init_sources_rec.initiation_source_id IS NOT NULL
840: THEN
841: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(
842: 'pv_pg_enrq_init_sources',
843: 'initiation_source_id = ''' || p_enrq_init_sources_rec.initiation_source_id ||''''
844: );
845: END IF;
846:

Line 1013: FROM pv_pg_enrq_init_sources

1009: l_return_status VARCHAR2(1);
1010:
1011: CURSOR c_complete IS
1012: SELECT *
1013: FROM pv_pg_enrq_init_sources
1014: WHERE initiation_source_id = p_enrq_init_sources_rec.initiation_source_id;
1015: l_enrq_init_sources_rec c_complete%ROWTYPE;
1016: BEGIN
1017: x_complete_rec := p_enrq_init_sources_rec;

Line 1283: END Pv_Pg_Enrq_Init_Sources_Pvt;

1279: p_data => x_msg_data
1280: );
1281: END Validate_Init_Src_Rec;
1282:
1283: END Pv_Pg_Enrq_Init_Sources_Pvt;