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 3116: l_name CZ_RP_ENTRIES.name%TYPE;

3112: p_object_id IN NUMBER,
3113: p_object_type IN VARCHAR2
3114: ) RETURN VARCHAR2 IS
3115:
3116: l_name CZ_RP_ENTRIES.name%TYPE;
3117: l_root_name CZ_RP_ENTRIES.name%TYPE;
3118: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3119: l_repository_path VARCHAR2(32000);
3120:

Line 3117: l_root_name CZ_RP_ENTRIES.name%TYPE;

3113: p_object_type IN VARCHAR2
3114: ) RETURN VARCHAR2 IS
3115:
3116: l_name CZ_RP_ENTRIES.name%TYPE;
3117: l_root_name CZ_RP_ENTRIES.name%TYPE;
3118: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3119: l_repository_path VARCHAR2(32000);
3120:
3121: BEGIN

Line 3118: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;

3114: ) RETURN VARCHAR2 IS
3115:
3116: l_name CZ_RP_ENTRIES.name%TYPE;
3117: l_root_name CZ_RP_ENTRIES.name%TYPE;
3118: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3119: l_repository_path VARCHAR2(32000);
3120:
3121: BEGIN
3122:

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

3119: l_repository_path VARCHAR2(32000);
3120:
3121: BEGIN
3122:
3123: SELECT name,enclosing_folder INTO l_repository_path,l_enclosing_folder FROM CZ_RP_ENTRIES
3124: WHERE object_id=p_object_id AND object_type=p_object_type AND deleted_flag='0';
3125:
3126: l_repository_path := set_name_entity(l_repository_path);
3127:

Line 3129: FOR i IN(SELECT name FROM CZ_RP_ENTRIES

3125:
3126: l_repository_path := set_name_entity(l_repository_path);
3127:
3128: IF l_enclosing_folder<>0 THEN
3129: FOR i IN(SELECT name FROM CZ_RP_ENTRIES
3130: START WITH object_id=l_enclosing_folder AND object_type='FLD' AND deleted_flag='0'
3131: CONNECT BY PRIOR enclosing_folder=object_id
3132: AND deleted_flag='0' AND PRIOR deleted_flag='0'
3133: AND object_type='FLD' AND PRIOR object_type='FLD' AND object_id<>0 AND PRIOR object_id<>0)

Line 3143: SELECT name INTO l_root_name FROM CZ_RP_ENTRIES

3139: END IF;
3140:
3141: IF NOT(l_enclosing_folder=0 AND p_object_id=0 AND p_object_type='FLD') THEN
3142: BEGIN
3143: SELECT name INTO l_root_name FROM CZ_RP_ENTRIES
3144: WHERE object_id=0 AND object_type='FLD' AND deleted_flag='0' AND rownum<2;
3145:
3146: --If the name contains special symbols, enclose the name in single quotes.
3147:

Line 3171: l_name CZ_RP_ENTRIES.name%TYPE;

3167: p_rule_folder_id IN NUMBER,
3168: p_object_type IN VARCHAR2
3169: ) RETURN VARCHAR2 IS
3170:
3171: l_name CZ_RP_ENTRIES.name%TYPE;
3172: l_root_name CZ_RP_ENTRIES.name%TYPE;
3173: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3174: l_rule_folder_path VARCHAR2(32000);
3175:

Line 3172: l_root_name CZ_RP_ENTRIES.name%TYPE;

3168: p_object_type IN VARCHAR2
3169: ) RETURN VARCHAR2 IS
3170:
3171: l_name CZ_RP_ENTRIES.name%TYPE;
3172: l_root_name CZ_RP_ENTRIES.name%TYPE;
3173: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3174: l_rule_folder_path VARCHAR2(32000);
3175:
3176: BEGIN

Line 3173: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;

3169: ) RETURN VARCHAR2 IS
3170:
3171: l_name CZ_RP_ENTRIES.name%TYPE;
3172: l_root_name CZ_RP_ENTRIES.name%TYPE;
3173: l_enclosing_folder CZ_RP_ENTRIES.enclosing_folder%TYPE;
3174: l_rule_folder_path VARCHAR2(32000);
3175:
3176: BEGIN
3177:

Line 3319: l_folder_name cz_rp_entries.name%TYPE;

3315: l_model_id NUMBER;
3316: l_run_id NUMBER;
3317: l_status VARCHAR2(255);
3318: l_new_id NUMBER;
3319: l_folder_name cz_rp_entries.name%TYPE;
3320:
3321: BEGIN
3322:
3323: --initialize the message stack depending on the input parameter

Line 3333: FROM cz_rp_entries

3329: x_return_status := FND_API.G_RET_STS_SUCCESS;
3330:
3331: BEGIN
3332: SELECT name INTO l_folder_name
3333: FROM cz_rp_entries
3334: WHERE object_id = p_encl_folder_id
3335: AND object_type = 'FLD'
3336: AND deleted_flag = '0';
3337: EXCEPTION

Line 3345: FROM CZ_RP_ENTRIES

3341:
3342: BEGIN
3343: SELECT object_id,object_type , enclosing_folder
3344: BULK COLLECT INTO l_object_id_tbl,l_object_type_tbl, l_encl_folder_tbl
3345: FROM CZ_RP_ENTRIES
3346: START WITH object_id=p_folder_id AND object_type='FLD' AND deleted_flag='0'
3347: CONNECT BY PRIOR object_id=ENCLOSING_FOLDER AND PRIOR object_type = 'FLD' AND deleted_flag='0'
3348: AND PRIOR deleted_flag='0';
3349:

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

3373: END LOOP;
3374: END IF;
3375:
3376: IF l_object_type_tbl(i)='FLD' THEN
3377: l_new_object_id_tbl(i) := allocateId('CZ_RP_ENTRIES_S');
3378:
3379: -- Create the new folder
3380:
3381: INSERT INTO CZ_RP_ENTRIES

Line 3381: INSERT INTO CZ_RP_ENTRIES

3377: l_new_object_id_tbl(i) := allocateId('CZ_RP_ENTRIES_S');
3378:
3379: -- Create the new folder
3380:
3381: INSERT INTO CZ_RP_ENTRIES
3382: (
3383: OBJECT_TYPE
3384: ,OBJECT_ID
3385: ,ENCLOSING_FOLDER

Line 3401: FROM CZ_RP_ENTRIES

3397: ,DESCRIPTION
3398: ,NOTES
3399: ,0
3400: ,DELETED_FLAG
3401: FROM CZ_RP_ENTRIES
3402: WHERE object_id=l_object_id_tbl(i) AND object_type=l_object_type_tbl(i)
3403: AND deleted_flag='0';
3404:
3405: ELSIF l_object_type_tbl(i)='EFF' THEN

Line 3839: FROM cz_rp_entries

3835: AND r.ui_def_id = d.ui_def_id
3836: AND d.deleted_flag = '0'
3837: AND r.deleted_flag = '0'
3838: AND d.devl_project_id IN (SELECT object_id
3839: FROM cz_rp_entries
3840: WHERE cz_rp_entries.object_type = 'PRJ'
3841: AND cz_rp_entries.deleted_flag = '0');
3842:
3843: ---------------------------------

Line 3840: WHERE cz_rp_entries.object_type = 'PRJ'

3836: AND d.deleted_flag = '0'
3837: AND r.deleted_flag = '0'
3838: AND d.devl_project_id IN (SELECT object_id
3839: FROM cz_rp_entries
3840: WHERE cz_rp_entries.object_type = 'PRJ'
3841: AND cz_rp_entries.deleted_flag = '0');
3842:
3843: ---------------------------------
3844: -- referencing UI Defs HTML Style

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

3837: AND r.deleted_flag = '0'
3838: AND d.devl_project_id IN (SELECT object_id
3839: FROM cz_rp_entries
3840: WHERE cz_rp_entries.object_type = 'PRJ'
3841: AND cz_rp_entries.deleted_flag = '0');
3842:
3843: ---------------------------------
3844: -- referencing UI Defs HTML Style
3845: ---------------------------------

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

4554:
4555: --
4556: -- is_model_deleteable
4557: -- Parameters :
4558: -- p_model_id - object_id in cz_rp_entries where object_type = 'PRJ'
4559: -- x_return_status - status string: 'S', 'E', 'U'
4560: -- x_msg_count - number of error messages
4561: -- x_msg_data - string which contains error messages
4562:

Line 4613: FROM cz_rp_entries a, cz_devl_projects b

4609: ------------------------------
4610: BEGIN
4611: SELECT a.seeded_flag, a.name, a.deleted_flag, checkout_user
4612: INTO l_seeded_flag, l_model_name, l_deleted_flag, l_checkout_user
4613: FROM cz_rp_entries a, cz_devl_projects b
4614: WHERE object_id = p_model_id
4615: AND object_type = 'PRJ'
4616: AND object_id = devl_project_id;
4617: EXCEPTION

Line 4845: UPDATE cz_rp_entries

4841: x_msg_data => x_msg_data);
4842: ELSE
4843: l_usage_name := copy_name(p_model_usage_id,'USG');
4844:
4845: UPDATE cz_rp_entries
4846: SET name = l_usage_name
4847: WHERE object_id = usageID
4848: AND object_type = 'USG';
4849:

Line 4896: l_name cz_rp_entries.name%TYPE;

4892: l_api_version CONSTANT NUMBER := 1.0;
4893: l_api_name CONSTANT VARCHAR2(30) := 'copy_property';
4894: INVALID_PROPERTY_ID_EXCP EXCEPTION;
4895: USER_IS_NULL_EXCP EXCEPTION;
4896: l_name cz_rp_entries.name%TYPE;
4897: l_new_intl_text_id cz_localized_texts.intl_text_id%TYPE;
4898: l_text_id NUMBER;
4899:
4900: BEGIN

Line 4975: INSERT INTO CZ_RP_ENTRIES

4971: END LOOP;
4972:
4973: --Create Repository Entry
4974:
4975: INSERT INTO CZ_RP_ENTRIES
4976: (
4977: OBJECT_TYPE
4978: ,OBJECT_ID
4979: ,ENCLOSING_FOLDER

Line 4995: FROM CZ_RP_ENTRIES

4991: ,DESCRIPTION
4992: ,NOTES
4993: ,'0'
4994: ,DELETED_FLAG
4995: FROM CZ_RP_ENTRIES
4996: WHERE object_id= p_property_id AND object_type='PRP'
4997: AND deleted_flag='0';
4998:
4999: IF SQL%ROWCOUNT = 0 THEN

Line 5039: l_name cz_rp_entries.name%TYPE;

5035: l_api_version CONSTANT NUMBER := 1.0;
5036: l_api_name CONSTANT VARCHAR2(30) := 'copy_effectivity_set';
5037: INVALID_EFF_SET_ID_EXCP EXCEPTION;
5038: USER_IS_NULL_EXCP EXCEPTION;
5039: l_name cz_rp_entries.name%TYPE;
5040: BEGIN
5041: FND_MSG_PUB.initialize;
5042: x_return_status := FND_API.G_RET_STS_SUCCESS;
5043: x_new_effectivity_set_id := allocateId('CZ_EFFECTIVITY_SETS_S');

Line 5045: INSERT INTO CZ_RP_ENTRIES

5041: FND_MSG_PUB.initialize;
5042: x_return_status := FND_API.G_RET_STS_SUCCESS;
5043: x_new_effectivity_set_id := allocateId('CZ_EFFECTIVITY_SETS_S');
5044: l_name := copy_name(p_effectivity_set_id,'EFF');
5045: INSERT INTO CZ_RP_ENTRIES
5046: (
5047: OBJECT_TYPE
5048: ,OBJECT_ID
5049: ,ENCLOSING_FOLDER

Line 5065: FROM CZ_RP_ENTRIES

5061: ,DESCRIPTION
5062: ,NOTES
5063: ,'0'
5064: ,DELETED_FLAG
5065: FROM CZ_RP_ENTRIES
5066: WHERE object_id= p_effectivity_set_id AND object_type='EFF'
5067: AND deleted_flag='0';
5068:
5069: IF SQL%ROWCOUNT = 0 THEN

Line 5177: INSERT INTO CZ_RP_ENTRIES

5173: END IF;
5174:
5175: --Create Repository Entry
5176:
5177: INSERT INTO CZ_RP_ENTRIES
5178: (
5179: OBJECT_TYPE
5180: ,OBJECT_ID
5181: ,ENCLOSING_FOLDER

Line 5197: FROM CZ_RP_ENTRIES

5193: ,DESCRIPTION
5194: ,NOTES
5195: ,'0'
5196: ,DELETED_FLAG
5197: FROM CZ_RP_ENTRIES
5198: WHERE object_id= p_archive_id AND object_type='ARC'
5199: AND deleted_flag='0';
5200:
5201: IF SQL%ROWCOUNT = 0 THEN

Line 5910: l_name cz_rp_entries.name%TYPE;

5906: -- l_api_name CONSTANT VARCHAR2(30) := 'copy_ui_template';
5907: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5908: l_copied_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5909: INVALID_TEMPLATE_ID_EXCP EXCEPTION;
5910: l_name cz_rp_entries.name%TYPE;
5911: l_title_id NUMBER;
5912: l_main_message_id NUMBER;
5913: l_old_title_id NUMBER;
5914: l_old_main_message_id NUMBER;

Line 6066: INSERT INTO CZ_RP_ENTRIES

6062: deleted_flag='0';
6063:
6064: --Create Repository Entry
6065:
6066: INSERT INTO CZ_RP_ENTRIES
6067: (
6068: OBJECT_TYPE
6069: ,OBJECT_ID
6070: ,ENCLOSING_FOLDER

Line 6086: FROM CZ_RP_ENTRIES

6082: ,DESCRIPTION
6083: ,NOTES
6084: ,'0'
6085: ,DELETED_FLAG
6086: FROM CZ_RP_ENTRIES
6087: WHERE object_id= p_template_id AND object_type='UCT'
6088: AND deleted_flag='0';
6089:
6090: IF SQL%ROWCOUNT = 0 THEN

Line 6158: l_name cz_rp_entries.name%TYPE;

6154:
6155: l_api_version CONSTANT NUMBER := 1.0;
6156: l_api_name CONSTANT VARCHAR2(30) := 'copy_ui_master_template';
6157: INVALID_UIDEF_ID_EXCP EXCEPTION;
6158: l_name cz_rp_entries.name%TYPE;
6159:
6160: BEGIN
6161: x_new_ui_def_id := allocateId('CZ_UI_DEFS_S');
6162: l_name := copy_name(p_ui_def_id,'UMT');

Line 6345: INSERT INTO CZ_RP_ENTRIES

6341: WHERE ui_def_id = p_ui_def_id AND deleted_flag='0';
6342:
6343: --Create Repository Entry
6344:
6345: INSERT INTO CZ_RP_ENTRIES
6346: (
6347: OBJECT_TYPE
6348: ,OBJECT_ID
6349: ,ENCLOSING_FOLDER

Line 6365: FROM CZ_RP_ENTRIES

6361: ,DESCRIPTION
6362: ,NOTES
6363: ,'0'
6364: ,DELETED_FLAG
6365: FROM CZ_RP_ENTRIES
6366: WHERE object_id= p_ui_def_id AND object_type='UMT'
6367: AND deleted_flag='0';
6368:
6369: IF SQL%ROWCOUNT = 0 THEN

Line 6415: FROM cz_rp_entries

6411:
6412: ----check if eff set exists
6413: SELECT object_id,name
6414: INTO l_eff_set_id,l_eff_name
6415: FROM cz_rp_entries
6416: WHERE cz_rp_entries.object_id = p_eff_set_id
6417: AND cz_rp_entries.object_type = 'EFF'
6418: AND cz_rp_entries.deleted_flag = '0'
6419: AND cz_rp_entries.seeded_flag <> '1';

Line 6416: WHERE cz_rp_entries.object_id = p_eff_set_id

6412: ----check if eff set exists
6413: SELECT object_id,name
6414: INTO l_eff_set_id,l_eff_name
6415: FROM cz_rp_entries
6416: WHERE cz_rp_entries.object_id = p_eff_set_id
6417: AND cz_rp_entries.object_type = 'EFF'
6418: AND cz_rp_entries.deleted_flag = '0'
6419: AND cz_rp_entries.seeded_flag <> '1';
6420:

Line 6417: AND cz_rp_entries.object_type = 'EFF'

6413: SELECT object_id,name
6414: INTO l_eff_set_id,l_eff_name
6415: FROM cz_rp_entries
6416: WHERE cz_rp_entries.object_id = p_eff_set_id
6417: AND cz_rp_entries.object_type = 'EFF'
6418: AND cz_rp_entries.deleted_flag = '0'
6419: AND cz_rp_entries.seeded_flag <> '1';
6420:
6421: SELECT name BULK COLLECT INTO l_prj_name_tbl

Line 6418: AND cz_rp_entries.deleted_flag = '0'

6414: INTO l_eff_set_id,l_eff_name
6415: FROM cz_rp_entries
6416: WHERE cz_rp_entries.object_id = p_eff_set_id
6417: AND cz_rp_entries.object_type = 'EFF'
6418: AND cz_rp_entries.deleted_flag = '0'
6419: AND cz_rp_entries.seeded_flag <> '1';
6420:
6421: SELECT name BULK COLLECT INTO l_prj_name_tbl
6422: FROM cz_devl_projects

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

6415: FROM cz_rp_entries
6416: WHERE cz_rp_entries.object_id = p_eff_set_id
6417: AND cz_rp_entries.object_type = 'EFF'
6418: AND cz_rp_entries.deleted_flag = '0'
6419: AND cz_rp_entries.seeded_flag <> '1';
6420:
6421: SELECT name BULK COLLECT INTO l_prj_name_tbl
6422: FROM cz_devl_projects
6423: WHERE deleted_flag = '0' AND devl_project_id IN

Line 6480: UPDATE cz_rp_entries

6476: SET deleted_flag = '1',
6477: name = append_name(p_eff_set_id, 'EFF', name)
6478: WHERE effectivity_set_id = p_eff_set_id;
6479:
6480: UPDATE cz_rp_entries
6481: SET deleted_flag = '1',
6482: name = append_name(p_eff_set_id, 'EFF', name)
6483: WHERE object_id = p_eff_set_id
6484: AND object_type = 'EFF';

Line 6509: l_object_id cz_rp_entries.object_id%TYPE;

6505: x_msg_data OUT NOCOPY VARCHAR2)
6506: IS
6507:
6508: l_devl_project_tbl t_indexes;
6509: l_object_id cz_rp_entries.object_id%TYPE;
6510: l_object_name cz_rp_entries.name%TYPE;
6511: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6512: l_devl_name cz_devl_projects.name%TYPE;
6513: BEGIN

Line 6510: l_object_name cz_rp_entries.name%TYPE;

6506: IS
6507:
6508: l_devl_project_tbl t_indexes;
6509: l_object_id cz_rp_entries.object_id%TYPE;
6510: l_object_name cz_rp_entries.name%TYPE;
6511: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6512: l_devl_name cz_devl_projects.name%TYPE;
6513: BEGIN
6514: FND_MSG_PUB.initialize;

Line 6511: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;

6507:
6508: l_devl_project_tbl t_indexes;
6509: l_object_id cz_rp_entries.object_id%TYPE;
6510: l_object_name cz_rp_entries.name%TYPE;
6511: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6512: l_devl_name cz_devl_projects.name%TYPE;
6513: BEGIN
6514: FND_MSG_PUB.initialize;
6515: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6523: FROM cz_rp_entries

6519: ----check if archive exists
6520: BEGIN
6521: SELECT object_id,name,seeded_flag
6522: INTO l_object_id,l_object_name,l_seeded_flag
6523: FROM cz_rp_entries
6524: WHERE cz_rp_entries.object_id = p_archive_id
6525: AND cz_rp_entries.object_type = 'ARC'
6526: AND cz_rp_entries.deleted_flag = '0';
6527: EXCEPTION

Line 6524: WHERE cz_rp_entries.object_id = p_archive_id

6520: BEGIN
6521: SELECT object_id,name,seeded_flag
6522: INTO l_object_id,l_object_name,l_seeded_flag
6523: FROM cz_rp_entries
6524: WHERE cz_rp_entries.object_id = p_archive_id
6525: AND cz_rp_entries.object_type = 'ARC'
6526: AND cz_rp_entries.deleted_flag = '0';
6527: EXCEPTION
6528: WHEN NO_DATA_FOUND THEN

Line 6525: AND cz_rp_entries.object_type = 'ARC'

6521: SELECT object_id,name,seeded_flag
6522: INTO l_object_id,l_object_name,l_seeded_flag
6523: FROM cz_rp_entries
6524: WHERE cz_rp_entries.object_id = p_archive_id
6525: AND cz_rp_entries.object_type = 'ARC'
6526: AND cz_rp_entries.deleted_flag = '0';
6527: EXCEPTION
6528: WHEN NO_DATA_FOUND THEN
6529: l_object_id := -1;

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

6522: INTO l_object_id,l_object_name,l_seeded_flag
6523: FROM cz_rp_entries
6524: WHERE cz_rp_entries.object_id = p_archive_id
6525: AND cz_rp_entries.object_type = 'ARC'
6526: AND cz_rp_entries.deleted_flag = '0';
6527: EXCEPTION
6528: WHEN NO_DATA_FOUND THEN
6529: l_object_id := -1;
6530: END;

Line 6549: FROM cz_rp_entries

6545: FROM cz_archive_refs
6546: WHERE cz_archive_refs.archive_id = p_archive_id
6547: AND cz_archive_refs.deleted_flag = '0'
6548: AND cz_archive_refs.devl_project_id IN (SELECT object_id
6549: FROM cz_rp_entries
6550: WHERE object_type = 'PRJ'
6551: AND deleted_flag = '0');
6552:
6553: IF (l_devl_project_tbl.COUNT > 0) THEN

Line 6609: UPDATE cz_rp_entries

6605: x_msg_data := '';
6606:
6607: is_archive_deleteable(p_archive_id,l_return_status,l_msg_count,l_msg_data);
6608: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6609: UPDATE cz_rp_entries
6610: set deleted_flag = '1',
6611: name = append_name(p_archive_id, 'ARC', name)
6612: where object_id = p_archive_id
6613: and object_type = 'ARC'

Line 6643: l_object_id cz_rp_entries.object_id%TYPE;

6639: x_msg_count OUT NOCOPY NUMBER,
6640: x_msg_data OUT NOCOPY VARCHAR2)
6641: IS
6642:
6643: l_object_id cz_rp_entries.object_id%TYPE;
6644: l_object_name cz_rp_entries.name%TYPE;
6645: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6646: l_ps_prop_count NUMBER := 0;
6647: l_item_prop_count NUMBER := 0;

Line 6644: l_object_name cz_rp_entries.name%TYPE;

6640: x_msg_data OUT NOCOPY VARCHAR2)
6641: IS
6642:
6643: l_object_id cz_rp_entries.object_id%TYPE;
6644: l_object_name cz_rp_entries.name%TYPE;
6645: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6646: l_ps_prop_count NUMBER := 0;
6647: l_item_prop_count NUMBER := 0;
6648: l_ui_pages_count NUMBER := 0;

Line 6645: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;

6641: IS
6642:
6643: l_object_id cz_rp_entries.object_id%TYPE;
6644: l_object_name cz_rp_entries.name%TYPE;
6645: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6646: l_ps_prop_count NUMBER := 0;
6647: l_item_prop_count NUMBER := 0;
6648: l_ui_pages_count NUMBER := 0;
6649: l_prop_count NUMBER := 0;

Line 6663: FROM cz_rp_entries

6659: ----check if prop exists
6660: BEGIN
6661: SELECT object_id,name,seeded_flag
6662: INTO l_object_id,l_object_name,l_seeded_flag
6663: FROM cz_rp_entries
6664: WHERE cz_rp_entries.object_id = p_property_id
6665: AND cz_rp_entries.object_type = 'PRP'
6666: AND cz_rp_entries.deleted_flag = '0';
6667: EXCEPTION

Line 6664: WHERE cz_rp_entries.object_id = p_property_id

6660: BEGIN
6661: SELECT object_id,name,seeded_flag
6662: INTO l_object_id,l_object_name,l_seeded_flag
6663: FROM cz_rp_entries
6664: WHERE cz_rp_entries.object_id = p_property_id
6665: AND cz_rp_entries.object_type = 'PRP'
6666: AND cz_rp_entries.deleted_flag = '0';
6667: EXCEPTION
6668: WHEN NO_DATA_FOUND THEN

Line 6665: AND cz_rp_entries.object_type = 'PRP'

6661: SELECT object_id,name,seeded_flag
6662: INTO l_object_id,l_object_name,l_seeded_flag
6663: FROM cz_rp_entries
6664: WHERE cz_rp_entries.object_id = p_property_id
6665: AND cz_rp_entries.object_type = 'PRP'
6666: AND cz_rp_entries.deleted_flag = '0';
6667: EXCEPTION
6668: WHEN NO_DATA_FOUND THEN
6669: l_object_id := -1;

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

6662: INTO l_object_id,l_object_name,l_seeded_flag
6663: FROM cz_rp_entries
6664: WHERE cz_rp_entries.object_id = p_property_id
6665: AND cz_rp_entries.object_type = 'PRP'
6666: AND cz_rp_entries.deleted_flag = '0';
6667: EXCEPTION
6668: WHEN NO_DATA_FOUND THEN
6669: l_object_id := -1;
6670: END;

Line 6773: UPDATE cz_rp_entries

6769: x_msg_data := '';
6770:
6771: is_property_deleteable(p_property_id,l_return_status,l_msg_count,l_msg_data);
6772: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6773: UPDATE cz_rp_entries
6774: SET deleted_flag = '1',
6775: name = append_name(p_property_id, 'PRP', name)
6776: WHERE object_id = p_property_id
6777: AND object_type = 'PRP'

Line 6806: l_object_id cz_rp_entries.object_id%TYPE;

6802: x_msg_count OUT NOCOPY NUMBER,
6803: x_msg_data OUT NOCOPY VARCHAR2)
6804: IS
6805:
6806: l_object_id cz_rp_entries.object_id%TYPE;
6807: l_object_name cz_rp_entries.name%TYPE;
6808: l_seeded_flag VARCHAR2(1);
6809: TYPE ui_name_tbl is TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
6810: l_ui_name_tbl ui_name_tbl;

Line 6807: l_object_name cz_rp_entries.name%TYPE;

6803: x_msg_data OUT NOCOPY VARCHAR2)
6804: IS
6805:
6806: l_object_id cz_rp_entries.object_id%TYPE;
6807: l_object_name cz_rp_entries.name%TYPE;
6808: l_seeded_flag VARCHAR2(1);
6809: TYPE ui_name_tbl is TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
6810: l_ui_name_tbl ui_name_tbl;
6811:

