eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_RP_ENTRIES

Line 269: FROM cz_rp_entries

265:
266: --check if p_rp_folder_id exists
267: SELECT object_id
268: INTO l_rp_folder
269: FROM cz_rp_entries
270: WHERE cz_rp_entries.object_id = p_rp_folder_id
271: AND cz_rp_entries.object_type = 'FLD'
272: AND cz_rp_entries.deleted_flag = '0';
273:

Line 270: WHERE cz_rp_entries.object_id = p_rp_folder_id

266: --check if p_rp_folder_id exists
267: SELECT object_id
268: INTO l_rp_folder
269: FROM cz_rp_entries
270: WHERE cz_rp_entries.object_id = p_rp_folder_id
271: AND cz_rp_entries.object_type = 'FLD'
272: AND cz_rp_entries.deleted_flag = '0';
273:
274: l_rp_fld_tbl.DELETE;

Line 271: AND cz_rp_entries.object_type = 'FLD'

267: SELECT object_id
268: INTO l_rp_folder
269: FROM cz_rp_entries
270: WHERE cz_rp_entries.object_id = p_rp_folder_id
271: AND cz_rp_entries.object_type = 'FLD'
272: AND cz_rp_entries.deleted_flag = '0';
273:
274: l_rp_fld_tbl.DELETE;
275:

Line 272: AND cz_rp_entries.deleted_flag = '0';

268: INTO l_rp_folder
269: FROM cz_rp_entries
270: WHERE cz_rp_entries.object_id = p_rp_folder_id
271: AND cz_rp_entries.object_type = 'FLD'
272: AND cz_rp_entries.deleted_flag = '0';
273:
274: l_rp_fld_tbl.DELETE;
275:
276: -- Get all folders and subfolders

Line 281: FROM cz_rp_entries

277: SELECT object_id
278: BULK
279: COLLECT
280: INTO l_rp_fld_tbl
281: FROM cz_rp_entries
282: WHERE cz_rp_entries.deleted_flag = '0'
283: AND cz_rp_entries.object_type = 'FLD'
284: START WITH cz_rp_entries.object_type = 'FLD'
285: AND cz_rp_entries.object_id = l_rp_folder

Line 282: WHERE cz_rp_entries.deleted_flag = '0'

278: BULK
279: COLLECT
280: INTO l_rp_fld_tbl
281: FROM cz_rp_entries
282: WHERE cz_rp_entries.deleted_flag = '0'
283: AND cz_rp_entries.object_type = 'FLD'
284: START WITH cz_rp_entries.object_type = 'FLD'
285: AND cz_rp_entries.object_id = l_rp_folder
286: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder

Line 283: AND cz_rp_entries.object_type = 'FLD'

279: COLLECT
280: INTO l_rp_fld_tbl
281: FROM cz_rp_entries
282: WHERE cz_rp_entries.deleted_flag = '0'
283: AND cz_rp_entries.object_type = 'FLD'
284: START WITH cz_rp_entries.object_type = 'FLD'
285: AND cz_rp_entries.object_id = l_rp_folder
286: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
287: AND PRIOR cz_rp_entries.object_type = 'FLD';

Line 284: START WITH cz_rp_entries.object_type = 'FLD'

280: INTO l_rp_fld_tbl
281: FROM cz_rp_entries
282: WHERE cz_rp_entries.deleted_flag = '0'
283: AND cz_rp_entries.object_type = 'FLD'
284: START WITH cz_rp_entries.object_type = 'FLD'
285: AND cz_rp_entries.object_id = l_rp_folder
286: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
287: AND PRIOR cz_rp_entries.object_type = 'FLD';
288:

Line 285: AND cz_rp_entries.object_id = l_rp_folder

281: FROM cz_rp_entries
282: WHERE cz_rp_entries.deleted_flag = '0'
283: AND cz_rp_entries.object_type = 'FLD'
284: START WITH cz_rp_entries.object_type = 'FLD'
285: AND cz_rp_entries.object_id = l_rp_folder
286: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
287: AND PRIOR cz_rp_entries.object_type = 'FLD';
288:
289: IF (l_rp_fld_tbl.COUNT > 0) THEN

Line 286: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder

282: WHERE cz_rp_entries.deleted_flag = '0'
283: AND cz_rp_entries.object_type = 'FLD'
284: START WITH cz_rp_entries.object_type = 'FLD'
285: AND cz_rp_entries.object_id = l_rp_folder
286: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
287: AND PRIOR cz_rp_entries.object_type = 'FLD';
288:
289: IF (l_rp_fld_tbl.COUNT > 0) THEN
290: FOR I IN l_rp_fld_tbl.FIRST..l_rp_fld_tbl.LAST

Line 287: AND PRIOR cz_rp_entries.object_type = 'FLD';

283: AND cz_rp_entries.object_type = 'FLD'
284: START WITH cz_rp_entries.object_type = 'FLD'
285: AND cz_rp_entries.object_id = l_rp_folder
286: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
287: AND PRIOR cz_rp_entries.object_type = 'FLD';
288:
289: IF (l_rp_fld_tbl.COUNT > 0) THEN
290: FOR I IN l_rp_fld_tbl.FIRST..l_rp_fld_tbl.LAST
291: LOOP

Line 298: FROM cz_rp_entries, cz_devl_projects

294: l_rp_model_tbl.DELETE;
295: SELECT object_id, checkout_user, cz_devl_projects.name
296: BULK COLLECT
297: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
298: FROM cz_rp_entries, cz_devl_projects
299: WHERE cz_rp_entries.object_type = 'PRJ'
300: AND cz_rp_entries.deleted_flag = '0'
301: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
302: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;

Line 299: WHERE cz_rp_entries.object_type = 'PRJ'

295: SELECT object_id, checkout_user, cz_devl_projects.name
296: BULK COLLECT
297: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
298: FROM cz_rp_entries, cz_devl_projects
299: WHERE cz_rp_entries.object_type = 'PRJ'
300: AND cz_rp_entries.deleted_flag = '0'
301: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
302: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
303:

Line 300: AND cz_rp_entries.deleted_flag = '0'

296: BULK COLLECT
297: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
298: FROM cz_rp_entries, cz_devl_projects
299: WHERE cz_rp_entries.object_type = 'PRJ'
300: AND cz_rp_entries.deleted_flag = '0'
301: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
302: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
303:
304: IF (l_rp_model_tbl.COUNT > 0) THEN

Line 301: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)

297: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
298: FROM cz_rp_entries, cz_devl_projects
299: WHERE cz_rp_entries.object_type = 'PRJ'
300: AND cz_rp_entries.deleted_flag = '0'
301: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
302: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
303:
304: IF (l_rp_model_tbl.COUNT > 0) THEN
305: FOR J IN l_rp_model_tbl.FIRST..l_rp_model_tbl.LAST

Line 302: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;

298: FROM cz_rp_entries, cz_devl_projects
299: WHERE cz_rp_entries.object_type = 'PRJ'
300: AND cz_rp_entries.deleted_flag = '0'
301: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
302: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
303:
304: IF (l_rp_model_tbl.COUNT > 0) THEN
305: FOR J IN l_rp_model_tbl.FIRST..l_rp_model_tbl.LAST
306: LOOP

Line 322: FROM cz_rp_entries, cz_ui_templates

318: l_uct_tbl.DELETE;
319: SELECT object_id, checkout_user, template_name
320: BULK COLLECT
321: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
322: FROM cz_rp_entries, cz_ui_templates
323: WHERE cz_rp_entries.object_type = 'UCT'
324: AND cz_rp_entries.deleted_flag = '0'
325: AND cz_rp_entries.seeded_flag <> '1'
326: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)

Line 323: WHERE cz_rp_entries.object_type = 'UCT'

319: SELECT object_id, checkout_user, template_name
320: BULK COLLECT
321: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
322: FROM cz_rp_entries, cz_ui_templates
323: WHERE cz_rp_entries.object_type = 'UCT'
324: AND cz_rp_entries.deleted_flag = '0'
325: AND cz_rp_entries.seeded_flag <> '1'
326: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
327: AND cz_rp_entries.object_id = cz_ui_templates.template_id

Line 324: AND cz_rp_entries.deleted_flag = '0'

320: BULK COLLECT
321: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
322: FROM cz_rp_entries, cz_ui_templates
323: WHERE cz_rp_entries.object_type = 'UCT'
324: AND cz_rp_entries.deleted_flag = '0'
325: AND cz_rp_entries.seeded_flag <> '1'
326: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
327: AND cz_rp_entries.object_id = cz_ui_templates.template_id
328: AND cz_ui_templates.ui_def_id = 0;

Line 325: AND cz_rp_entries.seeded_flag <> '1'

321: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
322: FROM cz_rp_entries, cz_ui_templates
323: WHERE cz_rp_entries.object_type = 'UCT'
324: AND cz_rp_entries.deleted_flag = '0'
325: AND cz_rp_entries.seeded_flag <> '1'
326: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
327: AND cz_rp_entries.object_id = cz_ui_templates.template_id
328: AND cz_ui_templates.ui_def_id = 0;
329:

Line 326: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)

322: FROM cz_rp_entries, cz_ui_templates
323: WHERE cz_rp_entries.object_type = 'UCT'
324: AND cz_rp_entries.deleted_flag = '0'
325: AND cz_rp_entries.seeded_flag <> '1'
326: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
327: AND cz_rp_entries.object_id = cz_ui_templates.template_id
328: AND cz_ui_templates.ui_def_id = 0;
329:
330: IF (l_uct_tbl.COUNT > 0) THEN

Line 327: AND cz_rp_entries.object_id = cz_ui_templates.template_id

323: WHERE cz_rp_entries.object_type = 'UCT'
324: AND cz_rp_entries.deleted_flag = '0'
325: AND cz_rp_entries.seeded_flag <> '1'
326: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
327: AND cz_rp_entries.object_id = cz_ui_templates.template_id
328: AND cz_ui_templates.ui_def_id = 0;
329:
330: IF (l_uct_tbl.COUNT > 0) THEN
331: FOR J IN l_uct_tbl.FIRST..l_uct_tbl.LAST

Line 3144: l_name CZ_RP_ENTRIES.name%TYPE;

3140: p_object_id IN NUMBER,
3141: p_object_type IN VARCHAR2
3142: ) RETURN VARCHAR2 IS
3143:
3144: l_name CZ_RP_ENTRIES.name%TYPE;
3145: l_root_name CZ_RP_ENTRIES.name%TYPE;
3146: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3147: l_repository_path VARCHAR2(32000);
3148:

Line 3145: l_root_name CZ_RP_ENTRIES.name%TYPE;

3141: p_object_type IN VARCHAR2
3142: ) RETURN VARCHAR2 IS
3143:
3144: l_name CZ_RP_ENTRIES.name%TYPE;
3145: l_root_name CZ_RP_ENTRIES.name%TYPE;
3146: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3147: l_repository_path VARCHAR2(32000);
3148:
3149: BEGIN

Line 3146: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;

