APPS.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on FND_PROFILE

Line 466: -- l_org_id := NVL( r_ii.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));

462: -- SYSTEM ITEM
463: OPEN c_ii( p_instance_id );
464: FETCH c_ii INTO r_ii;
465: IF c_ii%FOUND THEN
466: -- l_org_id := NVL( r_ii.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));
467: l_org_id := r_ii.INV_MASTER_ORGANIZATION_ID;
468: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Pre_Insert_Child(
469: p_inventory_item_id => r_ii.INVENTORY_ITEM_ID
470: , p_organization_id => l_org_id

Line 605: -- l_org_id := NVL( r_ii.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));

601: -- SYSTEM ITEM
602: OPEN c_ii( p_instance_id );
603: FETCH c_ii INTO r_ii;
604: IF c_ii%FOUND THEN
605: -- l_org_id := NVL( r_ii.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));
606: l_org_id := r_ii.INV_MASTER_ORGANIZATION_ID;
607: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Post_Delete_Child
608: ( p_inventory_item_id => r_ii.INVENTORY_ITEM_ID
609: , p_organization_id => l_org_id

Line 667: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_CHILDS'), 'N' );

663: , 'Entering Insert_Childs'
664: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
665: END IF;
666:
667: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_CHILDS'), 'N' );
668: -- IF Replicate Childs profile set to Y THEN
669: IF l_profile_value = 'Y' THEN
670: -- LOOP through the child list
671: FOR r_child_instance IN c_child_instance( p_instance_id ) LOOP

Line 726: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_PARENTS'), 'N' );

722: , 'Entering Insert_Parents'
723: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
724: END IF;
725:
726: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_PARENTS'), 'N' );
727:
728: -- If Replicate Parents profile set to Y THEN
729: IF l_profile_value = 'Y' THEN
730: -- LOOP through the parent list

Line 904: IF g_ib_count >= NVL(FND_PROFILE.VALUE (

900: Insert_ACC_Record ( p_instance_id ,p_resource_id ,p_flow_type);
901: END LOOP;
902:
903: -- Greater than check for Profile IB count was reset to a lower value
904: IF g_ib_count >= NVL(FND_PROFILE.VALUE (
905: 'CSL_IBITEM_COUNT_AT_LOCATION'), 0) THEN
906: RETURN TRUE;
907: ELSE
908:

Line 914: IF g_ib_count < NVL(FND_PROFILE.VALUE (

910: FOR c_ib_items IN c_new_ib_at_location (
911: p_resource_id, p_party_site_id , l_location_id, l_party_id )
912: LOOP
913:
914: IF g_ib_count < NVL(FND_PROFILE.VALUE (
915: 'CSL_IBITEM_COUNT_AT_LOCATION'), 0) THEN
916: Insert_ACC_Record ( c_ib_items.instance_id,
917: p_resource_id, p_flow_type);
918: ELSE

Line 979: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_CHILDS'), 'N' );

975: , 'Entering Delete_Childs'
976: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
977: END IF;
978:
979: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_CHILDS'), 'N' );
980: -- IF Replicate childs profile set to Y THEN
981: IF l_profile_value = 'Y' THEN
982: -- LOOP through the child list
983: FOR r_child_instance IN c_child_instance( p_instance_id ) LOOP

Line 1036: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_PARENTS'), 'N' );

1032: , 'Entering Delete_Parents'
1033: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1034: END IF;
1035:
1036: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_PARENTS'), 'N' );
1037:
1038: -- If Replicate Parents profile set to Y THEN
1039: IF l_profile_value = 'Y' THEN
1040: -- LOOP through the parent list

Line 1199: --l_org_id := NVL( r_item_instance.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));

1195: ,P_PK1_NUM_VALUE => r_item_instance.instance_id
1196: );
1197:
1198: -- Add SYSTEM ITEMs
1199: --l_org_id := NVL( r_item_instance.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));
1200: l_org_id := r_item_instance.INV_MASTER_ORGANIZATION_ID;
1201: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Pre_Insert_Child( p_inventory_item_id => r_item_instance.INVENTORY_ITEM_ID
1202: , p_organization_id => l_org_id
1203: , p_resource_id => p_resource_id

Line 1270: --l_org_id := NVL( r_item_instance.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));

1266: ,P_RESOURCE_ID => p_resource_id
1267: );
1268:
1269: -- Delete SYSTEM ITEMs
1270: --l_org_id := NVL( r_item_instance.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));
1271: l_org_id := r_item_instance.INV_MASTER_ORGANIZATION_ID;
1272: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Post_Delete_Child( p_inventory_item_id => r_item_instance.INVENTORY_ITEM_ID
1273: , p_organization_id => l_org_id
1274: , p_resource_id => p_resource_id