DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on FND_GLOBAL

Line 286: l_pull_sequence_rec.Created_By := FND_GLOBAL.USER_ID;

282:
283: Validate_Pull_sequence(l_pull_sequence_rec);
284:
285: l_pull_sequence_rec.Creation_Date := SYSDATE;
286: l_pull_sequence_rec.Created_By := FND_GLOBAL.USER_ID;
287: l_pull_sequence_rec.last_update_date := SYSDATE;
288: l_pull_sequence_rec.last_updated_by := FND_GLOBAL.USER_ID;
289: l_pull_sequence_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
290:

Line 288: l_pull_sequence_rec.last_updated_by := FND_GLOBAL.USER_ID;

284:
285: l_pull_sequence_rec.Creation_Date := SYSDATE;
286: l_pull_sequence_rec.Created_By := FND_GLOBAL.USER_ID;
287: l_pull_sequence_rec.last_update_date := SYSDATE;
288: l_pull_sequence_rec.last_updated_by := FND_GLOBAL.USER_ID;
289: l_pull_sequence_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
290:
291: INV_PullSequence_PKG.Insert_Row(l_pull_sequence_rec);
292:

Line 289: l_pull_sequence_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

285: l_pull_sequence_rec.Creation_Date := SYSDATE;
286: l_pull_sequence_rec.Created_By := FND_GLOBAL.USER_ID;
287: l_pull_sequence_rec.last_update_date := SYSDATE;
288: l_pull_sequence_rec.last_updated_by := FND_GLOBAL.USER_ID;
289: l_pull_sequence_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
290:
291: INV_PullSequence_PKG.Insert_Row(l_pull_sequence_rec);
292:
293: x_return_status := l_return_status;

Line 431: l_pull_sequence_rec.last_updated_by := FND_GLOBAL.USER_ID;

427: );
428: Validate_Pull_sequence(l_Pull_sequence_rec);
429:
430: l_pull_sequence_rec.last_update_date := SYSDATE;
431: l_pull_sequence_rec.last_updated_by := FND_GLOBAL.USER_ID;
432: l_pull_sequence_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
433:
434: INV_PullSequence_PKG.Update_Row(l_pull_sequence_Rec);
435:

Line 432: l_pull_sequence_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

428: Validate_Pull_sequence(l_Pull_sequence_rec);
429:
430: l_pull_sequence_rec.last_update_date := SYSDATE;
431: l_pull_sequence_rec.last_updated_by := FND_GLOBAL.USER_ID;
432: l_pull_sequence_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
433:
434: INV_PullSequence_PKG.Update_Row(l_pull_sequence_Rec);
435:
436: x_return_status := l_return_status;

Line 801: l_kanban_card_rec.last_updated_by := FND_GLOBAL.USER_ID;

797: l_kanban_card_rec.document_type := p_document_type;
798: l_kanban_card_rec.document_header_id := p_document_header_id;
799: l_kanban_card_rec.document_detail_id := p_document_detail_id;
800: l_kanban_card_rec.last_update_date := SYSDATE;
801: l_kanban_card_rec.last_updated_by := FND_GLOBAL.USER_ID;
802: l_kanban_card_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
803: l_kanban_card_rec.replenish_quantity := p_replenish_quantity;
804: l_kanban_card_rec.need_by_date := p_need_by_date;
805: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;

Line 802: l_kanban_card_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

798: l_kanban_card_rec.document_header_id := p_document_header_id;
799: l_kanban_card_rec.document_detail_id := p_document_detail_id;
800: l_kanban_card_rec.last_update_date := SYSDATE;
801: l_kanban_card_rec.last_updated_by := FND_GLOBAL.USER_ID;
802: l_kanban_card_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
803: l_kanban_card_rec.replenish_quantity := p_replenish_quantity;
804: l_kanban_card_rec.need_by_date := p_need_by_date;
805: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
806: mydebug('calling INV_KanbanCard_PKG.Update_Row');

