APPS.CZ_MODELOPERATIONS_PUB dependencies on DUAL

Line 22: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

18: l_errbuf VARCHAR2(2000);
19: NOT_VALID_PROJECT_ID EXCEPTION;
20:
21: BEGIN
22: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
23: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
24: RAISE G_INCOMPATIBLE_API;
25: END IF;
26:

Line 123: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

119:
120: BEGIN
121: SAVEPOINT create_ui_PUB;
122:
123: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
124: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
125: RAISE G_INCOMPATIBLE_API;
126: END IF;
127:

Line 463: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

459: BEGIN
460: -- Start of API savepoint
461: SAVEPOINT refresh_ui_PUB;
462:
463: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
464: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
465: RAISE G_INCOMPATIBLE_API;
466: END IF;
467:

Line 1039: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

1035: l_status VARCHAR2(3);
1036: l_errbuf VARCHAR2(2000);
1037:
1038: BEGIN
1039: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
1040:
1041: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1042: RAISE G_INCOMPATIBLE_API;
1043: END IF;

Line 1102: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

1098: l_found NUMBER;
1099: NOT_VALID_PROJECT_ID EXCEPTION;
1100:
1101: BEGIN
1102: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
1103: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1104: RAISE G_INCOMPATIBLE_API;
1105: END IF;
1106:

Line 1191: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

1187:
1188: BEGIN
1189: SAVEPOINT execute_populator_PUB;
1190:
1191: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
1192: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1193: RAISE G_INCOMPATIBLE_API;
1194: END IF;
1195:

Line 1275: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

1271:
1272: BEGIN
1273: SAVEPOINT repopulate_PUB;
1274:
1275: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
1276: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1277: RAISE G_INCOMPATIBLE_API;
1278: END IF;
1279:

Line 1363: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

1359: l_start_date DATE;
1360: l_end_date DATE;
1361: l_publication_id NUMBER;
1362: BEGIN
1363: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
1364:
1365: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1366: RAISE G_INCOMPATIBLE_API;
1367: END IF;

Line 1566: FROM DUAL;

1562: WHEN NO_DATA_FOUND THEN
1563:
1564: SELECT cz_rp_entries_s.NEXTVAL
1565: INTO l_new_object_id
1566: FROM DUAL;
1567:
1568: INSERT INTO cz_rp_entries
1569: (object_id
1570: ,name