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_DEVL_PROJECTS

Line 245: TYPE t_checkout_user_tbl IS TABLE OF cz_devl_projects.checkout_user%TYPE INDEX BY BINARY_INTEGER;

241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2)
243: IS
244:
245: TYPE t_checkout_user_tbl IS TABLE OF cz_devl_projects.checkout_user%TYPE INDEX BY BINARY_INTEGER;
246: TYPE number_type_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
247: TYPE name_tbl IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
248:
249: l_user_name cz_ui_templates.checkout_user%type;

Line 295: SELECT object_id, checkout_user, cz_devl_projects.name

291: LOOP
292:
293: ----collect all 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'

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 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 3561: TYPE l_tName IS TABLE OF cz_devl_projects.name%TYPE INDEX BY BINARY_INTEGER;

3557: IS
3558:
3559: l_procedure_name CONSTANT VARCHAR2(30) := 'delete_model_node';
3560:
3561: TYPE l_tName IS TABLE OF cz_devl_projects.name%TYPE INDEX BY BINARY_INTEGER;
3562:
3563: MODEL_LOCKED_EXCP EXCEPTION;
3564: INVALID_PS_NODE_ID_EXCP EXCEPTION;
3565: NO_PRIV_EXCP EXCEPTION;

Line 3840: l_checkout_user cz_devl_projects.checkout_user%TYPE;

3836: USER_IS_NULL_EXCP EXCEPTION;
3837: DEL_UI_IS_PUBLISHED EXCEPTION;
3838:
3839: l_user_name VARCHAR2(40);
3840: l_checkout_user cz_devl_projects.checkout_user%TYPE;
3841: l_priv VARCHAR2(1) := 'F';
3842: l_ui_def_tbl t_num_array_tbl_type;
3843: l_name_tbl l_tName;
3844:

Line 4146: l_checkout_user cz_devl_projects.checkout_user%TYPE;

4142: NOT_EDITABLE_EXCP EXCEPTION;
4143: USER_IS_NULL_EXCP EXCEPTION;
4144:
4145: l_user_name VARCHAR2(40);
4146: l_checkout_user cz_devl_projects.checkout_user%TYPE;
4147: l_model_name_tbl t_varchar_array_tbl_type;
4148: l_rule_folder_id_tbl t_num_array_tbl_type;
4149: l_object_type_tbl t_varchar_array_tbl_type;
4150: l_devl_project_id cz_rule_folders.devl_project_id%TYPE;

Line 4324: l_checkout_user cz_devl_projects.checkout_user%TYPE;

4320: NOT_EDITABLE_EXCP EXCEPTION;
4321: USER_IS_NULL_EXCP EXCEPTION;
4322:
4323: l_user_name VARCHAR2(40);
4324: l_checkout_user cz_devl_projects.checkout_user%TYPE;
4325: l_ui_def_tbl t_num_array_tbl_type; -- the referencing models
4326: l_model_name_tbl t_varchar_array_tbl_type;
4327: l_devl_project_id cz_ps_nodes.devl_project_id%TYPE;
4328:

Line 4473: l_checkout_user cz_devl_projects.checkout_user%TYPE;

4469: USER_IS_NULL_EXCP EXCEPTION;
4470: NO_PRIV_EXCP EXCEPTION;
4471:
4472: l_user_name VARCHAR2(40);
4473: l_checkout_user cz_devl_projects.checkout_user%TYPE;
4474: l_item_id_tbl t_num_array_tbl_type;
4475:
4476: CURSOR l_item_csr IS
4477: SELECT item_id

Line 4598: TYPE tModelNames IS TABLE OF cz_devl_projects.name%TYPE INDEX BY BINARY_INTEGER;

4594: x_msg_data OUT NOCOPY VARCHAR2)
4595: IS
4596:
4597: TYPE number_type_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4598: TYPE tModelNames IS TABLE OF cz_devl_projects.name%TYPE INDEX BY BINARY_INTEGER;
4599: TYPE tModelIds IS TABLE OF cz_devl_projects.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
4600:
4601: SEEDED_FLAG_EXCP EXCEPTION;
4602: MODEL_LOCKED EXCEPTION;

Line 4599: TYPE tModelIds IS TABLE OF cz_devl_projects.devl_project_id%TYPE INDEX BY BINARY_INTEGER;

4595: IS
4596:
4597: TYPE number_type_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4598: TYPE tModelNames IS TABLE OF cz_devl_projects.name%TYPE INDEX BY BINARY_INTEGER;
4599: TYPE tModelIds IS TABLE OF cz_devl_projects.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
4600:
4601: SEEDED_FLAG_EXCP EXCEPTION;
4602: MODEL_LOCKED EXCEPTION;
4603: NO_PRIV EXCEPTION;

Line 4612: l_checkout_user cz_devl_projects.checkout_user%TYPE;

4608: USER_IS_NULL_EXCP EXCEPTION;
4609: MODEL_DELETED EXCEPTION;
4610:
4611: l_user_name VARCHAR2(40);
4612: l_checkout_user cz_devl_projects.checkout_user%TYPE;
4613: l_model_name cz_devl_projects.name%TYPE;
4614: l_devl_project_id cz_devl_projects.devl_project_id%TYPE;
4615:
4616: l_priv VARCHAR2(1) := 'F';

Line 4613: l_model_name cz_devl_projects.name%TYPE;

4609: MODEL_DELETED EXCEPTION;
4610:
4611: l_user_name VARCHAR2(40);
4612: l_checkout_user cz_devl_projects.checkout_user%TYPE;
4613: l_model_name cz_devl_projects.name%TYPE;
4614: l_devl_project_id cz_devl_projects.devl_project_id%TYPE;
4615:
4616: l_priv VARCHAR2(1) := 'F';
4617: l_return_status VARCHAR2(1);

Line 4614: l_devl_project_id cz_devl_projects.devl_project_id%TYPE;

4610:
4611: l_user_name VARCHAR2(40);
4612: l_checkout_user cz_devl_projects.checkout_user%TYPE;
4613: l_model_name cz_devl_projects.name%TYPE;
4614: l_devl_project_id cz_devl_projects.devl_project_id%TYPE;
4615:
4616: l_priv VARCHAR2(1) := 'F';
4617: l_return_status VARCHAR2(1);
4618: l_msg_count NUMBER := 0;

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 4679: FROM cz_ps_nodes p, cz_devl_projects d

4675: BEGIN
4676:
4677: SELECT d.devl_project_id, d.name
4678: BULK COLLECT INTO x_ref_model_ids_tbl, x_ref_model_names_tbl
4679: FROM cz_ps_nodes p, cz_devl_projects d
4680: WHERE p.reference_id = p_model_id
4681: AND p.ps_node_type IN (263, 264)
4682: AND p.deleted_flag = '0'
4683: AND p.devl_project_id = d.devl_project_id

Line 4810: -- Note: Updating(logical deletion) to the RP_ENTRIES is done through the trigger on cz_devl_projects

4806: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4807: RAISE LOCK_MODEL_EXCP;
4808: END IF;
4809:
4810: -- Note: Updating(logical deletion) to the RP_ENTRIES is done through the trigger on cz_devl_projects
4811: UPDATE cz_devl_projects
4812: SET deleted_flag = '1',
4813: name = append_name (p_model_id, 'PRJ', name)
4814: WHERE devl_project_id = p_model_id

Line 4811: UPDATE cz_devl_projects

4807: RAISE LOCK_MODEL_EXCP;
4808: END IF;
4809:
4810: -- Note: Updating(logical deletion) to the RP_ENTRIES is done through the trigger on cz_devl_projects
4811: UPDATE cz_devl_projects
4812: SET deleted_flag = '1',
4813: name = append_name (p_model_id, 'PRJ', name)
4814: WHERE devl_project_id = p_model_id
4815: AND deleted_flag = '0';

Line 6429: TYPE prj_name_tbl_type IS TABLE of cz_devl_projects.name%TYPE INDEX BY BINARY_INTEGER;

6425: x_msg_count OUT NOCOPY NUMBER,
6426: x_msg_data OUT NOCOPY VARCHAR2)
6427: IS
6428:
6429: TYPE prj_name_tbl_type IS TABLE of cz_devl_projects.name%TYPE INDEX BY BINARY_INTEGER;
6430: l_prj_name_tbl prj_name_tbl_type;
6431:
6432: l_eff_set_id NUMBER;
6433: l_eff_name VARCHAR2(255);

Line 6451: FROM cz_devl_projects

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
6453: (SELECT devl_project_id FROM cz_rules
6454: WHERE effectivity_set_id = p_eff_set_id
6455: AND deleted_flag = '0'

Line 6541: l_devl_name cz_devl_projects.name%TYPE;

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;
6545: x_msg_count := 0;

Line 6587: SELECT name into l_devl_name FROM cz_devl_projects WHERE devl_project_id = l_devl_project_tbl(i);

6583: x_return_status := FND_API.G_RET_STS_ERROR;
6584: FOR I IN l_devl_project_tbl.FIRST..l_devl_project_tbl.LAST
6585: LOOP
6586: x_msg_count := x_msg_count + 1;
6587: SELECT name into l_devl_name FROM cz_devl_projects WHERE devl_project_id = l_devl_project_tbl(i);
6588: handle_Error(p_message_name => 'CZ_ARC_IN_USE',
6589: p_token_name1 => 'ARCHIVENAME',
6590: p_token_value1 => l_object_name,
6591: p_token_name2 => 'MODELNAME',

Line 7583: TYPE model_names_tbl IS TABLE OF cz_devl_projects.name%TYPE INDEX BY BINARY_INTEGER;

7579: x_msg_data OUT NOCOPY VARCHAR2)
7580: IS
7581:
7582: TYPE number_type_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7583: TYPE model_names_tbl IS TABLE OF cz_devl_projects.name%TYPE INDEX BY BINARY_INTEGER;
7584: TYPE t_mask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;
7585: TYPE name_tbl IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
7586: TYPE t_checkout_user_tbl IS TABLE OF cz_devl_projects.checkout_user%TYPE INDEX BY BINARY_INTEGER;
7587: l_rp_folder NUMBER;

Line 7586: TYPE t_checkout_user_tbl IS TABLE OF cz_devl_projects.checkout_user%TYPE INDEX BY BINARY_INTEGER;

7582: TYPE number_type_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7583: TYPE model_names_tbl IS TABLE OF cz_devl_projects.name%TYPE INDEX BY BINARY_INTEGER;
7584: TYPE t_mask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;
7585: TYPE name_tbl IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
7586: TYPE t_checkout_user_tbl IS TABLE OF cz_devl_projects.checkout_user%TYPE INDEX BY BINARY_INTEGER;
7587: l_rp_folder NUMBER;
7588: l_rp_fld_tbl number_type_tbl;
7589: l_rp_model_tbl number_type_tbl;
7590: l_rp_model_ref number_type_tbl;

Line 7604: l_devl_name cz_devl_projects.name%TYPE;

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;
7608: l_usg_ref number_type_tbl;

Line 7626: l_checkout_user cz_devl_projects.checkout_user%TYPE;

7622: l_ref_model_ids_tbl number_type_tbl;
7623: l_ref_model_names_tbl model_names_tbl;
7624: l_eff_encl_fld_id NUMBER := 0;
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';

Line 7627: l_model_name cz_devl_projects.name%TYPE;

7623: l_ref_model_names_tbl model_names_tbl;
7624: l_eff_encl_fld_id NUMBER := 0;
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);

Line 7655: l_ref_model_name cz_devl_projects.name%TYPE;

7651: v_masks_nodes t_mask;
7652: v_masks_rules t_mask;
7653: l_nodes_name_tbl name_tbl;
7654: l_rules_name_tbl name_tbl;
7655: l_ref_model_name cz_devl_projects.name%TYPE;
7656: l_locked_models_tbl number_type_tbl;
7657: l_all_locked_models_tbl number_type_tbl;
7658: l_checkout_user_tbl t_checkout_user_tbl;
7659: l_user_name cz_devl_projects.checkout_user%TYPE;

Line 7659: l_user_name cz_devl_projects.checkout_user%TYPE;

7655: l_ref_model_name cz_devl_projects.name%TYPE;
7656: l_locked_models_tbl number_type_tbl;
7657: l_all_locked_models_tbl number_type_tbl;
7658: l_checkout_user_tbl t_checkout_user_tbl;
7659: l_user_name cz_devl_projects.checkout_user%TYPE;
7660: l_devl_prj_name_tbl name_tbl;
7661: l_template_name_tbl name_tbl;
7662: --Bug#13770170: Additional declations for missing checked in UCT
7663: l_ref_template_tbl number_type_tbl;

Line 7707: SELECT object_id, checkout_user, cz_devl_projects.name

7703: l_encl_idx_ref(l_rp_fld_tbl(i)) := l_rp_fld_tbl(i);
7704:
7705: ----collect all 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'

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 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 7873: cz_devl_projects d,

