APPS.PV_GE_TEMP_APPROVERS_PVT dependencies on PV_GE_TEMP_APPROVERS

Line 1: PACKAGE BODY Pv_Ge_Temp_Approvers_PVT as

1: PACKAGE BODY Pv_Ge_Temp_Approvers_PVT as
2: /* $Header: pvxvptab.pls 120.3 2006/01/25 15:43:01 ktsao ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- Pv_Ge_Temp_Approvers_PVT

2: /* $Header: pvxvptab.pls 120.3 2006/01/25 15:43:01 ktsao ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- Pv_Ge_Temp_Approvers_PVT
7: -- Purpose
8: --
9: -- History
10: --

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

16: -- End of Comments
17: -- ===============================================================
18:
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Pv_Ge_Temp_Approvers_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvptab.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_ge_temp_approvers_s.NEXTVAL

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

Line 102: FROM PV_GE_TEMP_APPROVERS

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

Line 198: -- Invoke table handler(Pv_Ge_Temp_Approvers_Pkg.Insert_Row)

194:
195: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
196: END IF;
197:
198: -- Invoke table handler(Pv_Ge_Temp_Approvers_Pkg.Insert_Row)
199: Pv_Ge_Temp_Approvers_Pkg.Insert_Row(
200: px_entity_approver_id => l_entity_approver_id,
201: px_object_version_number => l_object_version_number,
202: p_arc_appr_for_entity_code => p_approver_rec.arc_appr_for_entity_code,

Line 199: Pv_Ge_Temp_Approvers_Pkg.Insert_Row(

195: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
196: END IF;
197:
198: -- Invoke table handler(Pv_Ge_Temp_Approvers_Pkg.Insert_Row)
199: Pv_Ge_Temp_Approvers_Pkg.Insert_Row(
200: px_entity_approver_id => l_entity_approver_id,
201: px_object_version_number => l_object_version_number,
202: p_arc_appr_for_entity_code => p_approver_rec.arc_appr_for_entity_code,
203: p_appr_for_entity_id => p_approver_rec.appr_for_entity_id,

Line 336: FROM PV_GE_TEMP_APPROVERS

332:
333:
334: CURSOR c_get_ptr_enr_temp_appr(entity_approver_id NUMBER) IS
335: SELECT *
336: FROM PV_GE_TEMP_APPROVERS
337: WHERE entity_approver_id = p_approver_rec.entity_approver_id;
338: -- Hint: Developer need to provide Where clause
339:
340:

Line 483: -- Invoke table handler(Pv_Ge_Temp_Approvers_Pkg.Update_Row)

479:
480: PVX_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');
481: END IF;
482:
483: -- Invoke table handler(Pv_Ge_Temp_Approvers_Pkg.Update_Row)
484: Pv_Ge_Temp_Approvers_Pkg.Update_Row(
485: p_entity_approver_id => p_approver_rec.entity_approver_id,
486: p_object_version_number => p_approver_rec.object_version_number,
487: p_arc_appr_for_entity_code => p_approver_rec.arc_appr_for_entity_code,

Line 484: Pv_Ge_Temp_Approvers_Pkg.Update_Row(

480: PVX_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');
481: END IF;
482:
483: -- Invoke table handler(Pv_Ge_Temp_Approvers_Pkg.Update_Row)
484: Pv_Ge_Temp_Approvers_Pkg.Update_Row(
485: p_entity_approver_id => p_approver_rec.entity_approver_id,
486: p_object_version_number => p_approver_rec.object_version_number,
487: p_arc_appr_for_entity_code => p_approver_rec.arc_appr_for_entity_code,
488: p_appr_for_entity_id => p_approver_rec.appr_for_entity_id,

Line 696: -- Invoke table handler(Pv_Ge_Temp_Approvers_Pkg.Delete_Row)

692:
693: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
694: END IF;
695:
696: -- Invoke table handler(Pv_Ge_Temp_Approvers_Pkg.Delete_Row)
697: Pv_Ge_Temp_Approvers_Pkg.Delete_Row(
698: p_entity_approver_id => p_entity_approver_id,
699: p_object_version_number => p_object_version_number );
700: --

Line 697: Pv_Ge_Temp_Approvers_Pkg.Delete_Row(

693: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
694: END IF;
695:
696: -- Invoke table handler(Pv_Ge_Temp_Approvers_Pkg.Delete_Row)
697: Pv_Ge_Temp_Approvers_Pkg.Delete_Row(
698: p_entity_approver_id => p_entity_approver_id,
699: p_object_version_number => p_object_version_number );
700: --
701: -- End of API body

Line 852: Pv_Ge_Temp_Approvers_Pkg.Lock_Row(l_entity_approver_id,p_object_version);

848: x_return_status := FND_API.G_RET_STS_SUCCESS;
849:
850:
851: ------------------------ lock -------------------------
852: Pv_Ge_Temp_Approvers_Pkg.Lock_Row(l_entity_approver_id,p_object_version);
853:
854:
855: -------------------- finish --------------------------
856: FND_MSG_PUB.count_and_get(

Line 922: 'pv_ge_temp_approvers',

918: IF p_validation_mode = JTF_PLSQL_API.g_create
919: AND p_approver_rec.entity_approver_id IS NOT NULL
920: THEN
921: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
922: 'pv_ge_temp_approvers',
923: 'entity_approver_id = ''' || p_approver_rec.entity_approver_id ||''''
924: );
925: END IF;
926:

Line 1109: FROM pv_ge_temp_approvers

1105: l_return_status VARCHAR2(1);
1106:
1107: CURSOR c_complete IS
1108: SELECT *
1109: FROM pv_ge_temp_approvers
1110: WHERE entity_approver_id = p_approver_rec.entity_approver_id;
1111: l_approver_rec c_complete%ROWTYPE;
1112: BEGIN
1113: x_complete_rec := p_approver_rec;

Line 1395: END Pv_Ge_Temp_Approvers_PVT;

1391: p_data => x_msg_data
1392: );
1393: END Validate_approver_Rec;
1394:
1395: END Pv_Ge_Temp_Approvers_PVT;