DBA Data[Home] [Help]

APPS.OZF_REASON_PVT dependencies on FND_GLOBAL

Line 72: IF FND_GLOBAL.User_Id IS NULL

68:
69: -- ******************************************************************
70: -- Validate Environment
71: -- ******************************************************************
72: IF FND_GLOBAL.User_Id IS NULL
73: THEN
74: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
75: THEN
76: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');

Line 119: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

115: OZF_reason_codes_All_PKG.Insert_Row(
116: px_REASON_CODE_ID => l_REASON_CODE_ID,
117: px_OBJECT_VERSION_NUMBER => l_object_version_number,
118: p_LAST_UPDATE_DATE => SYSDATE,
119: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
120: p_CREATION_DATE => SYSDATE,
121: p_CREATED_BY => FND_GLOBAL.USER_ID,
122: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
123: p_REASON_CODE => p_reason_rec.REASON_CODE,

Line 121: p_CREATED_BY => FND_GLOBAL.USER_ID,

117: px_OBJECT_VERSION_NUMBER => l_object_version_number,
118: p_LAST_UPDATE_DATE => SYSDATE,
119: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
120: p_CREATION_DATE => SYSDATE,
121: p_CREATED_BY => FND_GLOBAL.USER_ID,
122: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
123: p_REASON_CODE => p_reason_rec.REASON_CODE,
124: p_START_DATE_ACTIVE => p_reason_rec.START_DATE_ACTIVE,
125: p_END_DATE_ACTIVE => p_reason_rec.END_DATE_ACTIVE,

Line 122: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

118: p_LAST_UPDATE_DATE => SYSDATE,
119: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
120: p_CREATION_DATE => SYSDATE,
121: p_CREATED_BY => FND_GLOBAL.USER_ID,
122: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
123: p_REASON_CODE => p_reason_rec.REASON_CODE,
124: p_START_DATE_ACTIVE => p_reason_rec.START_DATE_ACTIVE,
125: p_END_DATE_ACTIVE => p_reason_rec.END_DATE_ACTIVE,
126: p_ATTRIBUTE_CATEGORY => p_reason_rec.ATTRIBUTE_CATEGORY,

Line 433: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

429: OZF_reason_codes_All_PKG.Update_Row(
430: p_REASON_CODE_ID => l_reason_rec.REASON_CODE_ID,
431: p_OBJECT_VERSION_NUMBER => l_object_version_number,
432: p_LAST_UPDATE_DATE => SYSDATE,
433: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
434: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
435: p_REASON_CODE => l_reason_rec.REASON_CODE,
436: p_START_DATE_ACTIVE => l_reason_rec.START_DATE_ACTIVE,
437: p_END_DATE_ACTIVE => l_reason_rec.END_DATE_ACTIVE,

Line 434: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

430: p_REASON_CODE_ID => l_reason_rec.REASON_CODE_ID,
431: p_OBJECT_VERSION_NUMBER => l_object_version_number,
432: p_LAST_UPDATE_DATE => SYSDATE,
433: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
434: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
435: p_REASON_CODE => l_reason_rec.REASON_CODE,
436: p_START_DATE_ACTIVE => l_reason_rec.START_DATE_ACTIVE,
437: p_END_DATE_ACTIVE => l_reason_rec.END_DATE_ACTIVE,
438: p_ATTRIBUTE_CATEGORY => l_reason_rec.ATTRIBUTE_CATEGORY,

Line 808: FND_GLOBAL.USER_ID,

804: ) VALUES (
805: l_reason_type_id,
806: l_object_version_number,
807: SYSDATE,
808: FND_GLOBAL.USER_ID,
809: SYSDATE,
810: FND_GLOBAL.USER_ID,
811: FND_GLOBAL.CONC_LOGIN_ID,
812: p_action_tbl(i).reason_code_id,

Line 810: FND_GLOBAL.USER_ID,

806: l_object_version_number,
807: SYSDATE,
808: FND_GLOBAL.USER_ID,
809: SYSDATE,
810: FND_GLOBAL.USER_ID,
811: FND_GLOBAL.CONC_LOGIN_ID,
812: p_action_tbl(i).reason_code_id,
813: l_task_template_group_id,
814: l_active_flag,

Line 811: FND_GLOBAL.CONC_LOGIN_ID,

807: SYSDATE,
808: FND_GLOBAL.USER_ID,
809: SYSDATE,
810: FND_GLOBAL.USER_ID,
811: FND_GLOBAL.CONC_LOGIN_ID,
812: p_action_tbl(i).reason_code_id,
813: l_task_template_group_id,
814: l_active_flag,
815: l_default_flag

Line 858: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID

854: BEGIN
855: UPDATE ozf_reasons
856: SET OBJECT_VERSION_NUMBER = l_object_version_number
857: , LAST_UPDATE_DATE = SYSDATE
858: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
859: , LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
860: , REASON_CODE_ID = p_action_tbl(i).reason_code_id
861: , TASK_TEMPLATE_GROUP_ID= p_action_tbl(i).task_template_group_id
862: , ACTIVE_FLAG = p_action_tbl(i).active_flag

Line 859: , LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

855: UPDATE ozf_reasons
856: SET OBJECT_VERSION_NUMBER = l_object_version_number
857: , LAST_UPDATE_DATE = SYSDATE
858: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
859: , LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
860: , REASON_CODE_ID = p_action_tbl(i).reason_code_id
861: , TASK_TEMPLATE_GROUP_ID= p_action_tbl(i).task_template_group_id
862: , ACTIVE_FLAG = p_action_tbl(i).active_flag
863: , default_flag = p_action_tbl(i).default_flag