APPS.PVX_PRTNR_PRFLS_PVT dependencies on PV_PARTNER_PROFILES

Line 59: SELECT PV_partner_profiles_S.NEXTVAL

55:
56:
57: -- Cursor to get the sequence for prtnr_prfls
58: CURSOR c_prtnr_prfls_seq IS
59: SELECT PV_partner_profiles_S.NEXTVAL
60: FROM DUAL;
61:
62: -- Cursor to validate the uniqueness
63: CURSOR c_count(cv_partner_profile_id IN NUMBER) IS

Line 65: FROM PV_partner_profiles

61:
62: -- Cursor to validate the uniqueness
63: CURSOR c_count(cv_partner_profile_id IN NUMBER) IS
64: SELECT 'ANYTHING'
65: FROM PV_partner_profiles
66: WHERE partner_profile_id = cv_partner_profile_id;
67:
68:
69: BEGIN

Line 154: INSERT INTO PV_partner_profiles (

150: l_status := l_prtnr_prfls_rec.status;
151: END IF;
152:
153: --dbms_output.put_line(l_full_name||': start insert');
154: INSERT INTO PV_partner_profiles (
155: partner_profile_id
156: ,last_update_date
157: ,last_updated_by
158: ,creation_date

Line 349: DELETE FROM PV_PARTNER_PROFILES

345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
346: PVX_Utility_PVT.debug_message(l_full_name ||': delete');
347: END IF;
348:
349: DELETE FROM PV_PARTNER_PROFILES
350: WHERE partner_profile_id = p_partner_profile_id
351: AND object_version_number = p_object_version;
352:
353: IF (SQL%NOTFOUND) THEN

Line 441: FROM PV_PARTNER_PROFILES

437: l_partner_profile_id NUMBER;
438:
439: CURSOR c_prtnr_prfls IS
440: SELECT partner_profile_id
441: FROM PV_PARTNER_PROFILES
442: WHERE partner_profile_id = p_partner_profile_id
443: AND object_version_number = p_object_version
444: FOR UPDATE OF partner_profile_id NOWAIT;
445:

Line 579: FROM pv_partner_profiles

575: -- Cursor to select old status value
576:
577: CURSOR c_prtnr_status IS
578: SELECT NVL(status, 'A') partner_status
579: FROM pv_partner_profiles
580: WHERE partner_profile_id = p_prtnr_prfls_rec.partner_profile_id;
581:
582: -- Cursor : cur_related_record
583: CURSOR cur_related_record (var_partner_id IN NUMBER) IS

Line 585: FROM pv_partner_profiles

581:
582: -- Cursor : cur_related_record
583: CURSOR cur_related_record (var_partner_id IN NUMBER) IS
584: SELECT partner_id, partner_profile_id, object_version_number
585: FROM pv_partner_profiles
586: WHERE related_partner_id = var_partner_id;
587: -- Cursor record
588: currec_related_record cur_related_record%ROWTYPE;
589:

Line 723: UPDATE PV_PARTNER_PROFILES SET

719: l_list.DELETE;
720:
721: END IF;
722:
723: UPDATE PV_PARTNER_PROFILES SET
724: last_update_date = SYSDATE
725: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)
726: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)
727: ,PARTNER_ID = l_prtnr_prfls_rec.PARTNER_ID

Line 1170: 'PV_PARTNER_PROFILES',

1166: IF p_validation_mode = JTF_PLSQL_API.g_create
1167: AND p_prtnr_prfls_rec.partner_profile_id IS NOT NULL
1168: THEN
1169: IF PVX_Utility_PVT.check_uniqueness(
1170: 'PV_PARTNER_PROFILES',
1171: 'partner_profile_id = ' || p_prtnr_prfls_rec.partner_profile_id
1172: ) = FND_API.g_false
1173: THEN
1174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1451: FROM PV_PARTNER_PROFILES

1447: IS
1448:
1449: CURSOR c_prtnr_prfls IS
1450: SELECT *
1451: FROM PV_PARTNER_PROFILES
1452: WHERE partner_profile_id = p_prtnr_prfls_rec.partner_profile_id;
1453:
1454: l_prtnr_prfls_rec c_prtnr_prfls%ROWTYPE;
1455: