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_CF_API dependencies on CZ_DEVL_PROJECTS

Line 1364: p_product_id cz_devl_projects.product_key%TYPE := NULL;

1360: p_calling_application_id VARCHAR2(10) := NULL;
1361: p_config_model_lookup_date DATE := NULL;
1362: p_config_effective_usage VARCHAR2(3) := NULL;
1363: p_publication_mode VARCHAR(1):= NULL;
1364: p_product_id cz_devl_projects.product_key%TYPE := NULL;
1365: p_inventory_item_id cz_devl_projects.inventory_item_id%TYPE := NULL;
1366: p_context_org_id cz_devl_projects.organization_id%TYPE := NULL;
1367: p_config_header_id cz_config_hdrs.config_hdr_id%TYPE := NULL;
1368: p_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := NULL;

Line 1365: p_inventory_item_id cz_devl_projects.inventory_item_id%TYPE := NULL;

1361: p_config_model_lookup_date DATE := NULL;
1362: p_config_effective_usage VARCHAR2(3) := NULL;
1363: p_publication_mode VARCHAR(1):= NULL;
1364: p_product_id cz_devl_projects.product_key%TYPE := NULL;
1365: p_inventory_item_id cz_devl_projects.inventory_item_id%TYPE := NULL;
1366: p_context_org_id cz_devl_projects.organization_id%TYPE := NULL;
1367: p_config_header_id cz_config_hdrs.config_hdr_id%TYPE := NULL;
1368: p_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := NULL;
1369: --

Line 1366: p_context_org_id cz_devl_projects.organization_id%TYPE := NULL;

1362: p_config_effective_usage VARCHAR2(3) := NULL;
1363: p_publication_mode VARCHAR(1):= NULL;
1364: p_product_id cz_devl_projects.product_key%TYPE := NULL;
1365: p_inventory_item_id cz_devl_projects.inventory_item_id%TYPE := NULL;
1366: p_context_org_id cz_devl_projects.organization_id%TYPE := NULL;
1367: p_config_header_id cz_config_hdrs.config_hdr_id%TYPE := NULL;
1368: p_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := NULL;
1369: --
1370: MISSING_CAL_APPL EXCEPTION;

Line 1517: l_product_key cz_devl_projects.product_key%TYPE;

1513: )
1514: IS
1515: l_url VARCHAR2(32767);
1516: l_publication_id NUMBER;
1517: l_product_key cz_devl_projects.product_key%TYPE;
1518: l_index NUMBER;
1519: l_init_message VARCHAR2(32767);
1520: l_pool_identifier cz_model_pool_mappings.pool_identifier%TYPE := NULL;
1521: -- vsingava 18th Dec '10. bug10410329

Line 3319: FROM cz_devl_projects prj, cz_model_ref_expls expl

3315: ,x_organization_id OUT NOCOPY NUMBER)
3316: IS
3317: CURSOR reference_cursor IS
3318: SELECT prj.inventory_item_id, prj.organization_id
3319: FROM cz_devl_projects prj, cz_model_ref_expls expl
3320: WHERE expl.model_id = p_model_id
3321: AND expl.ps_node_type = PS_NODE_TYPE_REFERENCE
3322: AND expl.deleted_flag = '0'
3323: AND prj.devl_project_id = expl.component_id

Line 3352: v_product_key cz_devl_projects.product_key%TYPE;

3348: v_config_hdr_id NUMBER := config_hdr_id;
3349: v_config_rev_nbr NUMBER := config_rev_nbr;
3350: v_inventory_item_id NUMBER;
3351: v_organization_id NUMBER;
3352: v_product_key cz_devl_projects.product_key%TYPE;
3353: v_component_id NUMBER;
3354: v_model_identifier cz_config_hdrs.model_identifier%TYPE;
3355: v_ndebug NUMBER := 0;
3356:

Line 3401: FROM CZ_DEVL_PROJECTS

3397: v_ndebug := 2;
3398: BEGIN
3399: SELECT inventory_item_id, organization_id, product_key
3400: INTO v_inventory_item_id, v_organization_id, v_product_key
3401: FROM CZ_DEVL_PROJECTS
3402: WHERE deleted_flag = '0' AND devl_project_id = v_component_id;
3403: EXCEPTION
3404: WHEN no_data_found THEN
3405: v_ndebug := 3;

