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 1024: , FND_GLOBAL.user_id

1020: , DECODE(p_Item_Revision_rec.attribute13, G_Miss_Char, NULL, p_Item_Revision_rec.attribute13 )
1021: , DECODE(p_Item_Revision_rec.attribute14, G_Miss_Char, NULL, p_Item_Revision_rec.attribute14 )
1022: , DECODE(p_Item_Revision_rec.attribute15, G_Miss_Char, NULL, p_Item_Revision_rec.attribute15 )
1023: , l_sysdate
1024: , FND_GLOBAL.user_id
1025: , l_sysdate
1026: , FND_GLOBAL.user_id
1027: , FND_GLOBAL.conc_login_id
1028: , DECODE(p_Item_Revision_rec.request_id, G_Miss_Num, NULL, p_Item_Revision_rec.request_id )

Line 1026: , FND_GLOBAL.user_id

1022: , DECODE(p_Item_Revision_rec.attribute15, G_Miss_Char, NULL, p_Item_Revision_rec.attribute15 )
1023: , l_sysdate
1024: , FND_GLOBAL.user_id
1025: , l_sysdate
1026: , FND_GLOBAL.user_id
1027: , FND_GLOBAL.conc_login_id
1028: , DECODE(p_Item_Revision_rec.request_id, G_Miss_Num, NULL, p_Item_Revision_rec.request_id )
1029: , DECODE(p_Item_Revision_rec.program_application_id, G_Miss_Num, NULL, p_Item_Revision_rec.program_application_id )
1030: , DECODE(p_Item_Revision_rec.program_id, G_Miss_Num, NULL, p_Item_Revision_rec.program_id )

Line 1027: , FND_GLOBAL.conc_login_id

1023: , l_sysdate
1024: , FND_GLOBAL.user_id
1025: , l_sysdate
1026: , FND_GLOBAL.user_id
1027: , FND_GLOBAL.conc_login_id
1028: , DECODE(p_Item_Revision_rec.request_id, G_Miss_Num, NULL, p_Item_Revision_rec.request_id )
1029: , DECODE(p_Item_Revision_rec.program_application_id, G_Miss_Num, NULL, p_Item_Revision_rec.program_application_id )
1030: , DECODE(p_Item_Revision_rec.program_id, G_Miss_Num, NULL, p_Item_Revision_rec.program_id )
1031: , DECODE(p_Item_Revision_rec.program_update_date, G_Miss_Date, NULL, p_Item_Revision_rec.program_update_date )

Line 1747: , last_updated_by = FND_GLOBAL.user_id

1743: , attribute13 = DECODE(p_Item_Revision_rec.attribute13, G_Miss_Char, null, null, attribute13, p_Item_Revision_rec.attribute13 )
1744: , attribute14 = DECODE(p_Item_Revision_rec.attribute14, G_Miss_Char, null, null, attribute14, p_Item_Revision_rec.attribute14 )
1745: , attribute15 = DECODE(p_Item_Revision_rec.attribute15, G_Miss_Char, null, null, attribute15, p_Item_Revision_rec.attribute15 )
1746: , last_update_date = l_sysdate
1747: , last_updated_by = FND_GLOBAL.user_id
1748: , last_update_login = FND_GLOBAL.conc_login_id
1749: , request_id = DECODE(p_Item_Revision_rec.request_id, G_Miss_Num, null, null, request_id, p_Item_Revision_rec.request_id )
1750: , 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 )
1751: , program_id = DECODE(p_Item_Revision_rec.program_id, G_Miss_Num, null, null, program_id, p_Item_Revision_rec.program_id )

Line 1748: , last_update_login = FND_GLOBAL.conc_login_id

1744: , attribute14 = DECODE(p_Item_Revision_rec.attribute14, G_Miss_Char, null, null, attribute14, p_Item_Revision_rec.attribute14 )
1745: , attribute15 = DECODE(p_Item_Revision_rec.attribute15, G_Miss_Char, null, null, attribute15, p_Item_Revision_rec.attribute15 )
1746: , last_update_date = l_sysdate
1747: , last_updated_by = FND_GLOBAL.user_id
1748: , last_update_login = FND_GLOBAL.conc_login_id
1749: , request_id = DECODE(p_Item_Revision_rec.request_id, G_Miss_Num, null, null, request_id, p_Item_Revision_rec.request_id )
1750: , 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 )
1751: , program_id = DECODE(p_Item_Revision_rec.program_id, G_Miss_Num, null, null, program_id, p_Item_Revision_rec.program_id )
1752: , 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 )