DBA Data[Home] [Help]

APPS.PA_RES_AVL_PVT dependencies on FND_GLOBAL

Line 43: ,fnd_global.user_id

39: ,P_RECORD_TYPE
40: ,P_PERCENT
41: ,P_HOURS
42: ,sysdate
43: ,fnd_global.user_id
44: ,sysdate
45: ,fnd_global.user_id
46: ,fnd_global.login_id
47: )

Line 45: ,fnd_global.user_id

41: ,P_HOURS
42: ,sysdate
43: ,fnd_global.user_id
44: ,sysdate
45: ,fnd_global.user_id
46: ,fnd_global.login_id
47: )
48: RETURNING rowid INTO X_ROW_ID;
49:

Line 46: ,fnd_global.login_id

42: ,sysdate
43: ,fnd_global.user_id
44: ,sysdate
45: ,fnd_global.user_id
46: ,fnd_global.login_id
47: )
48: RETURNING rowid INTO X_ROW_ID;
49:
50: EXCEPTION

Line 84: ,LAST_UPDATED_BY = fnd_global.user_id

80: set END_DATE = DECODE(p_end_date, FND_API.G_MISS_DATE, END_DATE, p_end_date)
81: ,PERCENT = DECODE(p_percent, FND_API.G_MISS_NUM, PERCENT, p_percent)
82: ,HOURS = DECODE(p_hours, FND_API.G_MISS_NUM, HOURS, p_hours)
83: ,LAST_UPDATE_DATE = sysdate
84: ,LAST_UPDATED_BY = fnd_global.user_id
85: ,LAST_UPDATE_LOGIN = fnd_global.login_id
86: where
87: RESOURCE_ID = p_resource_id
88: and START_DATE = p_start_date

Line 85: ,LAST_UPDATE_LOGIN = fnd_global.login_id

81: ,PERCENT = DECODE(p_percent, FND_API.G_MISS_NUM, PERCENT, p_percent)
82: ,HOURS = DECODE(p_hours, FND_API.G_MISS_NUM, HOURS, p_hours)
83: ,LAST_UPDATE_DATE = sysdate
84: ,LAST_UPDATED_BY = fnd_global.user_id
85: ,LAST_UPDATE_LOGIN = fnd_global.login_id
86: where
87: RESOURCE_ID = p_resource_id
88: and START_DATE = p_start_date
89: and RECORD_TYPE = p_record_type;