3142: ) RETURN VARCHAR2 IS
3143:
3144: l_name CZ_RP_ENTRIES.name%TYPE;
3145: l_root_name CZ_RP_ENTRIES.name%TYPE;
3146: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3147: l_repository_path VARCHAR2(32000);
3148:
3149: BEGIN
3150:

Line 3151: SELECT name,enclosing_folder INTO l_repository_path,l_enclosing_folder FROM CZ_RP_ENTRIES

3147: l_repository_path VARCHAR2(32000);
3148:
3149: BEGIN
3150:
3151: SELECT name,enclosing_folder INTO l_repository_path,l_enclosing_folder FROM CZ_RP_ENTRIES
3152: WHERE object_id=p_object_id AND object_type=p_object_type AND deleted_flag='0';
3153:
3154: l_repository_path := set_name_entity(l_repository_path);
3155:

Line 3157: FOR i IN(SELECT name FROM CZ_RP_ENTRIES

3153:
3154: l_repository_path := set_name_entity(l_repository_path);
3155:
3156: IF l_enclosing_folder<>0 THEN
3157: FOR i IN(SELECT name FROM CZ_RP_ENTRIES
3158: START WITH object_id=l_enclosing_folder AND object_type='FLD' AND deleted_flag='0'
3159: CONNECT BY PRIOR enclosing_folder=object_id
3160: AND deleted_flag='0' AND PRIOR deleted_flag='0'
3161: AND object_type='FLD' AND PRIOR object_type='FLD' AND object_id<>0 AND PRIOR object_id<>0)

Line 3171: SELECT name INTO l_root_name FROM CZ_RP_ENTRIES

3167: END IF;
3168:
3169: IF NOT(l_enclosing_folder=0 AND p_object_id=0 AND p_object_type='FLD') THEN
3170: BEGIN
3171: SELECT name INTO l_root_name FROM CZ_RP_ENTRIES
3172: WHERE object_id=0 AND object_type='FLD' AND deleted_flag='0' AND rownum<2;
3173:
3174: --If the name contains special symbols, enclose the name in single quotes.
3175:

Line 3199: l_name CZ_RP_ENTRIES.name%TYPE;

3195: p_rule_folder_id IN NUMBER,
3196: p_object_type IN VARCHAR2
3197: ) RETURN VARCHAR2 IS
3198:
3199: l_name CZ_RP_ENTRIES.name%TYPE;
3200: l_root_name CZ_RP_ENTRIES.name%TYPE;
3201: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3202: l_rule_folder_path VARCHAR2(32000);
3203:

Line 3200: l_root_name CZ_RP_ENTRIES.name%TYPE;

3196: p_object_type IN VARCHAR2
3197: ) RETURN VARCHAR2 IS
3198:
3199: l_name CZ_RP_ENTRIES.name%TYPE;
3200: l_root_name CZ_RP_ENTRIES.name%TYPE;
3201: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3202: l_rule_folder_path VARCHAR2(32000);
3203:
3204: BEGIN

Line 3201: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;

3197: ) RETURN VARCHAR2 IS
3198:
3199: l_name CZ_RP_ENTRIES.name%TYPE;
3200: l_root_name CZ_RP_ENTRIES.name%TYPE;
3201: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3202: l_rule_folder_path VARCHAR2(32000);
3203:
3204: BEGIN
3205:

Line 3347: l_folder_name cz_rp_entries.name%TYPE;

3343: l_model_id NUMBER;
3344: l_run_id NUMBER;
3345: l_status VARCHAR2(255);
3346: l_new_id NUMBER;
3347: l_folder_name cz_rp_entries.name%TYPE;
3348:
3349: BEGIN
3350:
3351: --initialize the message stack depending on the input parameter

Line 3361: FROM cz_rp_entries

3357: x_return_status := FND_API.G_RET_STS_SUCCESS;
3358:
3359: BEGIN
3360: SELECT name INTO l_folder_name
3361: FROM cz_rp_entries
3362: WHERE object_id = p_encl_folder_id
3363: AND object_type = 'FLD'
3364: AND deleted_flag = '0';
3365: EXCEPTION

Line 3373: FROM CZ_RP_ENTRIES

3369:
3370: BEGIN
3371: SELECT object_id,object_type , enclosing_folder
3372: BULK COLLECT INTO l_object_id_tbl,l_object_type_tbl, l_encl_folder_tbl
3373: FROM CZ_RP_ENTRIES
3374: START WITH object_id=p_folder_id AND object_type='FLD' AND deleted_flag='0'
3375: CONNECT BY PRIOR object_id=ENCLOSING_FOLDER AND PRIOR object_type = 'FLD' AND deleted_flag='0'
3376: AND PRIOR deleted_flag='0';
3377:

Line 3405: l_new_object_id_tbl(i) := allocateId('CZ_RP_ENTRIES_S');

3401: END LOOP;
3402: END IF;
3403:
3404: IF l_object_type_tbl(i)='FLD' THEN
3405: l_new_object_id_tbl(i) := allocateId('CZ_RP_ENTRIES_S');
3406:
3407: -- Create the new folder
3408:
3409: INSERT INTO CZ_RP_ENTRIES

Line 3409: INSERT INTO CZ_RP_ENTRIES

3405: l_new_object_id_tbl(i) := allocateId('CZ_RP_ENTRIES_S');
3406:
3407: -- Create the new folder
3408:
3409: INSERT INTO CZ_RP_ENTRIES
3410: (
3411: OBJECT_TYPE
3412: ,OBJECT_ID
3413: ,ENCLOSING_FOLDER

Line 3429: FROM CZ_RP_ENTRIES

3425: ,DESCRIPTION
3426: ,NOTES
3427: ,0
3428: ,DELETED_FLAG
3429: FROM CZ_RP_ENTRIES
3430: WHERE object_id=l_object_id_tbl(i) AND object_type=l_object_type_tbl(i)
3431: AND deleted_flag='0';
3432:
3433: ELSIF l_object_type_tbl(i)='EFF' THEN

Line 3867: FROM cz_rp_entries

3863: AND r.ui_def_id = d.ui_def_id
3864: AND d.deleted_flag = '0'
3865: AND r.deleted_flag = '0'
3866: AND d.devl_project_id IN (SELECT object_id
3867: FROM cz_rp_entries
3868: WHERE cz_rp_entries.object_type = 'PRJ'
3869: AND cz_rp_entries.deleted_flag = '0');
3870:
3871: ---------------------------------

Line 3868: WHERE cz_rp_entries.object_type = 'PRJ'

3864: AND d.deleted_flag = '0'
3865: AND r.deleted_flag = '0'
3866: AND d.devl_project_id IN (SELECT object_id
3867: FROM cz_rp_entries
3868: WHERE cz_rp_entries.object_type = 'PRJ'
3869: AND cz_rp_entries.deleted_flag = '0');
3870:
3871: ---------------------------------
3872: -- referencing UI Defs HTML Style

Line 3869: AND cz_rp_entries.deleted_flag = '0');

3865: AND r.deleted_flag = '0'
3866: AND d.devl_project_id IN (SELECT object_id
3867: FROM cz_rp_entries
3868: WHERE cz_rp_entries.object_type = 'PRJ'
3869: AND cz_rp_entries.deleted_flag = '0');
3870:
3871: ---------------------------------
3872: -- referencing UI Defs HTML Style
3873: ---------------------------------

Line 4586: -- p_model_id - object_id in cz_rp_entries where object_type = 'PRJ'

4582:
4583: --
4584: -- is_model_deleteable
4585: -- Parameters :
4586: -- p_model_id - object_id in cz_rp_entries where object_type = 'PRJ'
4587: -- x_return_status - status string: 'S', 'E', 'U'
4588: -- x_msg_count - number of error messages
4589: -- x_msg_data - string which contains error messages
4590:

Line 4641: FROM cz_rp_entries a, cz_devl_projects b

4637: ------------------------------
4638: BEGIN
4639: SELECT a.seeded_flag, a.name, a.deleted_flag, checkout_user
4640: INTO l_seeded_flag, l_model_name, l_deleted_flag, l_checkout_user
4641: FROM cz_rp_entries a, cz_devl_projects b
4642: WHERE object_id = p_model_id
4643: AND object_type = 'PRJ'
4644: AND object_id = devl_project_id;
4645: EXCEPTION

Line 4874: UPDATE cz_rp_entries

4870: x_msg_data => x_msg_data);
4871: ELSE
4872: l_usage_name := copy_name(p_model_usage_id,'USG');
4873:
4874: UPDATE cz_rp_entries
4875: SET name = l_usage_name
4876: WHERE object_id = usageID
4877: AND object_type = 'USG';
4878:

Line 4925: l_name cz_rp_entries.name%TYPE;

4921: l_api_version CONSTANT NUMBER := 1.0;
4922: l_api_name CONSTANT VARCHAR2(30) := 'copy_property';
4923: INVALID_PROPERTY_ID_EXCP EXCEPTION;
4924: USER_IS_NULL_EXCP EXCEPTION;
4925: l_name cz_rp_entries.name%TYPE;
4926: l_new_intl_text_id cz_localized_texts.intl_text_id%TYPE;
4927: l_text_id NUMBER;
4928:
4929: BEGIN

Line 5004: INSERT INTO CZ_RP_ENTRIES