Line 6822: FROM cz_rp_entries

6818:
6819: BEGIN
6820: SELECT object_id,name,seeded_flag
6821: INTO l_object_id,l_object_name,l_seeded_flag
6822: FROM cz_rp_entries
6823: WHERE cz_rp_entries.object_id = p_umt_id
6824: AND cz_rp_entries.object_type = 'UMT'
6825: AND cz_rp_entries.deleted_flag = '0';
6826: EXCEPTION

Line 6823: WHERE cz_rp_entries.object_id = p_umt_id

6819: BEGIN
6820: SELECT object_id,name,seeded_flag
6821: INTO l_object_id,l_object_name,l_seeded_flag
6822: FROM cz_rp_entries
6823: WHERE cz_rp_entries.object_id = p_umt_id
6824: AND cz_rp_entries.object_type = 'UMT'
6825: AND cz_rp_entries.deleted_flag = '0';
6826: EXCEPTION
6827: WHEN NO_DATA_FOUND THEN

Line 6824: AND cz_rp_entries.object_type = 'UMT'

6820: SELECT object_id,name,seeded_flag
6821: INTO l_object_id,l_object_name,l_seeded_flag
6822: FROM cz_rp_entries
6823: WHERE cz_rp_entries.object_id = p_umt_id
6824: AND cz_rp_entries.object_type = 'UMT'
6825: AND cz_rp_entries.deleted_flag = '0';
6826: EXCEPTION
6827: WHEN NO_DATA_FOUND THEN
6828: l_object_id := -1;

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

