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 1043: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

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

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

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

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

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

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

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

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

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

Line 1570: FROM DUAL;

1566: WHEN NO_DATA_FOUND THEN
1567:
1568: SELECT cz_rp_entries_s.NEXTVAL
1569: INTO l_new_object_id
1570: FROM DUAL;
1571:
1572: INSERT INTO cz_rp_entries
1573: (object_id
1574: ,name