Line 3461: v_product_key cz_devl_projects.product_key%TYPE := product_key ;

3457: )
3458: RETURN NUMBER
3459: IS
3460:
3461: v_product_key cz_devl_projects.product_key%TYPE := product_key ;
3462: v_config_lookup_date DATE := config_lookup_date ;
3463: v_usage_id NUMBER ;
3464: v_publication_mode VARCHAR2(1) := publication_mode ;
3465: v_usage_name VARCHAR2(255) := usage_name ;

Line 3471: c_product_key cz_devl_projects.product_key%TYPE;

3467: v_application_id NUMBER := calling_application_id;
3468: v_source_target_flag VARCHAR2(3) := 'T' ;
3469: v_publication_id NUMBER ;
3470: v_pb_count NUMBER;
3471: c_product_key cz_devl_projects.product_key%TYPE;
3472:
3473: CURSOR pub_cur IS
3474: SELECT publication_id
3475: FROM cz_model_applicabilities_v

Line 3784: TYPE model_type_tbl_type IS TABLE OF cz_devl_projects.model_type%TYPE

3780: ,x_last_update_dates OUT NOCOPY date_tbl_indexby_type
3781: ,x_model_type OUT NOCOPY VARCHAR2
3782: )
3783: IS
3784: TYPE model_type_tbl_type IS TABLE OF cz_devl_projects.model_type%TYPE
3785: INDEX BY BINARY_INTEGER;
3786: l_model_type_tbl model_type_tbl_type;
3787: BEGIN
3788: SELECT pub.publication_id, pub.model_id, pub.ui_def_id, pub.start_date,

Line 3792: FROM cz_model_applicabilities_v pub, cz_devl_projects prj

3788: SELECT pub.publication_id, pub.model_id, pub.ui_def_id, pub.start_date,
3789: pub.last_update_date, prj.model_type
3790: BULK COLLECT INTO x_publication_ids, x_model_ids, x_ui_def_ids,
3791: x_start_dates, x_last_update_dates, l_model_type_tbl
3792: FROM cz_model_applicabilities_v pub, cz_devl_projects prj
3793: WHERE pub.model_id = prj.devl_project_id
3794: AND prj.deleted_flag ='0' AND pub.deleted_flag = '0'
3795: AND pub.inventory_item_id = p_inventory_item_id
3796: AND bom_explosion_org_id = p_organization_id

Line 3923: v_product_key cz_devl_projects.product_key%TYPE := NULL;

3919: v_config_hdr_id NUMBER := p_config_hdr_id;
3920: v_config_rev_nbr NUMBER := p_config_rev_nbr;
3921: v_inventory_item_id NUMBER;
3922: v_organization_id NUMBER;
3923: v_product_key cz_devl_projects.product_key%TYPE := NULL;
3924: v_persist_comp_id NUMBER;
3925: v_model_identifier cz_config_hdrs.model_identifier%TYPE;
3926:
3927: CURSOR prj_cursor IS

Line 3929: FROM CZ_DEVL_PROJECTS

3925: v_model_identifier cz_config_hdrs.model_identifier%TYPE;
3926:
3927: CURSOR prj_cursor IS
3928: SELECT product_key
3929: FROM CZ_DEVL_PROJECTS
3930: WHERE persistent_project_id = v_persist_comp_id
3931: AND product_key IS NOT NULL
3932: AND deleted_flag = '0';
3933:

Line 4204: lOSR CZ_DEVL_PROJECTS.ORIG_SYS_REF%TYPE := NULL;

4200: --------------------------------------------------------------------------------
4201: --LA 9595142 Procedures to enable the BOM model for Import
4202: PROCEDURE enable_model_for_import(inDevlProjectId IN NUMBER, xStatus IN OUT NOCOPY VARCHAR2)
4203: IS
4204: lOSR CZ_DEVL_PROJECTS.ORIG_SYS_REF%TYPE := NULL;
4205: lModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE := -1;
4206: xError BOOLEAN := FALSE;
4207: lConfigEngineType CZ_DEVL_PROJECTS.CONFIG_ENGINE_TYPE%TYPE;
4208: BEGIN

Line 4205: lModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE := -1;

