DBA Data[Home] [Help]

APPS.OE_PO_CALLBACK_UTIL dependencies on FND_PROFILE

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

84: P_PO_Line_ID,
85: P_Line_Location_ID,
86: P_PO_Release_ID,
87: Trunc(Sysdate),
88: Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),
89: Trunc(Sysdate),
90: Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
91: );
92: End Insert_SO_Drop_Ship_Sources;

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

86: P_PO_Release_ID,
87: Trunc(Sysdate),
88: Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1),
89: Trunc(Sysdate),
90: Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
91: );
92: End Insert_SO_Drop_Ship_Sources;
93: --
94: -- Update_Req_Info is an OE procedure that is called by Oracle Purchasing to

Line 137: FND_PROFILE.Get('SO_SOURCE_CODE',G_OE_SOURCE_CODE); -- Returns OE's profile

133: G_PKG_Name) Then
134: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
135: End If;
136: --
137: FND_PROFILE.Get('SO_SOURCE_CODE',G_OE_SOURCE_CODE); -- Returns OE's profile
138: -- value for SO_SOURCE_CODE
139: If P_Interface_Source_Code = G_OE_Source_Code Then
140: Null;
141: Else -- Interface source code is not an OE interface source code

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

168: Update SO_Drop_Ship_Sources
169: Set Requisition_Header_ID = P_Requisition_Header_ID,
170: Requisition_LIne_ID = P_Requisition_Line_ID,
171: Last_Update_Date = Trunc(Sysdate),
172: Last_Updated_By = Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
173: Where Current of L_SO_Drop_Ship_SOurce_Csr;
174: Else -- Another requisition for same order line.
175: Insert_SO_Drop_Ship_Sources ( P_Drop_Ship_Source_ID => G_Drop_Ship_Source_ID,
176: P_Header_ID => G_Header_ID,

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

344: PO_Line_ID = P_PO_Line_ID,
345: Line_Location_ID = P_Line_Location_ID,
346: PO_Release_ID = Nvl(P_PO_Release_Id,PO_Release_ID),
347: Last_Update_Date = Trunc(Sysdate),
348: Last_Updated_By = Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1)
349: Where Current of L_SO_Drop_Ship_Source_Csr;
350: Else -- Another PO for same order line.
351: Insert_SO_Drop_Ship_Sources (P_Drop_Ship_Source_ID => G_Drop_Ship_Source_ID,
352: P_Header_ID => G_Header_ID,