APPS.PVX_LEAD_PSS_LINES_PVT dependencies on PV_LEAD_PSS_LINES

Line 58: SELECT PV_LEAD_PSS_LINES_S.NEXTVAL

54:
55:
56: -- Cursor to get the sequence for enty_attr_value
57: CURSOR c_lead_pss_lines_seq IS
58: SELECT PV_LEAD_PSS_LINES_S.NEXTVAL
59: FROM DUAL;
60:
61: -- Cursor to validate the uniqueness
62: CURSOR c_count(cv_lead_pss_line_id IN NUMBER) IS

Line 64: FROM pv_lead_pss_lines

60:
61: -- Cursor to validate the uniqueness
62: CURSOR c_count(cv_lead_pss_line_id IN NUMBER) IS
63: SELECT 'X'
64: FROM pv_lead_pss_lines
65: WHERE lead_pss_line_id = cv_lead_pss_line_id;
66:
67:
68: BEGIN

Line 145: INSERT INTO PV_LEAD_PSS_LINES (

141: END LOOP;
142: END IF;
143:
144:
145: INSERT INTO PV_LEAD_PSS_LINES (
146: lead_pss_line_id
147: ,last_update_date
148: ,last_updated_by
149: ,creation_date

Line 341: DELETE FROM PV_LEAD_PSS_LINES

337: PVX_Utility_PVT.debug_message(l_full_name ||': delete');
338: END IF;
339:
340:
341: DELETE FROM PV_LEAD_PSS_LINES
342: WHERE lead_pss_line_id = p_lead_pss_line_id
343: AND object_version_number = p_object_version;
344:
345: IF (SQL%NOTFOUND) THEN

Line 435: FROM pv_lead_pss_lines

431: l_lead_pss_line_id NUMBER;
432:
433: CURSOR c_lead_pss_line IS
434: SELECT lead_pss_line_id
435: FROM pv_lead_pss_lines
436: WHERE lead_pss_line_id = p_lead_pss_line_id
437: AND object_version_number = p_object_version
438: FOR UPDATE OF lead_pss_line_id NOWAIT;
439:

Line 646: UPDATE PV_LEAD_PSS_LINES SET

642: END IF;
643:
644:
645:
646: UPDATE PV_LEAD_PSS_LINES SET
647: last_update_date = SYSDATE
648: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)
649: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)
650: ,request_id = l_lead_pss_lines_rec.request_id

Line 973: 'PV_lead_pss_lines',

969: IF p_validation_mode = JTF_PLSQL_API.g_create
970: AND p_lead_pss_lines_rec.lead_pss_line_id IS NOT NULL
971: THEN
972: IF PVX_Utility_PVT.check_uniqueness(
973: 'PV_lead_pss_lines',
974: 'lead_pss_line_id = ' || p_lead_pss_lines_rec.lead_pss_line_id
975: ) = FND_API.g_false
976: THEN
977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1301: FROM PV_lead_pss_lines

1297: IS
1298:
1299: CURSOR c_lead_pss_line IS
1300: SELECT *
1301: FROM PV_lead_pss_lines
1302: WHERE lead_pss_line_id = p_lead_pss_lines_rec.lead_pss_line_id;
1303:
1304: l_lead_pss_lines_rec c_Lead_pss_line%ROWTYPE;
1305: