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_GE_PTNR_RESPS_PVT dependencies on PV_GE_PTNR_RESPS

Line 1: PACKAGE BODY PV_Ge_Ptnr_Resps_PVT as

1: PACKAGE BODY PV_Ge_Ptnr_Resps_PVT as
2: /* $Header: pvxvgprb.pls 120.1 2005/08/26 10:20:13 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_Ge_Ptnr_Resps_PVT

2: /* $Header: pvxvgprb.pls 120.1 2005/08/26 10:20:13 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_Ge_Ptnr_Resps_PVT
7: -- Purpose
8: --
9: -- History
10: -- 14-SEP-2003 Karen.Tsao Created.

Line 23: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Ge_Ptnr_Resps_PVT';

19: -- End of Comments
20: -- ===============================================================
21:
22:
23: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Ge_Ptnr_Resps_PVT';
24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvgprb.pls';
25:
26: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
27: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 100: SELECT pv_ge_ptnr_resps_s.NEXTVAL

96: l_org_id NUMBER := FND_API.G_MISS_NUM;
97: l_ptnr_resp_id NUMBER;
98: l_dummy NUMBER;
99: CURSOR c_id IS
100: SELECT pv_ge_ptnr_resps_s.NEXTVAL
101: FROM dual;
102:
103: CURSOR c_id_exists (l_id IN NUMBER) IS
104: SELECT 1

Line 105: FROM PV_GE_PTNR_RESPS

101: FROM dual;
102:
103: CURSOR c_id_exists (l_id IN NUMBER) IS
104: SELECT 1
105: FROM PV_GE_PTNR_RESPS
106: WHERE ptnr_resp_id = l_id;
107: BEGIN
108: -- Standard Start of API savepoint
109: SAVEPOINT create_ge_ptnr_resps_pvt;

Line 200: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Insert_Row)

196:
197: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
198: END IF;
199:
200: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Insert_Row)
201: Pv_Ge_Ptnr_Resps_Pkg.Insert_Row(
202: px_ptnr_resp_id => l_ptnr_resp_id,
203: p_partner_id => p_ge_ptnr_resps_rec.partner_id,
204: p_user_role_code => p_ge_ptnr_resps_rec.user_role_code,

Line 201: Pv_Ge_Ptnr_Resps_Pkg.Insert_Row(

197: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
198: END IF;
199:
200: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Insert_Row)
201: Pv_Ge_Ptnr_Resps_Pkg.Insert_Row(
202: px_ptnr_resp_id => l_ptnr_resp_id,
203: p_partner_id => p_ge_ptnr_resps_rec.partner_id,
204: p_user_role_code => p_ge_ptnr_resps_rec.user_role_code,
205: p_program_id => p_ge_ptnr_resps_rec.program_id,

Line 337: FROM PV_GE_PTNR_RESPS

333:
334:
335: CURSOR c_get_ge_ptnr_resps(ptnr_resp_id NUMBER) IS
336: SELECT *
337: FROM PV_GE_PTNR_RESPS
338: WHERE ptnr_resp_id = p_ge_ptnr_resps_rec.ptnr_resp_id;
339: -- Hint: Developer need to provide Where clause
340:
341:

Line 463: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Update_Row)

459:
460: PVX_UTILITY_PVT.debug_message('Private API: Calling update table handler');
461: END IF;
462:
463: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Update_Row)
464: Pv_Ge_Ptnr_Resps_Pkg.Update_Row(
465: p_ptnr_resp_id => p_ge_ptnr_resps_rec.ptnr_resp_id,
466: p_partner_id => p_ge_ptnr_resps_rec.partner_id,
467: p_user_role_code => p_ge_ptnr_resps_rec.user_role_code,

Line 464: Pv_Ge_Ptnr_Resps_Pkg.Update_Row(

460: PVX_UTILITY_PVT.debug_message('Private API: Calling update table handler');
461: END IF;
462:
463: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Update_Row)
464: Pv_Ge_Ptnr_Resps_Pkg.Update_Row(
465: p_ptnr_resp_id => p_ge_ptnr_resps_rec.ptnr_resp_id,
466: p_partner_id => p_ge_ptnr_resps_rec.partner_id,
467: p_user_role_code => p_ge_ptnr_resps_rec.user_role_code,
468: p_program_id => p_ge_ptnr_resps_rec.program_id,

Line 635: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Delete_Row)

631:
632: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
633: END IF;
634:
635: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Delete_Row)
636: Pv_Ge_Ptnr_Resps_Pkg.Delete_Row(
637: p_ptnr_resp_id => p_ptnr_resp_id,
638: p_object_version_number => p_object_version_number );
639: --

Line 636: Pv_Ge_Ptnr_Resps_Pkg.Delete_Row(

632: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
633: END IF;
634:
635: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Delete_Row)
636: Pv_Ge_Ptnr_Resps_Pkg.Delete_Row(
637: p_ptnr_resp_id => p_ptnr_resp_id,
638: p_object_version_number => p_object_version_number );
639: --
640: -- End of API body

Line 790: Pv_Ge_Ptnr_Resps_Pkg.Lock_Row(l_ptnr_resp_id,p_object_version);

786: x_return_status := FND_API.G_RET_STS_SUCCESS;
787:
788:
789: ------------------------ lock -------------------------
790: Pv_Ge_Ptnr_Resps_Pkg.Lock_Row(l_ptnr_resp_id,p_object_version);
791:
792:
793: -------------------- finish --------------------------
794: FND_MSG_PUB.count_and_get(

Line 859: 'pv_ge_ptnr_resps',

855: IF p_validation_mode = JTF_PLSQL_API.g_create
856: AND p_ge_ptnr_resps_rec.ptnr_resp_id IS NOT NULL
857: THEN
858: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
859: 'pv_ge_ptnr_resps',
860: 'ptnr_resp_id = ''' || p_ge_ptnr_resps_rec.ptnr_resp_id ||''''
861: );
862: END IF;
863:

Line 871: 'pv_ge_ptnr_resps'

867: END IF;
868:
869: IF p_ge_ptnr_resps_rec.PROGRAM_ID is null THEN
870: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
871: 'pv_ge_ptnr_resps'
872: ,'PARTNER_ID = ''' || p_ge_ptnr_resps_rec.PARTNER_ID ||
873: ''' AND USER_ROLE_CODE = ''' || p_ge_ptnr_resps_rec.USER_ROLE_CODE ||
874: ''' AND RESPONSIBILITY_ID = ''' || p_ge_ptnr_resps_rec.RESPONSIBILITY_ID ||
875: ''' AND SOURCE_RESP_MAP_RULE_ID = ''' || p_ge_ptnr_resps_rec.SOURCE_RESP_MAP_RULE_ID ||

Line 880: 'pv_ge_ptnr_resps'

876: ''' AND RESP_TYPE_CODE = ''' || p_ge_ptnr_resps_rec.RESP_TYPE_CODE || ''''
877: );
878: ELSE
879: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
880: 'pv_ge_ptnr_resps'
881: ,'PROGRAM_ID = ''' || p_ge_ptnr_resps_rec.PROGRAM_ID ||
882: ''' AND PARTNER_ID = ''' || p_ge_ptnr_resps_rec.PARTNER_ID ||
883: ''' AND USER_ROLE_CODE = ''' || p_ge_ptnr_resps_rec.USER_ROLE_CODE ||
884: ''' AND RESPONSIBILITY_ID = ''' || p_ge_ptnr_resps_rec.RESPONSIBILITY_ID ||

Line 1085: FROM pv_ge_ptnr_resps

1081: l_return_status VARCHAR2(1);
1082:
1083: CURSOR c_complete IS
1084: SELECT *
1085: FROM pv_ge_ptnr_resps
1086: WHERE ptnr_resp_id = p_ge_ptnr_resps_rec.ptnr_resp_id;
1087: l_ge_ptnr_resps_rec c_complete%ROWTYPE;
1088: BEGIN
1089: x_complete_rec := p_ge_ptnr_resps_rec;

Line 1367: END PV_Ge_Ptnr_Resps_PVT;

1363: p_data => x_msg_data
1364: );
1365: END Validate_ge_ptnr_resps_Rec;
1366:
1367: END PV_Ge_Ptnr_Resps_PVT;