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.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 820: l_kanban_card_rec.last_updated_by := FND_GLOBAL.USER_ID;

816: l_kanban_card_rec.document_type := p_document_type;
817: l_kanban_card_rec.document_header_id := p_document_header_id;
818: l_kanban_card_rec.document_detail_id := p_document_detail_id;
819: l_kanban_card_rec.last_update_date := SYSDATE;
820: l_kanban_card_rec.last_updated_by := FND_GLOBAL.USER_ID;
821: l_kanban_card_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
822: l_kanban_card_rec.replenish_quantity := p_replenish_quantity;
823: l_kanban_card_rec.need_by_date := p_need_by_date;
824: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;

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

817: l_kanban_card_rec.document_header_id := p_document_header_id;
818: l_kanban_card_rec.document_detail_id := p_document_detail_id;
819: l_kanban_card_rec.last_update_date := SYSDATE;
820: l_kanban_card_rec.last_updated_by := FND_GLOBAL.USER_ID;
821: l_kanban_card_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
822: l_kanban_card_rec.replenish_quantity := p_replenish_quantity;
823: l_kanban_card_rec.need_by_date := p_need_by_date;
824: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
825: mydebug('calling INV_KanbanCard_PKG.Update_Row');

Line 1650: P_Last_Updated_By => FND_GLOBAL.USER_ID,

1646: P_Kanban_Card_Type => Nvl(p_pull_sequence_rec.kanban_card_type,INV_Kanban_Pvt.g_card_type_replenishable),
1647: P_Source_type => p_Pull_Sequence_Rec.Source_type,
1648: P_Kanban_size => nvl(p_Pull_Sequence_Rec.Kanban_size,0),
1649: P_Last_Update_Date => SYSDATE,
1650: P_Last_Updated_By => FND_GLOBAL.USER_ID,
1651: P_Creation_Date => SYSDATE,
1652: P_Created_By => FND_GLOBAL.USER_ID,
1653: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1654: P_Last_Print_Date => NULL,

Line 1652: P_Created_By => FND_GLOBAL.USER_ID,

1648: P_Kanban_size => nvl(p_Pull_Sequence_Rec.Kanban_size,0),
1649: P_Last_Update_Date => SYSDATE,
1650: P_Last_Updated_By => FND_GLOBAL.USER_ID,
1651: P_Creation_Date => SYSDATE,
1652: P_Created_By => FND_GLOBAL.USER_ID,
1653: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1654: P_Last_Print_Date => NULL,
1655: P_Locator_id => p_Pull_Sequence_Rec.Locator_id,
1656: P_Supplier_id => l_supplier_id,

Line 1653: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,

1649: P_Last_Update_Date => SYSDATE,
1650: P_Last_Updated_By => FND_GLOBAL.USER_ID,
1651: P_Creation_Date => SYSDATE,
1652: P_Created_By => FND_GLOBAL.USER_ID,
1653: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1654: P_Last_Print_Date => NULL,
1655: P_Locator_id => p_Pull_Sequence_Rec.Locator_id,
1656: P_Supplier_id => l_supplier_id,
1657: P_Supplier_site_id => l_supp_site_id,

Line 1849: P_Last_Updated_By => FND_GLOBAL.USER_ID,

1845: P_Kanban_Card_Type => Nvl(p_pull_sequence_rec.kanban_card_type,INV_Kanban_Pvt.g_card_type_replenishable),
1846: P_Source_type => p_Pull_Sequence_Rec.Source_type,
1847: P_Kanban_size => nvl(p_Pull_Sequence_Rec.Kanban_size,0),
1848: P_Last_Update_Date => SYSDATE,
1849: P_Last_Updated_By => FND_GLOBAL.USER_ID,
1850: P_Creation_Date => SYSDATE,
1851: P_Created_By => FND_GLOBAL.USER_ID,
1852: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1853: P_Last_Print_Date => NULL,

Line 1851: P_Created_By => FND_GLOBAL.USER_ID,

1847: P_Kanban_size => nvl(p_Pull_Sequence_Rec.Kanban_size,0),
1848: P_Last_Update_Date => SYSDATE,
1849: P_Last_Updated_By => FND_GLOBAL.USER_ID,
1850: P_Creation_Date => SYSDATE,
1851: P_Created_By => FND_GLOBAL.USER_ID,
1852: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1853: P_Last_Print_Date => NULL,
1854: P_Locator_id => p_Pull_Sequence_Rec.Locator_id,
1855: P_Supplier_id => p_Pull_Sequence_Rec.Supplier_id,

Line 1852: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,

1848: P_Last_Update_Date => SYSDATE,
1849: P_Last_Updated_By => FND_GLOBAL.USER_ID,
1850: P_Creation_Date => SYSDATE,
1851: P_Created_By => FND_GLOBAL.USER_ID,
1852: P_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1853: P_Last_Print_Date => NULL,
1854: P_Locator_id => p_Pull_Sequence_Rec.Locator_id,
1855: P_Supplier_id => p_Pull_Sequence_Rec.Supplier_id,
1856: P_Supplier_site_id => p_Pull_Sequence_Rec.Supplier_site_id,