5000: END LOOP;
5001:
5002: --Create Repository Entry
5003:
5004: INSERT INTO CZ_RP_ENTRIES
5005: (
5006: OBJECT_TYPE
5007: ,OBJECT_ID
5008: ,ENCLOSING_FOLDER

Line 5024: FROM CZ_RP_ENTRIES

5020: ,DESCRIPTION
5021: ,NOTES
5022: ,'0'
5023: ,DELETED_FLAG
5024: FROM CZ_RP_ENTRIES
5025: WHERE object_id= p_property_id AND object_type='PRP'
5026: AND deleted_flag='0';
5027:
5028: IF SQL%ROWCOUNT = 0 THEN

Line 5068: l_name cz_rp_entries.name%TYPE;

5064: l_api_version CONSTANT NUMBER := 1.0;
5065: l_api_name CONSTANT VARCHAR2(30) := 'copy_effectivity_set';
5066: INVALID_EFF_SET_ID_EXCP EXCEPTION;
5067: USER_IS_NULL_EXCP EXCEPTION;
5068: l_name cz_rp_entries.name%TYPE;
5069: BEGIN
5070: FND_MSG_PUB.initialize;
5071: x_return_status := FND_API.G_RET_STS_SUCCESS;
5072: x_new_effectivity_set_id := allocateId('CZ_EFFECTIVITY_SETS_S');

Line 5074: INSERT INTO CZ_RP_ENTRIES

5070: FND_MSG_PUB.initialize;
5071: x_return_status := FND_API.G_RET_STS_SUCCESS;
5072: x_new_effectivity_set_id := allocateId('CZ_EFFECTIVITY_SETS_S');
5073: l_name := copy_name(p_effectivity_set_id,'EFF');
5074: INSERT INTO CZ_RP_ENTRIES
5075: (
5076: OBJECT_TYPE
5077: ,OBJECT_ID
5078: ,ENCLOSING_FOLDER

Line 5094: FROM CZ_RP_ENTRIES

5090: ,DESCRIPTION
5091: ,NOTES
5092: ,'0'
5093: ,DELETED_FLAG
5094: FROM CZ_RP_ENTRIES
5095: WHERE object_id= p_effectivity_set_id AND object_type='EFF'
5096: AND deleted_flag='0';
5097:
5098: IF SQL%ROWCOUNT = 0 THEN

Line 5206: INSERT INTO CZ_RP_ENTRIES

5202: END IF;
5203:
5204: --Create Repository Entry
5205:
5206: INSERT INTO CZ_RP_ENTRIES
5207: (
5208: OBJECT_TYPE
5209: ,OBJECT_ID
5210: ,ENCLOSING_FOLDER

Line 5226: FROM CZ_RP_ENTRIES

5222: ,DESCRIPTION
5223: ,NOTES
5224: ,'0'
5225: ,DELETED_FLAG
5226: FROM CZ_RP_ENTRIES
5227: WHERE object_id= p_archive_id AND object_type='ARC'
5228: AND deleted_flag='0';
5229:
5230: IF SQL%ROWCOUNT = 0 THEN

Line 5939: l_name cz_rp_entries.name%TYPE;

5935: -- l_api_name CONSTANT VARCHAR2(30) := 'copy_ui_template';
5936: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5937: l_copied_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5938: INVALID_TEMPLATE_ID_EXCP EXCEPTION;
5939: l_name cz_rp_entries.name%TYPE;
5940: l_title_id NUMBER;
5941: l_main_message_id NUMBER;
5942: l_old_title_id NUMBER;
5943: l_old_main_message_id NUMBER;

Line 6095: INSERT INTO CZ_RP_ENTRIES

6091: deleted_flag='0';
6092:
6093: --Create Repository Entry
6094:
6095: INSERT INTO CZ_RP_ENTRIES
6096: (
6097: OBJECT_TYPE
6098: ,OBJECT_ID
6099: ,ENCLOSING_FOLDER

Line 6115: FROM CZ_RP_ENTRIES

6111: ,DESCRIPTION
6112: ,NOTES
6113: ,'0'
6114: ,DELETED_FLAG
6115: FROM CZ_RP_ENTRIES
6116: WHERE object_id= p_template_id AND object_type='UCT'
6117: AND deleted_flag='0';
6118:
6119: IF SQL%ROWCOUNT = 0 THEN

Line 6187: l_name cz_rp_entries.name%TYPE;

6183:
6184: l_api_version CONSTANT NUMBER := 1.0;
6185: l_api_name CONSTANT VARCHAR2(30) := 'copy_ui_master_template';
6186: INVALID_UIDEF_ID_EXCP EXCEPTION;
6187: l_name cz_rp_entries.name%TYPE;
6188:
6189: BEGIN
6190: x_new_ui_def_id := allocateId('CZ_UI_DEFS_S');
6191: l_name := copy_name(p_ui_def_id,'UMT');

Line 6374: INSERT INTO CZ_RP_ENTRIES

6370: WHERE ui_def_id = p_ui_def_id AND deleted_flag='0';
6371:
6372: --Create Repository Entry
6373:
6374: INSERT INTO CZ_RP_ENTRIES
6375: (
6376: OBJECT_TYPE
6377: ,OBJECT_ID
6378: ,ENCLOSING_FOLDER

Line 6394: FROM CZ_RP_ENTRIES

6390: ,DESCRIPTION
6391: ,NOTES
6392: ,'0'
6393: ,DELETED_FLAG
6394: FROM CZ_RP_ENTRIES
6395: WHERE object_id= p_ui_def_id AND object_type='UMT'
6396: AND deleted_flag='0';
6397:
6398: IF SQL%ROWCOUNT = 0 THEN

Line 6444: FROM cz_rp_entries

6440:
6441: ----check if eff set exists
6442: SELECT object_id,name
6443: INTO l_eff_set_id,l_eff_name
6444: FROM cz_rp_entries
6445: WHERE cz_rp_entries.object_id = p_eff_set_id
6446: AND cz_rp_entries.object_type = 'EFF'
6447: AND cz_rp_entries.deleted_flag = '0'
6448: AND cz_rp_entries.seeded_flag <> '1';

Line 6445: WHERE cz_rp_entries.object_id = p_eff_set_id

6441: ----check if eff set exists
6442: SELECT object_id,name
6443: INTO l_eff_set_id,l_eff_name
6444: FROM cz_rp_entries
6445: WHERE cz_rp_entries.object_id = p_eff_set_id
6446: AND cz_rp_entries.object_type = 'EFF'
6447: AND cz_rp_entries.deleted_flag = '0'
6448: AND cz_rp_entries.seeded_flag <> '1';
6449:

Line 6446: AND cz_rp_entries.object_type = 'EFF'

6442: SELECT object_id,name
6443: INTO l_eff_set_id,l_eff_name
6444: FROM cz_rp_entries
6445: WHERE cz_rp_entries.object_id = p_eff_set_id
6446: AND cz_rp_entries.object_type = 'EFF'
6447: AND cz_rp_entries.deleted_flag = '0'
6448: AND cz_rp_entries.seeded_flag <> '1';
6449:
6450: SELECT name BULK COLLECT INTO l_prj_name_tbl

Line 6447: AND cz_rp_entries.deleted_flag = '0'

6443: INTO l_eff_set_id,l_eff_name
6444: FROM cz_rp_entries
6445: WHERE cz_rp_entries.object_id = p_eff_set_id
6446: AND cz_rp_entries.object_type = 'EFF'
6447: AND cz_rp_entries.deleted_flag = '0'
6448: AND cz_rp_entries.seeded_flag <> '1';
6449:
6450: SELECT name BULK COLLECT INTO l_prj_name_tbl
6451: FROM cz_devl_projects

Line 6448: AND cz_rp_entries.seeded_flag <> '1';

6444: FROM cz_rp_entries
6445: WHERE cz_rp_entries.object_id = p_eff_set_id
6446: AND cz_rp_entries.object_type = 'EFF'
6447: AND cz_rp_entries.deleted_flag = '0'
6448: AND cz_rp_entries.seeded_flag <> '1';
6449:
6450: SELECT name BULK COLLECT INTO l_prj_name_tbl
6451: FROM cz_devl_projects
6452: WHERE deleted_flag = '0' AND devl_project_id IN

Line 6509: UPDATE cz_rp_entries

6505: SET deleted_flag = '1',
6506: name = append_name(p_eff_set_id, 'EFF', name)
6507: WHERE effectivity_set_id = p_eff_set_id;
6508:
6509: UPDATE cz_rp_entries
6510: SET deleted_flag = '1',
6511: name = append_name(p_eff_set_id, 'EFF', name)
6512: WHERE object_id = p_eff_set_id
6513: AND object_type = 'EFF';

Line 6538: l_object_id cz_rp_entries.object_id%TYPE;

6534: x_msg_data OUT NOCOPY VARCHAR2)
6535: IS
6536:
6537: l_devl_project_tbl t_indexes;
6538: l_object_id cz_rp_entries.object_id%TYPE;
6539: l_object_name cz_rp_entries.name%TYPE;
6540: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6541: l_devl_name cz_devl_projects.name%TYPE;
6542: BEGIN

Line 6539: l_object_name cz_rp_entries.name%TYPE;

6535: IS
6536:
6537: l_devl_project_tbl t_indexes;
6538: l_object_id cz_rp_entries.object_id%TYPE;
6539: l_object_name cz_rp_entries.name%TYPE;
6540: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6541: l_devl_name cz_devl_projects.name%TYPE;
6542: BEGIN
6543: FND_MSG_PUB.initialize;

Line 6540: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;

6536:
6537: l_devl_project_tbl t_indexes;
6538: l_object_id cz_rp_entries.object_id%TYPE;
6539: l_object_name cz_rp_entries.name%TYPE;
6540: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6541: l_devl_name cz_devl_projects.name%TYPE;
6542: BEGIN
6543: FND_MSG_PUB.initialize;
6544: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6552: FROM cz_rp_entries

6548: ----check if archive exists
6549: BEGIN
6550: SELECT object_id,name,seeded_flag
6551: INTO l_object_id,l_object_name,l_seeded_flag
6552: FROM cz_rp_entries
6553: WHERE cz_rp_entries.object_id = p_archive_id
6554: AND cz_rp_entries.object_type = 'ARC'
6555: AND cz_rp_entries.deleted_flag = '0';
6556: EXCEPTION

Line 6553: WHERE cz_rp_entries.object_id = p_archive_id

6549: BEGIN
6550: SELECT object_id,name,seeded_flag
6551: INTO l_object_id,l_object_name,l_seeded_flag
6552: FROM cz_rp_entries
6553: WHERE cz_rp_entries.object_id = p_archive_id
6554: AND cz_rp_entries.object_type = 'ARC'
6555: AND cz_rp_entries.deleted_flag = '0';
6556: EXCEPTION
6557: WHEN NO_DATA_FOUND THEN

Line 6554: AND cz_rp_entries.object_type = 'ARC'

6550: SELECT object_id,name,seeded_flag
6551: INTO l_object_id,l_object_name,l_seeded_flag
6552: FROM cz_rp_entries
6553: WHERE cz_rp_entries.object_id = p_archive_id
6554: AND cz_rp_entries.object_type = 'ARC'
6555: AND cz_rp_entries.deleted_flag = '0';
6556: EXCEPTION
6557: WHEN NO_DATA_FOUND THEN
6558: l_object_id := -1;

Line 6555: AND cz_rp_entries.deleted_flag = '0';

6551: INTO l_object_id,l_object_name,l_seeded_flag
6552: FROM cz_rp_entries
6553: WHERE cz_rp_entries.object_id = p_archive_id
6554: AND cz_rp_entries.object_type = 'ARC'
6555: AND cz_rp_entries.deleted_flag = '0';
6556: EXCEPTION
6557: WHEN NO_DATA_FOUND THEN
6558: l_object_id := -1;
6559: END;

Line 6578: FROM cz_rp_entries

6574: FROM cz_archive_refs
6575: WHERE cz_archive_refs.archive_id = p_archive_id
6576: AND cz_archive_refs.deleted_flag = '0'
6577: AND cz_archive_refs.devl_project_id IN (SELECT object_id
6578: FROM cz_rp_entries
6579: WHERE object_type = 'PRJ'
6580: AND deleted_flag = '0');
6581:
6582: IF (l_devl_project_tbl.COUNT > 0) THEN

Line 6638: UPDATE cz_rp_entries

6634: x_msg_data := '';
6635:
6636: is_archive_deleteable(p_archive_id,l_return_status,l_msg_count,l_msg_data);
6637: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6638: UPDATE cz_rp_entries
6639: set deleted_flag = '1',
6640: name = append_name(p_archive_id, 'ARC', name)
6641: where object_id = p_archive_id
6642: and object_type = 'ARC'

Line 6672: l_object_id cz_rp_entries.object_id%TYPE;

6668: x_msg_count OUT NOCOPY NUMBER,
6669: x_msg_data OUT NOCOPY VARCHAR2)
6670: IS
6671:
6672: l_object_id cz_rp_entries.object_id%TYPE;
6673: l_object_name cz_rp_entries.name%TYPE;
6674: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6675: l_ps_prop_count NUMBER := 0;
6676: l_item_prop_count NUMBER := 0;

Line 6673: l_object_name cz_rp_entries.name%TYPE;

6669: x_msg_data OUT NOCOPY VARCHAR2)
6670: IS
6671:
6672: l_object_id cz_rp_entries.object_id%TYPE;
6673: l_object_name cz_rp_entries.name%TYPE;
6674: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6675: l_ps_prop_count NUMBER := 0;
6676: l_item_prop_count NUMBER := 0;
6677: l_ui_pages_count NUMBER := 0;

Line 6674: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;

6670: IS
6671:
6672: l_object_id cz_rp_entries.object_id%TYPE;
6673: l_object_name cz_rp_entries.name%TYPE;
6674: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6675: l_ps_prop_count NUMBER := 0;
6676: l_item_prop_count NUMBER := 0;
6677: l_ui_pages_count NUMBER := 0;
6678: l_prop_count NUMBER := 0;

Line 6692: FROM cz_rp_entries

6688: ----check if prop exists
6689: BEGIN
6690: SELECT object_id,name,seeded_flag
6691: INTO l_object_id,l_object_name,l_seeded_flag
6692: FROM cz_rp_entries
6693: WHERE cz_rp_entries.object_id = p_property_id
6694: AND cz_rp_entries.object_type = 'PRP'
6695: AND cz_rp_entries.deleted_flag = '0';
6696: EXCEPTION

Line 6693: WHERE cz_rp_entries.object_id = p_property_id

6689: BEGIN
6690: SELECT object_id,name,seeded_flag
6691: INTO l_object_id,l_object_name,l_seeded_flag
6692: FROM cz_rp_entries
6693: WHERE cz_rp_entries.object_id = p_property_id
6694: AND cz_rp_entries.object_type = 'PRP'
6695: AND cz_rp_entries.deleted_flag = '0';
6696: EXCEPTION
6697: WHEN NO_DATA_FOUND THEN

Line 6694: AND cz_rp_entries.object_type = 'PRP'

6690: SELECT object_id,name,seeded_flag
6691: INTO l_object_id,l_object_name,l_seeded_flag
6692: FROM cz_rp_entries
6693: WHERE cz_rp_entries.object_id = p_property_id
6694: AND cz_rp_entries.object_type = 'PRP'
6695: AND cz_rp_entries.deleted_flag = '0';
6696: EXCEPTION
6697: WHEN NO_DATA_FOUND THEN
6698: l_object_id := -1;

Line 6695: AND cz_rp_entries.deleted_flag = '0';

6691: INTO l_object_id,l_object_name,l_seeded_flag
6692: FROM cz_rp_entries
6693: WHERE cz_rp_entries.object_id = p_property_id
6694: AND cz_rp_entries.object_type = 'PRP'
6695: AND cz_rp_entries.deleted_flag = '0';
6696: EXCEPTION
6697: WHEN NO_DATA_FOUND THEN
6698: l_object_id := -1;
6699: END;

Line 6802: UPDATE cz_rp_entries

6798: x_msg_data := '';
6799:
6800: is_property_deleteable(p_property_id,l_return_status,l_msg_count,l_msg_data);
6801: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6802: UPDATE cz_rp_entries
6803: SET deleted_flag = '1',
6804: name = append_name(p_property_id, 'PRP', name)
6805: WHERE object_id = p_property_id
6806: AND object_type = 'PRP'

Line 6835: l_object_id cz_rp_entries.object_id%TYPE;

6831: x_msg_count OUT NOCOPY NUMBER,
6832: x_msg_data OUT NOCOPY VARCHAR2)
6833: IS
6834:
6835: l_object_id cz_rp_entries.object_id%TYPE;
6836: l_object_name cz_rp_entries.name%TYPE;
6837: l_seeded_flag VARCHAR2(1);
6838: TYPE ui_name_tbl is TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
6839: l_ui_name_tbl ui_name_tbl;

Line 6836: l_object_name cz_rp_entries.name%TYPE;

6832: x_msg_data OUT NOCOPY VARCHAR2)
6833: IS
6834:
6835: l_object_id cz_rp_entries.object_id%TYPE;
6836: l_object_name cz_rp_entries.name%TYPE;
6837: l_seeded_flag VARCHAR2(1);
6838: TYPE ui_name_tbl is TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
6839: l_ui_name_tbl ui_name_tbl;
6840:

