[Home] [Help]
253: -- Get respective profile values
254: --
255: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Checking item type access . . . '); END IF;
256:
257: IF fnd_profile.value('BOM:STANDARD_ITEM_ACCESS') = '1'
258: THEN
259: BOM_Globals.Set_STD_Item_Access
260: ( p_std_item_access => 4);
261: ELSE
263: BOM_Globals.Set_STD_Item_Access
264: (p_std_item_access => NULL);
265: END IF;
266:
267: IF fnd_profile.value('BOM:MODEL_ITEM_ACCESS') = '1'
268: THEN
269: BOM_Globals.Set_MDL_Item_Access
270: ( p_mdl_item_access => 1);
271: BOM_Globals.Set_OC_Item_Access
278: ( p_oc_item_access => NULL);
279: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(' Model/OC item access denied . . . '); END IF;
280: END IF;
281:
282: IF fnd_profile.value('BOM:PLANNING_ITEM_ACCESS') = '1'
283: THEN
284: BOM_Globals.Set_PLN_Item_Access
285: ( p_pln_item_access => 3);
286: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Planning item accessible. . . '); END IF;
1137: )
1138: )
1139: AND (
1140: (
1141: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
1142: and
1143: (not( bit = 4
1144: AND pto = 'Y'
1145: AND s.bom_item_type = 4
1146: AND s.replenish_to_order_flag = 'Y'
1147: )
1148: )
1149: ) OR
1150: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)
1151: ) /* BOM ER 9904085 */
1152: AND (
1153: (
1154: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
1150: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)
1151: ) /* BOM ER 9904085 */
1152: AND (
1153: (
1154: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
1155: and
1156: (not( bit = 1
1157: AND pto = 'Y'
1158: AND nvl(bic.optional, 1) = 2
1160: AND s.replenish_to_order_flag = 'Y'
1161: )
1162: )
1163: ) OR
1164: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)
1165: ) /* BOM ER 9904085 */
1166: );
1167:
1168:
1280: AND msi1.replenish_to_order_flag = 'Y'
1281: ) */
1282: (
1283: (
1284: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
1285: and
1286: (not( bit = 4
1287: AND pto = 'Y'
1288: AND msi1.bom_item_type = 4
1289: AND msi1.replenish_to_order_flag = 'Y'
1290: )
1291: )
1292: ) OR
1293: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)
1294: ) /* BOM ER 9904085 */
1295: );
1296: IF (l_count > 0) THEN
1297: l_token_tbl.DELETE;
1366: AND s.bom_enabled_flag = 'Y'
1367: AND s.inventory_item_id <> p_bom_head_unexp_rec.assembly_item_id
1368: AND (
1369: (
1370: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
1371: and
1372: (not( bit = 4
1373: AND pto = 'Y'
1374: AND s.bom_item_type = 4
1375: AND s.replenish_to_order_flag = 'Y'
1376: )
1377: )
1378: ) OR
1379: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)
1380: )
1381: AND (
1382: (
1383: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
1379: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)
1380: )
1381: AND (
1382: (
1383: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
1384: and
1385: (not( bit = 1
1386: AND pto = 'Y'
1387: AND nvl(bic.optional, 1) = 2
1389: AND s.replenish_to_order_flag = 'Y'
1390: )
1391: )
1392: ) OR
1393: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)
1394: )
1395: );
1396:
1397: IF l_Count > 0
1443:
1444: AND
1445: (
1446: (
1447: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
1448: and
1449: (not( bit = 4
1450: AND pto = 'Y'
1451: AND msi1.bom_item_type = 4
1452: AND msi1.replenish_to_order_flag = 'Y'
1453: )
1454: )
1455: ) OR
1456: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)
1457: )
1458: );
1459: IF (l_count > 0) THEN
1460: l_token_tbl.DELETE;