[Home] [Help]
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
465: , p_organization_id IN NUMBER
466: , p_category_set_id IN NUMBER
467: , p_category_id IN NUMBER )
466: , p_category_set_id IN NUMBER
467: , p_category_id IN NUMBER )
468: IS
469: BEGIN
470: INSERT INTO CSL_RESOURCE_INVENTORY_ORG ( RESOURCE_ID, ORGANIZATION_ID, LAST_UPDATE_DATE
471: , LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, CATEGORY_SET_ID, CATEGORY_ID )
472: VALUES ( p_resource_id, p_organization_id
473: , SYSDATE, 1, SYSDATE, 1, p_category_set_id, p_category_id );
474: END INSERT_RESOURCE_PROFILE_REC;
472: VALUES ( p_resource_id, p_organization_id
473: , SYSDATE, 1, SYSDATE, 1, p_category_set_id, p_category_id );
474: END INSERT_RESOURCE_PROFILE_REC;
475:
476: /*Private procedure that updates a record in CSL_RESOURCE_INVENTORY_ORG*/
477: PROCEDURE UPDATE_RESOURCE_PROFILE_REC( p_resource_id IN NUMBER
478: , p_organization_id IN NUMBER
479: , p_category_set_id IN NUMBER
480: , p_category_id IN NUMBER )
479: , p_category_set_id IN NUMBER
480: , p_category_id IN NUMBER )
481: IS
482: BEGIN
483: UPDATE CSL_RESOURCE_INVENTORY_ORG
484: SET ORGANIZATION_ID = p_organization_id
485: , CATEGORY_SET_ID = p_category_set_id
486: , CATEGORY_ID = p_category_id
487: , LAST_UPDATE_DATE = SYSDATE
487: , LAST_UPDATE_DATE = SYSDATE
488: WHERE RESOURCE_ID = p_resource_id;
489: END UPDATE_RESOURCE_PROFILE_REC;
490:
491: /*Private procedure that deletes a record from CSL_RESOURCE_INVENTORY_ORG*/
492: PROCEDURE DELETE_RESOURCE_PROFILE_REC( p_resource_id IN NUMBER )
493: IS
494: BEGIN
495: DELETE CSL_RESOURCE_INVENTORY_ORG
491: /*Private procedure that deletes a record from CSL_RESOURCE_INVENTORY_ORG*/
492: PROCEDURE DELETE_RESOURCE_PROFILE_REC( p_resource_id IN NUMBER )
493: IS
494: BEGIN
495: DELETE CSL_RESOURCE_INVENTORY_ORG
496: WHERE RESOURCE_ID = p_resource_id;
497: EXCEPTION
498: WHEN NO_DATA_FOUND THEN
499: NULL;
526:
527: /*Reduce rollback segments*/
528: COMMIT;
529:
530: /*Delete the resource from CSL_RESOURCE_INVENTORY_ORG*/
531: DELETE_RESOURCE_PROFILE_REC( p_resource_id => p_resource_id );
532:
533: /*Reduce rollback segments*/
534: COMMIT;
712: COMMIT;
713: CSL_MTL_SEC_LOCATORS_ACC_PKG.POPULATE_SEC_LOCATORS_ACC;
714: COMMIT;
715:
716: /*Delete any old record for resource from CSL_RESOURCE_INVENTORY_ORG*/
717: DELETE_RESOURCE_PROFILE_REC( p_resource_id => p_resource_id );
718: /*Insert resource org record*/
719: INSERT_RESOURCE_PROFILE_REC( p_resource_id => p_resource_id
720: , p_organization_id => l_profile_org_id
1408: l_cat_filter_changed BOOLEAN; -- TRUE when category filter changed
1409:
1410: CURSOR c_org ( b_resource_id NUMBER ) IS
1411: SELECT organization_id, category_set_id, category_id
1412: FROM csl_resource_inventory_org
1413: WHERE resource_id = b_resource_id;
1414: r_org c_org%ROWTYPE;
1415: BEGIN
1416:
1446: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1447: jtm_message_log_pkg.Log_Msg
1448: ( 0
1449: , g_table_name
1450: , 'Resource profile record not found in csl_resource_inventory_org.' || fnd_global.local_chr(10)||
1451: 'Inserting all system item records without calling markdirty.'
1452: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1453: );
1454: END IF;