DBA Data[Home] [Help]

APPS.CZ_RUNTIME dependencies on CZ_MODEL_PUBLICATIONS

Line 732: l_publication_id cz_model_publications.publication_id%TYPE;

728: )
729: RETURN NUMBER
730: IS
731:
732: l_publication_id cz_model_publications.publication_id%TYPE;
733: l_ui_style cz_model_publications.ui_style%TYPE;
734:
735: BEGIN
736: l_publication_id := cz_cf_api.publication_for_item (inventory_item_id,organization_id,config_lookup_date,

Line 733: l_ui_style cz_model_publications.ui_style%TYPE;

729: RETURN NUMBER
730: IS
731:
732: l_publication_id cz_model_publications.publication_id%TYPE;
733: l_ui_style cz_model_publications.ui_style%TYPE;
734:
735: BEGIN
736: l_publication_id := cz_cf_api.publication_for_item (inventory_item_id,organization_id,config_lookup_date,
737: calling_application_id,usage_name,publication_mode,language);

Line 742: from cz_model_publications

738:
739: IF (l_publication_id IS NOT NULL) THEN
740: BEGIN
741: Select ui_style INTO l_ui_style
742: from cz_model_publications
743: where cz_model_publications.publication_id = l_publication_id
744: and cz_model_publications.deleted_flag = '0';
745: EXCEPTION
746: WHEN NO_DATA_FOUND THEN

Line 743: where cz_model_publications.publication_id = l_publication_id

739: IF (l_publication_id IS NOT NULL) THEN
740: BEGIN
741: Select ui_style INTO l_ui_style
742: from cz_model_publications
743: where cz_model_publications.publication_id = l_publication_id
744: and cz_model_publications.deleted_flag = '0';
745: EXCEPTION
746: WHEN NO_DATA_FOUND THEN
747: l_ui_style := -1;

Line 744: and cz_model_publications.deleted_flag = '0';

740: BEGIN
741: Select ui_style INTO l_ui_style
742: from cz_model_publications
743: where cz_model_publications.publication_id = l_publication_id
744: and cz_model_publications.deleted_flag = '0';
745: EXCEPTION
746: WHEN NO_DATA_FOUND THEN
747: l_ui_style := -1;
748: END;

Line 772: l_publication_id cz_model_publications.publication_id%TYPE;

768: )
769: RETURN NUMBER
770: IS
771:
772: l_publication_id cz_model_publications.publication_id%TYPE;
773: l_ui_style cz_model_publications.ui_style%TYPE;
774:
775: BEGIN
776: l_publication_id := cz_cf_api.publication_for_product(product_key,

Line 773: l_ui_style cz_model_publications.ui_style%TYPE;

769: RETURN NUMBER
770: IS
771:
772: l_publication_id cz_model_publications.publication_id%TYPE;
773: l_ui_style cz_model_publications.ui_style%TYPE;
774:
775: BEGIN
776: l_publication_id := cz_cf_api.publication_for_product(product_key,
777: config_lookup_date,

Line 785: from cz_model_publications

781: language);
782: IF (l_publication_id IS NOT NULL) THEN
783: BEGIN
784: Select ui_style INTO l_ui_style
785: from cz_model_publications
786: where cz_model_publications.publication_id = l_publication_id
787: and cz_model_publications.deleted_flag = '0';
788: EXCEPTION
789: WHEN NO_DATA_FOUND THEN

Line 786: where cz_model_publications.publication_id = l_publication_id

782: IF (l_publication_id IS NOT NULL) THEN
783: BEGIN
784: Select ui_style INTO l_ui_style
785: from cz_model_publications
786: where cz_model_publications.publication_id = l_publication_id
787: and cz_model_publications.deleted_flag = '0';
788: EXCEPTION
789: WHEN NO_DATA_FOUND THEN
790: l_ui_style := -1;

Line 787: and cz_model_publications.deleted_flag = '0';

783: BEGIN
784: Select ui_style INTO l_ui_style
785: from cz_model_publications
786: where cz_model_publications.publication_id = l_publication_id
787: and cz_model_publications.deleted_flag = '0';
788: EXCEPTION
789: WHEN NO_DATA_FOUND THEN
790: l_ui_style := -1;
791: END;

Line 816: l_publication_id cz_model_publications.publication_id%TYPE;

812: )
813: RETURN NUMBER
814: IS
815:
816: l_publication_id cz_model_publications.publication_id%TYPE;
817: l_ui_style cz_model_publications.ui_style%TYPE;
818:
819: BEGIN
820: l_publication_id := cz_cf_api.publication_for_saved_config (config_hdr_id,

Line 817: l_ui_style cz_model_publications.ui_style%TYPE;

813: RETURN NUMBER
814: IS
815:
816: l_publication_id cz_model_publications.publication_id%TYPE;
817: l_ui_style cz_model_publications.ui_style%TYPE;
818:
819: BEGIN
820: l_publication_id := cz_cf_api.publication_for_saved_config (config_hdr_id,
821: config_rev_nbr,

Line 831: from cz_model_publications

827: );
828: IF (l_publication_id IS NOT NULL) THEN
829: BEGIN
830: Select ui_style INTO l_ui_style
831: from cz_model_publications
832: where cz_model_publications.publication_id = l_publication_id
833: and cz_model_publications.deleted_flag = '0';
834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN

Line 832: where cz_model_publications.publication_id = l_publication_id

828: IF (l_publication_id IS NOT NULL) THEN
829: BEGIN
830: Select ui_style INTO l_ui_style
831: from cz_model_publications
832: where cz_model_publications.publication_id = l_publication_id
833: and cz_model_publications.deleted_flag = '0';
834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN
836: l_ui_style := -1;

Line 833: and cz_model_publications.deleted_flag = '0';

829: BEGIN
830: Select ui_style INTO l_ui_style
831: from cz_model_publications
832: where cz_model_publications.publication_id = l_publication_id
833: and cz_model_publications.deleted_flag = '0';
834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN
836: l_ui_style := -1;
837: END;