Line 1578: P_Last_Updated_By => FND_GLOBAL.USER_ID,

1574: P_Kanban_Card_Type => Nvl(p_pull_sequence_rec.kanban_card_type,INV_Kanban_Pvt.g_card_type_replenishable),
1575: P_Source_type => p_Pull_Sequence_Rec.Source_type,
1576: P_Kanban_size => nvl(p_Pull_Sequence_Rec.Kanban_size,0),
1577: P_Last_Update_Date => SYSDATE,
1578: P_Last_Updated_By => FND_GLOBAL.USER_ID,
1579: P_Creation_Date => SYSDATE,
1580: P_Created_By => FND_GLOBAL.USER_ID,
1581: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1582: P_Last_Print_Date => NULL,

Line 1580: P_Created_By => FND_GLOBAL.USER_ID,

1576: P_Kanban_size => nvl(p_Pull_Sequence_Rec.Kanban_size,0),
1577: P_Last_Update_Date => SYSDATE,
1578: P_Last_Updated_By => FND_GLOBAL.USER_ID,
1579: P_Creation_Date => SYSDATE,
1580: P_Created_By => FND_GLOBAL.USER_ID,
1581: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1582: P_Last_Print_Date => NULL,
1583: P_Locator_id => p_Pull_Sequence_Rec.Locator_id,
1584: P_Supplier_id => p_Pull_Sequence_Rec.Supplier_id,

Line 1581: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,

1577: P_Last_Update_Date => SYSDATE,
1578: P_Last_Updated_By => FND_GLOBAL.USER_ID,
1579: P_Creation_Date => SYSDATE,
1580: P_Created_By => FND_GLOBAL.USER_ID,
1581: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1582: P_Last_Print_Date => NULL,
1583: P_Locator_id => p_Pull_Sequence_Rec.Locator_id,
1584: P_Supplier_id => p_Pull_Sequence_Rec.Supplier_id,
1585: P_Supplier_site_id => p_Pull_Sequence_Rec.Supplier_site_id,

Line 1783: FND_GLOBAL.USER_ID,

