DBA Data[Home] [Help]

APPS.ASO_PRICE_ADJ_RLTSHIP_PVT dependencies on FND_GLOBAL

Line 58: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

54:
55: l_api_name CONSTANT VARCHAR2(30) := 'Create_price_adj_rltship';
56: l_api_version_number CONSTANT NUMBER := 1.0;
57:
58: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
59: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
60: BEGIN
61: -- Standard Start of API savepoint
62: SAVEPOINT CREATE_PRICE_ADJ_RLTSHIP_PVT;

Line 59: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

55: l_api_name CONSTANT VARCHAR2(30) := 'Create_price_adj_rltship';
56: l_api_version_number CONSTANT NUMBER := 1.0;
57:
58: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
59: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
60: BEGIN
61: -- Standard Start of API savepoint
62: SAVEPOINT CREATE_PRICE_ADJ_RLTSHIP_PVT;
63:

Line 108: IF FND_GLOBAL.User_Id IS NULL

104: */
105: -- ******************************************************************
106: -- Validate Environment
107: -- ******************************************************************
108: IF FND_GLOBAL.User_Id IS NULL
109: THEN
110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
111: THEN
112: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

Line 268: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

264: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
265: )
266: IS
267:
268: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
269: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
270: Cursor C_Get_price_rltship(lc_ADJ_RELATIONSHIP_ID Number) IS
271: Select --rowid,
272: ADJ_RELATIONSHIP_ID ,

Line 269: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

265: )
266: IS
267:
268: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
269: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
270: Cursor C_Get_price_rltship(lc_ADJ_RELATIONSHIP_ID Number) IS
271: Select --rowid,
272: ADJ_RELATIONSHIP_ID ,
273: CREATION_DATE ,

Line 604: IF FND_GLOBAL.User_Id IS NULL

600: */
601: -- ******************************************************************
602: -- Validate Environment
603: -- ******************************************************************
604: IF FND_GLOBAL.User_Id IS NULL
605: THEN
606: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
607: THEN
608: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');