APPS.OZF_OM_VALIDATION_PVT dependencies on OZF_SYS_PARAMETERS

Line 628: FROM ozf_sys_parameters

624: WHERE claim_type_id = cv_claim_type_id;
625:
626: CURSOR csr_sys_param_rma_trx_type(cv_set_of_books_id IN NUMBER) IS
627: SELECT order_type_id
628: FROM ozf_sys_parameters
629: WHERE set_of_books_id = cv_set_of_books_id;
630:
631: BEGIN
632: IF OZF_DEBUG_HIGH_ON THEN

Line 640: -- 3. System Parameter (ozf_sys_parameters_all.order_type_id)

636: -- The following hierarchy is used to determine the default RMA transaction type,
637: -- stopping when one is found
638: -- 1. Reason (ozf_reason_codes_all_b.order_type_id)
639: -- 2. Claim Type (ozf_claim_types_all_b.order_type_id)
640: -- 3. System Parameter (ozf_sys_parameters_all.order_type_id)
641:
642: OPEN csr_reason_rma_trx_type(p_reason_code_id);
643: FETCH csr_reason_rma_trx_type INTO x_order_type_id;
644: CLOSE csr_reason_rma_trx_type;