DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on FND_GLOBAL

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

3376: -- will store the Correct qty (rounded up) to create replenishment MO for each Item
3377:
3378: l_src_sub := NULL;
3379:
3380: l_trohdr_rec.created_by := fnd_global.user_id;
3381: l_trohdr_rec.creation_date := sysdate;
3382: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
3383: l_trohdr_rec.last_updated_by := fnd_global.user_id;
3384: l_trohdr_rec.last_update_date := sysdate;

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

3379:
3380: l_trohdr_rec.created_by := fnd_global.user_id;
3381: l_trohdr_rec.creation_date := sysdate;
3382: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
3383: l_trohdr_rec.last_updated_by := fnd_global.user_id;
3384: l_trohdr_rec.last_update_date := sysdate;
3385: l_trohdr_rec.last_update_login := fnd_global.user_id;
3386: l_trohdr_rec.organization_id := NULL; -- assigned inside the loop
3387: l_trohdr_rec.status_date := sysdate;

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

3381: l_trohdr_rec.creation_date := sysdate;
3382: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
3383: l_trohdr_rec.last_updated_by := fnd_global.user_id;
3384: l_trohdr_rec.last_update_date := sysdate;
3385: l_trohdr_rec.last_update_login := fnd_global.user_id;
3386: l_trohdr_rec.organization_id := NULL; -- assigned inside the loop
3387: l_trohdr_rec.status_date := sysdate;
3388: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
3389: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

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

3708: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Lines');
3709: END IF;
3710: l_line_num := l_line_num + 1;
3711: l_trolin_tbl(l_order_count).header_id := l_x_trohdr_rec.header_id;
3712: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;
3713: l_trolin_tbl(l_order_count).creation_date := sysdate;
3714: l_trolin_tbl(l_order_count).date_required := p_consol_item_repl_tbl(i).date_required;
3715: l_trolin_tbl(l_order_count).from_subinventory_code := l_src_sub;
3716: l_trolin_tbl(l_order_count).line_number := l_line_num;

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

3714: l_trolin_tbl(l_order_count).date_required := p_consol_item_repl_tbl(i).date_required;
3715: l_trolin_tbl(l_order_count).from_subinventory_code := l_src_sub;
3716: l_trolin_tbl(l_order_count).line_number := l_line_num;
3717: l_trolin_tbl(l_order_count).inventory_item_id := p_consol_item_repl_tbl(i).Item_id;
3718: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
3719: l_trolin_tbl(l_order_count).last_update_date := sysdate;
3720: l_trolin_tbl(l_order_count).last_update_login := fnd_global.user_id;
3721: l_trolin_tbl(l_order_count).line_status := INV_Globals.g_to_status_preapproved;
3722: l_trolin_tbl(l_order_count).organization_id := p_consol_item_repl_tbl(i).ORGANIZATION_ID;

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

3716: l_trolin_tbl(l_order_count).line_number := l_line_num;
3717: l_trolin_tbl(l_order_count).inventory_item_id := p_consol_item_repl_tbl(i).Item_id;
3718: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
3719: l_trolin_tbl(l_order_count).last_update_date := sysdate;
3720: l_trolin_tbl(l_order_count).last_update_login := fnd_global.user_id;
3721: l_trolin_tbl(l_order_count).line_status := INV_Globals.g_to_status_preapproved;
3722: l_trolin_tbl(l_order_count).organization_id := p_consol_item_repl_tbl(i).ORGANIZATION_ID;
3723: l_trolin_tbl(l_order_count).quantity := p_consol_item_repl_tbl(i).final_replenishment_qty;
3724: l_trolin_tbl(l_order_count).uom_code := p_consol_item_repl_tbl(i).Repl_UOM_Code;

Line 4025: fnd_global.user_id,

4021: l_repl_level_tab(k),
4022: l_repl_type_tab(k),
4023: Sysdate,
4024: Sysdate,
4025: fnd_global.user_id,
4026: fnd_global.user_id,
4027: fnd_global.user_id);
4028:
4029: -- CLEAR all entries in the tables

Line 4026: fnd_global.user_id,

