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_ENRL_REQUESTS_PVT dependencies on PV_PG_ENRL_REQUESTS

Line 1: PACKAGE BODY PV_Pg_Enrl_Requests_PVT as

1: PACKAGE BODY PV_Pg_Enrl_Requests_PVT as
2: /* $Header: pvxvperb.pls 120.7 2006/02/08 09:21:50 dgottlie ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_Pg_Enrl_Requests_PVT

2: /* $Header: pvxvperb.pls 120.7 2006/02/08 09:21:50 dgottlie ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_Pg_Enrl_Requests_PVT
7: -- Purpose
8: --
9: -- History
10: -- 20-OCT-2002 Karen.Tsao Created

Line 16: -- pv_pg_enrl_requests: membership_fee, transactional_curr_code

12: -- 2. Debug message to be wrapped with IF check.
13: -- 3. Replace of COPY with NOCOPY string.
14: -- 27-AUG-2003 Karen.Tsao Update the Create_Pg_Enrl_Requests, Update_Pg_Enrl_Requests,
15: -- and Complete_Enrl_Request_Rec with two new columns in
16: -- pv_pg_enrl_requests: membership_fee, transactional_curr_code
17: -- 29-AUG-2003 Karen.Tsao Modified for column name change: transactional_curr_code to trans_curr_code
18: -- 26-SEP-2003 pukken Added dependent_program_id column in pv_pg_enrl_requests record
19: -- 23-FEB-2004 pukken Modified code in is_payment_exists function.
20: -- 01-APR-2004 Karen.Tsao Modified Is_Contract_Exists for bug 3540615.

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

14: -- 27-AUG-2003 Karen.Tsao Update the Create_Pg_Enrl_Requests, Update_Pg_Enrl_Requests,
15: -- and Complete_Enrl_Request_Rec with two new columns in
16: -- pv_pg_enrl_requests: membership_fee, transactional_curr_code
17: -- 29-AUG-2003 Karen.Tsao Modified for column name change: transactional_curr_code to trans_curr_code
18: -- 26-SEP-2003 pukken Added dependent_program_id column in pv_pg_enrl_requests record
19: -- 23-FEB-2004 pukken Modified code in is_payment_exists function.
20: -- 01-APR-2004 Karen.Tsao Modified Is_Contract_Exists for bug 3540615.
21: -- 20-APR-2005 Karen.Tsao Modified for R12.
22: -- 05-JUL-2005 kvattiku Added trxn_extension_id column in pv_pg_enrl_requests record

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

18: -- 26-SEP-2003 pukken Added dependent_program_id column in pv_pg_enrl_requests record
19: -- 23-FEB-2004 pukken Modified code in is_payment_exists function.
20: -- 01-APR-2004 Karen.Tsao Modified Is_Contract_Exists for bug 3540615.
21: -- 20-APR-2005 Karen.Tsao Modified for R12.
22: -- 05-JUL-2005 kvattiku Added trxn_extension_id column in pv_pg_enrl_requests record
23: -- 06-SEP-2005 Karen.Tsao Move the return call to the end of Is_Contract_Exists.
24: --
25: -- NOTE
26: --

Line 33: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Pg_Enrl_Requests_PVT';

29: -- NULL indicates missing value. Rosetta Version 1.55
30: -- End of Comments
31: -- ===============================================================
32:
33: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Pg_Enrl_Requests_PVT';
34: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvperb.pls';
35:
36: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
37: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 311: SELECT pv_pg_enrl_requests_s.NEXTVAL

307: l_score_result_code VARCHAR2(30) := p_enrl_request_rec.score_result_code;
308: l_dummy NUMBER;
309: l_enrl_request_rec enrl_request_rec_type:= g_miss_enrl_request_rec;
310: CURSOR c_id IS
311: SELECT pv_pg_enrl_requests_s.NEXTVAL
312: FROM dual;
313:
314: CURSOR c_id_exists (l_id IN NUMBER) IS
315: SELECT 1

Line 316: FROM PV_PG_ENRL_REQUESTS

312: FROM dual;
313:
314: CURSOR c_id_exists (l_id IN NUMBER) IS
315: SELECT 1
316: FROM PV_PG_ENRL_REQUESTS
317: WHERE enrl_request_id = l_id;
318: BEGIN
319: -- Standard Start of API savepoint
320: SAVEPOINT create_pg_enrl_requests_pvt;

Line 419: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Insert_Row)

415: l_enrl_request_rec:=p_enrl_request_rec;
416: l_custom_setup_id := Get_Custom_Setup_Id(l_enrl_request_id, l_enrl_request_rec);
417:
418:
419: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Insert_Row)
420: Pv_Pg_Enrl_Requests_Pkg.Insert_Row(
421: px_enrl_request_id => l_enrl_request_id,
422: px_object_version_number => l_object_version_number,
423: p_program_id => p_enrl_request_rec.program_id,

Line 420: Pv_Pg_Enrl_Requests_Pkg.Insert_Row(

416: l_custom_setup_id := Get_Custom_Setup_Id(l_enrl_request_id, l_enrl_request_rec);
417:
418:
419: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Insert_Row)
420: Pv_Pg_Enrl_Requests_Pkg.Insert_Row(
421: px_enrl_request_id => l_enrl_request_id,
422: px_object_version_number => l_object_version_number,
423: p_program_id => p_enrl_request_rec.program_id,
424: p_partner_id => p_enrl_request_rec.partner_id,

Line 605: FROM PV_PG_ENRL_REQUESTS

601:
602:
603: CURSOR c_get_pg_enrl_requests(enrl_request_id NUMBER) IS
604: SELECT *
605: FROM PV_PG_ENRL_REQUESTS
606: WHERE enrl_request_id = p_enrl_request_rec.enrl_request_id;
607: -- Hint: Developer need to provide Where clause
608:
609:

Line 729: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Update_Row)

725: FND_MSG_PUB.add;
726: RAISE FND_API.G_EXC_ERROR;
727: END IF;
728:
729: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Update_Row)
730: Pv_Pg_Enrl_Requests_Pkg.Update_Row(
731: p_enrl_request_id => p_enrl_request_rec.enrl_request_id,
732: p_object_version_number => p_enrl_request_rec.object_version_number,
733: p_program_id => p_enrl_request_rec.program_id,

Line 730: Pv_Pg_Enrl_Requests_Pkg.Update_Row(

726: RAISE FND_API.G_EXC_ERROR;
727: END IF;
728:
729: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Update_Row)
730: Pv_Pg_Enrl_Requests_Pkg.Update_Row(
731: p_enrl_request_id => p_enrl_request_rec.enrl_request_id,
732: p_object_version_number => p_enrl_request_rec.object_version_number,
733: p_program_id => p_enrl_request_rec.program_id,
734: p_partner_id => p_enrl_request_rec.partner_id,

Line 818: FND_MESSAGE.Set_Token('INFO', 'Pv_Pg_Enrl_Requests');

814: CLOSE c_get_Pg_Enrl_Requests;
815: IF (l_tar_enrl_request_rec.object_version_number <> l_ref_enrl_request_rec.object_version_number) THEN
816: x_return_status := Fnd_Api.G_RET_STS_ERROR;
817: FND_MESSAGE.Set_Name ('PV', 'API_RECORD_CHANGED');
818: FND_MESSAGE.Set_Token('INFO', 'Pv_Pg_Enrl_Requests');
819: FND_MSG_PUB.Add;
820: END IF;
821: Fnd_Msg_Pub.Count_And_Get (
822: p_encoded => Fnd_Api.G_FALSE,

Line 960: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Delete_Row)

956:
957: Pvx_Utility_Pvt.debug_message( 'PRIVATE API: Calling DELETE TABLE handler');
958: END IF;
959:
960: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Delete_Row)
961: Pv_Pg_Enrl_Requests_Pkg.Delete_Row(
962: p_enrl_request_id => p_enrl_request_id,
963: p_object_version_number => p_object_version_number );
964: --

Line 961: Pv_Pg_Enrl_Requests_Pkg.Delete_Row(

957: Pvx_Utility_Pvt.debug_message( 'PRIVATE API: Calling DELETE TABLE handler');
958: END IF;
959:
960: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Delete_Row)
961: Pv_Pg_Enrl_Requests_Pkg.Delete_Row(
962: p_enrl_request_id => p_enrl_request_id,
963: p_object_version_number => p_object_version_number );
964: --
965: -- End of API body

Line 1116: Pv_Pg_Enrl_Requests_Pkg.Lock_Row(l_enrl_request_id,p_object_version);

1112: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1113:
1114:
1115: ------------------------ lock -------------------------
1116: Pv_Pg_Enrl_Requests_Pkg.Lock_Row(l_enrl_request_id,p_object_version);
1117:
1118:
1119: -------------------- finish --------------------------
1120: Fnd_Msg_Pub.count_and_get(

Line 1186: 'pv_pg_enrl_requests',

1182: IF p_validation_mode = Jtf_Plsql_Api.g_create
1183: AND p_enrl_request_rec.enrl_request_id IS NOT NULL
1184: THEN
1185: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(
1186: 'pv_pg_enrl_requests',
1187: 'enrl_request_id = ''' || p_enrl_request_rec.enrl_request_id ||''''
1188: );
1189: END IF;
1190:

Line 1428: FROM pv_pg_enrl_requests

1424: l_return_status VARCHAR2(1);
1425:
1426: CURSOR c_complete IS
1427: SELECT *
1428: FROM pv_pg_enrl_requests
1429: WHERE enrl_request_id = p_enrl_request_rec.enrl_request_id;
1430: l_enrl_request_rec c_complete%ROWTYPE;
1431: BEGIN
1432: x_complete_rec := p_enrl_request_rec;

Line 1798: END Pv_Pg_Enrl_Requests_Pvt;

1794: p_data => x_msg_data
1795: );
1796: END Validate_enrl_request_Rec;
1797:
1798: END Pv_Pg_Enrl_Requests_Pvt;