Line 6851: FROM cz_rp_entries

6847:
6848: BEGIN
6849: SELECT object_id,name,seeded_flag
6850: INTO l_object_id,l_object_name,l_seeded_flag
6851: FROM cz_rp_entries
6852: WHERE cz_rp_entries.object_id = p_umt_id
6853: AND cz_rp_entries.object_type = 'UMT'
6854: AND cz_rp_entries.deleted_flag = '0';
6855: EXCEPTION

Line 6852: WHERE cz_rp_entries.object_id = p_umt_id

6848: BEGIN
6849: SELECT object_id,name,seeded_flag
6850: INTO l_object_id,l_object_name,l_seeded_flag
6851: FROM cz_rp_entries
6852: WHERE cz_rp_entries.object_id = p_umt_id
6853: AND cz_rp_entries.object_type = 'UMT'
6854: AND cz_rp_entries.deleted_flag = '0';
6855: EXCEPTION
6856: WHEN NO_DATA_FOUND THEN

Line 6853: AND cz_rp_entries.object_type = 'UMT'

6849: SELECT object_id,name,seeded_flag
6850: INTO l_object_id,l_object_name,l_seeded_flag
6851: FROM cz_rp_entries
6852: WHERE cz_rp_entries.object_id = p_umt_id
6853: AND cz_rp_entries.object_type = 'UMT'
6854: AND cz_rp_entries.deleted_flag = '0';
6855: EXCEPTION
6856: WHEN NO_DATA_FOUND THEN
6857: l_object_id := -1;

Line 6854: AND cz_rp_entries.deleted_flag = '0';

6850: INTO l_object_id,l_object_name,l_seeded_flag
6851: FROM cz_rp_entries
6852: WHERE cz_rp_entries.object_id = p_umt_id
6853: AND cz_rp_entries.object_type = 'UMT'
6854: AND cz_rp_entries.deleted_flag = '0';
6855: EXCEPTION
6856: WHEN NO_DATA_FOUND THEN
6857: l_object_id := -1;
6858: END;

Line 6876: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'

6872: FROM cz_ui_defs ui
6873: WHERE from_master_template_id = p_umt_id
6874: AND deleted_flag = '0'
6875: AND seeded_flag <> '1'
6876: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
6877: AND object_id = ui.devl_project_id and object_type = 'PRJ');
6878: EXCEPTION
6879: WHEN NO_DATA_FOUND THEN
6880: l_object_id := -1;

Line 6933: UPDATE cz_rp_entries

6929: x_msg_data := '';
6930:
6931: is_umt_deleteable(p_umt_id,l_return_status,l_msg_count,l_msg_data);
6932: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6933: UPDATE cz_rp_entries
6934: SET deleted_flag = '1',
6935: name = append_name(p_umt_id, 'UMT', name)
6936: WHERE object_id = p_umt_id
6937: AND object_type = 'UMT';

Line 6969: l_object_id cz_rp_entries.object_id%TYPE;

6965: IS
6966: TYPE ui_name_tbl is TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
6967: TYPE num_type_tbl is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6968:
6969: l_object_id cz_rp_entries.object_id%TYPE;
6970: l_object_name cz_rp_entries.name%TYPE;
6971: l_seeded_flag VARCHAR2(1);
6972: l_ui_name_tbl ui_name_tbl;
6973: l_mt_flag_tbl ui_name_tbl;

Line 6970: l_object_name cz_rp_entries.name%TYPE;

6966: TYPE ui_name_tbl is TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
6967: TYPE num_type_tbl is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6968:
6969: l_object_id cz_rp_entries.object_id%TYPE;
6970: l_object_name cz_rp_entries.name%TYPE;
6971: l_seeded_flag VARCHAR2(1);
6972: l_ui_name_tbl ui_name_tbl;
6973: l_mt_flag_tbl ui_name_tbl;
6974: l_ref_template_tbl num_type_tbl;

Line 6988: FROM cz_rp_entries

6984: -- check if p_uct_id exists
6985: BEGIN
6986: SELECT object_id,name,seeded_flag
6987: INTO l_object_id,l_object_name,l_seeded_flag
6988: FROM cz_rp_entries
6989: WHERE cz_rp_entries.object_id = p_uct_id
6990: AND cz_rp_entries.object_type = 'UCT'
6991: AND cz_rp_entries.deleted_flag = '0';
6992: EXCEPTION

Line 6989: WHERE cz_rp_entries.object_id = p_uct_id

6985: BEGIN
6986: SELECT object_id,name,seeded_flag
6987: INTO l_object_id,l_object_name,l_seeded_flag
6988: FROM cz_rp_entries
6989: WHERE cz_rp_entries.object_id = p_uct_id
6990: AND cz_rp_entries.object_type = 'UCT'
6991: AND cz_rp_entries.deleted_flag = '0';
6992: EXCEPTION
6993: WHEN NO_DATA_FOUND THEN

Line 6990: AND cz_rp_entries.object_type = 'UCT'

6986: SELECT object_id,name,seeded_flag
6987: INTO l_object_id,l_object_name,l_seeded_flag
6988: FROM cz_rp_entries
6989: WHERE cz_rp_entries.object_id = p_uct_id
6990: AND cz_rp_entries.object_type = 'UCT'
6991: AND cz_rp_entries.deleted_flag = '0';
6992: EXCEPTION
6993: WHEN NO_DATA_FOUND THEN
6994: l_object_id := -1;

Line 6991: AND cz_rp_entries.deleted_flag = '0';

6987: INTO l_object_id,l_object_name,l_seeded_flag
6988: FROM cz_rp_entries
6989: WHERE cz_rp_entries.object_id = p_uct_id
6990: AND cz_rp_entries.object_type = 'UCT'
6991: AND cz_rp_entries.deleted_flag = '0';
6992: EXCEPTION
6993: WHEN NO_DATA_FOUND THEN
6994: l_object_id := -1;
6995: END;

Line 7023: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'

7019: FROM cz_ui_page_elements
7020: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id
7021: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
7022: AND cz_ui_page_elements.deleted_flag = '0')
7023: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
7024: AND object_id = ui.devl_project_id and object_type = 'PRJ');
7025: EXCEPTION
7026: WHEN NO_DATA_FOUND THEN
7027: l_object_id := -1;

Line 7139: UPDATE cz_rp_entries

7135: WHERE template_id = p_uct_id;
7136: RAISE FAILED_TO_LOCK_UCT;
7137: END IF;
7138:
7139: UPDATE cz_rp_entries
7140: SET deleted_flag = '1',
7141: name = append_name(p_uct_id, 'UCT', name)
7142: WHERE object_id = p_uct_id
7143: AND object_type = 'UCT'

