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_MODEL_PUBLICATIONS

Line 1496: SELECT product_key INTO x_product_key FROM cz_model_publications WHERE publication_id = x_publication_id;

1492: END IF;
1493: END IF;
1494:
1495: ELSE
1496: SELECT product_key INTO x_product_key FROM cz_model_publications WHERE publication_id = x_publication_id;
1497: END IF;
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: cz_utils.log_report('cz_cf_api', 'publication_for_init_message', null,

Line 2727: l_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;

2723: ,p_organization_id IN NUMBER
2724: )
2725: RETURN NUMBER
2726: IS
2727: l_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;
2728: l_pub_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;
2729: l_dummy INTEGER;
2730:
2731: BEGIN

Line 2728: l_pub_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;

2724: )
2725: RETURN NUMBER
2726: IS
2727: l_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;
2728: l_pub_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;
2729: l_dummy INTEGER;
2730:
2731: BEGIN
2732: IF p_publication_id IS NULL THEN

Line 2755: FROM CZ_MODEL_PUBLICATIONS

2751: END IF;
2752:
2753: ELSE
2754: SELECT ui_style INTO l_pub_ui_style
2755: FROM CZ_MODEL_PUBLICATIONS
2756: WHERE publication_id = p_publication_id;
2757:
2758: IF px_ui_type IS NOT NULL THEN
2759: -- If input ui_type is APPLET, either APPLET or DHTML or JRAD is OK.

Line 2935: FROM CZ_MODEL_PUBLICATIONS

2931:
2932: BEGIN
2933: SELECT model_id
2934: INTO v_model_id
2935: FROM CZ_MODEL_PUBLICATIONS
2936: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2937: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2938: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2939:

Line 2936: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id

2932: BEGIN
2933: SELECT model_id
2934: INTO v_model_id
2935: FROM CZ_MODEL_PUBLICATIONS
2936: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2937: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2938: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2939:
2940: IF v_model_id IS NULL THEN

Line 2937: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'

2933: SELECT model_id
2934: INTO v_model_id
2935: FROM CZ_MODEL_PUBLICATIONS
2936: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2937: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2938: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2939:
2940: IF v_model_id IS NULL THEN
2941: RETURN NULL;

Line 2938: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';

2934: INTO v_model_id
2935: FROM CZ_MODEL_PUBLICATIONS
2936: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2937: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2938: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2939:
2940: IF v_model_id IS NULL THEN
2941: RETURN NULL;
2942: ELSE

Line 2959: FROM CZ_MODEL_PUBLICATIONS

2955:
2956: BEGIN
2957: SELECT ui_def_id
2958: INTO v_ui_def_id
2959: FROM CZ_MODEL_PUBLICATIONS
2960: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2961: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2962: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2963:

Line 2960: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id

2956: BEGIN
2957: SELECT ui_def_id
2958: INTO v_ui_def_id
2959: FROM CZ_MODEL_PUBLICATIONS
2960: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2961: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2962: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2963:
2964: IF v_ui_def_id IS NULL THEN

Line 2961: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'

2957: SELECT ui_def_id
2958: INTO v_ui_def_id
2959: FROM CZ_MODEL_PUBLICATIONS
2960: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2961: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2962: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2963:
2964: IF v_ui_def_id IS NULL THEN
2965: RETURN NULL;

Line 2962: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';

2958: INTO v_ui_def_id
2959: FROM CZ_MODEL_PUBLICATIONS
2960: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2961: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2962: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2963:
2964: IF v_ui_def_id IS NULL THEN
2965: RETURN NULL;
2966: ELSE

Line 4001: nModel_product_key CZ_MODEL_PUBLICATIONS.PRODUCT_KEY%TYPE;

3997: AND B.CONCATENATED_SEGMENTS = p_inventory_item_id;
3998:
3999: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
4000: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
4001: nModel_product_key CZ_MODEL_PUBLICATIONS.PRODUCT_KEY%TYPE;
4002: nRet BOOLEAN := FALSE;
4003:
4004: BEGIN
4005:

Line 4104: nModel_product_key CZ_MODEL_PUBLICATIONS.PRODUCT_KEY%TYPE;

4100: AND B.CONCATENATED_SEGMENTS = p_inventory_item_id;
4101:
4102: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
4103: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
4104: nModel_product_key CZ_MODEL_PUBLICATIONS.PRODUCT_KEY%TYPE;
4105: nRet BOOLEAN := FALSE;
4106: BEGIN
4107:
4108: retcode := 0;