DBA Data[Home] [Help]

APPS.OKE_DTS_INTEGRATION_PKG dependencies on FND_GLOBAL

Line 80: X_Last_Updated_By => fnd_global.user_id,

76: X_Inventory_Item_Id => p_Item_Id,
77: X_Organization_Id => p_inventory_org_id,
78: X_Schedule_Designator => p_plan,
79: X_Last_Update_Date => sysdate,
80: X_Last_Updated_By => fnd_global.user_id,
81: X_Creation_Date => sysdate,
82: X_Created_By => fnd_global.user_id,
83: X_Last_Update_Login => fnd_global.login_id,
84: X_MPS_Explosion_Level => L_Level

Line 82: X_Created_By => fnd_global.user_id,

78: X_Schedule_Designator => p_plan,
79: X_Last_Update_Date => sysdate,
80: X_Last_Updated_By => fnd_global.user_id,
81: X_Creation_Date => sysdate,
82: X_Created_By => fnd_global.user_id,
83: X_Last_Update_Login => fnd_global.login_id,
84: X_MPS_Explosion_Level => L_Level
85: );
86: END IF;

Line 83: X_Last_Update_Login => fnd_global.login_id,

79: X_Last_Update_Date => sysdate,
80: X_Last_Updated_By => fnd_global.user_id,
81: X_Creation_Date => sysdate,
82: X_Created_By => fnd_global.user_id,
83: X_Last_Update_Login => fnd_global.login_id,
84: X_MPS_Explosion_Level => L_Level
85: );
86: END IF;
87:

Line 155: Fnd_Global.User_Id ,

151: L_Id ,
152: lu.lookup_code ,
153: L_Supply_Demand_Type ,
154: Sysdate ,
155: Fnd_Global.User_Id ,
156: Sysdate ,
157: Fnd_Global.User_Id ,
158: Fnd_Global.Login_Id ,
159: p_Item_Id ,

Line 157: Fnd_Global.User_Id ,

153: L_Supply_Demand_Type ,
154: Sysdate ,
155: Fnd_Global.User_Id ,
156: Sysdate ,
157: Fnd_Global.User_Id ,
158: Fnd_Global.Login_Id ,
159: p_Item_Id ,
160: p_Inv_Org_ID ,
161: p_Designator ,

Line 158: Fnd_Global.Login_Id ,

154: Sysdate ,
155: Fnd_Global.User_Id ,
156: Sysdate ,
157: Fnd_Global.User_Id ,
158: Fnd_Global.Login_Id ,
159: p_Item_Id ,
160: p_Inv_Org_ID ,
161: p_Designator ,
162: p_Demand_Date ,

Line 215: LAST_UPDATED_BY = Fnd_Global.User_Id,

211:
212: UPDATE MRP_SCHEDULE_DATES d
213: SET
214: LAST_UPDATE_DATE = Sysdate,
215: LAST_UPDATED_BY = Fnd_Global.User_Id,
216: LAST_UPDATE_LOGIN = Fnd_Global.Login_Id,
217: INVENTORY_ITEM_ID = p_Item_Id,
218: ORGANIZATION_ID = p_Inv_Org_Id,
219: SCHEDULE_DESIGNATOR = p_Designator,

Line 216: LAST_UPDATE_LOGIN = Fnd_Global.Login_Id,

212: UPDATE MRP_SCHEDULE_DATES d
213: SET
214: LAST_UPDATE_DATE = Sysdate,
215: LAST_UPDATED_BY = Fnd_Global.User_Id,
216: LAST_UPDATE_LOGIN = Fnd_Global.Login_Id,
217: INVENTORY_ITEM_ID = p_Item_Id,
218: ORGANIZATION_ID = p_Inv_Org_Id,
219: SCHEDULE_DESIGNATOR = p_Designator,
220: SCHEDULE_DATE = p_Demand_Date,

Line 843: l_ship_rec.created_by := fnd_global.user_id;

839: l_ship_rec.attribute12 := null;
840: l_ship_rec.attribute13 := null;
841: l_ship_rec.attribute14 := null;
842: l_ship_rec.attribute15 := null;
843: l_ship_rec.created_by := fnd_global.user_id;
844: l_ship_rec.creation_date := sysdate;
845: l_ship_rec.last_update_date := sysdate;
846: l_ship_rec.last_update_login := fnd_global.login_id;
847: l_ship_rec.last_updated_by := fnd_global.user_id;

Line 846: l_ship_rec.last_update_login := fnd_global.login_id;

842: l_ship_rec.attribute15 := null;
843: l_ship_rec.created_by := fnd_global.user_id;
844: l_ship_rec.creation_date := sysdate;
845: l_ship_rec.last_update_date := sysdate;
846: l_ship_rec.last_update_login := fnd_global.login_id;
847: l_ship_rec.last_updated_by := fnd_global.user_id;
848: l_ship_rec.program_application_id := null;
849: l_ship_rec.program_id := null;
850: l_ship_rec.program_update_date := null;

Line 847: l_ship_rec.last_updated_by := fnd_global.user_id;

843: l_ship_rec.created_by := fnd_global.user_id;
844: l_ship_rec.creation_date := sysdate;
845: l_ship_rec.last_update_date := sysdate;
846: l_ship_rec.last_update_login := fnd_global.login_id;
847: l_ship_rec.last_updated_by := fnd_global.user_id;
848: l_ship_rec.program_application_id := null;
849: l_ship_rec.program_id := null;
850: l_ship_rec.program_update_date := null;
851: l_ship_rec.request_id := null;

Line 1416: select fnd_global.user_id,

1412: suggested_vendor_site_id,
1413: line_type_id,
1414: category_id,
1415: item_description)
1416: select fnd_global.user_id,
1417: fnd_global.login_id,
1418: sysdate,
1419: sysdate,
1420: fnd_global.user_id,

Line 1417: fnd_global.login_id,

1413: line_type_id,
1414: category_id,
1415: item_description)
1416: select fnd_global.user_id,
1417: fnd_global.login_id,
1418: sysdate,
1419: sysdate,
1420: fnd_global.user_id,
1421: d.item_id,

Line 1420: fnd_global.user_id,

1416: select fnd_global.user_id,
1417: fnd_global.login_id,
1418: sysdate,
1419: sysdate,
1420: fnd_global.user_id,
1421: d.item_id,
1422: l_quantity,
1423: l_unit_price,
1424: l_need_by_date,

Line 2038: l_error_text := l_error_text || fnd_global.newline || fnd_global.newline ||

2034: if ( l_error_text is null ) then
2035: l_error_text := i || '. ' ||
2036: fnd_msg_pub.get( p_msg_index => i , p_encoded => 'F' );
2037: else
2038: l_error_text := l_error_text || fnd_global.newline || fnd_global.newline ||
2039: i || '. ' ||
2040: fnd_msg_pub.get( p_msg_index => i , p_encoded => 'F' );
2041: end if;
2042: end loop;

Line 2200: L_REQUESTOR VARCHAR2(240) := NVL(P_REQUESTOR,FND_GLOBAL.User_Name);

2196: L_WF_Item_Type VARCHAR2(8) ;
2197: L_WF_Process VARCHAR2(240) ;
2198: L_WF_Item_Key VARCHAR2(240) ;
2199: L_WF_User_Key VARCHAR2(240) ;
2200: L_REQUESTOR VARCHAR2(240) := NVL(P_REQUESTOR,FND_GLOBAL.User_Name);
2201: BEGIN
2202: L_WF_Item_Type :='OKEDTS';
2203:
2204: IF P_ACTION = 'PLAN' THEN