Line 7471: DELETE FROM cz_rp_entries

7467:
7468: DELETE FROM cz_publication_usages
7469: WHERE usage_id = usageId;
7470:
7471: DELETE FROM cz_rp_entries
7472: WHERE object_type ='USG' and object_id = usageId;
7473:
7474: IF (v_nodes.COUNT > 0) THEN
7475: v_first_index := v_masks_nodes.FIRST;

Line 7601: l_object_id cz_rp_entries.object_id%TYPE;

7597: l_encl_eff_fld NUMBER := 0;
7598: l_eff_name VARCHAR2(255);
7599:
7600: l_devl_project_tbl number_type_tbl;
7601: l_object_id cz_rp_entries.object_id%TYPE;
7602: l_object_name cz_rp_entries.name%TYPE;
7603: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
7604: l_devl_name cz_devl_projects.name%TYPE;
7605: l_encl_arc_fld NUMBER := 0;

Line 7602: l_object_name cz_rp_entries.name%TYPE;

7598: l_eff_name VARCHAR2(255);
7599:
7600: l_devl_project_tbl number_type_tbl;
7601: l_object_id cz_rp_entries.object_id%TYPE;
7602: l_object_name cz_rp_entries.name%TYPE;
7603: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
7604: l_devl_name cz_devl_projects.name%TYPE;
7605: l_encl_arc_fld NUMBER := 0;
7606:

Line 7603: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;

7599:
7600: l_devl_project_tbl number_type_tbl;
7601: l_object_id cz_rp_entries.object_id%TYPE;
7602: l_object_name cz_rp_entries.name%TYPE;
7603: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
7604: l_devl_name cz_devl_projects.name%TYPE;
7605: l_encl_arc_fld NUMBER := 0;
7606:
7607: l_usg_tbl number_type_tbl;

Line 7629: l_fld_name cz_rp_entries.name%TYPE;

7625: rec_count NUMBER := 0;
7626: l_checkout_user cz_devl_projects.checkout_user%TYPE;
7627: l_model_name cz_devl_projects.name%TYPE;
7628: l_template_name cz_ui_templates.template_name%TYPE;
7629: l_fld_name cz_rp_entries.name%TYPE;
7630: l_priv VARCHAR2(1) := 'F';
7631: l_return_status VARCHAR2(1);
7632: l_msg_count NUMBER := 0;
7633: l_msg_data VARCHAR2(2000);

Line 7677: FROM cz_rp_entries

7673: l_user_name := FND_GLOBAL.user_name;
7674: ------check if p_rp_folder_id exists
7675: SELECT object_id
7676: INTO l_rp_folder
7677: FROM cz_rp_entries
7678: WHERE cz_rp_entries.object_id = p_rp_folder_id
7679: AND cz_rp_entries.object_type = 'FLD'
7680: AND cz_rp_entries.deleted_flag = '0';
7681:

Line 7678: WHERE cz_rp_entries.object_id = p_rp_folder_id

7674: ------check if p_rp_folder_id exists
7675: SELECT object_id
7676: INTO l_rp_folder
7677: FROM cz_rp_entries
7678: WHERE cz_rp_entries.object_id = p_rp_folder_id
7679: AND cz_rp_entries.object_type = 'FLD'
7680: AND cz_rp_entries.deleted_flag = '0';
7681:
7682: l_rp_fld_tbl.DELETE;

Line 7679: AND cz_rp_entries.object_type = 'FLD'

7675: SELECT object_id
7676: INTO l_rp_folder
7677: FROM cz_rp_entries
7678: WHERE cz_rp_entries.object_id = p_rp_folder_id
7679: AND cz_rp_entries.object_type = 'FLD'
7680: AND cz_rp_entries.deleted_flag = '0';
7681:
7682: l_rp_fld_tbl.DELETE;
7683: l_encl_idx_ref.DELETE;

Line 7680: AND cz_rp_entries.deleted_flag = '0';

7676: INTO l_rp_folder
7677: FROM cz_rp_entries
7678: WHERE cz_rp_entries.object_id = p_rp_folder_id
7679: AND cz_rp_entries.object_type = 'FLD'
7680: AND cz_rp_entries.deleted_flag = '0';
7681:
7682: l_rp_fld_tbl.DELETE;
7683: l_encl_idx_ref.DELETE;
7684: l_encl_fld_tbl.DELETE;

Line 7689: FROM cz_rp_entries

7685: SELECT object_id,enclosing_folder
7686: BULK
7687: COLLECT
7688: INTO l_rp_fld_tbl,l_encl_fld_tbl
7689: FROM cz_rp_entries
7690: WHERE cz_rp_entries.deleted_flag = '0'
7691: AND cz_rp_entries.object_type = 'FLD'
7692: START WITH cz_rp_entries.object_type = 'FLD'
7693: AND cz_rp_entries.object_id = l_rp_folder

Line 7690: WHERE cz_rp_entries.deleted_flag = '0'

7686: BULK
7687: COLLECT
7688: INTO l_rp_fld_tbl,l_encl_fld_tbl
7689: FROM cz_rp_entries
7690: WHERE cz_rp_entries.deleted_flag = '0'
7691: AND cz_rp_entries.object_type = 'FLD'
7692: START WITH cz_rp_entries.object_type = 'FLD'
7693: AND cz_rp_entries.object_id = l_rp_folder
7694: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder

Line 7691: AND cz_rp_entries.object_type = 'FLD'

7687: COLLECT
7688: INTO l_rp_fld_tbl,l_encl_fld_tbl
7689: FROM cz_rp_entries
7690: WHERE cz_rp_entries.deleted_flag = '0'
7691: AND cz_rp_entries.object_type = 'FLD'
7692: START WITH cz_rp_entries.object_type = 'FLD'
7693: AND cz_rp_entries.object_id = l_rp_folder
7694: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
7695: AND PRIOR cz_rp_entries.object_type = 'FLD';

Line 7692: START WITH cz_rp_entries.object_type = 'FLD'

7688: INTO l_rp_fld_tbl,l_encl_fld_tbl
7689: FROM cz_rp_entries
7690: WHERE cz_rp_entries.deleted_flag = '0'
7691: AND cz_rp_entries.object_type = 'FLD'
7692: START WITH cz_rp_entries.object_type = 'FLD'
7693: AND cz_rp_entries.object_id = l_rp_folder
7694: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
7695: AND PRIOR cz_rp_entries.object_type = 'FLD';
7696:

Line 7693: AND cz_rp_entries.object_id = l_rp_folder

7689: FROM cz_rp_entries
7690: WHERE cz_rp_entries.deleted_flag = '0'
7691: AND cz_rp_entries.object_type = 'FLD'
7692: START WITH cz_rp_entries.object_type = 'FLD'
7693: AND cz_rp_entries.object_id = l_rp_folder
7694: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
7695: AND PRIOR cz_rp_entries.object_type = 'FLD';
7696:
7697: ---l_folder_count := l_rp_fld_tbl.COUNT + 1;

Line 7694: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder

7690: WHERE cz_rp_entries.deleted_flag = '0'
7691: AND cz_rp_entries.object_type = 'FLD'
7692: START WITH cz_rp_entries.object_type = 'FLD'
7693: AND cz_rp_entries.object_id = l_rp_folder
7694: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
7695: AND PRIOR cz_rp_entries.object_type = 'FLD';
7696:
7697: ---l_folder_count := l_rp_fld_tbl.COUNT + 1;
7698: ---l_rp_fld_tbl(l_folder_count) := l_rp_folder;

Line 7695: AND PRIOR cz_rp_entries.object_type = 'FLD';

7691: AND cz_rp_entries.object_type = 'FLD'
7692: START WITH cz_rp_entries.object_type = 'FLD'
7693: AND cz_rp_entries.object_id = l_rp_folder
7694: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
7695: AND PRIOR cz_rp_entries.object_type = 'FLD';
7696:
7697: ---l_folder_count := l_rp_fld_tbl.COUNT + 1;
7698: ---l_rp_fld_tbl(l_folder_count) := l_rp_folder;
7699: ---l_encl_fld_tbl(l_folder_count) := -1;

Line 7710: FROM cz_rp_entries, cz_devl_projects

7706: l_rp_model_tbl.DELETE;
7707: SELECT object_id, checkout_user, cz_devl_projects.name
7708: BULK COLLECT
7709: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
7710: FROM cz_rp_entries, cz_devl_projects
7711: WHERE cz_rp_entries.object_type = 'PRJ'
7712: AND cz_rp_entries.deleted_flag = '0'
7713: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7714: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;

Line 7711: WHERE cz_rp_entries.object_type = 'PRJ'

7707: SELECT object_id, checkout_user, cz_devl_projects.name
7708: BULK COLLECT
7709: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
7710: FROM cz_rp_entries, cz_devl_projects
7711: WHERE cz_rp_entries.object_type = 'PRJ'
7712: AND cz_rp_entries.deleted_flag = '0'
7713: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7714: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
7715:

Line 7712: AND cz_rp_entries.deleted_flag = '0'

7708: BULK COLLECT
7709: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
7710: FROM cz_rp_entries, cz_devl_projects
7711: WHERE cz_rp_entries.object_type = 'PRJ'
7712: AND cz_rp_entries.deleted_flag = '0'
7713: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7714: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
7715:
7716: IF (l_rp_model_tbl.COUNT > 0) THEN

Line 7713: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)

7709: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
7710: FROM cz_rp_entries, cz_devl_projects
7711: WHERE cz_rp_entries.object_type = 'PRJ'
7712: AND cz_rp_entries.deleted_flag = '0'
7713: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7714: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
7715:
7716: IF (l_rp_model_tbl.COUNT > 0) THEN
7717: rec_count := l_rp_model_ref.COUNT;

Line 7714: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;

7710: FROM cz_rp_entries, cz_devl_projects
7711: WHERE cz_rp_entries.object_type = 'PRJ'
7712: AND cz_rp_entries.deleted_flag = '0'
7713: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7714: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
7715:
7716: IF (l_rp_model_tbl.COUNT > 0) THEN
7717: rec_count := l_rp_model_ref.COUNT;
7718: FOR J IN l_rp_model_tbl.FIRST..l_rp_model_tbl.LAST

Line 7737: FROM cz_rp_entries

7733: l_eff_set_tbl.DELETE;
7734: SELECT object_id
7735: BULK COLLECT
7736: INTO l_eff_set_tbl
7737: FROM cz_rp_entries
7738: WHERE cz_rp_entries.object_type = 'EFF'
7739: AND cz_rp_entries.deleted_flag = '0'
7740: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7741:

Line 7738: WHERE cz_rp_entries.object_type = 'EFF'

7734: SELECT object_id
7735: BULK COLLECT
7736: INTO l_eff_set_tbl
7737: FROM cz_rp_entries
7738: WHERE cz_rp_entries.object_type = 'EFF'
7739: AND cz_rp_entries.deleted_flag = '0'
7740: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7741:
7742: IF (l_eff_set_tbl.COUNT > 0) THEN

