APPS.PVX_TIMEOUT_SETUP_PVT dependencies on PV_COUNTRY_TIMEOUTS

Line 52: SELECT PV_COUNTRY_TIMEOUTS_S.NEXTVAL

48: l_uniqueness_check VARCHAR2(10);
49:
50: -- Cursor to get the sequence for enty_attr_value
51: CURSOR c_timout_setup_seq IS
52: SELECT PV_COUNTRY_TIMEOUTS_S.NEXTVAL
53: FROM DUAL;
54:
55: -- Cursor to validate the uniqueness
56: CURSOR c_count(cv_timeout_setup_id IN NUMBER) IS

Line 58: FROM PV_COUNTRY_TIMEOUTS

54:
55: -- Cursor to validate the uniqueness
56: CURSOR c_count(cv_timeout_setup_id IN NUMBER) IS
57: SELECT 'ANYTHING'
58: FROM PV_COUNTRY_TIMEOUTS
59: WHERE timeout_id = cv_timeout_setup_id;
60:
61:
62: BEGIN

Line 142: INSERT INTO PV_COUNTRY_TIMEOUTS (

138: END IF;
139:
140:
141: --DBMS_output.put_line(l_full_name||': start insert');
142: INSERT INTO PV_COUNTRY_TIMEOUTS (
143: timeout_id
144: ,last_update_date
145: ,last_updated_by
146: ,creation_date

Line 289: DELETE FROM PV_country_timeouts

285: END IF;
286:
287:
288:
289: DELETE FROM PV_country_timeouts
290: WHERE timeout_id = p_timeout_id
291: AND object_version_number = p_object_version;
292:
293: IF (SQL%NOTFOUND) THEN

Line 455: UPDATE PV_COUNTRY_TIMEOUTS

451: PVX_Utility_PVT.debug_message(l_full_name ||': update');
452: END IF;
453:
454:
455: UPDATE PV_COUNTRY_TIMEOUTS
456: SET
457: last_update_date = SYSDATE
458: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)
459: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)

Line 578: FROM PV_COUNTRY_TIMEOUTS

574: l_uniqueness_check VARCHAR2(10);
575: -- check for uniqueness
576: CURSOR c_unique_timeout IS
577: SELECT 'ANYTHING'
578: FROM PV_COUNTRY_TIMEOUTS
579: WHERE country_code = p_timeout_setup_rec.country_code
580: AND timeout_type = p_timeout_setup_rec.timeout_type;
581:
582:

Line 810: FROM PV_COUNTRY_TIMEOUTS

806: l_timeout_id NUMBER;
807:
808: CURSOR c_timeout_setup IS
809: SELECT timeout_id
810: FROM PV_COUNTRY_TIMEOUTS
811: WHERE timeout_id = p_timeout_id
812: AND object_version_number = p_object_version
813: FOR UPDATE OF timeout_id NOWAIT;
814:

Line 929: FROM PV_COUNTRY_TIMEOUTS

925: IS
926:
927: CURSOR c_timeout_setup IS
928: SELECT *
929: FROM PV_COUNTRY_TIMEOUTS
930: WHERE timeout_id = p_timeout_setup_rec.timeout_id;
931:
932: l_timeout_setup_rec c_timeout_setup%ROWTYPE;
933: