DBA Data[Home] [Help]

APPS.INV_ITEM_REVISION_PUB dependencies on FND_GLOBAL

Line 11: G_USER_ID NUMBER := FND_GLOBAL.User_Id;

7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ITEM_REVISION_PUB';
9: G_FILE_NAME CONSTANT VARCHAR2(12) := 'INVPREVB.pls';
10:
11: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
12: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
13:
14: G_Miss_Char VARCHAR2(1) := fnd_api.G_MISS_CHAR;
15: G_Miss_Num NUMBER := fnd_api.G_MISS_NUM;

Line 12: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;

8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ITEM_REVISION_PUB';
9: G_FILE_NAME CONSTANT VARCHAR2(12) := 'INVPREVB.pls';
10:
11: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
12: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
13:
14: G_Miss_Char VARCHAR2(1) := fnd_api.G_MISS_CHAR;
15: G_Miss_Num NUMBER := fnd_api.G_MISS_NUM;
16: G_Miss_Date DATE := fnd_api.G_MISS_DATE;

Line 969: , FND_GLOBAL.user_id

965: , DECODE(p_Item_Revision_rec.attribute13, G_Miss_Char, NULL, p_Item_Revision_rec.attribute13 )
966: , DECODE(p_Item_Revision_rec.attribute14, G_Miss_Char, NULL, p_Item_Revision_rec.attribute14 )
967: , DECODE(p_Item_Revision_rec.attribute15, G_Miss_Char, NULL, p_Item_Revision_rec.attribute15 )
968: , l_sysdate
969: , FND_GLOBAL.user_id
970: , l_sysdate
971: , FND_GLOBAL.user_id
972: , FND_GLOBAL.conc_login_id
973: , DECODE(p_Item_Revision_rec.request_id, G_Miss_Num, NULL, p_Item_Revision_rec.request_id )

Line 971: , FND_GLOBAL.user_id

967: , DECODE(p_Item_Revision_rec.attribute15, G_Miss_Char, NULL, p_Item_Revision_rec.attribute15 )
968: , l_sysdate
969: , FND_GLOBAL.user_id
970: , l_sysdate
971: , FND_GLOBAL.user_id
972: , FND_GLOBAL.conc_login_id
973: , DECODE(p_Item_Revision_rec.request_id, G_Miss_Num, NULL, p_Item_Revision_rec.request_id )
974: , DECODE(p_Item_Revision_rec.program_application_id, G_Miss_Num, NULL, p_Item_Revision_rec.program_application_id )
975: , DECODE(p_Item_Revision_rec.program_id, G_Miss_Num, NULL, p_Item_Revision_rec.program_id )

Line 972: , FND_GLOBAL.conc_login_id

968: , l_sysdate
969: , FND_GLOBAL.user_id
970: , l_sysdate
971: , FND_GLOBAL.user_id
972: , FND_GLOBAL.conc_login_id
973: , DECODE(p_Item_Revision_rec.request_id, G_Miss_Num, NULL, p_Item_Revision_rec.request_id )
974: , DECODE(p_Item_Revision_rec.program_application_id, G_Miss_Num, NULL, p_Item_Revision_rec.program_application_id )
975: , DECODE(p_Item_Revision_rec.program_id, G_Miss_Num, NULL, p_Item_Revision_rec.program_id )
976: , DECODE(p_Item_Revision_rec.program_update_date, G_Miss_Date, NULL, p_Item_Revision_rec.program_update_date )

Line 1685: , last_updated_by = FND_GLOBAL.user_id

1681: , attribute13 = DECODE(p_Item_Revision_rec.attribute13, G_Miss_Char, null, null, attribute13, p_Item_Revision_rec.attribute13 )
1682: , attribute14 = DECODE(p_Item_Revision_rec.attribute14, G_Miss_Char, null, null, attribute14, p_Item_Revision_rec.attribute14 )
1683: , attribute15 = DECODE(p_Item_Revision_rec.attribute15, G_Miss_Char, null, null, attribute15, p_Item_Revision_rec.attribute15 )
1684: , last_update_date = l_sysdate
1685: , last_updated_by = FND_GLOBAL.user_id
1686: , last_update_login = FND_GLOBAL.conc_login_id
1687: , request_id = DECODE(p_Item_Revision_rec.request_id, G_Miss_Num, null, null, request_id, p_Item_Revision_rec.request_id )
1688: , program_application_id = DECODE(p_Item_Revision_rec.program_application_id, G_Miss_Num, null, null, program_application_id, p_Item_Revision_rec.program_application_id )
1689: , program_id = DECODE(p_Item_Revision_rec.program_id, G_Miss_Num, null, null, program_id, p_Item_Revision_rec.program_id )

Line 1686: , last_update_login = FND_GLOBAL.conc_login_id

1682: , attribute14 = DECODE(p_Item_Revision_rec.attribute14, G_Miss_Char, null, null, attribute14, p_Item_Revision_rec.attribute14 )
1683: , attribute15 = DECODE(p_Item_Revision_rec.attribute15, G_Miss_Char, null, null, attribute15, p_Item_Revision_rec.attribute15 )
1684: , last_update_date = l_sysdate
1685: , last_updated_by = FND_GLOBAL.user_id
1686: , last_update_login = FND_GLOBAL.conc_login_id
1687: , request_id = DECODE(p_Item_Revision_rec.request_id, G_Miss_Num, null, null, request_id, p_Item_Revision_rec.request_id )
1688: , program_application_id = DECODE(p_Item_Revision_rec.program_application_id, G_Miss_Num, null, null, program_application_id, p_Item_Revision_rec.program_application_id )
1689: , program_id = DECODE(p_Item_Revision_rec.program_id, G_Miss_Num, null, null, program_id, p_Item_Revision_rec.program_id )
1690: , program_update_date = DECODE(p_Item_Revision_rec.program_update_date, G_Miss_Date, null, null, program_update_date, p_Item_Revision_rec.program_update_date )