APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_ARCHIVES

Line 5146: x_new_archive_id := allocateId('CZ_ARCHIVES_S');

5142: INVALID_ARCHIVE_ID_EXCP EXCEPTION;
5143: USER_IS_NULL_EXCP EXCEPTION;
5144:
5145: BEGIN
5146: x_new_archive_id := allocateId('CZ_ARCHIVES_S');
5147: INSERT INTO CZ_ARCHIVES(
5148: ARCHIVE_ID
5149: ,NAME
5150: ,DESCRIPTION

Line 5147: INSERT INTO CZ_ARCHIVES(

5143: USER_IS_NULL_EXCP EXCEPTION;
5144:
5145: BEGIN
5146: x_new_archive_id := allocateId('CZ_ARCHIVES_S');
5147: INSERT INTO CZ_ARCHIVES(
5148: ARCHIVE_ID
5149: ,NAME
5150: ,DESCRIPTION
5151: ,ARCHIVE_TYPE

Line 5168: FROM CZ_ARCHIVES

5164: ,ARCHIVE_URL
5165: ,PERSISTENT_ARCHIVE_ID
5166: ,DELETED_FLAG
5167: ,DOCUMENTATION_URL
5168: FROM CZ_ARCHIVES
5169: WHERE archive_id = p_archive_id;
5170:
5171: IF SQL%ROWCOUNT = 0 THEN
5172: RAISE INVALID_ARCHIVE_ID_EXCP;

Line 6617: UPDATE cz_archives

6613: and object_type = 'ARC'
6614: and deleted_flag = '0'
6615: and seeded_flag <> '1';
6616:
6617: UPDATE cz_archives
6618: SET cz_archives.deleted_flag = '1',
6619: cz_archives.name = append_name(p_archive_id, 'ARC', name)
6620: WHERE cz_archives.archive_id = p_archive_id;
6621: ELSE

Line 6618: SET cz_archives.deleted_flag = '1',

6614: and deleted_flag = '0'
6615: and seeded_flag <> '1';
6616:
6617: UPDATE cz_archives
6618: SET cz_archives.deleted_flag = '1',
6619: cz_archives.name = append_name(p_archive_id, 'ARC', name)
6620: WHERE cz_archives.archive_id = p_archive_id;
6621: ELSE
6622: x_return_status := l_return_status;

Line 6619: cz_archives.name = append_name(p_archive_id, 'ARC', name)

6615: and seeded_flag <> '1';
6616:
6617: UPDATE cz_archives
6618: SET cz_archives.deleted_flag = '1',
6619: cz_archives.name = append_name(p_archive_id, 'ARC', name)
6620: WHERE cz_archives.archive_id = p_archive_id;
6621: ELSE
6622: x_return_status := l_return_status;
6623: x_msg_count := l_msg_count;

Line 6620: WHERE cz_archives.archive_id = p_archive_id;

6616:
6617: UPDATE cz_archives
6618: SET cz_archives.deleted_flag = '1',
6619: cz_archives.name = append_name(p_archive_id, 'ARC', name)
6620: WHERE cz_archives.archive_id = p_archive_id;
6621: ELSE
6622: x_return_status := l_return_status;
6623: x_msg_count := l_msg_count;
6624: x_msg_data := l_msg_data;

Line 8407: UPDATE cz_archives

8403: DELETE FROM CZ_RP_ENTRIES
8404: WHERE OBJECT_TYPE = 'USG'
8405: AND OBJECT_ID = l_object_id_tbl(i);
8406: ELSIF (l_object_typ_tbl(i) = 'ARC') THEN
8407: UPDATE cz_archives
8408: SET deleted_flag = '1'
8409: WHERE archive_id = l_object_id_tbl(i);
8410: ELSIF (l_object_typ_tbl(i) = 'EFF') THEN
8411: UPDATE cz_effectivity_sets