6821: INTO l_object_id,l_object_name,l_seeded_flag
6822: FROM cz_rp_entries
6823: WHERE cz_rp_entries.object_id = p_umt_id
6824: AND cz_rp_entries.object_type = 'UMT'
6825: AND cz_rp_entries.deleted_flag = '0';
6826: EXCEPTION
6827: WHEN NO_DATA_FOUND THEN
6828: l_object_id := -1;
6829: END;

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

6843: FROM cz_ui_defs ui
6844: WHERE from_master_template_id = p_umt_id
6845: AND deleted_flag = '0'
6846: AND seeded_flag <> '1'
6847: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
6848: AND object_id = ui.devl_project_id and object_type = 'PRJ');
6849: EXCEPTION
6850: WHEN NO_DATA_FOUND THEN
6851: l_object_id := -1;

Line 6904: UPDATE cz_rp_entries

6900: x_msg_data := '';
6901:
6902: is_umt_deleteable(p_umt_id,l_return_status,l_msg_count,l_msg_data);
6903: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6904: UPDATE cz_rp_entries
6905: SET deleted_flag = '1',
6906: name = append_name(p_umt_id, 'UMT', name)
6907: WHERE object_id = p_umt_id
6908: AND object_type = 'UMT';

Line 6940: l_object_id cz_rp_entries.object_id%TYPE;

6936: IS
6937: TYPE ui_name_tbl is TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
6938: TYPE num_type_tbl is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6939:
6940: l_object_id cz_rp_entries.object_id%TYPE;
6941: l_object_name cz_rp_entries.name%TYPE;
6942: l_seeded_flag VARCHAR2(1);
6943: l_ui_name_tbl ui_name_tbl;
6944: l_mt_flag_tbl ui_name_tbl;

Line 6941: l_object_name cz_rp_entries.name%TYPE;

6937: TYPE ui_name_tbl is TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
6938: TYPE num_type_tbl is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6939:
6940: l_object_id cz_rp_entries.object_id%TYPE;
6941: l_object_name cz_rp_entries.name%TYPE;
6942: l_seeded_flag VARCHAR2(1);
6943: l_ui_name_tbl ui_name_tbl;
6944: l_mt_flag_tbl ui_name_tbl;
6945: l_ref_template_tbl num_type_tbl;

Line 6959: FROM cz_rp_entries

6955: -- check if p_uct_id exists
6956: BEGIN
6957: SELECT object_id,name,seeded_flag
6958: INTO l_object_id,l_object_name,l_seeded_flag
6959: FROM cz_rp_entries
6960: WHERE cz_rp_entries.object_id = p_uct_id
6961: AND cz_rp_entries.object_type = 'UCT'
6962: AND cz_rp_entries.deleted_flag = '0';
6963: EXCEPTION

Line 6960: WHERE cz_rp_entries.object_id = p_uct_id

6956: BEGIN
6957: SELECT object_id,name,seeded_flag
6958: INTO l_object_id,l_object_name,l_seeded_flag
6959: FROM cz_rp_entries
6960: WHERE cz_rp_entries.object_id = p_uct_id
6961: AND cz_rp_entries.object_type = 'UCT'
6962: AND cz_rp_entries.deleted_flag = '0';
6963: EXCEPTION
6964: WHEN NO_DATA_FOUND THEN

Line 6961: AND cz_rp_entries.object_type = 'UCT'

6957: SELECT object_id,name,seeded_flag
6958: INTO l_object_id,l_object_name,l_seeded_flag
6959: FROM cz_rp_entries
6960: WHERE cz_rp_entries.object_id = p_uct_id
6961: AND cz_rp_entries.object_type = 'UCT'
6962: AND cz_rp_entries.deleted_flag = '0';
6963: EXCEPTION
6964: WHEN NO_DATA_FOUND THEN
6965: l_object_id := -1;

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

6958: INTO l_object_id,l_object_name,l_seeded_flag
6959: FROM cz_rp_entries
6960: WHERE cz_rp_entries.object_id = p_uct_id
6961: AND cz_rp_entries.object_type = 'UCT'
6962: AND cz_rp_entries.deleted_flag = '0';
6963: EXCEPTION
6964: WHEN NO_DATA_FOUND THEN
6965: l_object_id := -1;
6966: END;

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

6990: FROM cz_ui_page_elements
6991: WHERE cz_ui_page_elements.ctrl_template_id = p_uct_id
6992: AND cz_ui_page_elements.ctrl_template_ui_def_id = 0
6993: AND cz_ui_page_elements.deleted_flag = '0')
6994: AND exists (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
6995: AND object_id = ui.devl_project_id and object_type = 'PRJ');
6996: EXCEPTION
6997: WHEN NO_DATA_FOUND THEN
6998: l_object_id := -1;

Line 7093: UPDATE cz_rp_entries

7089: x_msg_data := '';
7090:
7091: is_uct_deleteable(p_uct_id,l_return_status,l_msg_count,l_msg_data);
7092: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7093: UPDATE cz_rp_entries
7094: SET deleted_flag = '1',
7095: name = append_name(p_uct_id, 'UCT', name)
7096: WHERE object_id = p_uct_id
7097: AND object_type = 'UCT'

Line 7418: DELETE FROM cz_rp_entries

7414:
7415: DELETE FROM cz_publication_usages
7416: WHERE usage_id = usageId;
7417:
7418: DELETE FROM cz_rp_entries
7419: WHERE object_type ='USG' and object_id = usageId;
7420:
7421: IF (v_nodes.COUNT > 0) THEN
7422: v_first_index := v_masks_nodes.FIRST;

Line 7548: l_object_id cz_rp_entries.object_id%TYPE;

7544: l_encl_eff_fld NUMBER := 0;
7545: l_eff_name VARCHAR2(255);
7546:
7547: l_devl_project_tbl number_type_tbl;
7548: l_object_id cz_rp_entries.object_id%TYPE;
7549: l_object_name cz_rp_entries.name%TYPE;
7550: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
7551: l_devl_name cz_devl_projects.name%TYPE;
7552: l_encl_arc_fld NUMBER := 0;

Line 7549: l_object_name cz_rp_entries.name%TYPE;

7545: l_eff_name VARCHAR2(255);
7546:
7547: l_devl_project_tbl number_type_tbl;
7548: l_object_id cz_rp_entries.object_id%TYPE;
7549: l_object_name cz_rp_entries.name%TYPE;
7550: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
7551: l_devl_name cz_devl_projects.name%TYPE;
7552: l_encl_arc_fld NUMBER := 0;
7553:

Line 7550: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;

7546:
7547: l_devl_project_tbl number_type_tbl;
7548: l_object_id cz_rp_entries.object_id%TYPE;
7549: l_object_name cz_rp_entries.name%TYPE;
7550: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
7551: l_devl_name cz_devl_projects.name%TYPE;
7552: l_encl_arc_fld NUMBER := 0;
7553:
7554: l_usg_tbl number_type_tbl;

Line 7576: l_fld_name cz_rp_entries.name%TYPE;

7572: rec_count NUMBER := 0;
7573: l_checkout_user cz_devl_projects.checkout_user%TYPE;
7574: l_model_name cz_devl_projects.name%TYPE;
7575: l_template_name cz_ui_templates.template_name%TYPE;
7576: l_fld_name cz_rp_entries.name%TYPE;
7577: l_priv VARCHAR2(1) := 'F';
7578: l_return_status VARCHAR2(1);
7579: l_msg_count NUMBER := 0;
7580: l_msg_data VARCHAR2(2000);

Line 7619: FROM cz_rp_entries

7615: l_user_name := FND_GLOBAL.user_name;
7616: ------check if p_rp_folder_id exists
7617: SELECT object_id
7618: INTO l_rp_folder
7619: FROM cz_rp_entries
7620: WHERE cz_rp_entries.object_id = p_rp_folder_id
7621: AND cz_rp_entries.object_type = 'FLD'
7622: AND cz_rp_entries.deleted_flag = '0';
7623:

Line 7620: WHERE cz_rp_entries.object_id = p_rp_folder_id

7616: ------check if p_rp_folder_id exists
7617: SELECT object_id
7618: INTO l_rp_folder
7619: FROM cz_rp_entries
7620: WHERE cz_rp_entries.object_id = p_rp_folder_id
7621: AND cz_rp_entries.object_type = 'FLD'
7622: AND cz_rp_entries.deleted_flag = '0';
7623:
7624: l_rp_fld_tbl.DELETE;

Line 7621: AND cz_rp_entries.object_type = 'FLD'

7617: SELECT object_id
7618: INTO l_rp_folder
7619: FROM cz_rp_entries
7620: WHERE cz_rp_entries.object_id = p_rp_folder_id
7621: AND cz_rp_entries.object_type = 'FLD'
7622: AND cz_rp_entries.deleted_flag = '0';
7623:
7624: l_rp_fld_tbl.DELETE;
7625: l_encl_idx_ref.DELETE;

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

7618: INTO l_rp_folder
7619: FROM cz_rp_entries
7620: WHERE cz_rp_entries.object_id = p_rp_folder_id
7621: AND cz_rp_entries.object_type = 'FLD'
7622: AND cz_rp_entries.deleted_flag = '0';
7623:
7624: l_rp_fld_tbl.DELETE;
7625: l_encl_idx_ref.DELETE;
7626: l_encl_fld_tbl.DELETE;

