DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on FND_GLOBAL

Line 3292: l_trohdr_rec.created_by := fnd_global.user_id;

3288: -- will store the Correct qty (rounded up) to create replenishment MO for each Item
3289:
3290: l_src_sub := NULL;
3291:
3292: l_trohdr_rec.created_by := fnd_global.user_id;
3293: l_trohdr_rec.creation_date := sysdate;
3294: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
3295: l_trohdr_rec.last_updated_by := fnd_global.user_id;
3296: l_trohdr_rec.last_update_date := sysdate;

Line 3295: l_trohdr_rec.last_updated_by := fnd_global.user_id;

3291:
3292: l_trohdr_rec.created_by := fnd_global.user_id;
3293: l_trohdr_rec.creation_date := sysdate;
3294: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
3295: l_trohdr_rec.last_updated_by := fnd_global.user_id;
3296: l_trohdr_rec.last_update_date := sysdate;
3297: l_trohdr_rec.last_update_login := fnd_global.user_id;
3298: l_trohdr_rec.organization_id := NULL; -- assigned inside the loop
3299: l_trohdr_rec.status_date := sysdate;

Line 3297: l_trohdr_rec.last_update_login := fnd_global.user_id;

3293: l_trohdr_rec.creation_date := sysdate;
3294: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
3295: l_trohdr_rec.last_updated_by := fnd_global.user_id;
3296: l_trohdr_rec.last_update_date := sysdate;
3297: l_trohdr_rec.last_update_login := fnd_global.user_id;
3298: l_trohdr_rec.organization_id := NULL; -- assigned inside the loop
3299: l_trohdr_rec.status_date := sysdate;
3300: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
3301: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

Line 3611: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;

3607: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Lines');
3608: END IF;
3609: l_line_num := l_line_num + 1;
3610: l_trolin_tbl(l_order_count).header_id := l_x_trohdr_rec.header_id;
3611: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;
3612: l_trolin_tbl(l_order_count).creation_date := sysdate;
3613: l_trolin_tbl(l_order_count).date_required := p_consol_item_repl_tbl(i).date_required;
3614: l_trolin_tbl(l_order_count).from_subinventory_code := l_src_sub;
3615: l_trolin_tbl(l_order_count).line_number := l_line_num;

Line 3617: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;

3613: l_trolin_tbl(l_order_count).date_required := p_consol_item_repl_tbl(i).date_required;
3614: l_trolin_tbl(l_order_count).from_subinventory_code := l_src_sub;
3615: l_trolin_tbl(l_order_count).line_number := l_line_num;
3616: l_trolin_tbl(l_order_count).inventory_item_id := p_consol_item_repl_tbl(i).Item_id;
3617: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
3618: l_trolin_tbl(l_order_count).last_update_date := sysdate;
3619: l_trolin_tbl(l_order_count).last_update_login := fnd_global.user_id;
3620: l_trolin_tbl(l_order_count).line_status := INV_Globals.g_to_status_preapproved;
3621: l_trolin_tbl(l_order_count).organization_id := p_consol_item_repl_tbl(i).ORGANIZATION_ID;

Line 3619: l_trolin_tbl(l_order_count).last_update_login := fnd_global.user_id;

3615: l_trolin_tbl(l_order_count).line_number := l_line_num;
3616: l_trolin_tbl(l_order_count).inventory_item_id := p_consol_item_repl_tbl(i).Item_id;
3617: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
3618: l_trolin_tbl(l_order_count).last_update_date := sysdate;
3619: l_trolin_tbl(l_order_count).last_update_login := fnd_global.user_id;
3620: l_trolin_tbl(l_order_count).line_status := INV_Globals.g_to_status_preapproved;
3621: l_trolin_tbl(l_order_count).organization_id := p_consol_item_repl_tbl(i).ORGANIZATION_ID;
3622: l_trolin_tbl(l_order_count).quantity := p_consol_item_repl_tbl(i).final_replenishment_qty;
3623: l_trolin_tbl(l_order_count).uom_code := p_consol_item_repl_tbl(i).Repl_UOM_Code;

Line 3905: fnd_global.user_id,

3901: l_repl_level_tab(k),
3902: l_repl_type_tab(k),
3903: Sysdate,
3904: Sysdate,
3905: fnd_global.user_id,
3906: fnd_global.user_id,
3907: fnd_global.user_id);
3908:
3909: -- CLEAR all entries in the tables

