DBA Data[Home] [Help]

APPS.FTE_CARRIER_RANK_LIST_PVT dependencies on FND_GLOBAL

Line 135: last_updated_by = FND_GLOBAL.USER_ID,

131: ATTRIBUTE15 = decode(p_rank_info_rec.ATTRIBUTE15,NULL,ATTRIBUTE15,
132: FND_API.G_MISS_CHAR,NULL,
133: p_rank_info_rec.ATTRIBUTE15),
134: last_update_date = SYSDATE,
135: last_updated_by = FND_GLOBAL.USER_ID,
136: last_update_login = FND_GLOBAL.USER_ID
137: WHERE rank_id = p_rank_info_rec.rank_id;
138:
139: IF (SQL%NOTFOUND) THEN

Line 136: last_update_login = FND_GLOBAL.USER_ID

132: FND_API.G_MISS_CHAR,NULL,
133: p_rank_info_rec.ATTRIBUTE15),
134: last_update_date = SYSDATE,
135: last_updated_by = FND_GLOBAL.USER_ID,
136: last_update_login = FND_GLOBAL.USER_ID
137: WHERE rank_id = p_rank_info_rec.rank_id;
138:
139: IF (SQL%NOTFOUND) THEN
140: RAISE no_data_found;

Line 700: decode(p_rank_info_rec.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_rank_info_rec.created_by),

696: decode(p_rank_info_rec.ATTRIBUTE14,FND_API.G_MISS_CHAR,NULL,p_rank_info_rec.ATTRIBUTE14),
697: decode(p_rank_info_rec.ATTRIBUTE15,FND_API.G_MISS_CHAR,NULL,p_rank_info_rec.ATTRIBUTE15),
698:
699: decode(p_rank_info_rec.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_rank_info_rec.creation_date),
700: decode(p_rank_info_rec.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_rank_info_rec.created_by),
701: decode(p_rank_info_rec.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_rank_info_rec.last_update_date),
702: decode(p_rank_info_rec.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_rank_info_rec.last_updated_by),
703: decode(p_rank_info_rec.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_rank_info_rec.last_update_login)
704: );

Line 702: decode(p_rank_info_rec.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_rank_info_rec.last_updated_by),

698:
699: decode(p_rank_info_rec.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_rank_info_rec.creation_date),
700: decode(p_rank_info_rec.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_rank_info_rec.created_by),
701: decode(p_rank_info_rec.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_rank_info_rec.last_update_date),
702: decode(p_rank_info_rec.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_rank_info_rec.last_updated_by),
703: decode(p_rank_info_rec.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_rank_info_rec.last_update_login)
704: );
705:
706: IF l_debug_on THEN

Line 703: decode(p_rank_info_rec.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_rank_info_rec.last_update_login)

699: decode(p_rank_info_rec.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_rank_info_rec.creation_date),
700: decode(p_rank_info_rec.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_rank_info_rec.created_by),
701: decode(p_rank_info_rec.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_rank_info_rec.last_update_date),
702: decode(p_rank_info_rec.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_rank_info_rec.last_updated_by),
703: decode(p_rank_info_rec.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_rank_info_rec.last_update_login)
704: );
705:
706: IF l_debug_on THEN
707: WSH_DEBUG_SV.pop(l_module_name);

Line 3464: FND_GLOBAL.USER_ID,

3460: decode(l_temp_table.ATTRIBUTE13(i),FND_API.G_MISS_CHAR,NULL,l_temp_table.ATTRIBUTE13(i)),
3461: decode(l_temp_table.ATTRIBUTE14(i),FND_API.G_MISS_CHAR,NULL,l_temp_table.ATTRIBUTE14(i)),
3462: decode(l_temp_table.ATTRIBUTE15(i),FND_API.G_MISS_CHAR,NULL,l_temp_table.ATTRIBUTE15(i)),
3463: SYSDATE,
3464: FND_GLOBAL.USER_ID,
3465: SYSDATE,
3466: FND_GLOBAL.USER_ID,
3467: FND_GLOBAL.USER_ID
3468: );

Line 3466: FND_GLOBAL.USER_ID,

3462: decode(l_temp_table.ATTRIBUTE15(i),FND_API.G_MISS_CHAR,NULL,l_temp_table.ATTRIBUTE15(i)),
3463: SYSDATE,
3464: FND_GLOBAL.USER_ID,
3465: SYSDATE,
3466: FND_GLOBAL.USER_ID,
3467: FND_GLOBAL.USER_ID
3468: );
3469:
3470: IF l_debug_on

Line 3467: FND_GLOBAL.USER_ID

3463: SYSDATE,
3464: FND_GLOBAL.USER_ID,
3465: SYSDATE,
3466: FND_GLOBAL.USER_ID,
3467: FND_GLOBAL.USER_ID
3468: );
3469:
3470: IF l_debug_on
3471: THEN