APPS.CSP_RESOURCE_PUB dependencies on CSP_SEC_INVENTORIES

Line 171: FROM csp_sec_inventories

167: -- check whether the subinventory is a Spare subinventory in the organization.
168: ELSE
169: /* BEGIN
170: SELECT SECONDARY_INVENTORY_ID INTO l_check_existence
171: FROM csp_sec_inventories
172: WHERE organization_id = p_organization_id
173: AND secondary_inventory_name = p_subinventory_code;
174:
175: EXCEPTION

Line 187: fnd_message.set_token('TABLE', 'csp_sec_inventories', TRUE);

183: WHEN OTHERS THEN
184: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
185: fnd_message.set_token('ERR_FIELD', 'p_subinventory_code', TRUE);
186: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
187: fnd_message.set_token('TABLE', 'csp_sec_inventories', TRUE);
188: FND_MSG_PUB.ADD;
189: RAISE EXCP_USER_DEFINED;
190: END;
191: */

Line 271: FROM csp_sec_inventories

267: l_good_type VARCHAR2(1) := fnd_api.g_false;
268: l_bad_type VARCHAR2(1) := fnd_api.g_false;
269: CURSOR c_Get_Condition_Type IS
270: SELECT condition_type
271: FROM csp_sec_inventories
272: WHERE secondary_inventory_name = p_subinventory_code
273: AND organization_id = p_organization_id;
274:
275: BEGIN

Line 561: FROM csp_sec_inventories

557: l_good_type VARCHAR2(1) := fnd_api.g_false;
558: l_bad_type VARCHAR2(1) := fnd_api.g_false;
559: CURSOR c_Get_Condition_Type IS
560: SELECT condition_type
561: FROM csp_sec_inventories
562: WHERE secondary_inventory_name = decode(p_subinventory_code, null, l_csp_rec_update.subinventory_code, p_subinventory_code)
563: AND organization_id = decode(p_organization_id, null, l_csp_rec_update.organization_id, p_organization_id);
564:
565: BEGIN