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 881: l_ship_rec.created_by := fnd_global.user_id;

877: l_ship_rec.attribute12 := null;
878: l_ship_rec.attribute13 := null;
879: l_ship_rec.attribute14 := null;
880: l_ship_rec.attribute15 := null;
881: l_ship_rec.created_by := fnd_global.user_id;
882: l_ship_rec.creation_date := sysdate;
883: l_ship_rec.last_update_date := sysdate;
884: l_ship_rec.last_update_login := fnd_global.login_id;
885: l_ship_rec.last_updated_by := fnd_global.user_id;

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

880: l_ship_rec.attribute15 := null;
881: l_ship_rec.created_by := fnd_global.user_id;
882: l_ship_rec.creation_date := sysdate;
883: l_ship_rec.last_update_date := sysdate;
884: l_ship_rec.last_update_login := fnd_global.login_id;
885: l_ship_rec.last_updated_by := fnd_global.user_id;
886: l_ship_rec.program_application_id := null;
887: l_ship_rec.program_id := null;
888: l_ship_rec.program_update_date := null;

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

881: l_ship_rec.created_by := fnd_global.user_id;
882: l_ship_rec.creation_date := sysdate;
883: l_ship_rec.last_update_date := sysdate;
884: l_ship_rec.last_update_login := fnd_global.login_id;
885: l_ship_rec.last_updated_by := fnd_global.user_id;
886: l_ship_rec.program_application_id := null;
887: l_ship_rec.program_id := null;
888: l_ship_rec.program_update_date := null;
889: l_ship_rec.request_id := null;

Line 1459: select fnd_global.user_id,

1455: suggested_vendor_site_id,
1456: line_type_id,
1457: category_id,
1458: item_description)
1459: select fnd_global.user_id,
1460: fnd_global.login_id,
1461: sysdate,
1462: sysdate,
1463: fnd_global.user_id,

Line 1460: fnd_global.login_id,

1456: line_type_id,
1457: category_id,
1458: item_description)
1459: select fnd_global.user_id,
1460: fnd_global.login_id,
1461: sysdate,
1462: sysdate,
1463: fnd_global.user_id,
1464: d.item_id,

Line 1463: fnd_global.user_id,

1459: select fnd_global.user_id,
1460: fnd_global.login_id,
1461: sysdate,
1462: sysdate,
1463: fnd_global.user_id,
1464: d.item_id,
1465: l_quantity,
1466: l_unit_price,
1467: l_need_by_date,

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

2078: if ( l_error_text is null ) then
2079: l_error_text := i || '. ' ||
2080: fnd_msg_pub.get( p_msg_index => i , p_encoded => 'F' );
2081: else
2082: l_error_text := l_error_text || fnd_global.newline || fnd_global.newline ||
2083: i || '. ' ||
2084: fnd_msg_pub.get( p_msg_index => i , p_encoded => 'F' );
2085: end if;
2086: end loop;

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

2240: L_WF_Item_Type VARCHAR2(8) ;
2241: L_WF_Process VARCHAR2(240) ;
2242: L_WF_Item_Key VARCHAR2(240) ;
2243: L_WF_User_Key VARCHAR2(240) ;
2244: L_REQUESTOR VARCHAR2(240) := NVL(P_REQUESTOR,FND_GLOBAL.User_Name);
2245: BEGIN
2246: L_WF_Item_Type :='OKEDTS';
2247:
2248: IF P_ACTION = 'PLAN' THEN