Line 7739: AND cz_rp_entries.deleted_flag = '0'

7735: BULK COLLECT
7736: INTO l_eff_set_tbl
7737: FROM cz_rp_entries
7738: WHERE cz_rp_entries.object_type = 'EFF'
7739: AND cz_rp_entries.deleted_flag = '0'
7740: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7741:
7742: IF (l_eff_set_tbl.COUNT > 0) THEN
7743: rec_count := l_eff_set_ref.COUNT;

Line 7740: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);

7736: INTO l_eff_set_tbl
7737: FROM cz_rp_entries
7738: WHERE cz_rp_entries.object_type = 'EFF'
7739: AND cz_rp_entries.deleted_flag = '0'
7740: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7741:
7742: IF (l_eff_set_tbl.COUNT > 0) THEN
7743: rec_count := l_eff_set_ref.COUNT;
7744: FOR J IN l_eff_set_tbl.FIRST..l_eff_set_tbl.LAST

Line 7756: FROM cz_rp_entries

7752: l_usg_tbl.DELETE;
7753: SELECT object_id
7754: BULK COLLECT
7755: INTO l_usg_tbl
7756: FROM cz_rp_entries
7757: WHERE cz_rp_entries.object_type = 'USG'
7758: AND cz_rp_entries.deleted_flag = '0'
7759: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7760:

Line 7757: WHERE cz_rp_entries.object_type = 'USG'

7753: SELECT object_id
7754: BULK COLLECT
7755: INTO l_usg_tbl
7756: FROM cz_rp_entries
7757: WHERE cz_rp_entries.object_type = 'USG'
7758: AND cz_rp_entries.deleted_flag = '0'
7759: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7760:
7761: IF (l_usg_tbl.COUNT > 0) THEN

Line 7758: AND cz_rp_entries.deleted_flag = '0'

7754: BULK COLLECT
7755: INTO l_usg_tbl
7756: FROM cz_rp_entries
7757: WHERE cz_rp_entries.object_type = 'USG'
7758: AND cz_rp_entries.deleted_flag = '0'
7759: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7760:
7761: IF (l_usg_tbl.COUNT > 0) THEN
7762: rec_count := l_usg_ref.COUNT;

Line 7759: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);

7755: INTO l_usg_tbl
7756: FROM cz_rp_entries
7757: WHERE cz_rp_entries.object_type = 'USG'
7758: AND cz_rp_entries.deleted_flag = '0'
7759: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7760:
7761: IF (l_usg_tbl.COUNT > 0) THEN
7762: rec_count := l_usg_ref.COUNT;
7763: FOR J IN l_usg_tbl.FIRST..l_usg_tbl.LAST

Line 7775: FROM cz_rp_entries

7771: l_arc_tbl.DELETE;
7772: SELECT object_id
7773: BULK COLLECT
7774: INTO l_arc_tbl
7775: FROM cz_rp_entries
7776: WHERE cz_rp_entries.object_type = 'ARC'
7777: AND cz_rp_entries.deleted_flag = '0'
7778: AND cz_rp_entries.seeded_flag <> '1'
7779: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);

Line 7776: WHERE cz_rp_entries.object_type = 'ARC'

7772: SELECT object_id
7773: BULK COLLECT
7774: INTO l_arc_tbl
7775: FROM cz_rp_entries
7776: WHERE cz_rp_entries.object_type = 'ARC'
7777: AND cz_rp_entries.deleted_flag = '0'
7778: AND cz_rp_entries.seeded_flag <> '1'
7779: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7780:

Line 7777: AND cz_rp_entries.deleted_flag = '0'

7773: BULK COLLECT
7774: INTO l_arc_tbl
7775: FROM cz_rp_entries
7776: WHERE cz_rp_entries.object_type = 'ARC'
7777: AND cz_rp_entries.deleted_flag = '0'
7778: AND cz_rp_entries.seeded_flag <> '1'
7779: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7780:
7781: IF (l_arc_tbl.COUNT > 0) THEN

Line 7778: AND cz_rp_entries.seeded_flag <> '1'

7774: INTO l_arc_tbl
7775: FROM cz_rp_entries
7776: WHERE cz_rp_entries.object_type = 'ARC'
7777: AND cz_rp_entries.deleted_flag = '0'
7778: AND cz_rp_entries.seeded_flag <> '1'
7779: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7780:
7781: IF (l_arc_tbl.COUNT > 0) THEN
7782: rec_count := l_arc_ref.COUNT;

Line 7779: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);

7775: FROM cz_rp_entries
7776: WHERE cz_rp_entries.object_type = 'ARC'
7777: AND cz_rp_entries.deleted_flag = '0'
7778: AND cz_rp_entries.seeded_flag <> '1'
7779: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7780:
7781: IF (l_arc_tbl.COUNT > 0) THEN
7782: rec_count := l_arc_ref.COUNT;
7783: FOR J IN l_arc_tbl.FIRST..l_arc_tbl.LAST

Line 7795: FROM cz_rp_entries

7791: l_prp_tbl.DELETE;
7792: SELECT object_id
7793: BULK COLLECT
7794: INTO l_prp_tbl
7795: FROM cz_rp_entries
7796: WHERE cz_rp_entries.object_type = 'PRP'
7797: AND cz_rp_entries.deleted_flag = '0'
7798: AND cz_rp_entries.seeded_flag <> '1'
7799: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);

Line 7796: WHERE cz_rp_entries.object_type = 'PRP'

7792: SELECT object_id
7793: BULK COLLECT
7794: INTO l_prp_tbl
7795: FROM cz_rp_entries
7796: WHERE cz_rp_entries.object_type = 'PRP'
7797: AND cz_rp_entries.deleted_flag = '0'
7798: AND cz_rp_entries.seeded_flag <> '1'
7799: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7800:

Line 7797: AND cz_rp_entries.deleted_flag = '0'

7793: BULK COLLECT
7794: INTO l_prp_tbl
7795: FROM cz_rp_entries
7796: WHERE cz_rp_entries.object_type = 'PRP'
7797: AND cz_rp_entries.deleted_flag = '0'
7798: AND cz_rp_entries.seeded_flag <> '1'
7799: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7800:
7801: IF (l_prp_tbl.COUNT > 0) THEN

Line 7798: AND cz_rp_entries.seeded_flag <> '1'

7794: INTO l_prp_tbl
7795: FROM cz_rp_entries
7796: WHERE cz_rp_entries.object_type = 'PRP'
7797: AND cz_rp_entries.deleted_flag = '0'
7798: AND cz_rp_entries.seeded_flag <> '1'
7799: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7800:
7801: IF (l_prp_tbl.COUNT > 0) THEN
7802: rec_count := l_prp_ref.COUNT;

Line 7799: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);

7795: FROM cz_rp_entries
7796: WHERE cz_rp_entries.object_type = 'PRP'
7797: AND cz_rp_entries.deleted_flag = '0'
7798: AND cz_rp_entries.seeded_flag <> '1'
7799: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7800:
7801: IF (l_prp_tbl.COUNT > 0) THEN
7802: rec_count := l_prp_ref.COUNT;
7803: FOR J IN l_prp_tbl.FIRST..l_prp_tbl.LAST

Line 7815: FROM cz_rp_entries

7811: l_umt_tbl.DELETE;
7812: SELECT object_id
7813: BULK COLLECT
7814: INTO l_umt_tbl
7815: FROM cz_rp_entries
7816: WHERE cz_rp_entries.object_type = 'UMT'
7817: AND cz_rp_entries.deleted_flag = '0'
7818: AND cz_rp_entries.seeded_flag <> '1'
7819: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);

Line 7816: WHERE cz_rp_entries.object_type = 'UMT'

7812: SELECT object_id
7813: BULK COLLECT
7814: INTO l_umt_tbl
7815: FROM cz_rp_entries
7816: WHERE cz_rp_entries.object_type = 'UMT'
7817: AND cz_rp_entries.deleted_flag = '0'
7818: AND cz_rp_entries.seeded_flag <> '1'
7819: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7820:

Line 7817: AND cz_rp_entries.deleted_flag = '0'

7813: BULK COLLECT
7814: INTO l_umt_tbl
7815: FROM cz_rp_entries
7816: WHERE cz_rp_entries.object_type = 'UMT'
7817: AND cz_rp_entries.deleted_flag = '0'
7818: AND cz_rp_entries.seeded_flag <> '1'
7819: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7820:
7821: IF (l_umt_tbl.COUNT > 0) THEN

Line 7818: AND cz_rp_entries.seeded_flag <> '1'

7814: INTO l_umt_tbl
7815: FROM cz_rp_entries
7816: WHERE cz_rp_entries.object_type = 'UMT'
7817: AND cz_rp_entries.deleted_flag = '0'
7818: AND cz_rp_entries.seeded_flag <> '1'
7819: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7820:
7821: IF (l_umt_tbl.COUNT > 0) THEN
7822: rec_count := l_umt_ref.COUNT;

Line 7819: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);

7815: FROM cz_rp_entries
7816: WHERE cz_rp_entries.object_type = 'UMT'
7817: AND cz_rp_entries.deleted_flag = '0'
7818: AND cz_rp_entries.seeded_flag <> '1'
7819: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7820:
7821: IF (l_umt_tbl.COUNT > 0) THEN
7822: rec_count := l_umt_ref.COUNT;
7823: FOR J IN l_umt_tbl.FIRST..l_umt_tbl.LAST

Line 7835: FROM cz_rp_entries, cz_ui_templates

7831: l_uct_tbl.DELETE;
7832: SELECT object_id, checkout_user, template_name
7833: BULK COLLECT
7834: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
7835: FROM cz_rp_entries, cz_ui_templates
7836: WHERE cz_rp_entries.object_type = 'UCT'
7837: AND cz_rp_entries.deleted_flag = '0'
7838: AND cz_rp_entries.seeded_flag <> '1'
7839: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)

Line 7836: WHERE cz_rp_entries.object_type = 'UCT'

7832: SELECT object_id, checkout_user, template_name
7833: BULK COLLECT
7834: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
7835: FROM cz_rp_entries, cz_ui_templates
7836: WHERE cz_rp_entries.object_type = 'UCT'
7837: AND cz_rp_entries.deleted_flag = '0'
7838: AND cz_rp_entries.seeded_flag <> '1'
7839: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7840: AND cz_rp_entries.object_id = cz_ui_templates.template_id

Line 7837: AND cz_rp_entries.deleted_flag = '0'

7833: BULK COLLECT
7834: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
7835: FROM cz_rp_entries, cz_ui_templates
7836: WHERE cz_rp_entries.object_type = 'UCT'
7837: AND cz_rp_entries.deleted_flag = '0'
7838: AND cz_rp_entries.seeded_flag <> '1'
7839: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7840: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7841: AND cz_ui_templates.ui_def_id = 0;

Line 7838: AND cz_rp_entries.seeded_flag <> '1'