1779: )
1780: Values
1781: (
1782: sysdate,
1783: FND_GLOBAL.USER_ID,
1784: sysdate,
1785: FND_GLOBAL.USER_ID,
1786: p_buyer_Id,
1787: p_interface_Source_Code,

Line 1785: FND_GLOBAL.USER_ID,

1781: (
1782: sysdate,
1783: FND_GLOBAL.USER_ID,
1784: sysdate,
1785: FND_GLOBAL.USER_ID,
1786: p_buyer_Id,
1787: p_interface_Source_Code,
1788: p_requisition_type,
1789: p_approval,

Line 1911: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;

1907:
1908: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1909: begin
1910:
1911: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1912: l_trohdr_rec.creation_date := sysdate;
1913: l_trohdr_rec.date_required := p_need_by_date;
1914: l_trohdr_rec.from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;
1915: -- l_trohdr_rec.header_id := l_header_id;

Line 1917: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;

1913: l_trohdr_rec.date_required := p_need_by_date;
1914: l_trohdr_rec.from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;
1915: -- l_trohdr_rec.header_id := l_header_id;
1916: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1917: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
1918: l_trohdr_rec.last_update_date := sysdate;
1919: l_trohdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1920: l_trohdr_rec.organization_id := p_kanban_card_rec_tbl(1).organization_id;
1921: -- l_trohdr_rec.request_number := to_char(l_header_id);

Line 1919: l_trohdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

1915: -- l_trohdr_rec.header_id := l_header_id;
1916: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1917: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
1918: l_trohdr_rec.last_update_date := sysdate;
1919: l_trohdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1920: l_trohdr_rec.organization_id := p_kanban_card_rec_tbl(1).organization_id;
1921: -- l_trohdr_rec.request_number := to_char(l_header_id);
1922: l_trohdr_rec.status_date := sysdate;
1923: l_trohdr_rec.to_subinventory_code := p_kanban_card_rec_tbl(1).subinventory_name;

Line 1986: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;

1982:
1983:
1984: For l_order_count in 1..p_Kanban_Card_Rec_Tbl.Count Loop
1985: l_line_num := l_line_num + 1;
1986: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;
1987: l_trolin_tbl(l_order_count).creation_date := sysdate;
1988: l_trolin_tbl(l_order_count).date_required := p_need_by_date;
1989: l_trolin_tbl(l_order_count).from_locator_id := p_kanban_card_rec_tbl(1).source_locator_id;
1990: l_trolin_tbl(l_order_count).from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;

Line 1992: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;

1988: l_trolin_tbl(l_order_count).date_required := p_need_by_date;
1989: l_trolin_tbl(l_order_count).from_locator_id := p_kanban_card_rec_tbl(1).source_locator_id;
1990: l_trolin_tbl(l_order_count).from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;
1991: l_trolin_tbl(l_order_count).inventory_item_id := p_kanban_card_rec_tbl(1).inventory_item_id;
1992: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
1993: l_trolin_tbl(l_order_count).last_update_date := sysdate;
1994: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
1995: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
1996: l_trolin_tbl(l_order_count).line_number := l_line_num;

Line 1994: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;

1990: l_trolin_tbl(l_order_count).from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;
1991: l_trolin_tbl(l_order_count).inventory_item_id := p_kanban_card_rec_tbl(1).inventory_item_id;
1992: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
1993: l_trolin_tbl(l_order_count).last_update_date := sysdate;
1994: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
1995: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
1996: l_trolin_tbl(l_order_count).line_number := l_line_num;
1997: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1998: l_trolin_tbl(l_order_count).organization_id := p_kanban_card_rec_tbl(1).organization_id;

Line 2222: FND_GLOBAL.USER_ID,

2218: )
2219: values
2220: (
2221: sysdate ,
2222: FND_GLOBAL.USER_ID,
2223: sysdate ,
2224: FND_GLOBAL.USER_ID,
2225: p_kanban_card_rec_tbl(1).current_replnsh_cycle_id,
2226: 2,

Line 2224: FND_GLOBAL.USER_ID,

2220: (
2221: sysdate ,
2222: FND_GLOBAL.USER_ID,
2223: sysdate ,
2224: FND_GLOBAL.USER_ID,
2225: p_kanban_card_rec_tbl(1).current_replnsh_cycle_id,
2226: 2,
2227: 1,
2228: 'INV',

Line 2403: FND_GLOBAL.USER_ID,

2399: )
2400: values
2401: (
2402: SYSDATE ,
2403: FND_GLOBAL.USER_ID,
2404: SYSDATE ,
2405: FND_GLOBAL.USER_ID,
2406: p_kanban_card_rec_tbl(1).current_replnsh_cycle_id,
2407: 2,

Line 2405: FND_GLOBAL.USER_ID,

2401: (
2402: SYSDATE ,
2403: FND_GLOBAL.USER_ID,
2404: SYSDATE ,
2405: FND_GLOBAL.USER_ID,
2406: p_kanban_card_rec_tbl(1).current_replnsh_cycle_id,
2407: 2,
2408: 1,
2409: 'INV',

Line 2497: l_flow_schedule_rec.created_by := FND_GLOBAL.USER_ID;

2493:
2494: For l_order_count in 1..p_kanban_card_rec_tbl.Count
2495: Loop
2496:
2497: l_flow_schedule_rec.created_by := FND_GLOBAL.USER_ID;
2498: l_flow_schedule_rec.creation_date := sysdate;
2499: l_flow_schedule_rec.last_updated_by := FND_GLOBAL.USER_ID;
2500: l_flow_schedule_rec.last_update_date := sysdate;
2501: l_flow_schedule_rec.line_id :=

Line 2499: l_flow_schedule_rec.last_updated_by := FND_GLOBAL.USER_ID;

2495: Loop
2496:
2497: l_flow_schedule_rec.created_by := FND_GLOBAL.USER_ID;
2498: l_flow_schedule_rec.creation_date := sysdate;
2499: l_flow_schedule_rec.last_updated_by := FND_GLOBAL.USER_ID;
2500: l_flow_schedule_rec.last_update_date := sysdate;
2501: l_flow_schedule_rec.line_id :=
2502: p_kanban_card_rec_tbl(1).wip_line_id;
2503: l_flow_schedule_rec.organization_id :=

Line 2691: fnd_global.user_id,

2687: kanban_card_id)
2688: VALUES
2689: (l_mode_flag,
2690: sysdate,
2691: fnd_global.user_id,
2692: sysdate,
2693: fnd_global.user_id,
2694: fnd_global.login_id,
2695: l_group_id,

Line 2693: fnd_global.user_id,

2689: (l_mode_flag,
2690: sysdate,
2691: fnd_global.user_id,
2692: sysdate,
2693: fnd_global.user_id,
2694: fnd_global.login_id,
2695: l_group_id,
2696: Decode(l_mode_flag, 1,null,l_header_id),
2697: p_kanban_card_rec_tbl(1).organization_id,

Line 2694: fnd_global.login_id,

2690: sysdate,
2691: fnd_global.user_id,
2692: sysdate,
2693: fnd_global.user_id,
2694: fnd_global.login_id,
2695: l_group_id,
2696: Decode(l_mode_flag, 1,null,l_header_id),
2697: p_kanban_card_rec_tbl(1).organization_id,
2698: 5, --job creation

Line 2742: fnd_global.user_id,

2738: p_kanban_card_rec_tbl(l_order_count).lot_quantity,
2739: p_kanban_card_rec_tbl(l_order_count).lot_subinventory_code,
2740: p_kanban_card_rec_tbl(l_order_count).lot_location_id ,
2741: sysdate,
2742: fnd_global.user_id,
2743: sysdate,
2744: fnd_global.user_id,
2745: fnd_global.login_id);
2746:

Line 2744: fnd_global.user_id,

2740: p_kanban_card_rec_tbl(l_order_count).lot_location_id ,
2741: sysdate,
2742: fnd_global.user_id,
2743: sysdate,
2744: fnd_global.user_id,
2745: fnd_global.login_id);
2746:
2747:
2748: END IF;

Line 2745: fnd_global.login_id);

2741: sysdate,
2742: fnd_global.user_id,
2743: sysdate,
2744: fnd_global.user_id,
2745: fnd_global.login_id);
2746:
2747:
2748: END IF;
2749: p_kanban_card_rec_tbl(l_order_count).document_header_id := null;

Line 3186: where user_id = FND_GLOBAL.USER_ID;

3182:
3183: select employee_id
3184: into l_buyer_id
3185: from fnd_user
3186: where user_id = FND_GLOBAL.USER_ID;
3187:
3188:
3189:
3190: /* Need to error */

Line 3280: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));

3276: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
3277: Elsif l_sql_stmt_no = 60
3278: Then
3279: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
3280: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));
3281: End If;
3282: FND_MSG_PUB.Add;
3283: Raise FND_API.G_EXC_ERROR;
3284:

Line 3446: Last_Updated_By = FND_GLOBAL.USER_ID

3442: Update Mtl_Kanban_Cards
3443: Set Supply_Status = p_card_supply_status,
3444: Current_Replnsh_Cycle_Id = l_Current_Replenish_Cycle_Id,
3445: Last_Update_Date = SYSDATE,
3446: Last_Updated_By = FND_GLOBAL.USER_ID
3447: Where Kanban_Card_Id = l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id;
3448:
3449: l_Kanban_Card_Rec.Kanban_card_Id :=
3450: l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id;