4201: --LA 9595142 Procedures to enable the BOM model for Import
4202: PROCEDURE enable_model_for_import(inDevlProjectId IN NUMBER, xStatus IN OUT NOCOPY VARCHAR2)
4203: IS
4204: lOSR CZ_DEVL_PROJECTS.ORIG_SYS_REF%TYPE := NULL;
4205: lModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE := -1;
4206: xError BOOLEAN := FALSE;
4207: lConfigEngineType CZ_DEVL_PROJECTS.CONFIG_ENGINE_TYPE%TYPE;
4208: BEGIN
4209: xStatus := 'OK' ;

Line 4207: lConfigEngineType CZ_DEVL_PROJECTS.CONFIG_ENGINE_TYPE%TYPE;

4203: IS
4204: lOSR CZ_DEVL_PROJECTS.ORIG_SYS_REF%TYPE := NULL;
4205: lModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE := -1;
4206: xError BOOLEAN := FALSE;
4207: lConfigEngineType CZ_DEVL_PROJECTS.CONFIG_ENGINE_TYPE%TYPE;
4208: BEGIN
4209: xStatus := 'OK' ;
4210: BEGIN
4211: --Check whether model exists in repository

Line 4213: FROM cz_devl_projects d

4209: xStatus := 'OK' ;
4210: BEGIN
4211: --Check whether model exists in repository
4212: SELECT orig_sys_ref, NVL(config_engine_type,'L') INTO lOSR, lConfigEngineType
4213: FROM cz_devl_projects d
4214: WHERE d.deleted_flag = '0'
4215: AND d.devl_project_id = inDevlProjectId
4216: AND EXISTS (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0'
4217: AND object_type = 'PRJ' AND object_id = d.devl_project_id)

Line 4234: SELECT d.devl_project_id INTO lModelId FROM cz_devl_projects d

4230: END ;
4231:
4232: BEGIN
4233: -- check if there is any other model enabled for given orig_sys_ref
4234: SELECT d.devl_project_id INTO lModelId FROM cz_devl_projects d
4235: WHERE d.orig_sys_ref = lOSR
4236: AND d.deleted_flag = '0'
4237: AND NVL(d.import_enabled,'0') = '1'
4238: AND NVL(d.config_engine_type,'L') = lConfigEngineType

Line 4253: UPDATE cz_devl_projects SET import_enabled = '1'

4249: END IF;
4250: EXCEPTION
4251: WHEN NO_DATA_FOUND THEN
4252: BEGIN
4253: UPDATE cz_devl_projects SET import_enabled = '1'
4254: WHERE deleted_flag = '0'
4255: AND devl_project_id = inDevlProjectId ;
4256: xError := cz_utils.log_report('Model enabled for Import : '
4257: || inDevlProjectId ,1,'enable_model_for_import',9994,null);

Line 4285: lOSR CZ_DEVL_PROJECTS.ORIG_SYS_REF%TYPE := NULL;

4281: --LA 9595142 Procedure to disable the BOM model for Import
4282: PROCEDURE disable_model_for_import(inDevlProjectId IN NUMBER, xStatus IN OUT NOCOPY VARCHAR2 )
4283: IS
4284: xError BOOLEAN := FALSE;
4285: lOSR CZ_DEVL_PROJECTS.ORIG_SYS_REF%TYPE := NULL;
4286: BEGIN
4287:
4288: BEGIN
4289: --Check whether model exists in repository

Line 4290: SELECT orig_sys_ref INTO lOSR FROM cz_devl_projects d

4286: BEGIN
4287:
4288: BEGIN
4289: --Check whether model exists in repository
4290: SELECT orig_sys_ref INTO lOSR FROM cz_devl_projects d
4291: WHERE d.deleted_flag = '0'
4292: AND d.devl_project_id = inDevlProjectId
4293: AND EXISTS (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0'
4294: AND object_type = 'PRJ' AND object_id = d.devl_project_id)

Line 4310: UPDATE cz_devl_projects SET import_enabled = '0'

4306: RAISE;
4307: END ;
4308:
4309: BEGIN
4310: UPDATE cz_devl_projects SET import_enabled = '0'
4311: WHERE deleted_flag = '0'
4312: AND devl_project_id = inDevlProjectId ;
4313:
4314: COMMIT;