APPS.CSP_RESOURCE_PUB dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 325: FROM csp_inv_loc_assignments

321: IF px_CSP_INV_LOC_ASSIGNMENT_ID IS NOT NULL THEN
322: -- we have to find out whether the record ready exists.
323: BEGIN
324: SELECT csp_inv_loc_assignment_id INTO l_check_existence
325: FROM csp_inv_loc_assignments
326: WHERE csp_inv_loc_assignment_id = px_csp_inv_loc_assignment_id;
327:
328: RAISE TOO_MANY_ROWS;
329: EXCEPTION

Line 342: fnd_message.set_token('TABLE', 'csp_inv_loc_assignments', TRUE);

338: --l_msg_data := SQLERRM(SQLCODE);
339: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
340: fnd_message.set_token('ERR_FIELD', 'px_csp_inv_loc_assignment_id', TRUE);
341: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
342: fnd_message.set_token('TABLE', 'csp_inv_loc_assignments', TRUE);
343: fnd_msg_pub.ADD;
344: RAISE EXCP_USER_DEFINED;
345: END;
346: END IF;

Line 423: FROM csp_inv_loc_assignments

419: RAISE EXCP_USER_DEFINED;
420: ELSE
421: BEGIN
422: SELECT csp_inv_loc_assignment_id INTO l_check_existence
423: FROM csp_inv_loc_assignments
424: WHERE csp_inv_loc_assignment_id = px_csp_inv_loc_assignment_id;
425:
426:
427: EXCEPTION

Line 442: fnd_message.set_token('TABLE', 'csp_inv_loc_assignments', TRUE);

438: -- l_msg_data := l_msg_data||'. Unexpected errors occurred while validating the Assignment ID. Please contact your system administrator.';
439: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
440: fnd_message.set_token('ERR_FIELD', 'px_csp_inv_loc_assignment_id', TRUE);
441: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
442: fnd_message.set_token('TABLE', 'csp_inv_loc_assignments', TRUE);
443: fnd_msg_pub.ADD;
444: RAISE EXCP_USER_DEFINED;
445: END;
446: -- construct the l_csp_rec record

Line 515: FROM csp_inv_loc_assignments

511: ATTRIBUTE12 ,
512: ATTRIBUTE13 ,
513: ATTRIBUTE14 ,
514: ATTRIBUTE15
515: FROM csp_inv_loc_assignments
516: WHERE csp_inv_loc_assignment_id = px_csp_inv_loc_assignment_id;
517:
518: BEGIN
519:

Line 532: FROM csp_inv_loc_assignments

528: END IF;
529: CLOSE C_Get_Inv_Loc_Assignments;
530:
531: SELECT csp_inv_loc_assignment_id into l_result
532: FROM csp_inv_loc_assignments
533: WHERE resource_id = p_resource_id
534: AND resource_type = p_resource_type
535: AND organization_id = p_organization_id
536: AND subinventory_code = p_subinventory_code

Line 646: fnd_message.set_token('TABLE', 'csp_inv_loc_assignments', TRUE);

642: --l_msg_data := l_msg_data||'. This update operation is not allowed because updating this record creates a duplicate record with an existing one.';
643: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
644: fnd_message.set_token('ERR_FIELD', 'px_csp_inv_loc_assignment_id', TRUE);
645: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
646: fnd_message.set_token('TABLE', 'csp_inv_loc_assignments', TRUE);
647: fnd_msg_pub.ADD;
648: RAISE EXCP_USER_DEFINED;
649: END;
650:

Line 658: FROM csp_inv_loc_assignments

654: END IF;
655: IF l_csp_rec.creation_date IS NULL THEN
656: BEGIN
657: SELECT creation_date INTO l_csp_rec.creation_date
658: FROM csp_inv_loc_assignments
659: WHERE csp_inv_loc_assignment_id = l_csp_rec.csp_inv_loc_assignment_id;
660: END;
661: END IF;
662: CSP_RESOURCE_PVT.Update_resource(

Line 773: FROM csp_inv_loc_assignments

769:
770: BEGIN
771: IF p_default_code IS NULL THEN
772: SELECT csp_inv_loc_assignment_id into l_result
773: FROM csp_inv_loc_assignments
774: WHERE resource_id = p_resource_id
775: AND resource_type = p_resource_type
776: AND organization_id = p_organization_id
777: AND subinventory_code = p_subinventory_code;

Line 781: FROM csp_inv_loc_assignments

777: AND subinventory_code = p_subinventory_code;
778: -- AND default_code IS NULL;
779: ELSE
780: SELECT csp_inv_loc_assignment_id into l_result
781: FROM csp_inv_loc_assignments
782: WHERE resource_id = p_resource_id
783: AND resource_type = p_resource_type
784: AND organization_id = p_organization_id
785: AND subinventory_code = p_subinventory_code;