4022: l_repl_type_tab(k),
4023: Sysdate,
4024: Sysdate,
4025: fnd_global.user_id,
4026: fnd_global.user_id,
4027: fnd_global.user_id);
4028:
4029: -- CLEAR all entries in the tables
4030: l_organization_id_tab.DELETE;

Line 4027: fnd_global.user_id);

4023: Sysdate,
4024: Sysdate,
4025: fnd_global.user_id,
4026: fnd_global.user_id,
4027: fnd_global.user_id);
4028:
4029: -- CLEAR all entries in the tables
4030: l_organization_id_tab.DELETE;
4031: l_mo_header_id_tab.DELETE;

Line 4113: fnd_global.user_id,

4109: repl_level,
4110: repl_type,
4111: Sysdate,
4112: Sysdate,
4113: fnd_global.user_id,
4114: fnd_global.user_id,
4115: fnd_global.user_id
4116: FROM WMS_REPL_DEMAND_GTMP
4117: WHERE ORGANIZATION_ID = p_consol_item_repl_tbl(i).ORGANIZATION_ID

Line 4114: fnd_global.user_id,

4110: repl_type,
4111: Sysdate,
4112: Sysdate,
4113: fnd_global.user_id,
4114: fnd_global.user_id,
4115: fnd_global.user_id
4116: FROM WMS_REPL_DEMAND_GTMP
4117: WHERE ORGANIZATION_ID = p_consol_item_repl_tbl(i).ORGANIZATION_ID
4118: AND inventory_item_id = p_consol_item_repl_tbl(i).item_id

Line 4115: fnd_global.user_id

4111: Sysdate,
4112: Sysdate,
4113: fnd_global.user_id,
4114: fnd_global.user_id,
4115: fnd_global.user_id
4116: FROM WMS_REPL_DEMAND_GTMP
4117: WHERE ORGANIZATION_ID = p_consol_item_repl_tbl(i).ORGANIZATION_ID
4118: AND inventory_item_id = p_consol_item_repl_tbl(i).item_id
4119: AND REPL_TO_SUBINVENTORY_CODE = p_consol_item_repl_tbl(i).repl_to_subinventory_code;

Line 4988: fnd_global.user_id,

4984: l_repl_level_tab(k),
4985: l_repl_type_tab(k),
4986: Sysdate,
4987: Sysdate,
4988: fnd_global.user_id,
4989: fnd_global.user_id,
4990: fnd_global.user_id
4991: );
4992:

Line 4989: fnd_global.user_id,

4985: l_repl_type_tab(k),
4986: Sysdate,
4987: Sysdate,
4988: fnd_global.user_id,
4989: fnd_global.user_id,
4990: fnd_global.user_id
4991: );
4992:
4993: -- CLEAR all entries in the tables

Line 4990: fnd_global.user_id

4986: Sysdate,
4987: Sysdate,
4988: fnd_global.user_id,
4989: fnd_global.user_id,
4990: fnd_global.user_id
4991: );
4992:
4993: -- CLEAR all entries in the tables
4994: l_organization_id_tab.DELETE;

Line 7746: fnd_global.user_id,

7742: L_repl_type,
7743: l_repl_level,
7744: Sysdate,
7745: Sysdate,
7746: fnd_global.user_id,
7747: fnd_global.user_id,
7748: fnd_global.user_id);
7749:
7750: END IF; -- FOR l_orig_pri_qty <> -9999

Line 7747: fnd_global.user_id,

7743: l_repl_level,
7744: Sysdate,
7745: Sysdate,
7746: fnd_global.user_id,
7747: fnd_global.user_id,
7748: fnd_global.user_id);
7749:
7750: END IF; -- FOR l_orig_pri_qty <> -9999
7751:

Line 7748: fnd_global.user_id);

7744: Sysdate,
7745: Sysdate,
7746: fnd_global.user_id,
7747: fnd_global.user_id,
7748: fnd_global.user_id);
7749:
7750: END IF; -- FOR l_orig_pri_qty <> -9999
7751:
7752: END IF; -- MEANS DELIVERY IS SPLIT