Line 7631: FROM cz_rp_entries

7627: SELECT object_id,enclosing_folder
7628: BULK
7629: COLLECT
7630: INTO l_rp_fld_tbl,l_encl_fld_tbl
7631: FROM cz_rp_entries
7632: WHERE cz_rp_entries.deleted_flag = '0'
7633: AND cz_rp_entries.object_type = 'FLD'
7634: START WITH cz_rp_entries.object_type = 'FLD'
7635: AND cz_rp_entries.object_id = l_rp_folder

Line 7632: WHERE cz_rp_entries.deleted_flag = '0'

7628: BULK
7629: COLLECT
7630: INTO l_rp_fld_tbl,l_encl_fld_tbl
7631: FROM cz_rp_entries
7632: WHERE cz_rp_entries.deleted_flag = '0'
7633: AND cz_rp_entries.object_type = 'FLD'
7634: START WITH cz_rp_entries.object_type = 'FLD'
7635: AND cz_rp_entries.object_id = l_rp_folder
7636: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder

Line 7633: AND cz_rp_entries.object_type = 'FLD'

7629: COLLECT
7630: INTO l_rp_fld_tbl,l_encl_fld_tbl
7631: FROM cz_rp_entries
7632: WHERE cz_rp_entries.deleted_flag = '0'
7633: AND cz_rp_entries.object_type = 'FLD'
7634: START WITH cz_rp_entries.object_type = 'FLD'
7635: AND cz_rp_entries.object_id = l_rp_folder
7636: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
7637: AND PRIOR cz_rp_entries.object_type = 'FLD';

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

7630: INTO l_rp_fld_tbl,l_encl_fld_tbl
7631: FROM cz_rp_entries
7632: WHERE cz_rp_entries.deleted_flag = '0'
7633: AND cz_rp_entries.object_type = 'FLD'
7634: START WITH cz_rp_entries.object_type = 'FLD'
7635: AND cz_rp_entries.object_id = l_rp_folder
7636: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
7637: AND PRIOR cz_rp_entries.object_type = 'FLD';
7638:

Line 7635: AND cz_rp_entries.object_id = l_rp_folder

7631: FROM cz_rp_entries
7632: WHERE cz_rp_entries.deleted_flag = '0'
7633: AND cz_rp_entries.object_type = 'FLD'
7634: START WITH cz_rp_entries.object_type = 'FLD'
7635: AND cz_rp_entries.object_id = l_rp_folder
7636: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
7637: AND PRIOR cz_rp_entries.object_type = 'FLD';
7638:
7639: ---l_folder_count := l_rp_fld_tbl.COUNT + 1;

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

7632: WHERE cz_rp_entries.deleted_flag = '0'
7633: AND cz_rp_entries.object_type = 'FLD'
7634: START WITH cz_rp_entries.object_type = 'FLD'
7635: AND cz_rp_entries.object_id = l_rp_folder
7636: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
7637: AND PRIOR cz_rp_entries.object_type = 'FLD';
7638:
7639: ---l_folder_count := l_rp_fld_tbl.COUNT + 1;
7640: ---l_rp_fld_tbl(l_folder_count) := l_rp_folder;

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

7633: AND cz_rp_entries.object_type = 'FLD'
7634: START WITH cz_rp_entries.object_type = 'FLD'
7635: AND cz_rp_entries.object_id = l_rp_folder
7636: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
7637: AND PRIOR cz_rp_entries.object_type = 'FLD';
7638:
7639: ---l_folder_count := l_rp_fld_tbl.COUNT + 1;
7640: ---l_rp_fld_tbl(l_folder_count) := l_rp_folder;
7641: ---l_encl_fld_tbl(l_folder_count) := -1;

Line 7652: FROM cz_rp_entries, cz_devl_projects

7648: l_rp_model_tbl.DELETE;
7649: SELECT object_id, checkout_user, cz_devl_projects.name
7650: BULK COLLECT
7651: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
7652: FROM cz_rp_entries, cz_devl_projects
7653: WHERE cz_rp_entries.object_type = 'PRJ'
7654: AND cz_rp_entries.deleted_flag = '0'
7655: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7656: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;

Line 7653: WHERE cz_rp_entries.object_type = 'PRJ'

7649: SELECT object_id, checkout_user, cz_devl_projects.name
7650: BULK COLLECT
7651: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
7652: FROM cz_rp_entries, cz_devl_projects
7653: WHERE cz_rp_entries.object_type = 'PRJ'
7654: AND cz_rp_entries.deleted_flag = '0'
7655: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7656: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
7657:

Line 7654: AND cz_rp_entries.deleted_flag = '0'

7650: BULK COLLECT
7651: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
7652: FROM cz_rp_entries, cz_devl_projects
7653: WHERE cz_rp_entries.object_type = 'PRJ'
7654: AND cz_rp_entries.deleted_flag = '0'
7655: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7656: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
7657:
7658: IF (l_rp_model_tbl.COUNT > 0) THEN

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

7651: INTO l_rp_model_tbl, l_checkout_user_tbl, l_devl_prj_name_tbl
7652: FROM cz_rp_entries, cz_devl_projects
7653: WHERE cz_rp_entries.object_type = 'PRJ'
7654: AND cz_rp_entries.deleted_flag = '0'
7655: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7656: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
7657:
7658: IF (l_rp_model_tbl.COUNT > 0) THEN
7659: rec_count := l_rp_model_ref.COUNT;

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

7652: FROM cz_rp_entries, cz_devl_projects
7653: WHERE cz_rp_entries.object_type = 'PRJ'
7654: AND cz_rp_entries.deleted_flag = '0'
7655: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7656: AND cz_rp_entries.object_id = cz_devl_projects.devl_project_id;
7657:
7658: IF (l_rp_model_tbl.COUNT > 0) THEN
7659: rec_count := l_rp_model_ref.COUNT;
7660: FOR J IN l_rp_model_tbl.FIRST..l_rp_model_tbl.LAST

Line 7679: FROM cz_rp_entries

7675: l_eff_set_tbl.DELETE;
7676: SELECT object_id
7677: BULK COLLECT
7678: INTO l_eff_set_tbl
7679: FROM cz_rp_entries
7680: WHERE cz_rp_entries.object_type = 'EFF'
7681: AND cz_rp_entries.deleted_flag = '0'
7682: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7683:

Line 7680: WHERE cz_rp_entries.object_type = 'EFF'

7676: SELECT object_id
7677: BULK COLLECT
7678: INTO l_eff_set_tbl
7679: FROM cz_rp_entries
7680: WHERE cz_rp_entries.object_type = 'EFF'
7681: AND cz_rp_entries.deleted_flag = '0'
7682: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7683:
7684: IF (l_eff_set_tbl.COUNT > 0) THEN

Line 7681: AND cz_rp_entries.deleted_flag = '0'

7677: BULK COLLECT
7678: INTO l_eff_set_tbl
7679: FROM cz_rp_entries
7680: WHERE cz_rp_entries.object_type = 'EFF'
7681: AND cz_rp_entries.deleted_flag = '0'
7682: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7683:
7684: IF (l_eff_set_tbl.COUNT > 0) THEN
7685: rec_count := l_eff_set_ref.COUNT;

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

7678: INTO l_eff_set_tbl
7679: FROM cz_rp_entries
7680: WHERE cz_rp_entries.object_type = 'EFF'
7681: AND cz_rp_entries.deleted_flag = '0'
7682: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7683:
7684: IF (l_eff_set_tbl.COUNT > 0) THEN
7685: rec_count := l_eff_set_ref.COUNT;
7686: FOR J IN l_eff_set_tbl.FIRST..l_eff_set_tbl.LAST

Line 7698: FROM cz_rp_entries

7694: l_usg_tbl.DELETE;
7695: SELECT object_id
7696: BULK COLLECT
7697: INTO l_usg_tbl
7698: FROM cz_rp_entries
7699: WHERE cz_rp_entries.object_type = 'USG'
7700: AND cz_rp_entries.deleted_flag = '0'
7701: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7702:

Line 7699: WHERE cz_rp_entries.object_type = 'USG'

7695: SELECT object_id
7696: BULK COLLECT
7697: INTO l_usg_tbl
7698: FROM cz_rp_entries
7699: WHERE cz_rp_entries.object_type = 'USG'
7700: AND cz_rp_entries.deleted_flag = '0'
7701: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7702:
7703: IF (l_usg_tbl.COUNT > 0) THEN

Line 7700: AND cz_rp_entries.deleted_flag = '0'

7696: BULK COLLECT
7697: INTO l_usg_tbl
7698: FROM cz_rp_entries
7699: WHERE cz_rp_entries.object_type = 'USG'
7700: AND cz_rp_entries.deleted_flag = '0'
7701: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7702:
7703: IF (l_usg_tbl.COUNT > 0) THEN
7704: rec_count := l_usg_ref.COUNT;

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

7697: INTO l_usg_tbl
7698: FROM cz_rp_entries
7699: WHERE cz_rp_entries.object_type = 'USG'
7700: AND cz_rp_entries.deleted_flag = '0'
7701: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7702:
7703: IF (l_usg_tbl.COUNT > 0) THEN
7704: rec_count := l_usg_ref.COUNT;
7705: FOR J IN l_usg_tbl.FIRST..l_usg_tbl.LAST

Line 7717: FROM cz_rp_entries

