APPS.PV_ENTY_ATTR_VALIDATIONS_PVT dependencies on PV_ENTY_ATTR_VALIDATIONS

Line 1: PACKAGE BODY PV_ENTY_ATTR_VALIDATIONS_PVT AS

1: PACKAGE BODY PV_ENTY_ATTR_VALIDATIONS_PVT AS
2: /* $Header: pvxvatvb.pls 115.1 2002/12/10 19:19:29 amaram ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_ENTY_ATTR_VALIDATIONS_PVT

2: /* $Header: pvxvatvb.pls 115.1 2002/12/10 19:19:29 amaram ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_ENTY_ATTR_VALIDATIONS_PVT
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_ENTY_ATTR_VALIDATIONS_PVT';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_ENTY_ATTR_VALIDATIONS_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvatvb.pls';
19:
20: G_USER_ID NUMBER := NVL(FND_GLOBAL.USER_ID,-1);
21: G_LOGIN_ID NUMBER := NVL(FND_GLOBAL.CONC_LOGIN_ID,-1);

Line 51: SELECT PV_ENTY_ATTR_VALIDATIONS_S.NEXTVAL

47: l_dummy NUMBER;
48: l_enty_attr_validation_rec enty_attr_validation_rec_type := p_enty_attr_validation_rec;
49:
50: CURSOR c_id IS
51: SELECT PV_ENTY_ATTR_VALIDATIONS_S.NEXTVAL
52: FROM dual;
53:
54: CURSOR c_id_exists (l_id IN NUMBER) IS
55: SELECT 1

Line 56: FROM PV_ENTY_ATTR_VALIDATIONS

52: FROM dual;
53:
54: CURSOR c_id_exists (l_id IN NUMBER) IS
55: SELECT 1
56: FROM PV_ENTY_ATTR_VALIDATIONS
57: WHERE VALIDATION_ID = l_id;
58:
59: BEGIN
60: -- Standard Start of API savepoint

Line 167: PV_ENTY_ATTR_VALIDATIONS_PKG.Insert_Row(

163: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
164: END IF;
165:
166: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Insert_Row)
167: PV_ENTY_ATTR_VALIDATIONS_PKG.Insert_Row(
168: px_enty_attr_validation_id => l_enty_attr_validation_rec.validation_id
169: ,p_last_update_date => l_enty_attr_validation_rec.last_update_date
170: ,p_last_updated_by => l_enty_attr_validation_rec.last_updated_by
171: ,p_creation_date => l_enty_attr_validation_rec.creation_date

Line 270: FROM PV_ENTY_ATTR_VALIDATIONS

266: IS
267:
268: CURSOR c_get_enty_attr_validation(cv_enty_attr_validation_id NUMBER) IS
269: SELECT *
270: FROM PV_ENTY_ATTR_VALIDATIONS
271: WHERE validation_id = cv_enty_attr_validation_id;
272:
273: l_api_name CONSTANT VARCHAR2(30) := 'Update_Enty_Attr_Validation';
274: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 280: l_tar_enty_attr_validation_rec PV_ENTY_ATTR_VALIDATIONS_PVT.enty_attr_validation_rec_type := p_enty_attr_validation_rec;

276: -- Local Variables
277: l_object_version_number NUMBER;
278: l_enty_attr_val_id NUMBER;
279: l_ref_enty_attr_validation_rec c_get_Enty_Attr_Validation%ROWTYPE ;
280: l_tar_enty_attr_validation_rec PV_ENTY_ATTR_VALIDATIONS_PVT.enty_attr_validation_rec_type := p_enty_attr_validation_rec;
281: l_rowid ROWID;
282:
283: BEGIN
284: -- Standard Start of API savepoint

Line 390: PV_ENTY_ATTR_VALIDATIONS_PKG.Update_Row(

386: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
387: END IF;
388:
389: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Update_Row)
390: PV_ENTY_ATTR_VALIDATIONS_PKG.Update_Row(
391: p_enty_attr_validation_id => p_enty_attr_validation_rec.validation_id
392: ,p_last_update_date => SYSDATE
393: ,p_last_updated_by => G_USER_ID
394: -- p_creation_date => SYSDATE

Line 524: -- Invoke table handler(PV_ENTY_ATTR_VALIDATIONS_PKG.Delete_Row)

520: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
521: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
522: END IF;
523:
524: -- Invoke table handler(PV_ENTY_ATTR_VALIDATIONS_PKG.Delete_Row)
525: PV_ENTY_ATTR_VALIDATIONS_PKG.Delete_Row(
526: p_enty_attr_validation_id => p_enty_attr_validation_id);
527: --
528: -- End of API body

Line 525: PV_ENTY_ATTR_VALIDATIONS_PKG.Delete_Row(

521: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
522: END IF;
523:
524: -- Invoke table handler(PV_ENTY_ATTR_VALIDATIONS_PKG.Delete_Row)
525: PV_ENTY_ATTR_VALIDATIONS_PKG.Delete_Row(
526: p_enty_attr_validation_id => p_enty_attr_validation_id);
527: --
528: -- End of API body
529: --

Line 611: FROM PV_ENTY_ATTR_VALIDATIONS

607: l_ENTY_ATTR_VALIDATION_ID NUMBER;
608:
609: CURSOR c_Enty_Attr_Validation IS
610: SELECT VALIDATION_ID
611: FROM PV_ENTY_ATTR_VALIDATIONS
612: WHERE VALIDATION_ID = p_ENTY_ATTR_VALIDATION_ID
613: AND object_version_number = p_object_version
614: FOR UPDATE NOWAIT;
615:

Line 731: 'PV_ENTY_ATTR_VALIDATIONS'

727:
728: x_return_status := FND_API.g_ret_sts_success;
729: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
730: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
731: 'PV_ENTY_ATTR_VALIDATIONS'
732: ,'VALIDATION_ID = ''' || p_enty_attr_validation_rec.VALIDATION_ID ||''''
733: );
734: ELSE
735: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

Line 736: 'PV_ENTY_ATTR_VALIDATIONS'

732: ,'VALIDATION_ID = ''' || p_enty_attr_validation_rec.VALIDATION_ID ||''''
733: );
734: ELSE
735: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
736: 'PV_ENTY_ATTR_VALIDATIONS'
737: ,'VALIDATION_ID = ''' || p_enty_attr_validation_rec.VALIDATION_ID ||
738: ''' AND VALIDATION_ID <> ' || p_enty_attr_validation_rec.VALIDATION_ID
739: );
740: END IF;

Line 1088: FROM pv_enty_attr_validations

1084: l_return_status VARCHAR2(1);
1085:
1086: CURSOR c_complete IS
1087: SELECT *
1088: FROM pv_enty_attr_validations
1089: WHERE validation_id = p_enty_attr_validation_rec.validation_id;
1090: l_pv_enty_attr_validation_rec c_complete%ROWTYPE;
1091: BEGIN
1092: x_complete_rec := p_enty_attr_validation_rec;

Line 1344: END PV_ENTY_ATTR_VALIDATIONS_PVT;

1340: ,p_data => x_msg_data
1341: );
1342: END Validate_enty_attr_vldtn_rec;
1343:
1344: END PV_ENTY_ATTR_VALIDATIONS_PVT;