DBA Data[Home] [Help]

APPS.IBC_ASSOCIATIONS_PKG dependencies on FND_GLOBAL

Line 81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)

77: ,DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val4)
78: ,DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val5)
79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)
80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)
82: ,DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
83: ,DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
84: ,DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
85: );

Line 83: ,DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)

79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)
80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)
82: ,DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
83: ,DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
84: ,DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
85: );
86:
87:

Line 84: ,DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)

80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)
82: ,DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
83: ,DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
84: ,DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
85: );
86:
87:
88:

Line 129: ,last_updated_by = DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)

125: ,associated_object_val2 = DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val2,p_associated_object_val2)
126: ,associated_object_val3 = DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val3,p_associated_object_val3)
127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)
128: ,associated_object_val5 = DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val5,p_associated_object_val5)
129: ,last_updated_by = DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
130: ,last_update_date = DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
131: ,last_update_login = DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
132: ,object_version_number = object_version_number + 1
133: WHERE association_id = p_association_id

Line 131: ,last_update_login = DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)

127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)
128: ,associated_object_val5 = DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val5,p_associated_object_val5)
129: ,last_updated_by = DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
130: ,last_update_date = DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
131: ,last_update_login = DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
132: ,object_version_number = object_version_number + 1
133: WHERE association_id = p_association_id
134: AND object_version_number = DECODE(p_object_version_number,
135: Fnd_Api.g_miss_num,