7713: l_arc_tbl.DELETE;
7714: SELECT object_id
7715: BULK COLLECT
7716: INTO l_arc_tbl
7717: FROM cz_rp_entries
7718: WHERE cz_rp_entries.object_type = 'ARC'
7719: AND cz_rp_entries.deleted_flag = '0'
7720: AND cz_rp_entries.seeded_flag <> '1'
7721: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);

Line 7718: WHERE cz_rp_entries.object_type = 'ARC'

7714: SELECT object_id
7715: BULK COLLECT
7716: INTO l_arc_tbl
7717: FROM cz_rp_entries
7718: WHERE cz_rp_entries.object_type = 'ARC'
7719: AND cz_rp_entries.deleted_flag = '0'
7720: AND cz_rp_entries.seeded_flag <> '1'
7721: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7722:

Line 7719: AND cz_rp_entries.deleted_flag = '0'

7715: BULK COLLECT
7716: INTO l_arc_tbl
7717: FROM cz_rp_entries
7718: WHERE cz_rp_entries.object_type = 'ARC'
7719: AND cz_rp_entries.deleted_flag = '0'
7720: AND cz_rp_entries.seeded_flag <> '1'
7721: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7722:
7723: IF (l_arc_tbl.COUNT > 0) THEN

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

7716: INTO l_arc_tbl
7717: FROM cz_rp_entries
7718: WHERE cz_rp_entries.object_type = 'ARC'
7719: AND cz_rp_entries.deleted_flag = '0'
7720: AND cz_rp_entries.seeded_flag <> '1'
7721: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7722:
7723: IF (l_arc_tbl.COUNT > 0) THEN
7724: rec_count := l_arc_ref.COUNT;

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

7717: FROM cz_rp_entries
7718: WHERE cz_rp_entries.object_type = 'ARC'
7719: AND cz_rp_entries.deleted_flag = '0'
7720: AND cz_rp_entries.seeded_flag <> '1'
7721: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7722:
7723: IF (l_arc_tbl.COUNT > 0) THEN
7724: rec_count := l_arc_ref.COUNT;
7725: FOR J IN l_arc_tbl.FIRST..l_arc_tbl.LAST

Line 7737: FROM cz_rp_entries

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

Line 7738: WHERE cz_rp_entries.object_type = 'PRP'

7734: SELECT object_id
7735: BULK COLLECT
7736: INTO l_prp_tbl
7737: FROM cz_rp_entries
7738: WHERE cz_rp_entries.object_type = 'PRP'
7739: AND cz_rp_entries.deleted_flag = '0'
7740: AND cz_rp_entries.seeded_flag <> '1'
7741: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7742:

Line 7739: AND cz_rp_entries.deleted_flag = '0'

7735: BULK COLLECT
7736: INTO l_prp_tbl
7737: FROM cz_rp_entries
7738: WHERE cz_rp_entries.object_type = 'PRP'
7739: AND cz_rp_entries.deleted_flag = '0'
7740: AND cz_rp_entries.seeded_flag <> '1'
7741: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7742:
7743: IF (l_prp_tbl.COUNT > 0) THEN

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

7736: INTO l_prp_tbl
7737: FROM cz_rp_entries
7738: WHERE cz_rp_entries.object_type = 'PRP'
7739: AND cz_rp_entries.deleted_flag = '0'
7740: AND cz_rp_entries.seeded_flag <> '1'
7741: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7742:
7743: IF (l_prp_tbl.COUNT > 0) THEN
7744: rec_count := l_prp_ref.COUNT;

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

7737: FROM cz_rp_entries
7738: WHERE cz_rp_entries.object_type = 'PRP'
7739: AND cz_rp_entries.deleted_flag = '0'
7740: AND cz_rp_entries.seeded_flag <> '1'
7741: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7742:
7743: IF (l_prp_tbl.COUNT > 0) THEN
7744: rec_count := l_prp_ref.COUNT;
7745: FOR J IN l_prp_tbl.FIRST..l_prp_tbl.LAST

Line 7757: FROM cz_rp_entries

7753: l_umt_tbl.DELETE;
7754: SELECT object_id
7755: BULK COLLECT
7756: INTO l_umt_tbl
7757: FROM cz_rp_entries
7758: WHERE cz_rp_entries.object_type = 'UMT'
7759: AND cz_rp_entries.deleted_flag = '0'
7760: AND cz_rp_entries.seeded_flag <> '1'
7761: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);

Line 7758: WHERE cz_rp_entries.object_type = 'UMT'

7754: SELECT object_id
7755: BULK COLLECT
7756: INTO l_umt_tbl
7757: FROM cz_rp_entries
7758: WHERE cz_rp_entries.object_type = 'UMT'
7759: AND cz_rp_entries.deleted_flag = '0'
7760: AND cz_rp_entries.seeded_flag <> '1'
7761: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7762:

Line 7759: AND cz_rp_entries.deleted_flag = '0'

7755: BULK COLLECT
7756: INTO l_umt_tbl
7757: FROM cz_rp_entries
7758: WHERE cz_rp_entries.object_type = 'UMT'
7759: AND cz_rp_entries.deleted_flag = '0'
7760: AND cz_rp_entries.seeded_flag <> '1'
7761: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7762:
7763: IF (l_umt_tbl.COUNT > 0) THEN

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

7756: INTO l_umt_tbl
7757: FROM cz_rp_entries
7758: WHERE cz_rp_entries.object_type = 'UMT'
7759: AND cz_rp_entries.deleted_flag = '0'
7760: AND cz_rp_entries.seeded_flag <> '1'
7761: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7762:
7763: IF (l_umt_tbl.COUNT > 0) THEN
7764: rec_count := l_umt_ref.COUNT;

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

7757: FROM cz_rp_entries
7758: WHERE cz_rp_entries.object_type = 'UMT'
7759: AND cz_rp_entries.deleted_flag = '0'
7760: AND cz_rp_entries.seeded_flag <> '1'
7761: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i);
7762:
7763: IF (l_umt_tbl.COUNT > 0) THEN
7764: rec_count := l_umt_ref.COUNT;
7765: FOR J IN l_umt_tbl.FIRST..l_umt_tbl.LAST

Line 7777: FROM cz_rp_entries, cz_ui_templates

7773: l_uct_tbl.DELETE;
7774: SELECT object_id, checkout_user, template_name
7775: BULK COLLECT
7776: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
7777: FROM cz_rp_entries, cz_ui_templates
7778: WHERE cz_rp_entries.object_type = 'UCT'
7779: AND cz_rp_entries.deleted_flag = '0'
7780: AND cz_rp_entries.seeded_flag <> '1'
7781: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)

Line 7778: WHERE cz_rp_entries.object_type = 'UCT'

7774: SELECT object_id, checkout_user, template_name
7775: BULK COLLECT
7776: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
7777: FROM cz_rp_entries, cz_ui_templates
7778: WHERE cz_rp_entries.object_type = 'UCT'
7779: AND cz_rp_entries.deleted_flag = '0'
7780: AND cz_rp_entries.seeded_flag <> '1'
7781: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7782: AND cz_rp_entries.object_id = cz_ui_templates.template_id

Line 7779: AND cz_rp_entries.deleted_flag = '0'

7775: BULK COLLECT
7776: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
7777: FROM cz_rp_entries, cz_ui_templates
7778: WHERE cz_rp_entries.object_type = 'UCT'
7779: AND cz_rp_entries.deleted_flag = '0'
7780: AND cz_rp_entries.seeded_flag <> '1'
7781: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7782: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7783: AND cz_ui_templates.ui_def_id = 0;

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

7776: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
7777: FROM cz_rp_entries, cz_ui_templates
7778: WHERE cz_rp_entries.object_type = 'UCT'
7779: AND cz_rp_entries.deleted_flag = '0'
7780: AND cz_rp_entries.seeded_flag <> '1'
7781: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7782: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7783: AND cz_ui_templates.ui_def_id = 0;
7784:

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

7777: FROM cz_rp_entries, cz_ui_templates
7778: WHERE cz_rp_entries.object_type = 'UCT'
7779: AND cz_rp_entries.deleted_flag = '0'
7780: AND cz_rp_entries.seeded_flag <> '1'
7781: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7782: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7783: AND cz_ui_templates.ui_def_id = 0;
7784:
7785: IF (l_uct_tbl.COUNT > 0) THEN

Line 7782: AND cz_rp_entries.object_id = cz_ui_templates.template_id

7778: WHERE cz_rp_entries.object_type = 'UCT'
7779: AND cz_rp_entries.deleted_flag = '0'
7780: AND cz_rp_entries.seeded_flag <> '1'
7781: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7782: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7783: AND cz_ui_templates.ui_def_id = 0;
7784:
7785: IF (l_uct_tbl.COUNT > 0) THEN
7786: rec_count := l_uct_ref.COUNT;

Line 7816: cz_rp_entries rp

7812: COLLECT
7813: INTO l_ref_model_ids_tbl,l_ref_model_names_tbl,l_encl_devl_tbl
7814: FROM cz_ps_nodes p,
7815: cz_devl_projects d,
7816: cz_rp_entries rp
7817: WHERE p.reference_id = l_rp_model_ref(modelId)
7818: AND p.ps_node_type IN (263, 264)
7819: AND p.deleted_flag = '0'
7820: AND p.devl_project_id = d.devl_project_id

Line 7875: FROM cz_rp_entries

