eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_PLANNER_NOTIFICATIONS dependencies on FND_PROFILE

Line 407: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)

403: -- call to min_max API
404: CSP_MINMAX_PVT.run_min_max_plan (
405: p_item_select => l_item_select
406: , p_handle_rep_item => p_repitem
407: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)
408: , p_cat_select => l_Cat_select
409: , p_cat_set_id => p_Category_set_id
410: , p_mcat_struct => l_mcat_struct_id
411: , p_level => 1 -- always run at organization level

Line 426: , p_approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))

422: , p_employee_id => l_employee_id
423: , p_subinv => null
424: , p_dd_loc_id => p_dd_loc_id
425: , p_wip_batch_id => l_wip_batch_id
426: , p_approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))
427: , p_buyer_hi => p_buyer_hi
428: , p_buyer_lo => p_buyer_lo
429: , p_range_buyer => l_range_buyer
430: , p_cust_id => l_cust_id

Line 557: FND_PROFILE.GET('CSP_ORDER_TYPE', l_header_rec.order_type_id);

553: l_header_rec.dest_organization_id := p_organization_id;
554: l_header_Rec.need_by_date := l_need_by_date;
555: l_header_rec.operation := 'CREATE';
556: l_header_rec.ship_to_location_id := p_dd_loc_id;
557: FND_PROFILE.GET('CSP_ORDER_TYPE', l_header_rec.order_type_id);
558:
559: l_line_tbl(1).line_num := 1;
560: l_line_tbl(1).inventory_item_id := l_item_attr_rec.item_id;
561: l_line_tbl(1).quantity := l_index.reord_qty;

Line 643: , approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))

639: , unit_price => l_item_Attr_rec.unit_price
640: , user_id => l_user_id
641: , sysd => sysdate
642: , organization_id => p_organization_id
643: , approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))
644: , src_type => l_item_attr_rec.src_Type
645: , encum_flag => l_encum_flag
646: , customer_id => l_cust_id
647: , employee_id => l_employee_id

Line 654: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)

650: , src_subinv => l_item_attr_Rec.src_subinv
651: , subinv => null
652: , location_id => p_dd_loc_id
653: , po_org_id => l_po_org_id
654: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)
655: , x_ret_stat => l_return_status
656: , x_ret_mesg => l_msg_data);
657:
658: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 769: , approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))

765: , wip_id => l_wip_batch_id
766: , user_id => l_user_id
767: , sysd => sysdate
768: , organization_id => p_organization_id
769: , approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))
770: , build_in_wip => l_item_attr_rec.build_in_wip
771: , pick_components => l_item_attr_rec.pick_components
772: , x_ret_stat => l_return_status
773: , x_ret_mesg => l_msg_data);

Line 788: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)

784: -- call min max api with selection as above max qty
785: CSP_MINMAX_PVT.run_min_max_plan (
786: p_item_select => l_item_select
787: , p_handle_rep_item => p_repitem
788: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)
789: , p_cat_select => l_Cat_select
790: , p_cat_set_id => p_Category_set_id
791: , p_mcat_struct => l_mcat_struct_id
792: , p_level => 1 -- always run at organization level

Line 807: , p_approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))

803: , p_employee_id => l_employee_id
804: , p_subinv => null
805: , p_dd_loc_id => p_dd_loc_id
806: , p_wip_batch_id => l_wip_batch_id
807: , p_approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))
808: , p_buyer_hi => p_buyer_hi
809: , p_buyer_lo => p_buyer_lo
810: , p_range_buyer => l_range_buyer
811: , p_cust_id => l_cust_id

Line 1237: FND_PROFILE.GET('CSP_ORDER_TYPE', l_header_rec.order_type_id);

1233: l_header_rec.dest_organization_id := p_organization_id;
1234: l_header_Rec.need_by_date := onc.need_Date;
1235: l_header_rec.operation := 'CREATE';
1236: l_header_rec.ship_to_location_id := p_dd_loc_id;
1237: FND_PROFILE.GET('CSP_ORDER_TYPE', l_header_rec.order_type_id);
1238:
1239: l_line_tbl(1).line_num := 1;
1240: l_line_tbl(1).inventory_item_id := onc.inventory_item_id;
1241: l_line_tbl(1).quantity := onc.quantity;

Line 1314: , approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))

1310: , unit_price => l_item_Attr_rec1.unit_price
1311: , user_id => l_user_id
1312: , sysd => sysdate
1313: , organization_id => p_organization_id
1314: , approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))
1315: , src_type => l_item_attr_rec1.src_Type
1316: , encum_flag => l_encum_flag
1317: , customer_id => l_cust_id
1318: , employee_id => l_employee_id

Line 1325: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)

1321: , src_subinv => l_item_attr_Rec1.src_subinv
1322: , subinv => null
1323: , location_id => p_dd_loc_id
1324: , po_org_id => l_po_org_id
1325: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)
1326: , x_ret_stat => l_return_status
1327: , x_ret_mesg => l_msg_data);
1328:
1329: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1373: , approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))

1369: , wip_id => l_wip_batch_id
1370: , user_id => l_user_id
1371: , sysd => sysdate
1372: , organization_id => p_organization_id
1373: , approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))
1374: , build_in_wip => l_item_attr_rec1.build_in_wip
1375: , pick_components => l_item_attr_rec1.pick_components
1376: , x_ret_stat => l_return_status
1377: , x_ret_mesg => l_msg_data);

Line 2099: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)

2095: ELSE
2096: CSP_MINMAX_PVT.run_min_max_plan (
2097: p_item_select => l_item_select
2098: , p_handle_rep_item => 2
2099: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)
2100: , p_cat_select => l_Cat_select
2101: , p_cat_set_id => nvl(p_item_rec.Category_set_id, l_category_set_id)
2102: , p_mcat_struct => l_mcat_struct_id
2103: , p_level => 1 -- run at orgn level

Line 2118: , p_approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))

2114: , p_employee_id => l_employee_id
2115: , p_subinv => null
2116: , p_dd_loc_id => p_item_rec.dd_loc_id
2117: , p_wip_batch_id => null --l_wip_batch_id
2118: , p_approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))
2119: , p_buyer_hi => null --p_buyer_hi
2120: , p_buyer_lo => null --p_buyer_lo
2121: , p_range_buyer => null --l_range_buyer
2122: , p_cust_id => null --l_cust_id

Line 2195: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)

2191: -- minmax planned
2192: CSP_MINMAX_PVT.run_min_max_plan (
2193: p_item_select => l_item_select
2194: , p_handle_rep_item => 2
2195: , p_pur_revision => nvl(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)
2196: , p_cat_select => l_Cat_select
2197: , p_cat_set_id => nvl(p_item_rec.Category_set_id, l_category_set_id)
2198: , p_mcat_struct => l_mcat_struct_id
2199: , p_level => 2 -- run at organization level

Line 2214: , p_approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))

2210: , p_employee_id => l_employee_id
2211: , p_subinv => rsc.secondary_inventory_name
2212: , p_dd_loc_id => p_item_rec.dd_loc_id
2213: , p_wip_batch_id => null --l_wip_batch_id
2214: , p_approval => to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'1'))
2215: , p_buyer_hi => null --p_buyer_hi
2216: , p_buyer_lo => null --p_buyer_lo
2217: , p_range_buyer => null --l_range_buyer
2218: , p_cust_id => null --l_cust_id