7834: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
7835: FROM cz_rp_entries, cz_ui_templates
7836: WHERE cz_rp_entries.object_type = 'UCT'
7837: AND cz_rp_entries.deleted_flag = '0'
7838: AND cz_rp_entries.seeded_flag <> '1'
7839: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7840: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7841: AND cz_ui_templates.ui_def_id = 0;
7842:

Line 7839: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)

7835: FROM cz_rp_entries, cz_ui_templates
7836: WHERE cz_rp_entries.object_type = 'UCT'
7837: AND cz_rp_entries.deleted_flag = '0'
7838: AND cz_rp_entries.seeded_flag <> '1'
7839: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7840: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7841: AND cz_ui_templates.ui_def_id = 0;
7842:
7843: IF (l_uct_tbl.COUNT > 0) THEN

Line 7840: AND cz_rp_entries.object_id = cz_ui_templates.template_id

7836: WHERE cz_rp_entries.object_type = 'UCT'
7837: AND cz_rp_entries.deleted_flag = '0'
7838: AND cz_rp_entries.seeded_flag <> '1'
7839: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7840: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7841: AND cz_ui_templates.ui_def_id = 0;
7842:
7843: IF (l_uct_tbl.COUNT > 0) THEN
7844: rec_count := l_uct_ref.COUNT;

Line 7874: cz_rp_entries rp

7870: COLLECT
7871: INTO l_ref_model_ids_tbl,l_ref_model_names_tbl,l_encl_devl_tbl
7872: FROM cz_ps_nodes p,
7873: cz_devl_projects d,
7874: cz_rp_entries rp
7875: WHERE p.reference_id = l_rp_model_ref(modelId)
7876: AND p.ps_node_type IN (263, 264)
7877: AND p.deleted_flag = '0'
7878: AND p.devl_project_id = d.devl_project_id

Line 7933: FROM cz_rp_entries

7929: LOOP
7930: BEGIN
7931: SELECT object_id,name
7932: INTO l_eff_set_id,l_eff_name
7933: FROM cz_rp_entries
7934: WHERE cz_rp_entries.object_id = l_eff_set_ref(i)
7935: AND cz_rp_entries.object_type = 'EFF'
7936: AND cz_rp_entries.deleted_flag = '0'
7937: AND cz_rp_entries.seeded_flag <> '1';

Line 7934: WHERE cz_rp_entries.object_id = l_eff_set_ref(i)

7930: BEGIN
7931: SELECT object_id,name
7932: INTO l_eff_set_id,l_eff_name
7933: FROM cz_rp_entries
7934: WHERE cz_rp_entries.object_id = l_eff_set_ref(i)
7935: AND cz_rp_entries.object_type = 'EFF'
7936: AND cz_rp_entries.deleted_flag = '0'
7937: AND cz_rp_entries.seeded_flag <> '1';
7938:

Line 7935: AND cz_rp_entries.object_type = 'EFF'

7931: SELECT object_id,name
7932: INTO l_eff_set_id,l_eff_name
7933: FROM cz_rp_entries
7934: WHERE cz_rp_entries.object_id = l_eff_set_ref(i)
7935: AND cz_rp_entries.object_type = 'EFF'
7936: AND cz_rp_entries.deleted_flag = '0'
7937: AND cz_rp_entries.seeded_flag <> '1';
7938:
7939: l_eff_tbl.DELETE;

Line 7936: AND cz_rp_entries.deleted_flag = '0'

7932: INTO l_eff_set_id,l_eff_name
7933: FROM cz_rp_entries
7934: WHERE cz_rp_entries.object_id = l_eff_set_ref(i)
7935: AND cz_rp_entries.object_type = 'EFF'
7936: AND cz_rp_entries.deleted_flag = '0'
7937: AND cz_rp_entries.seeded_flag <> '1';
7938:
7939: l_eff_tbl.DELETE;
7940: SELECT distinct devl_project_id

Line 7937: AND cz_rp_entries.seeded_flag <> '1';

7933: FROM cz_rp_entries
7934: WHERE cz_rp_entries.object_id = l_eff_set_ref(i)
7935: AND cz_rp_entries.object_type = 'EFF'
7936: AND cz_rp_entries.deleted_flag = '0'
7937: AND cz_rp_entries.seeded_flag <> '1';
7938:
7939: l_eff_tbl.DELETE;
7940: SELECT distinct devl_project_id
7941: BULK

Line 7984: from cz_rp_entries

7980: LOOP
7981: BEGIN
7982: SELECT enclosing_folder,name
7983: INTO l_encl_eff_fld,l_model_name
7984: from cz_rp_entries
7985: WHERE object_id = l_eff_ref(i)
7986: AND object_type = 'PRJ'
7987: AND deleted_flag = '0';
7988: EXCEPTION

Line 8017: FROM cz_rp_entries

8013: BEGIN
8014: ----check if archive exists
8015: SELECT object_id,name,seeded_flag,enclosing_folder
8016: INTO l_object_id,l_object_name,l_seeded_flag,l_encl_arc_fld
8017: FROM cz_rp_entries
8018: WHERE cz_rp_entries.object_id = l_arc_ref(modelId)
8019: AND cz_rp_entries.object_type = 'ARC'
8020: AND cz_rp_entries.deleted_flag = '0';
8021:

Line 8018: WHERE cz_rp_entries.object_id = l_arc_ref(modelId)

8014: ----check if archive exists
8015: SELECT object_id,name,seeded_flag,enclosing_folder
8016: INTO l_object_id,l_object_name,l_seeded_flag,l_encl_arc_fld
8017: FROM cz_rp_entries
8018: WHERE cz_rp_entries.object_id = l_arc_ref(modelId)
8019: AND cz_rp_entries.object_type = 'ARC'
8020: AND cz_rp_entries.deleted_flag = '0';
8021:
8022: l_devl_project_tbl.DELETE;

Line 8019: AND cz_rp_entries.object_type = 'ARC'

8015: SELECT object_id,name,seeded_flag,enclosing_folder
8016: INTO l_object_id,l_object_name,l_seeded_flag,l_encl_arc_fld
8017: FROM cz_rp_entries
8018: WHERE cz_rp_entries.object_id = l_arc_ref(modelId)
8019: AND cz_rp_entries.object_type = 'ARC'
8020: AND cz_rp_entries.deleted_flag = '0';
8021:
8022: l_devl_project_tbl.DELETE;
8023: SELECT DISTINCT devl_project_id

Line 8020: AND cz_rp_entries.deleted_flag = '0';

8016: INTO l_object_id,l_object_name,l_seeded_flag,l_encl_arc_fld
8017: FROM cz_rp_entries
8018: WHERE cz_rp_entries.object_id = l_arc_ref(modelId)
8019: AND cz_rp_entries.object_type = 'ARC'
8020: AND cz_rp_entries.deleted_flag = '0';
8021:
8022: l_devl_project_tbl.DELETE;
8023: SELECT DISTINCT devl_project_id
8024: BULK

Line 8031: FROM cz_rp_entries

8027: FROM cz_archive_refs
8028: WHERE cz_archive_refs.archive_id = l_arc_ref(modelId)
8029: AND cz_archive_refs.deleted_flag = '0'
8030: AND cz_archive_refs.devl_project_id IN (SELECT object_id
8031: FROM cz_rp_entries
8032: WHERE object_type = 'PRJ'
8033: AND deleted_flag = '0');
8034: IF (l_devl_project_tbl.COUNT > 0) THEN
8035: FOR I IN l_devl_project_tbl.FIRST..l_devl_project_tbl.LAST

Line 8039: FROM cz_rp_entries

8035: FOR I IN l_devl_project_tbl.FIRST..l_devl_project_tbl.LAST
8036: LOOP
8037: SELECT name,enclosing_folder
8038: into l_devl_name,l_encl_arc_fld
8039: FROM cz_rp_entries
8040: WHERE object_id = l_devl_project_tbl(i)
8041: AND object_type = 'PRJ';
8042: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld ) ) THEN
8043: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8065: FROM cz_rp_entries

8061: BEGIN
8062:
8063: SELECT object_id,name,seeded_flag
8064: INTO l_object_id,l_object_name,l_seeded_flag
8065: FROM cz_rp_entries
8066: WHERE cz_rp_entries.object_id = l_prp_ref(modelId)
8067: AND cz_rp_entries.object_type = 'PRP'
8068: AND cz_rp_entries.deleted_flag = '0';
8069:

Line 8066: WHERE cz_rp_entries.object_id = l_prp_ref(modelId)

8062:
8063: SELECT object_id,name,seeded_flag
8064: INTO l_object_id,l_object_name,l_seeded_flag
8065: FROM cz_rp_entries
8066: WHERE cz_rp_entries.object_id = l_prp_ref(modelId)
8067: AND cz_rp_entries.object_type = 'PRP'
8068: AND cz_rp_entries.deleted_flag = '0';
8069:
8070: SELECT devl_project_id BULK COLLECT INTO l_devl_project_tbl

Line 8067: AND cz_rp_entries.object_type = 'PRP'