7871: LOOP
7872: BEGIN
7873: SELECT object_id,name
7874: INTO l_eff_set_id,l_eff_name
7875: FROM cz_rp_entries
7876: WHERE cz_rp_entries.object_id = l_eff_set_ref(i)
7877: AND cz_rp_entries.object_type = 'EFF'
7878: AND cz_rp_entries.deleted_flag = '0'
7879: AND cz_rp_entries.seeded_flag <> '1';

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

7872: BEGIN
7873: SELECT object_id,name
7874: INTO l_eff_set_id,l_eff_name
7875: FROM cz_rp_entries
7876: WHERE cz_rp_entries.object_id = l_eff_set_ref(i)
7877: AND cz_rp_entries.object_type = 'EFF'
7878: AND cz_rp_entries.deleted_flag = '0'
7879: AND cz_rp_entries.seeded_flag <> '1';
7880:

Line 7877: AND cz_rp_entries.object_type = 'EFF'

7873: SELECT object_id,name
7874: INTO l_eff_set_id,l_eff_name
7875: FROM cz_rp_entries
7876: WHERE cz_rp_entries.object_id = l_eff_set_ref(i)
7877: AND cz_rp_entries.object_type = 'EFF'
7878: AND cz_rp_entries.deleted_flag = '0'
7879: AND cz_rp_entries.seeded_flag <> '1';
7880:
7881: l_eff_tbl.DELETE;

Line 7878: AND cz_rp_entries.deleted_flag = '0'

7874: INTO l_eff_set_id,l_eff_name
7875: FROM cz_rp_entries
7876: WHERE cz_rp_entries.object_id = l_eff_set_ref(i)
7877: AND cz_rp_entries.object_type = 'EFF'
7878: AND cz_rp_entries.deleted_flag = '0'
7879: AND cz_rp_entries.seeded_flag <> '1';
7880:
7881: l_eff_tbl.DELETE;
7882: SELECT distinct devl_project_id

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

7875: FROM cz_rp_entries
7876: WHERE cz_rp_entries.object_id = l_eff_set_ref(i)
7877: AND cz_rp_entries.object_type = 'EFF'
7878: AND cz_rp_entries.deleted_flag = '0'
7879: AND cz_rp_entries.seeded_flag <> '1';
7880:
7881: l_eff_tbl.DELETE;
7882: SELECT distinct devl_project_id
7883: BULK

Line 7926: from cz_rp_entries

7922: LOOP
7923: BEGIN
7924: SELECT enclosing_folder,name
7925: INTO l_encl_eff_fld,l_model_name
7926: from cz_rp_entries
7927: WHERE object_id = l_eff_ref(i)
7928: AND object_type = 'PRJ'
7929: AND deleted_flag = '0';
7930: EXCEPTION

Line 7959: FROM cz_rp_entries

7955: BEGIN
7956: ----check if archive exists
7957: SELECT object_id,name,seeded_flag,enclosing_folder
7958: INTO l_object_id,l_object_name,l_seeded_flag,l_encl_arc_fld
7959: FROM cz_rp_entries
7960: WHERE cz_rp_entries.object_id = l_arc_ref(modelId)
7961: AND cz_rp_entries.object_type = 'ARC'
7962: AND cz_rp_entries.deleted_flag = '0';
7963:

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

7956: ----check if archive exists
7957: SELECT object_id,name,seeded_flag,enclosing_folder
7958: INTO l_object_id,l_object_name,l_seeded_flag,l_encl_arc_fld
7959: FROM cz_rp_entries
7960: WHERE cz_rp_entries.object_id = l_arc_ref(modelId)
7961: AND cz_rp_entries.object_type = 'ARC'
7962: AND cz_rp_entries.deleted_flag = '0';
7963:
7964: l_devl_project_tbl.DELETE;

Line 7961: AND cz_rp_entries.object_type = 'ARC'

7957: SELECT object_id,name,seeded_flag,enclosing_folder
7958: INTO l_object_id,l_object_name,l_seeded_flag,l_encl_arc_fld
7959: FROM cz_rp_entries
7960: WHERE cz_rp_entries.object_id = l_arc_ref(modelId)
7961: AND cz_rp_entries.object_type = 'ARC'
7962: AND cz_rp_entries.deleted_flag = '0';
7963:
7964: l_devl_project_tbl.DELETE;
7965: SELECT DISTINCT devl_project_id

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

7958: INTO l_object_id,l_object_name,l_seeded_flag,l_encl_arc_fld
7959: FROM cz_rp_entries
7960: WHERE cz_rp_entries.object_id = l_arc_ref(modelId)
7961: AND cz_rp_entries.object_type = 'ARC'
7962: AND cz_rp_entries.deleted_flag = '0';
7963:
7964: l_devl_project_tbl.DELETE;
7965: SELECT DISTINCT devl_project_id
7966: BULK

Line 7973: FROM cz_rp_entries

7969: FROM cz_archive_refs
7970: WHERE cz_archive_refs.archive_id = l_arc_ref(modelId)
7971: AND cz_archive_refs.deleted_flag = '0'
7972: AND cz_archive_refs.devl_project_id IN (SELECT object_id
7973: FROM cz_rp_entries
7974: WHERE object_type = 'PRJ'
7975: AND deleted_flag = '0');
7976: IF (l_devl_project_tbl.COUNT > 0) THEN
7977: FOR I IN l_devl_project_tbl.FIRST..l_devl_project_tbl.LAST

Line 7981: FROM cz_rp_entries

7977: FOR I IN l_devl_project_tbl.FIRST..l_devl_project_tbl.LAST
7978: LOOP
7979: SELECT name,enclosing_folder
7980: into l_devl_name,l_encl_arc_fld
7981: FROM cz_rp_entries
7982: WHERE object_id = l_devl_project_tbl(i)
7983: AND object_type = 'PRJ';
7984: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld ) ) THEN
7985: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8007: FROM cz_rp_entries

8003: BEGIN
8004:
8005: SELECT object_id,name,seeded_flag
8006: INTO l_object_id,l_object_name,l_seeded_flag
8007: FROM cz_rp_entries
8008: WHERE cz_rp_entries.object_id = l_prp_ref(modelId)
8009: AND cz_rp_entries.object_type = 'PRP'
8010: AND cz_rp_entries.deleted_flag = '0';
8011:

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

8004:
8005: SELECT object_id,name,seeded_flag
8006: INTO l_object_id,l_object_name,l_seeded_flag
8007: FROM cz_rp_entries
8008: WHERE cz_rp_entries.object_id = l_prp_ref(modelId)
8009: AND cz_rp_entries.object_type = 'PRP'
8010: AND cz_rp_entries.deleted_flag = '0';
8011:
8012: SELECT devl_project_id BULK COLLECT INTO l_devl_project_tbl

Line 8009: AND cz_rp_entries.object_type = 'PRP'

