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.OZF_FORECAST_UTIL_PVT dependencies on OZF_FORECAST_PROD_EXCLUSIONS

Line 674: l_product_attribute_context_e ozf_forecast_prod_exclusions.product_attribute_context_e%TYPE;

670: l_product_attribute_context ozf_forecast_dimentions.product_attribute_context%TYPE;
671: l_product_attribute ozf_forecast_dimentions.product_attribute%TYPE;
672: l_product_attr_value ozf_forecast_dimentions.product_attr_value%TYPE;
673:
674: l_product_attribute_context_e ozf_forecast_prod_exclusions.product_attribute_context_e%TYPE;
675: l_product_attribute_e ozf_forecast_prod_exclusions.product_attribute_e%TYPE;
676: l_product_attr_value_e ozf_forecast_prod_exclusions.product_attr_value_e%TYPE;
677:
678: l_qualifier_grouping_no ozf_forecast_dimentions.qualifier_grouping_no%TYPE;

Line 675: l_product_attribute_e ozf_forecast_prod_exclusions.product_attribute_e%TYPE;

671: l_product_attribute ozf_forecast_dimentions.product_attribute%TYPE;
672: l_product_attr_value ozf_forecast_dimentions.product_attr_value%TYPE;
673:
674: l_product_attribute_context_e ozf_forecast_prod_exclusions.product_attribute_context_e%TYPE;
675: l_product_attribute_e ozf_forecast_prod_exclusions.product_attribute_e%TYPE;
676: l_product_attr_value_e ozf_forecast_prod_exclusions.product_attr_value_e%TYPE;
677:
678: l_qualifier_grouping_no ozf_forecast_dimentions.qualifier_grouping_no%TYPE;
679: l_qualifier_context ozf_forecast_dimentions.qualifier_context%TYPE;

Line 676: l_product_attr_value_e ozf_forecast_prod_exclusions.product_attr_value_e%TYPE;

672: l_product_attr_value ozf_forecast_dimentions.product_attr_value%TYPE;
673:
674: l_product_attribute_context_e ozf_forecast_prod_exclusions.product_attribute_context_e%TYPE;
675: l_product_attribute_e ozf_forecast_prod_exclusions.product_attribute_e%TYPE;
676: l_product_attr_value_e ozf_forecast_prod_exclusions.product_attr_value_e%TYPE;
677:
678: l_qualifier_grouping_no ozf_forecast_dimentions.qualifier_grouping_no%TYPE;
679: l_qualifier_context ozf_forecast_dimentions.qualifier_context%TYPE;
680: l_qualifier_context_attribute ozf_forecast_dimentions.qualifier_attribute%TYPE;

Line 836: DELETE FROM ozf_forecast_prod_exclusions

832: -- 11510 : Worksheets will not have exclusions
833: IF ( p_obj_type <> 'WKST' ) THEN
834: ----dbms_output.put_line( ' -- IN create_dimentions, p_obj_type <> WKST **** -- ');
835: /* inanaiah: R12 - not deleted as the reference is needed when creating new version
836: DELETE FROM ozf_forecast_prod_exclusions
837: WHERE obj_type = p_obj_type
838: AND obj_id = p_obj_id ;
839: */
840:

Line 855: ----dbms_output.put_line( ' -- IN create_dimentions, B4 INSERT INTO ozf_forecast_prod_exclusions **** -- ');

851: l_product_attribute_e,
852: l_product_attr_value_e ;
853: ----dbms_output.put_line( ' -- IN create_dimentions, AFTER fetching excp_cv **** -- ');
854: EXIT WHEN excp_cv%NOTFOUND;
855: ----dbms_output.put_line( ' -- IN create_dimentions, B4 INSERT INTO ozf_forecast_prod_exclusions **** -- ');
856: INSERT INTO ozf_forecast_prod_exclusions(
857: FORECAST_PROD_EXCLUSION_ID,
858: OBJ_TYPE,
859: OBJ_ID,

Line 856: INSERT INTO ozf_forecast_prod_exclusions(

852: l_product_attr_value_e ;
853: ----dbms_output.put_line( ' -- IN create_dimentions, AFTER fetching excp_cv **** -- ');
854: EXIT WHEN excp_cv%NOTFOUND;
855: ----dbms_output.put_line( ' -- IN create_dimentions, B4 INSERT INTO ozf_forecast_prod_exclusions **** -- ');
856: INSERT INTO ozf_forecast_prod_exclusions(
857: FORECAST_PROD_EXCLUSION_ID,
858: OBJ_TYPE,
859: OBJ_ID,
860: PRODUCT_ATTRIBUTE_CONTEXT,

Line 872: VALUES ( ozf_forecast_prod_exclusions_s.nextval,

868: CREATED_BY,
869: LAST_UPDATE_DATE,
870: LAST_UPDATED_BY,
871: LAST_UPDATE_LOGIN)
872: VALUES ( ozf_forecast_prod_exclusions_s.nextval,
873: p_obj_type,
874: p_obj_id,
875: l_product_attribute_context,
876: l_product_attribute,

Line 963: FROM ozf_forecast_prod_exclusions

959: p_product_attr_value IN VARCHAR2 ) IS
960: SELECT product_attribute_context_e,
961: product_attribute_e,
962: product_attr_value_e
963: FROM ozf_forecast_prod_exclusions
964: WHERE product_attribute_context = p_product_attribute_context
965: AND product_attribute = p_product_attribute
966: AND product_attr_value = p_product_attr_value
967: AND obj_type = p_obj_type

Line 980: FROM ozf_forecast_prod_exclusions

976: CURSOR c_no_excl_products( p_product_attribute_context IN VARCHAR2,
977: p_product_attribute IN VARCHAR2,
978: p_product_attr_value IN VARCHAR2 ) IS
979: SELECT COUNT(*)
980: FROM ozf_forecast_prod_exclusions
981: WHERE product_attribute_context = p_product_attribute_context
982: AND product_attribute = p_product_attribute
983: AND product_attr_value = p_product_attr_value
984: AND obj_type = p_obj_type