7869: BULK
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'

Line 7887: SELECT name into l_model_name from cz_devl_projects

7883: IF (l_ref_model_ids_tbl.COUNT > 0) THEN
7884: FOR I IN l_ref_model_ids_tbl.FIRST..l_ref_model_ids_tbl.LAST
7885: LOOP
7886: IF (NOT l_encl_idx_ref.EXISTS( l_encl_devl_tbl(i) ) ) THEN
7887: SELECT name into l_model_name from cz_devl_projects
7888: WHERE devl_project_id = l_ref_model_ids_tbl(i);
7889:
7890: SELECT name into l_ref_model_name from cz_devl_projects
7891: WHERE devl_project_id = l_rp_model_ref(modelId);

Line 7890: SELECT name into l_ref_model_name from cz_devl_projects

7886: IF (NOT l_encl_idx_ref.EXISTS( l_encl_devl_tbl(i) ) ) THEN
7887: SELECT name into l_model_name from cz_devl_projects
7888: WHERE devl_project_id = l_ref_model_ids_tbl(i);
7889:
7890: SELECT name into l_ref_model_name from cz_devl_projects
7891: WHERE devl_project_id = l_rp_model_ref(modelId);
7892:
7893: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
7894: FND_MESSAGE.SET_TOKEN('MODELNAME',l_ref_model_name);

Line 7913: SELECT name into l_model_name from cz_devl_projects

7909:
7910: IF (l_publication_tbl.COUNT > 0) THEN
7911: FOR I IN l_publication_tbl.FIRST..l_publication_tbl.LAST
7912: LOOP
7913: SELECT name into l_model_name from cz_devl_projects
7914: WHERE devl_project_id = l_ref_model_ids_tbl(i);
7915: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBLD');
7916: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7917: FND_MESSAGE.SET_TOKEN('PUBID', l_publication_tbl(i));

Line 8418: l_model_name cz_devl_projects.name%TYPE;

8414: l_rp_fld_tbl number_type_tbl;
8415: l_object_id_tbl number_type_tbl;
8416: l_object_typ_tbl object_type_tbl;
8417: l_locked_models_tbl cz_security_pvt.number_type_tbl;
8418: l_model_name cz_devl_projects.name%TYPE;
8419: l_template_name cz_ui_templates.template_name%TYPE;
8420: l_count NUMBER := 0;
8421:
8422: BEGIN

Line 8556: original_name cz_devl_projects.name%TYPE;

8552: RETURN VARCHAR2
8553:
8554: AS
8555:
8556: original_name cz_devl_projects.name%TYPE;
8557: copy_name cz_devl_projects.name%TYPE;
8558: L PLS_INTEGER := 0;
8559: x_error BOOLEAN := FALSE;
8560:

Line 8557: copy_name cz_devl_projects.name%TYPE;

8553:
8554: AS
8555:
8556: original_name cz_devl_projects.name%TYPE;
8557: copy_name cz_devl_projects.name%TYPE;
8558: L PLS_INTEGER := 0;
8559: x_error BOOLEAN := FALSE;
8560:
8561: BEGIN

Line 10685: FROM cz_devl_projects

10681:
10682: IF v_model_id > 0 THEN
10683: BEGIN
10684: SELECT name INTO v_model_name
10685: FROM cz_devl_projects
10686: WHERE devl_project_id = v_model_id;
10687: EXCEPTION
10688: WHEN NO_DATA_FOUND THEN
10689: RAISE;

Line 11932: l_config_engine_type cz_devl_projects.config_engine_type%TYPE;

11928: RETURN CZ_FCE_FILES.CREATION_DATE%TYPE
11929:
11930: IS
11931: l_last_log_gen_date cz_fce_files.creation_date%TYPE;
11932: l_config_engine_type cz_devl_projects.config_engine_type%TYPE;
11933: BEGIN
11934:
11935: SELECT config_engine_type
11936: INTO l_config_engine_type

Line 11937: FROM cz_devl_projects

11933: BEGIN
11934:
11935: SELECT config_engine_type
11936: INTO l_config_engine_type
11937: FROM cz_devl_projects
11938: WHERE devl_project_id = p_model_id;
11939:
11940:
11941: if (l_config_engine_type = LCE_ENGINE_TYPE OR l_config_engine_type IS NULL) THEN