8005: SELECT object_id,name,seeded_flag
8006: INTO l_object_id,l_object_name,l_seeded_flag
8007: FROM cz_rp_entries
8008: WHERE cz_rp_entries.object_id = l_prp_ref(modelId)
8009: AND cz_rp_entries.object_type = 'PRP'
8010: AND cz_rp_entries.deleted_flag = '0';
8011:
8012: SELECT devl_project_id BULK COLLECT INTO l_devl_project_tbl
8013: FROM (SELECT devl_project_id

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

8006: INTO l_object_id,l_object_name,l_seeded_flag
8007: FROM cz_rp_entries
8008: WHERE cz_rp_entries.object_id = l_prp_ref(modelId)
8009: AND cz_rp_entries.object_type = 'PRP'
8010: AND cz_rp_entries.deleted_flag = '0';
8011:
8012: SELECT devl_project_id BULK COLLECT INTO l_devl_project_tbl
8013: FROM (SELECT devl_project_id
8014: FROM cz_ps_prop_vals psp,

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

8032: IF (l_devl_project_tbl.COUNT > 0) THEN
8033: FOR J IN l_devl_project_tbl.FIRST..l_devl_project_tbl.LAST
8034: LOOP
8035: SELECT enclosing_folder into l_encl_arc_fld
8036: FROM cz_rp_entries WHERE object_id = l_devl_project_tbl(j)
8037: AND object_type = 'PRJ';
8038: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8039: x_return_status := FND_API.G_RET_STS_ERROR;
8040: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');

Line 8098: FROM cz_rp_entries

8094: LOOP
8095: BEGIN
8096: SELECT object_id,name,seeded_flag
8097: INTO l_object_id,l_object_name,l_seeded_flag
8098: FROM cz_rp_entries
8099: WHERE cz_rp_entries.object_id = l_umt_ref(modelId)
8100: AND cz_rp_entries.object_type = 'UMT'
8101: AND cz_rp_entries.deleted_flag = '0';
8102:

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

8095: BEGIN
8096: SELECT object_id,name,seeded_flag
8097: INTO l_object_id,l_object_name,l_seeded_flag
8098: FROM cz_rp_entries
8099: WHERE cz_rp_entries.object_id = l_umt_ref(modelId)
8100: AND cz_rp_entries.object_type = 'UMT'
8101: AND cz_rp_entries.deleted_flag = '0';
8102:
8103: l_ui_name_tbl.DELETE;

Line 8100: AND cz_rp_entries.object_type = 'UMT'

8096: SELECT object_id,name,seeded_flag
8097: INTO l_object_id,l_object_name,l_seeded_flag
8098: FROM cz_rp_entries
8099: WHERE cz_rp_entries.object_id = l_umt_ref(modelId)
8100: AND cz_rp_entries.object_type = 'UMT'
8101: AND cz_rp_entries.deleted_flag = '0';
8102:
8103: l_ui_name_tbl.DELETE;
8104: SELECT name

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

8097: INTO l_object_id,l_object_name,l_seeded_flag
8098: FROM cz_rp_entries
8099: WHERE cz_rp_entries.object_id = l_umt_ref(modelId)
8100: AND cz_rp_entries.object_type = 'UMT'
8101: AND cz_rp_entries.deleted_flag = '0';
8102:
8103: l_ui_name_tbl.DELETE;
8104: SELECT name
8105: BULK

Line 8137: FROM cz_rp_entries

8133: LOOP
8134: BEGIN
8135: SELECT object_id,name,seeded_flag
8136: INTO l_object_id,l_object_name,l_seeded_flag
8137: FROM cz_rp_entries
8138: WHERE cz_rp_entries.object_id = l_uct_ref(modelId)
8139: AND cz_rp_entries.object_type = 'UCT'
8140: AND cz_rp_entries.deleted_flag = '0';
8141:

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

8134: BEGIN
8135: SELECT object_id,name,seeded_flag
8136: INTO l_object_id,l_object_name,l_seeded_flag
8137: FROM cz_rp_entries
8138: WHERE cz_rp_entries.object_id = l_uct_ref(modelId)
8139: AND cz_rp_entries.object_type = 'UCT'
8140: AND cz_rp_entries.deleted_flag = '0';
8141:
8142: l_ui_name_tbl.DELETE;

Line 8139: AND cz_rp_entries.object_type = 'UCT'

8135: SELECT object_id,name,seeded_flag
8136: INTO l_object_id,l_object_name,l_seeded_flag
8137: FROM cz_rp_entries
8138: WHERE cz_rp_entries.object_id = l_uct_ref(modelId)
8139: AND cz_rp_entries.object_type = 'UCT'
8140: AND cz_rp_entries.deleted_flag = '0';
8141:
8142: l_ui_name_tbl.DELETE;
8143: SELECT name

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

8136: INTO l_object_id,l_object_name,l_seeded_flag
8137: FROM cz_rp_entries
8138: WHERE cz_rp_entries.object_id = l_uct_ref(modelId)
8139: AND cz_rp_entries.object_type = 'UCT'
8140: AND cz_rp_entries.deleted_flag = '0';
8141:
8142: l_ui_name_tbl.DELETE;
8143: SELECT name
8144: BULK

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

8239: LOOP
8240: l_map_has_usg_id := mapHasUsageId(l_usg_ref(modelId), v_masks_nodes(i));
8241: IF (l_map_has_usg_id = 1) THEN
8242: SELECT enclosing_folder,name into l_encl_arc_fld,l_model_name
8243: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8244: AND object_type = 'PRJ';
8245: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8246: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8247: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);

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

8260: LOOP
8261: l_map_has_usg_id := mapHasUsageId(l_usg_ref(modelId), v_masks_rules(i));
8262: IF (l_map_has_usg_id = 1) THEN
8263: SELECT enclosing_folder,name into l_encl_arc_fld,l_model_name
8264: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8265: AND object_type = 'PRJ';
8266: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8267: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8268: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);

Line 8326: FROM cz_rp_entries

8322: SELECT object_id
8323: BULK
8324: COLLECT
8325: INTO l_rp_fld_tbl
8326: FROM cz_rp_entries
8327: WHERE cz_rp_entries.deleted_flag = '0'
8328: AND cz_rp_entries.object_type = 'FLD'
8329: START WITH cz_rp_entries.object_type = 'FLD'
8330: AND cz_rp_entries.object_id = p_rp_folder_id

Line 8327: WHERE cz_rp_entries.deleted_flag = '0'

8323: BULK
8324: COLLECT
8325: INTO l_rp_fld_tbl
8326: FROM cz_rp_entries
8327: WHERE cz_rp_entries.deleted_flag = '0'
8328: AND cz_rp_entries.object_type = 'FLD'
8329: START WITH cz_rp_entries.object_type = 'FLD'
8330: AND cz_rp_entries.object_id = p_rp_folder_id
8331: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder

Line 8328: AND cz_rp_entries.object_type = 'FLD'

8324: COLLECT
8325: INTO l_rp_fld_tbl
8326: FROM cz_rp_entries
8327: WHERE cz_rp_entries.deleted_flag = '0'
8328: AND cz_rp_entries.object_type = 'FLD'
8329: START WITH cz_rp_entries.object_type = 'FLD'
8330: AND cz_rp_entries.object_id = p_rp_folder_id
8331: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8332: AND PRIOR cz_rp_entries.object_type = 'FLD';

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

8325: INTO l_rp_fld_tbl
8326: FROM cz_rp_entries
8327: WHERE cz_rp_entries.deleted_flag = '0'
8328: AND cz_rp_entries.object_type = 'FLD'
8329: START WITH cz_rp_entries.object_type = 'FLD'
8330: AND cz_rp_entries.object_id = p_rp_folder_id
8331: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8332: AND PRIOR cz_rp_entries.object_type = 'FLD';
8333:

Line 8330: AND cz_rp_entries.object_id = p_rp_folder_id

8326: FROM cz_rp_entries
8327: WHERE cz_rp_entries.deleted_flag = '0'
8328: AND cz_rp_entries.object_type = 'FLD'
8329: START WITH cz_rp_entries.object_type = 'FLD'
8330: AND cz_rp_entries.object_id = p_rp_folder_id
8331: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8332: AND PRIOR cz_rp_entries.object_type = 'FLD';
8333:
8334: is_repos_fld_deleteable (p_rp_folder_id,x_return_status,x_msg_count,x_msg_data);

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

8327: WHERE cz_rp_entries.deleted_flag = '0'
8328: AND cz_rp_entries.object_type = 'FLD'
8329: START WITH cz_rp_entries.object_type = 'FLD'
8330: AND cz_rp_entries.object_id = p_rp_folder_id
8331: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8332: AND PRIOR cz_rp_entries.object_type = 'FLD';
8333:
8334: is_repos_fld_deleteable (p_rp_folder_id,x_return_status,x_msg_count,x_msg_data);
8335: IF ( (x_return_status = FND_API.g_ret_sts_success)

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

8328: AND cz_rp_entries.object_type = 'FLD'
8329: START WITH cz_rp_entries.object_type = 'FLD'
8330: AND cz_rp_entries.object_id = p_rp_folder_id
8331: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8332: AND PRIOR cz_rp_entries.object_type = 'FLD';
8333:
8334: is_repos_fld_deleteable (p_rp_folder_id,x_return_status,x_msg_count,x_msg_data);
8335: IF ( (x_return_status = FND_API.g_ret_sts_success)
8336: AND (l_rp_fld_tbl.COUNT > 0) ) THEN

Line 8346: FROM cz_rp_entries

8342: SELECT object_id, object_type
8343: BULK
8344: COLLECT
8345: INTO l_object_id_tbl, l_object_typ_tbl
8346: FROM cz_rp_entries
8347: WHERE object_type <> 'FLD'
8348: AND enclosing_folder = l_rp_fld_tbl(i)
8349: AND deleted_flag = '0';
8350: EXCEPTION

Line 8403: DELETE FROM CZ_RP_ENTRIES

8399: ELSIF (l_object_typ_tbl(i) = 'USG') THEN
8400: UPDATE cz_model_usages
8401: SET in_use = 'X'
8402: WHERE model_usage_id = l_object_id_tbl(i);
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

Line 8422: UPDATE cz_rp_entries

8418: END IF;
8419: END LOOP;
8420: COMMIT;
8421: END IF;
8422: UPDATE cz_rp_entries
8423: SET deleted_flag = '1',
8424: name = append_name (object_id,object_type,name)
8425: WHERE object_type <> 'FLD'
8426: AND enclosing_folder = l_rp_fld_tbl(i);

Line 8432: UPDATE cz_rp_entries

8428:
8429: l_count := l_rp_fld_tbl.COUNT;
8430: WHILE (l_count > 0)
8431: LOOP
8432: UPDATE cz_rp_entries
8433: SET deleted_flag = '1',
8434: name = append_name (l_rp_fld_tbl(l_count), 'FLD', name)
8435: WHERE object_type = 'FLD'
8436: AND object_id = l_rp_fld_tbl(l_count);

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

8481: usageId := try_id;
8482: UPDATE cz_model_usages SET
8483: in_use = '1', name = 'New Usage ' || try_id
8484: WHERE model_usage_id = try_id AND in_use = 'X';
8485: INSERT INTO cz_rp_entries(object_id, object_type, enclosing_folder, name)
8486: VALUES (usageId, 'USG',enclosingFolderId, 'New Usage ' || try_id);
8487: EXIT;
8488: END LOOP;
8489: CLOSE Xed_usages;

Line 8514: FROM cz_rp_entries

8510: BEGIN
8511: BEGIN
8512: SELECT name
8513: INTO original_name
8514: FROM cz_rp_entries
8515: WHERE object_id = p_object_id
8516: AND object_type = p_object_type
8517: AND deleted_flag = '0';
8518: EXCEPTION

Line 8531: FROM cz_rp_entries

8527: BEGIN
8528:
8529: 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)
8530: INTO L
8531: FROM cz_rp_entries
8532: WHERE name LIKE 'Copy (%) of '||original_name
8533: and instr(SUBSTR(name, 1, instr(name,original_name, -1, 1)-1),'Copy (',7)=0
8534: 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'
8535: AND deleted_flag = '0' and object_type=p_object_type;