APPS.CS_CSXSVODS_CHECK_PKG dependencies on CS_SERVICE_AVAILABILITY

Line 110: FROM cs_service_availability serv

106: /* Cursor 1 : Check if a record is defined at all in the service availability
107: setup form*/
108: CURSOR service_available IS
109: SELECT 'x'
110: FROM cs_service_availability serv
111: WHERE serv.service_inventory_item_id = p_ord_serv_inv_item_id
112: AND serv.service_manufacturing_org_id = p_control_manu_org_id ;
113:
114: /* Cursor 2 : Check if a record is defined for service availability */

Line 117: FROM cs_service_availability avail

113:
114: /* Cursor 2 : Check if a record is defined for service availability */
115: CURSOR check_available IS
116: SELECT 'x'
117: FROM cs_service_availability avail
118: WHERE avail.service_inventory_item_id = p_ord_serv_inv_item_id
119: AND avail.service_manufacturing_org_id = p_control_manu_org_id
120: AND NVL(avail.inventory_item_id, p_Cp_inventory_item_id)
121: = p_cp_inventory_item_id

Line 135: FROM cs_service_availability avail

131:
132: /* Cursor 3 : Check if a record is defined for service restricted */
133: CURSOR check_restricted IS
134: SELECT 'x'
135: FROM cs_service_availability avail
136: WHERE avail.service_inventory_item_id = p_ord_serv_inv_item_id
137: AND avail.service_manufacturing_org_id = p_control_manu_org_id
138: AND NVL(avail.inventory_item_id, p_cp_inventory_item_id)
139: = p_cp_inventory_item_id

Line 153: FROM cs_service_availability avail

149:
150: /* Cursor 4 : Check if any record is defined for service restricted */
151: CURSOR check_any_restricted IS
152: SELECT 'x'
153: FROM cs_service_availability avail
154: WHERE avail.service_inventory_item_id = p_ord_serv_inv_item_id
155: AND avail.service_manufacturing_org_id = p_control_manu_org_id
156: AND avail.service_available_flag = 'N';
157:

Line 161: FROM cs_service_availability avail

157:
158: /* Cursor 5 : Check if any record is defined for service available */
159: CURSOR check_any_available IS
160: SELECT 'x'
161: FROM cs_service_availability avail
162: WHERE avail.service_inventory_item_id = p_ord_serv_inv_item_id
163: AND avail.service_manufacturing_org_id = p_control_manu_org_id
164: AND avail.service_available_flag = 'Y';
165:

Line 170: FROM cs_service_availability avail

166: /* Cursor 6 : Check if a record is defined for service restricted for
167: the same customer/product/revision (no date check) */
168: CURSOR check_same_restricted IS
169: SELECT 'x'
170: FROM cs_service_availability avail
171: WHERE avail.service_inventory_item_id = p_ord_serv_inv_item_id
172: AND avail.service_manufacturing_org_id = p_control_manu_org_id
173: AND NVL(avail.inventory_item_id, p_cp_inventory_item_id)
174: = p_cp_inventory_item_id

Line 187: FROM cs_service_availability avail

183: /* Cursor 6 : Check if a record is defined for service available for
184: the same customer/product/revision (no date check) */
185: CURSOR check_same_available IS
186: SELECT 'x'
187: FROM cs_service_availability avail
188: WHERE avail.service_inventory_item_id = p_ord_serv_inv_item_id
189: AND avail.service_manufacturing_org_id = p_control_manu_org_id
190: AND NVL(avail.inventory_item_id, p_cp_inventory_item_id)
191: = p_cp_inventory_item_id