454: , RESP_APPL_ID => p_application_id
455: );
456: /*Get the profile values*/
457: -- Bug 3724123
458: x_organization_id := TO_NUMBER( fnd_profile.value('CS_INV_VALIDATION_ORG') );
459: x_category_set_id := TO_NUMBER( fnd_profile.value('CSL_ITEM_CATEGORY_SET_FILTER') );
460: x_category_id := TO_NUMBER( fnd_profile.value('CSL_ITEM_CATEGORY_FILTER') );
461: END GET_PROFILES;
462:
455: );
456: /*Get the profile values*/
457: -- Bug 3724123
458: x_organization_id := TO_NUMBER( fnd_profile.value('CS_INV_VALIDATION_ORG') );
459: x_category_set_id := TO_NUMBER( fnd_profile.value('CSL_ITEM_CATEGORY_SET_FILTER') );
460: x_category_id := TO_NUMBER( fnd_profile.value('CSL_ITEM_CATEGORY_FILTER') );
461: END GET_PROFILES;
462:
463: /*Private procedure that inserts a record into CSL_RESOURCE_INVENTORY_ORG*/
456: /*Get the profile values*/
457: -- Bug 3724123
458: x_organization_id := TO_NUMBER( fnd_profile.value('CS_INV_VALIDATION_ORG') );
459: x_category_set_id := TO_NUMBER( fnd_profile.value('CSL_ITEM_CATEGORY_SET_FILTER') );
460: x_category_id := TO_NUMBER( fnd_profile.value('CSL_ITEM_CATEGORY_FILTER') );
461: END GET_PROFILES;
462:
463: /*Private procedure that inserts a record into CSL_RESOURCE_INVENTORY_ORG*/
464: PROCEDURE INSERT_RESOURCE_PROFILE_REC( p_resource_id IN NUMBER