APPS.OE_DROP_SHIP_GRP dependencies on FND_PROFILE

Line 107: Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),

103: P_PO_Line_ID,
104: P_Line_Location_ID,
105: P_PO_Release_ID,
106: Trunc(Sysdate),
107: Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),
108: Trunc(Sysdate),
109: Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
110: );
111:

Line 109: Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)

105: P_PO_Release_ID,
106: Trunc(Sysdate),
107: Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),
108: Trunc(Sysdate),
109: Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
110: );
111:
112: End Insert_OE_Drop_Ship_Sources;
113:

Line 172: FND_PROFILE.Get('ONT_SOURCE_CODE',G_OE_SOURCE_CODE);

168: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:
171: -- Returns OE's profile value for SO_SOURCE_CODE
172: FND_PROFILE.Get('ONT_SOURCE_CODE',G_OE_SOURCE_CODE);
173:
174: IF P_Interface_Source_Code = G_OE_Source_Code THEN
175: Null;
176: ELSE -- Interface source code is not an OE interface source code

Line 210: Last_Updated_By = Nvl(To_Number(FND_PROFILE.VALUE

206: UPDATE OE_Drop_Ship_Sources
207: SET Requisition_Header_ID = P_Requisition_Header_ID,
208: Requisition_LIne_ID = P_Requisition_Line_ID,
209: Last_Update_Date = Trunc(Sysdate),
210: Last_Updated_By = Nvl(To_Number(FND_PROFILE.VALUE
211: ('USER_ID')),-1)
212: WHERE Current of L_OE_Drop_Ship_Source_Csr;
213:
214: ELSE

Line 435: Last_Updated_By = Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)

431: PO_Line_ID = P_PO_Line_ID,
432: Line_Location_ID = P_Line_Location_ID,
433: PO_Release_ID = Nvl(P_PO_Release_Id,PO_Release_ID),
434: Last_Update_Date = Trunc(Sysdate),
435: Last_Updated_By = Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
436: WHERE Current of L_OE_Drop_Ship_Source_Csr;
437: ELSE -- Another PO for same order line.
438: Insert_OE_Drop_Ship_Sources
439: (P_Drop_Ship_Source_ID => G_Drop_Ship_Source_ID,

Line 602: last_updated_by = NVL(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),

598: po_line_id = NULL,
599: po_release_id = NULL,
600: line_location_id = NULL,
601: last_update_date = Trunc(Sysdate),
602: last_updated_by = NVL(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),
603: last_update_login = NVL(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
604: WHERE line_id = l_line_id
605: AND header_id = l_header_id;
606:

Line 603: last_update_login = NVL(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)

599: po_release_id = NULL,
600: line_location_id = NULL,
601: last_update_date = Trunc(Sysdate),
602: last_updated_by = NVL(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),
603: last_update_login = NVL(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
604: WHERE line_id = l_line_id
605: AND header_id = l_header_id;
606:
607: IF l_debug_level > 0 THEN