APPS.CZ_LOGIC_GEN dependencies on CZ_LCE_HEADERS_S

Line 249: SELECT cz_lce_headers_s.NEXTVAL INTO last_id_allocated FROM DUAL;

245: BEGIN
246: IF((last_id_allocated IS NULL) OR
247: (next_id_to_use = (NVL(last_id_allocated, 0) + CZ_SEQUENCE_INCREMENT)))THEN
248:
249: SELECT cz_lce_headers_s.NEXTVAL INTO last_id_allocated FROM DUAL;
250: next_id_to_use := last_id_allocated;
251: END IF;
252:
253: id_to_return := next_id_to_use;

Line 11170: UPDATE cz_lce_headers SET deleted_flag = FLAG_DELETED

11166: END IF;
11167: END LOOP;
11168:
11169: FORALL i IN 1..OldHeaders.COUNT
11170: UPDATE cz_lce_headers SET deleted_flag = FLAG_DELETED
11171: WHERE lce_header_id = OldHeaders(i);
11172:
11173: FORALL i IN 1..OldHeaders.COUNT
11174: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_DELETED

Line 11178: UPDATE cz_lce_headers SET deleted_flag = FLAG_NOT_DELETED

11174: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_DELETED
11175: WHERE lce_header_id = OldHeaders(i);
11176:
11177: FORALL i IN 1..NewHeaders.COUNT
11178: UPDATE cz_lce_headers SET deleted_flag = FLAG_NOT_DELETED
11179: WHERE lce_header_id = NewHeaders(i);
11180:
11181: FORALL i IN 1..NewHeaders.COUNT
11182: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED

Line 11200: UPDATE cz_lce_headers SET deleted_flag = FLAG_DELETED

11196: PROCEDURE ROLLBACK_HEADERS IS
11197: BEGIN
11198:
11199: FORALL i IN 1..NewHeaders.COUNT
11200: UPDATE cz_lce_headers SET deleted_flag = FLAG_DELETED
11201: WHERE lce_header_id = NewHeaders(i);
11202:
11203: FORALL i IN 1..NewHeaders.COUNT
11204: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_DELETED

Line 11210: UPDATE cz_lce_headers SET deleted_flag = FLAG_NOT_DELETED

11206:
11207: IF(OldHeaders.COUNT > 0)THEN
11208:
11209: FORALL i IN 1..OldHeaders.COUNT
11210: UPDATE cz_lce_headers SET deleted_flag = FLAG_NOT_DELETED
11211: WHERE lce_header_id = OldHeaders(i);
11212:
11213: FORALL i IN 1..OldHeaders.COUNT
11214: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED