DBA Data[Home] [Help]

APPS.ASO_HEADER_RLTSHIP_PVT dependencies on FND_GLOBAL

Line 26: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

22: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23: )
24: IS
25: l_api_name CONSTANT VARCHAR2(30) := 'Create_header_rltship';
26: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
28: l_api_version_number CONSTANT NUMBER := 1.0;
29: l_return_status_full VARCHAR2(1);
30: --l_identity_sales_member_rec ASO_SALES_MEMBER_PUB.Sales_member_rec_Type;

Line 27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

23: )
24: IS
25: l_api_name CONSTANT VARCHAR2(30) := 'Create_header_rltship';
26: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
28: l_api_version_number CONSTANT NUMBER := 1.0;
29: l_return_status_full VARCHAR2(1);
30: --l_identity_sales_member_rec ASO_SALES_MEMBER_PUB.Sales_member_rec_Type;
31: BEGIN

Line 63: IF FND_GLOBAL.User_Id IS NULL

59:
60: -- ******************************************************************
61: -- Validate Environment
62: -- ******************************************************************
63: IF FND_GLOBAL.User_Id IS NULL
64: THEN
65: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
66: THEN
67: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

Line 180: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

176: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
177: )
178: IS
179:
180: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
181: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
182: Cursor C_Get_header_rltship(P_HEADER_RELATIONSHIP_ID Number) IS
183: Select --rowid,
184: HEADER_RELATIONSHIP_ID,

Line 181: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

177: )
178: IS
179:
180: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
181: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
182: Cursor C_Get_header_rltship(P_HEADER_RELATIONSHIP_ID Number) IS
183: Select --rowid,
184: HEADER_RELATIONSHIP_ID,
185: CREATION_DATE,