Line 2079: FND_GLOBAL.USER_ID,

2075: )
2076: Values
2077: (
2078: sysdate,
2079: FND_GLOBAL.USER_ID,
2080: sysdate,
2081: FND_GLOBAL.USER_ID,
2082: p_buyer_Id,
2083: p_interface_Source_Code,

Line 2081: FND_GLOBAL.USER_ID,

2077: (
2078: sysdate,
2079: FND_GLOBAL.USER_ID,
2080: sysdate,
2081: FND_GLOBAL.USER_ID,
2082: p_buyer_Id,
2083: p_interface_Source_Code,
2084: p_requisition_type,
2085: p_approval,

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

2206: l_proc_name CONSTANT VARCHAR2(30) := 'Create_Transfer_Order';
2207: l_secondary_qty NUMBER;
2208: begin
2209:
2210: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
2211: l_trohdr_rec.creation_date := sysdate;
2212: l_trohdr_rec.date_required := p_need_by_date;
2213: l_trohdr_rec.from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;
2214: -- l_trohdr_rec.header_id := l_header_id;

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

2212: l_trohdr_rec.date_required := p_need_by_date;
2213: l_trohdr_rec.from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;
2214: -- l_trohdr_rec.header_id := l_header_id;
2215: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
2216: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
2217: l_trohdr_rec.last_update_date := sysdate;
2218: l_trohdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2219: l_trohdr_rec.organization_id := p_kanban_card_rec_tbl(1).organization_id;
2220: -- l_trohdr_rec.request_number := to_char(l_header_id);

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

2214: -- l_trohdr_rec.header_id := l_header_id;
2215: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
2216: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
2217: l_trohdr_rec.last_update_date := sysdate;
2218: l_trohdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2219: l_trohdr_rec.organization_id := p_kanban_card_rec_tbl(1).organization_id;
2220: -- l_trohdr_rec.request_number := to_char(l_header_id);
2221: l_trohdr_rec.status_date := sysdate;
2222: l_trohdr_rec.to_subinventory_code := p_kanban_card_rec_tbl(1).subinventory_name;

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

2282:
2283:
2284: For l_order_count in 1..p_Kanban_Card_Rec_Tbl.Count Loop
2285: l_line_num := l_line_num + 1;
2286: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;
2287: l_trolin_tbl(l_order_count).creation_date := sysdate;
2288: l_trolin_tbl(l_order_count).date_required := p_need_by_date;
2289: l_trolin_tbl(l_order_count).from_locator_id := p_kanban_card_rec_tbl(1).source_locator_id;
2290: l_trolin_tbl(l_order_count).from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;

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

2288: l_trolin_tbl(l_order_count).date_required := p_need_by_date;
2289: l_trolin_tbl(l_order_count).from_locator_id := p_kanban_card_rec_tbl(1).source_locator_id;
2290: l_trolin_tbl(l_order_count).from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;
2291: l_trolin_tbl(l_order_count).inventory_item_id := p_kanban_card_rec_tbl(1).inventory_item_id;
2292: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
2293: l_trolin_tbl(l_order_count).last_update_date := sysdate;
2294: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
2295: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
2296: l_trolin_tbl(l_order_count).line_number := l_line_num;

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

2290: l_trolin_tbl(l_order_count).from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;
2291: l_trolin_tbl(l_order_count).inventory_item_id := p_kanban_card_rec_tbl(1).inventory_item_id;
2292: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
2293: l_trolin_tbl(l_order_count).last_update_date := sysdate;
2294: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
2295: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
2296: l_trolin_tbl(l_order_count).line_number := l_line_num;
2297: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
2298: l_trolin_tbl(l_order_count).organization_id := p_kanban_card_rec_tbl(1).organization_id;

Line 2592: FND_GLOBAL.USER_ID,

2588: )
2589: values
2590: (
2591: sysdate ,
2592: FND_GLOBAL.USER_ID,
2593: sysdate ,
2594: FND_GLOBAL.USER_ID,
2595: p_kanban_card_rec_tbl(1).current_replnsh_cycle_id,
2596: 2,

Line 2594: FND_GLOBAL.USER_ID,

2590: (
2591: sysdate ,
2592: FND_GLOBAL.USER_ID,
2593: sysdate ,
2594: FND_GLOBAL.USER_ID,
2595: p_kanban_card_rec_tbl(1).current_replnsh_cycle_id,
2596: 2,
2597: 1,
2598: 'INV',

Line 2779: FND_GLOBAL.USER_ID,

2775: )
2776: values
2777: (
2778: SYSDATE ,
2779: FND_GLOBAL.USER_ID,
2780: SYSDATE ,
2781: FND_GLOBAL.USER_ID,
2782: p_kanban_card_rec_tbl(1).current_replnsh_cycle_id,
2783: 2,

Line 2781: FND_GLOBAL.USER_ID,

2777: (
2778: SYSDATE ,
2779: FND_GLOBAL.USER_ID,
2780: SYSDATE ,
2781: FND_GLOBAL.USER_ID,
2782: p_kanban_card_rec_tbl(1).current_replnsh_cycle_id,
2783: 2,
2784: 1,
2785: 'INV',

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

2869:
2870: For l_order_count in 1..p_kanban_card_rec_tbl.Count
2871: Loop
2872:
2873: l_flow_schedule_rec.created_by := FND_GLOBAL.USER_ID;
2874: l_flow_schedule_rec.creation_date := sysdate;
2875: l_flow_schedule_rec.last_updated_by := FND_GLOBAL.USER_ID;
2876: l_flow_schedule_rec.last_update_date := sysdate;
2877: l_flow_schedule_rec.line_id :=

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

2871: Loop
2872:
2873: l_flow_schedule_rec.created_by := FND_GLOBAL.USER_ID;
2874: l_flow_schedule_rec.creation_date := sysdate;
2875: l_flow_schedule_rec.last_updated_by := FND_GLOBAL.USER_ID;
2876: l_flow_schedule_rec.last_update_date := sysdate;
2877: l_flow_schedule_rec.line_id :=
2878: p_kanban_card_rec_tbl(1).wip_line_id;
2879: l_flow_schedule_rec.organization_id :=

Line 3086: fnd_global.user_id,

3082: kanban_card_id)
3083: VALUES
3084: (l_mode_flag,
3085: sysdate,
3086: fnd_global.user_id,
3087: sysdate,
3088: fnd_global.user_id,
3089: fnd_global.login_id,
3090: l_group_id,

Line 3088: fnd_global.user_id,

3084: (l_mode_flag,
3085: sysdate,
3086: fnd_global.user_id,
3087: sysdate,
3088: fnd_global.user_id,
3089: fnd_global.login_id,
3090: l_group_id,
3091: Decode(l_mode_flag, 1,null,l_header_id),
3092: p_kanban_card_rec_tbl(1).organization_id,

Line 3089: fnd_global.login_id,

3085: sysdate,
3086: fnd_global.user_id,
3087: sysdate,
3088: fnd_global.user_id,
3089: fnd_global.login_id,
3090: l_group_id,
3091: Decode(l_mode_flag, 1,null,l_header_id),
3092: p_kanban_card_rec_tbl(1).organization_id,
3093: 5, --job creation

Line 3137: fnd_global.user_id,

3133: p_kanban_card_rec_tbl(l_order_count).lot_quantity,
3134: p_kanban_card_rec_tbl(l_order_count).lot_subinventory_code,
3135: p_kanban_card_rec_tbl(l_order_count).lot_location_id ,
3136: sysdate,
3137: fnd_global.user_id,
3138: sysdate,
3139: fnd_global.user_id,
3140: fnd_global.login_id);
3141:

Line 3139: fnd_global.user_id,

3135: p_kanban_card_rec_tbl(l_order_count).lot_location_id ,
3136: sysdate,
3137: fnd_global.user_id,
3138: sysdate,
3139: fnd_global.user_id,
3140: fnd_global.login_id);
3141:
3142:
3143: END IF;

Line 3140: fnd_global.login_id);

3136: sysdate,
3137: fnd_global.user_id,
3138: sysdate,
3139: fnd_global.user_id,
3140: fnd_global.login_id);
3141:
3142:
3143: END IF;
3144: end if;

Line 3585: where user_id = FND_GLOBAL.USER_ID;

3581:
3582: select employee_id
3583: into l_buyer_id
3584: from fnd_user
3585: where user_id = FND_GLOBAL.USER_ID;
3586:
3587:
3588:
3589: /* Need to error */

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

3675: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
3676: Elsif l_sql_stmt_no = 60
3677: Then
3678: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
3679: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));
3680: End If;
3681: FND_MSG_PUB.Add;
3682: Raise FND_API.G_EXC_ERROR;
3683:

Line 3840: Last_Updated_By = FND_GLOBAL.USER_ID

3836: Set Supply_Status = p_card_supply_status,
3837: Current_Replnsh_Cycle_Id = l_Current_Replenish_Cycle_Id,
3838: replenishment_count = nvl(replenishment_count,0)+1,
3839: Last_Update_Date = SYSDATE,
3840: Last_Updated_By = FND_GLOBAL.USER_ID
3841: Where Kanban_Card_Id = l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id;
3842:
3843: l_Kanban_Card_Rec.Kanban_card_Id := l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id;
3844: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row( p_Kanban_Card_id => l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id);

Line 3862: Last_Updated_By = FND_GLOBAL.USER_ID

3858: For l_card_Count in 2..l_Kanban_card_Tbl.Count Loop
3859: Update Mtl_Kanban_Cards
3860: Set Supply_Status = INV_Kanban_PVT.G_Supply_Status_Consolidate,
3861: Last_Update_Date = SYSDATE,
3862: Last_Updated_By = FND_GLOBAL.USER_ID
3863: Where Kanban_Card_Id = l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id;
3864: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row( p_Kanban_Card_id => l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id);
3865: INV_KanbanCard_PKG.Insert_Activity_For_Card(l_Kanban_Card_Rec);
3866: End Loop;