8063: SELECT object_id,name,seeded_flag
8064: INTO l_object_id,l_object_name,l_seeded_flag
8065: FROM cz_rp_entries
8066: WHERE cz_rp_entries.object_id = l_prp_ref(modelId)
8067: AND cz_rp_entries.object_type = 'PRP'
8068: AND cz_rp_entries.deleted_flag = '0';
8069:
8070: SELECT devl_project_id BULK COLLECT INTO l_devl_project_tbl
8071: FROM (SELECT devl_project_id

Line 8068: AND cz_rp_entries.deleted_flag = '0';

8064: INTO l_object_id,l_object_name,l_seeded_flag
8065: FROM cz_rp_entries
8066: WHERE cz_rp_entries.object_id = l_prp_ref(modelId)
8067: AND cz_rp_entries.object_type = 'PRP'
8068: AND cz_rp_entries.deleted_flag = '0';
8069:
8070: SELECT devl_project_id BULK COLLECT INTO l_devl_project_tbl
8071: FROM (SELECT devl_project_id
8072: FROM cz_ps_prop_vals psp,

Line 8094: FROM cz_rp_entries WHERE object_id = l_devl_project_tbl(j)

8090: IF (l_devl_project_tbl.COUNT > 0) THEN
8091: FOR J IN l_devl_project_tbl.FIRST..l_devl_project_tbl.LAST
8092: LOOP
8093: SELECT enclosing_folder into l_encl_arc_fld
8094: FROM cz_rp_entries WHERE object_id = l_devl_project_tbl(j)
8095: AND object_type = 'PRJ';
8096: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8097: x_return_status := FND_API.G_RET_STS_ERROR;
8098: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');

Line 8156: FROM cz_rp_entries

8152: LOOP
8153: BEGIN
8154: SELECT object_id,name,seeded_flag
8155: INTO l_object_id,l_object_name,l_seeded_flag
8156: FROM cz_rp_entries
8157: WHERE cz_rp_entries.object_id = l_umt_ref(modelId)
8158: AND cz_rp_entries.object_type = 'UMT'
8159: AND cz_rp_entries.deleted_flag = '0';
8160:

Line 8157: WHERE cz_rp_entries.object_id = l_umt_ref(modelId)

8153: BEGIN
8154: SELECT object_id,name,seeded_flag
8155: INTO l_object_id,l_object_name,l_seeded_flag
8156: FROM cz_rp_entries
8157: WHERE cz_rp_entries.object_id = l_umt_ref(modelId)
8158: AND cz_rp_entries.object_type = 'UMT'
8159: AND cz_rp_entries.deleted_flag = '0';
8160:
8161: l_ui_name_tbl.DELETE;

Line 8158: AND cz_rp_entries.object_type = 'UMT'

8154: SELECT object_id,name,seeded_flag
8155: INTO l_object_id,l_object_name,l_seeded_flag
8156: FROM cz_rp_entries
8157: WHERE cz_rp_entries.object_id = l_umt_ref(modelId)
8158: AND cz_rp_entries.object_type = 'UMT'
8159: AND cz_rp_entries.deleted_flag = '0';
8160:
8161: l_ui_name_tbl.DELETE;
8162: SELECT name

Line 8159: AND cz_rp_entries.deleted_flag = '0';

8155: INTO l_object_id,l_object_name,l_seeded_flag
8156: FROM cz_rp_entries
8157: WHERE cz_rp_entries.object_id = l_umt_ref(modelId)
8158: AND cz_rp_entries.object_type = 'UMT'
8159: AND cz_rp_entries.deleted_flag = '0';
8160:
8161: l_ui_name_tbl.DELETE;
8162: SELECT name
8163: BULK

Line 8171: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'

8167: WHERE cz_ui_defs.from_master_template_id = l_umt_ref(modelId)
8168: AND cz_ui_defs.deleted_flag = '0'
8169: AND cz_ui_defs.seeded_flag <> '1'
8170: --Additional Checks added. Must be a active model
8171: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
8172: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ');
8173:
8174: IF (l_ui_name_tbl.count > 0 ) THEN
8175: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8198: FROM cz_rp_entries

8194: LOOP
8195: BEGIN
8196: SELECT object_id,name,seeded_flag
8197: INTO l_object_id,l_object_name,l_seeded_flag
8198: FROM cz_rp_entries
8199: WHERE cz_rp_entries.object_id = l_uct_ref(modelId)
8200: AND cz_rp_entries.object_type = 'UCT'
8201: AND cz_rp_entries.deleted_flag = '0';
8202:

Line 8199: WHERE cz_rp_entries.object_id = l_uct_ref(modelId)

8195: BEGIN
8196: SELECT object_id,name,seeded_flag
8197: INTO l_object_id,l_object_name,l_seeded_flag
8198: FROM cz_rp_entries
8199: WHERE cz_rp_entries.object_id = l_uct_ref(modelId)
8200: AND cz_rp_entries.object_type = 'UCT'
8201: AND cz_rp_entries.deleted_flag = '0';
8202:
8203: l_ui_name_tbl.DELETE;

Line 8200: AND cz_rp_entries.object_type = 'UCT'

8196: SELECT object_id,name,seeded_flag
8197: INTO l_object_id,l_object_name,l_seeded_flag
8198: FROM cz_rp_entries
8199: WHERE cz_rp_entries.object_id = l_uct_ref(modelId)
8200: AND cz_rp_entries.object_type = 'UCT'
8201: AND cz_rp_entries.deleted_flag = '0';
8202:
8203: l_ui_name_tbl.DELETE;
8204: SELECT name

Line 8201: AND cz_rp_entries.deleted_flag = '0';

8197: INTO l_object_id,l_object_name,l_seeded_flag
8198: FROM cz_rp_entries
8199: WHERE cz_rp_entries.object_id = l_uct_ref(modelId)
8200: AND cz_rp_entries.object_type = 'UCT'
8201: AND cz_rp_entries.deleted_flag = '0';
8202:
8203: l_ui_name_tbl.DELETE;
8204: SELECT name
8205: BULK

Line 8220: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'

8216: FROM cz_ui_page_elements
8217: WHERE cz_ui_page_elements.ctrl_template_id = l_uct_ref(modelId)
8218: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
8219: AND cz_ui_page_elements.deleted_flag = '0')
8220: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
8221: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ')
8222: AND cz_ui_defs.deleted_flag = '0';
8223:
8224: IF (l_ui_name_tbl.count > 0 ) THEN

Line 8352: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)

8348: LOOP
8349: l_map_has_usg_id := mapHasUsageId(l_usg_ref(modelId), v_masks_nodes(i));
8350: IF (l_map_has_usg_id = 1) THEN
8351: SELECT enclosing_folder,name into l_encl_arc_fld,l_model_name
8352: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8353: AND object_type = 'PRJ';
8354: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8355: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8356: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);

Line 8373: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)

8369: LOOP
8370: l_map_has_usg_id := mapHasUsageId(l_usg_ref(modelId), v_masks_rules(i));
8371: IF (l_map_has_usg_id = 1) THEN
8372: SELECT enclosing_folder,name into l_encl_arc_fld,l_model_name
8373: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8374: AND object_type = 'PRJ';
8375: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8376: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8377: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);

Line 8434: FROM cz_rp_entries

8430: SELECT object_id
8431: BULK
8432: COLLECT
8433: INTO l_rp_fld_tbl
8434: FROM cz_rp_entries
8435: WHERE cz_rp_entries.deleted_flag = '0'
8436: AND cz_rp_entries.object_type = 'FLD'
8437: START WITH cz_rp_entries.object_type = 'FLD'
8438: AND cz_rp_entries.object_id = p_rp_folder_id

Line 8435: WHERE cz_rp_entries.deleted_flag = '0'

8431: BULK
8432: COLLECT
8433: INTO l_rp_fld_tbl
8434: FROM cz_rp_entries
8435: WHERE cz_rp_entries.deleted_flag = '0'
8436: AND cz_rp_entries.object_type = 'FLD'
8437: START WITH cz_rp_entries.object_type = 'FLD'
8438: AND cz_rp_entries.object_id = p_rp_folder_id
8439: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder

Line 8436: AND cz_rp_entries.object_type = 'FLD'

8432: COLLECT
8433: INTO l_rp_fld_tbl
8434: FROM cz_rp_entries
8435: WHERE cz_rp_entries.deleted_flag = '0'
8436: AND cz_rp_entries.object_type = 'FLD'
8437: START WITH cz_rp_entries.object_type = 'FLD'
8438: AND cz_rp_entries.object_id = p_rp_folder_id
8439: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8440: AND PRIOR cz_rp_entries.object_type = 'FLD';

Line 8437: START WITH cz_rp_entries.object_type = 'FLD'

8433: INTO l_rp_fld_tbl
8434: FROM cz_rp_entries
8435: WHERE cz_rp_entries.deleted_flag = '0'
8436: AND cz_rp_entries.object_type = 'FLD'
8437: START WITH cz_rp_entries.object_type = 'FLD'
8438: AND cz_rp_entries.object_id = p_rp_folder_id
8439: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8440: AND PRIOR cz_rp_entries.object_type = 'FLD';
8441:

Line 8438: AND cz_rp_entries.object_id = p_rp_folder_id

8434: FROM cz_rp_entries
8435: WHERE cz_rp_entries.deleted_flag = '0'
8436: AND cz_rp_entries.object_type = 'FLD'
8437: START WITH cz_rp_entries.object_type = 'FLD'
8438: AND cz_rp_entries.object_id = p_rp_folder_id
8439: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8440: AND PRIOR cz_rp_entries.object_type = 'FLD';
8441:
8442: is_repos_fld_deleteable (p_rp_folder_id,x_return_status,x_msg_count,x_msg_data);

Line 8439: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder

8435: WHERE cz_rp_entries.deleted_flag = '0'
8436: AND cz_rp_entries.object_type = 'FLD'
8437: START WITH cz_rp_entries.object_type = 'FLD'
8438: AND cz_rp_entries.object_id = p_rp_folder_id
8439: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8440: AND PRIOR cz_rp_entries.object_type = 'FLD';
8441:
8442: is_repos_fld_deleteable (p_rp_folder_id,x_return_status,x_msg_count,x_msg_data);
8443: IF ( (x_return_status = FND_API.g_ret_sts_success)

Line 8440: AND PRIOR cz_rp_entries.object_type = 'FLD';

8436: AND cz_rp_entries.object_type = 'FLD'
8437: START WITH cz_rp_entries.object_type = 'FLD'
8438: AND cz_rp_entries.object_id = p_rp_folder_id
8439: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8440: AND PRIOR cz_rp_entries.object_type = 'FLD';
8441:
8442: is_repos_fld_deleteable (p_rp_folder_id,x_return_status,x_msg_count,x_msg_data);
8443: IF ( (x_return_status = FND_API.g_ret_sts_success)
8444: AND (l_rp_fld_tbl.COUNT > 0) ) THEN

Line 8454: FROM cz_rp_entries

8450: SELECT object_id, object_type
8451: BULK
8452: COLLECT
8453: INTO l_object_id_tbl, l_object_typ_tbl
8454: FROM cz_rp_entries
8455: WHERE object_type <> 'FLD'
8456: AND enclosing_folder = l_rp_fld_tbl(i)
8457: AND deleted_flag = '0';
8458: EXCEPTION

Line 8495: UPDATE cz_rp_entries

8491:
8492: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8493: WHILE (l_count > 0)
8494: LOOP
8495: UPDATE cz_rp_entries
8496: SET deleted_flag = '1',
8497: name = append_name (l_rp_fld_tbl(l_count), 'FLD', name)
8498: WHERE object_type = 'FLD'
8499: AND object_id = l_rp_fld_tbl(l_count);

Line 8536: INSERT INTO cz_rp_entries(object_id, object_type, enclosing_folder, name)

8532: usageId := try_id;
8533: UPDATE cz_model_usages SET
8534: in_use = '1', name = 'New Usage ' || try_id
8535: WHERE model_usage_id = try_id AND in_use = 'X';
8536: INSERT INTO cz_rp_entries(object_id, object_type, enclosing_folder, name)
8537: VALUES (usageId, 'USG',enclosingFolderId, 'New Usage ' || try_id);
8538: EXIT;
8539: END LOOP;
8540: CLOSE Xed_usages;

Line 8565: FROM cz_rp_entries

8561: BEGIN
8562: BEGIN
8563: SELECT name
8564: INTO original_name
8565: FROM cz_rp_entries
8566: WHERE object_id = p_object_id
8567: AND object_type = p_object_type
8568: AND deleted_flag = '0';
8569: EXCEPTION

Line 8582: FROM cz_rp_entries

8578: BEGIN
8579:
8580: SELECT nvl(max(to_number(substr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),7,instr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),')',7)-7))),0)
8581: INTO L
8582: FROM cz_rp_entries
8583: WHERE name LIKE 'Copy (%) of '||original_name
8584: and instr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),'Copy (',7)=0
8585: and is_val_number(substr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),7,instr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),')',7)-7))='TRUE'
8586: AND deleted_flag = '0' and object_type=p_object_type;