Line 3906: fnd_global.user_id,

3902: l_repl_type_tab(k),
3903: Sysdate,
3904: Sysdate,
3905: fnd_global.user_id,
3906: fnd_global.user_id,
3907: fnd_global.user_id);
3908:
3909: -- CLEAR all entries in the tables
3910: l_organization_id_tab.DELETE;

Line 3907: fnd_global.user_id);

3903: Sysdate,
3904: Sysdate,
3905: fnd_global.user_id,
3906: fnd_global.user_id,
3907: fnd_global.user_id);
3908:
3909: -- CLEAR all entries in the tables
3910: l_organization_id_tab.DELETE;
3911: l_mo_header_id_tab.DELETE;

Line 3993: fnd_global.user_id,

3989: repl_level,
3990: repl_type,
3991: Sysdate,
3992: Sysdate,
3993: fnd_global.user_id,
3994: fnd_global.user_id,
3995: fnd_global.user_id
3996: FROM WMS_REPL_DEMAND_GTMP
3997: WHERE ORGANIZATION_ID = p_consol_item_repl_tbl(i).ORGANIZATION_ID

Line 3994: fnd_global.user_id,

3990: repl_type,
3991: Sysdate,
3992: Sysdate,
3993: fnd_global.user_id,
3994: fnd_global.user_id,
3995: fnd_global.user_id
3996: FROM WMS_REPL_DEMAND_GTMP
3997: WHERE ORGANIZATION_ID = p_consol_item_repl_tbl(i).ORGANIZATION_ID
3998: AND inventory_item_id = p_consol_item_repl_tbl(i).item_id

Line 3995: fnd_global.user_id

3991: Sysdate,
3992: Sysdate,
3993: fnd_global.user_id,
3994: fnd_global.user_id,
3995: fnd_global.user_id
3996: FROM WMS_REPL_DEMAND_GTMP
3997: WHERE ORGANIZATION_ID = p_consol_item_repl_tbl(i).ORGANIZATION_ID
3998: AND inventory_item_id = p_consol_item_repl_tbl(i).item_id
3999: AND REPL_TO_SUBINVENTORY_CODE = p_consol_item_repl_tbl(i).repl_to_subinventory_code;

Line 4822: fnd_global.user_id,

4818: l_repl_level_tab(k),
4819: l_repl_type_tab(k),
4820: Sysdate,
4821: Sysdate,
4822: fnd_global.user_id,
4823: fnd_global.user_id,
4824: fnd_global.user_id
4825: );
4826:

Line 4823: fnd_global.user_id,

4819: l_repl_type_tab(k),
4820: Sysdate,
4821: Sysdate,
4822: fnd_global.user_id,
4823: fnd_global.user_id,
4824: fnd_global.user_id
4825: );
4826:
4827: -- CLEAR all entries in the tables

Line 4824: fnd_global.user_id

4820: Sysdate,
4821: Sysdate,
4822: fnd_global.user_id,
4823: fnd_global.user_id,
4824: fnd_global.user_id
4825: );
4826:
4827: -- CLEAR all entries in the tables
4828: l_organization_id_tab.DELETE;

Line 7571: fnd_global.user_id,

7567: L_repl_type,
7568: l_repl_level,
7569: Sysdate,
7570: Sysdate,
7571: fnd_global.user_id,
7572: fnd_global.user_id,
7573: fnd_global.user_id);
7574:
7575: END IF; -- FOR l_orig_pri_qty <> -9999

Line 7572: fnd_global.user_id,

7568: l_repl_level,
7569: Sysdate,
7570: Sysdate,
7571: fnd_global.user_id,
7572: fnd_global.user_id,
7573: fnd_global.user_id);
7574:
7575: END IF; -- FOR l_orig_pri_qty <> -9999
7576:

Line 7573: fnd_global.user_id);

7569: Sysdate,
7570: Sysdate,
7571: fnd_global.user_id,
7572: fnd_global.user_id,
7573: fnd_global.user_id);
7574:
7575: END IF; -- FOR l_orig_pri_qty <> -9999
7576:
7577: END IF; -- MEANS DELIVERY IS SPLIT