APPS.CZ_CF_API dependencies on CZ_MODEL_PUBLICATIONS

Line 2327: l_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;

2323: ,p_organization_id IN NUMBER
2324: )
2325: RETURN NUMBER
2326: IS
2327: l_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;
2328: l_pub_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;
2329: l_dummy INTEGER;
2330:
2331: BEGIN

Line 2328: l_pub_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;

2324: )
2325: RETURN NUMBER
2326: IS
2327: l_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;
2328: l_pub_ui_style CZ_MODEL_PUBLICATIONS.ui_style%TYPE;
2329: l_dummy INTEGER;
2330:
2331: BEGIN
2332: IF p_publication_id IS NULL THEN

Line 2355: FROM CZ_MODEL_PUBLICATIONS

2351: END IF;
2352:
2353: ELSE
2354: SELECT ui_style INTO l_pub_ui_style
2355: FROM CZ_MODEL_PUBLICATIONS
2356: WHERE publication_id = p_publication_id;
2357:
2358: IF px_ui_type IS NOT NULL THEN
2359: -- If input ui_type is APPLET, either APPLET or DHTML or JRAD is OK.

Line 2535: FROM CZ_MODEL_PUBLICATIONS

2531:
2532: BEGIN
2533: SELECT model_id
2534: INTO v_model_id
2535: FROM CZ_MODEL_PUBLICATIONS
2536: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2537: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2538: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2539:

Line 2536: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id

2532: BEGIN
2533: SELECT model_id
2534: INTO v_model_id
2535: FROM CZ_MODEL_PUBLICATIONS
2536: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2537: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2538: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2539:
2540: IF v_model_id IS NULL THEN

Line 2537: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'

2533: SELECT model_id
2534: INTO v_model_id
2535: FROM CZ_MODEL_PUBLICATIONS
2536: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2537: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2538: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2539:
2540: IF v_model_id IS NULL THEN
2541: RETURN NULL;

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

2534: INTO v_model_id
2535: FROM CZ_MODEL_PUBLICATIONS
2536: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2537: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2538: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2539:
2540: IF v_model_id IS NULL THEN
2541: RETURN NULL;
2542: ELSE

Line 2559: FROM CZ_MODEL_PUBLICATIONS

2555:
2556: BEGIN
2557: SELECT ui_def_id
2558: INTO v_ui_def_id
2559: FROM CZ_MODEL_PUBLICATIONS
2560: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2561: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2562: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2563:

Line 2560: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id

2556: BEGIN
2557: SELECT ui_def_id
2558: INTO v_ui_def_id
2559: FROM CZ_MODEL_PUBLICATIONS
2560: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2561: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2562: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2563:
2564: IF v_ui_def_id IS NULL THEN

Line 2561: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'

2557: SELECT ui_def_id
2558: INTO v_ui_def_id
2559: FROM CZ_MODEL_PUBLICATIONS
2560: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2561: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2562: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2563:
2564: IF v_ui_def_id IS NULL THEN
2565: RETURN NULL;

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

2558: INTO v_ui_def_id
2559: FROM CZ_MODEL_PUBLICATIONS
2560: WHERE CZ_MODEL_PUBLICATIONS.publication_id = v_publication_id
2561: AND CZ_MODEL_PUBLICATIONS.export_status = 'OK'
2562: AND CZ_MODEL_PUBLICATIONS.deleted_flag = '0';
2563:
2564: IF v_ui_def_id IS NULL THEN
2565: RETURN NULL;
2566: ELSE