eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_STATUSES_PKG dependencies on FND_API

Line 57: If (v_project_status_code IS NULL) OR (v_project_status_code = FND_API.G_MISS_CHAR) then

53: IS
54: CURSOR C2 IS SELECT PA_PROJECT_STATUSES_S.nextval FROM sys.dual;
55: v_project_status_code VARCHAR2(30);
56: BEGIN
57: If (v_project_status_code IS NULL) OR (v_project_status_code = FND_API.G_MISS_CHAR) then
58: OPEN C2;
59: FETCH C2 INTO v_project_status_code;
60: CLOSE C2;
61: End If;

Line 101: decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, NULL, p_PROJECT_STATUS_NAME),

97: STATUS_TYPE,
98: NEXT_ALLOWABLE_STATUS_FLAG
99: ) VALUES (
100: v_project_status_code,
101: decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, NULL, p_PROJECT_STATUS_NAME),
102: decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PROJECT_SYSTEM_STATUS_CODE),
103: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
104: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
105: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),

Line 102: decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PROJECT_SYSTEM_STATUS_CODE),

98: NEXT_ALLOWABLE_STATUS_FLAG
99: ) VALUES (
100: v_project_status_code,
101: decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, NULL, p_PROJECT_STATUS_NAME),
102: decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PROJECT_SYSTEM_STATUS_CODE),
103: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
104: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
105: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
106: decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, NULL, p_PREDEFINED_FLAG),

Line 103: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),

99: ) VALUES (
100: v_project_status_code,
101: decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, NULL, p_PROJECT_STATUS_NAME),
102: decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PROJECT_SYSTEM_STATUS_CODE),
103: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
104: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
105: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
106: decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, NULL, p_PREDEFINED_FLAG),
107: decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_STARTING_STATUS_FLAG),

Line 104: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),

100: v_project_status_code,
101: decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, NULL, p_PROJECT_STATUS_NAME),
102: decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PROJECT_SYSTEM_STATUS_CODE),
103: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
104: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
105: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
106: decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, NULL, p_PREDEFINED_FLAG),
107: decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_STARTING_STATUS_FLAG),
108: decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLE_WF_FLAG),

Line 105: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),

101: decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, NULL, p_PROJECT_STATUS_NAME),
102: decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PROJECT_SYSTEM_STATUS_CODE),
103: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
104: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
105: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
106: decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, NULL, p_PREDEFINED_FLAG),
107: decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_STARTING_STATUS_FLAG),
108: decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLE_WF_FLAG),
109: decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_ITEM_TYPE),

Line 106: decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, NULL, p_PREDEFINED_FLAG),

102: decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PROJECT_SYSTEM_STATUS_CODE),
103: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
104: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
105: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
106: decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, NULL, p_PREDEFINED_FLAG),
107: decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_STARTING_STATUS_FLAG),
108: decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLE_WF_FLAG),
109: decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_ITEM_TYPE),
110: decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_PROCESS),

Line 107: decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_STARTING_STATUS_FLAG),

103: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
104: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
105: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
106: decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, NULL, p_PREDEFINED_FLAG),
107: decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_STARTING_STATUS_FLAG),
108: decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLE_WF_FLAG),
109: decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_ITEM_TYPE),
110: decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_PROCESS),
111: decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_SUCCESS_STATUS_CODE),

Line 108: decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLE_WF_FLAG),

104: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
105: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
106: decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, NULL, p_PREDEFINED_FLAG),
107: decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_STARTING_STATUS_FLAG),
108: decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLE_WF_FLAG),
109: decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_ITEM_TYPE),
110: decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_PROCESS),
111: decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_SUCCESS_STATUS_CODE),
112: decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_FAILURE_STATUS_CODE),

Line 109: decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_ITEM_TYPE),

105: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
106: decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, NULL, p_PREDEFINED_FLAG),
107: decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_STARTING_STATUS_FLAG),
108: decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLE_WF_FLAG),
109: decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_ITEM_TYPE),
110: decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_PROCESS),
111: decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_SUCCESS_STATUS_CODE),
112: decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_FAILURE_STATUS_CODE),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

Line 110: decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_PROCESS),

106: decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, NULL, p_PREDEFINED_FLAG),
107: decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_STARTING_STATUS_FLAG),
108: decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLE_WF_FLAG),
109: decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_ITEM_TYPE),
110: decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_PROCESS),
111: decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_SUCCESS_STATUS_CODE),
112: decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_FAILURE_STATUS_CODE),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

Line 111: decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_SUCCESS_STATUS_CODE),

107: decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_STARTING_STATUS_FLAG),
108: decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLE_WF_FLAG),
109: decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_ITEM_TYPE),
110: decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_PROCESS),
111: decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_SUCCESS_STATUS_CODE),
112: decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_FAILURE_STATUS_CODE),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

Line 112: decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_FAILURE_STATUS_CODE),

108: decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLE_WF_FLAG),
109: decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_ITEM_TYPE),
110: decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_PROCESS),
111: decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_SUCCESS_STATUS_CODE),
112: decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_FAILURE_STATUS_CODE),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

Line 113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

109: decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_ITEM_TYPE),
110: decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_PROCESS),
111: decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_SUCCESS_STATUS_CODE),
112: decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_FAILURE_STATUS_CODE),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

Line 114: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

110: decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, NULL, p_WORKFLOW_PROCESS),
111: decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_SUCCESS_STATUS_CODE),
112: decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_FAILURE_STATUS_CODE),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

Line 115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

111: decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_SUCCESS_STATUS_CODE),
112: decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_FAILURE_STATUS_CODE),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

Line 116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

112: decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WF_FAILURE_STATUS_CODE),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

Line 117: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

Line 118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

114: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

Line 119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

115: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

Line 120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

Line 121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

117: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

Line 122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

Line 123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

Line 124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

Line 125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

Line 126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

Line 127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

Line 128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

Line 129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

Line 130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_STATUS_TYPE),

Line 131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_STATUS_TYPE),
135: decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEXT_ALLOWABLE_STATUS_FLAG)

Line 132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_STATUS_TYPE),
135: decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEXT_ALLOWABLE_STATUS_FLAG)
136: );

Line 133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_STATUS_TYPE),
135: decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEXT_ALLOWABLE_STATUS_FLAG)
136: );
137: End Insert_Row;

Line 134: decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_STATUS_TYPE),

130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_STATUS_TYPE),
135: decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEXT_ALLOWABLE_STATUS_FLAG)
136: );
137: End Insert_Row;
138:

Line 135: decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEXT_ALLOWABLE_STATUS_FLAG)

131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, NULL, p_STATUS_TYPE),
135: decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEXT_ALLOWABLE_STATUS_FLAG)
136: );
137: End Insert_Row;
138:
139: PROCEDURE Update_Row(

Line 180: PROJECT_STATUS_NAME = decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, PROJECT_STATUS_NAME, p_PROJECT_STATUS_NAME),

176: IS
177: BEGIN
178: Update PA_PROJECT_STATUSES
179: SET
180: PROJECT_STATUS_NAME = decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, PROJECT_STATUS_NAME, p_PROJECT_STATUS_NAME),
181: PROJECT_SYSTEM_STATUS_CODE = decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, PROJECT_SYSTEM_STATUS_CODE, p_PROJECT_SYSTEM_STATUS_CODE),
182: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
183: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
184: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),

Line 181: PROJECT_SYSTEM_STATUS_CODE = decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, PROJECT_SYSTEM_STATUS_CODE, p_PROJECT_SYSTEM_STATUS_CODE),

177: BEGIN
178: Update PA_PROJECT_STATUSES
179: SET
180: PROJECT_STATUS_NAME = decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, PROJECT_STATUS_NAME, p_PROJECT_STATUS_NAME),
181: PROJECT_SYSTEM_STATUS_CODE = decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, PROJECT_SYSTEM_STATUS_CODE, p_PROJECT_SYSTEM_STATUS_CODE),
182: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
183: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
184: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
185: PREDEFINED_FLAG = decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, PREDEFINED_FLAG, p_PREDEFINED_FLAG),

Line 182: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),

178: Update PA_PROJECT_STATUSES
179: SET
180: PROJECT_STATUS_NAME = decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, PROJECT_STATUS_NAME, p_PROJECT_STATUS_NAME),
181: PROJECT_SYSTEM_STATUS_CODE = decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, PROJECT_SYSTEM_STATUS_CODE, p_PROJECT_SYSTEM_STATUS_CODE),
182: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
183: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
184: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
185: PREDEFINED_FLAG = decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, PREDEFINED_FLAG, p_PREDEFINED_FLAG),
186: STARTING_STATUS_FLAG = decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, STARTING_STATUS_FLAG, p_STARTING_STATUS_FLAG),

Line 183: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),

179: SET
180: PROJECT_STATUS_NAME = decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, PROJECT_STATUS_NAME, p_PROJECT_STATUS_NAME),
181: PROJECT_SYSTEM_STATUS_CODE = decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, PROJECT_SYSTEM_STATUS_CODE, p_PROJECT_SYSTEM_STATUS_CODE),
182: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
183: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
184: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
185: PREDEFINED_FLAG = decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, PREDEFINED_FLAG, p_PREDEFINED_FLAG),
186: STARTING_STATUS_FLAG = decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, STARTING_STATUS_FLAG, p_STARTING_STATUS_FLAG),
187: ENABLE_WF_FLAG = decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, ENABLE_WF_FLAG, p_ENABLE_WF_FLAG),

Line 184: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),

180: PROJECT_STATUS_NAME = decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, PROJECT_STATUS_NAME, p_PROJECT_STATUS_NAME),
181: PROJECT_SYSTEM_STATUS_CODE = decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, PROJECT_SYSTEM_STATUS_CODE, p_PROJECT_SYSTEM_STATUS_CODE),
182: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
183: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
184: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
185: PREDEFINED_FLAG = decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, PREDEFINED_FLAG, p_PREDEFINED_FLAG),
186: STARTING_STATUS_FLAG = decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, STARTING_STATUS_FLAG, p_STARTING_STATUS_FLAG),
187: ENABLE_WF_FLAG = decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, ENABLE_WF_FLAG, p_ENABLE_WF_FLAG),
188: WORKFLOW_ITEM_TYPE = decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, WORKFLOW_ITEM_TYPE, p_WORKFLOW_ITEM_TYPE),

Line 185: PREDEFINED_FLAG = decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, PREDEFINED_FLAG, p_PREDEFINED_FLAG),

181: PROJECT_SYSTEM_STATUS_CODE = decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, PROJECT_SYSTEM_STATUS_CODE, p_PROJECT_SYSTEM_STATUS_CODE),
182: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
183: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
184: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
185: PREDEFINED_FLAG = decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, PREDEFINED_FLAG, p_PREDEFINED_FLAG),
186: STARTING_STATUS_FLAG = decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, STARTING_STATUS_FLAG, p_STARTING_STATUS_FLAG),
187: ENABLE_WF_FLAG = decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, ENABLE_WF_FLAG, p_ENABLE_WF_FLAG),
188: WORKFLOW_ITEM_TYPE = decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, WORKFLOW_ITEM_TYPE, p_WORKFLOW_ITEM_TYPE),
189: WORKFLOW_PROCESS = decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, WORKFLOW_PROCESS, p_WORKFLOW_PROCESS),

Line 186: STARTING_STATUS_FLAG = decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, STARTING_STATUS_FLAG, p_STARTING_STATUS_FLAG),

182: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
183: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
184: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
185: PREDEFINED_FLAG = decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, PREDEFINED_FLAG, p_PREDEFINED_FLAG),
186: STARTING_STATUS_FLAG = decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, STARTING_STATUS_FLAG, p_STARTING_STATUS_FLAG),
187: ENABLE_WF_FLAG = decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, ENABLE_WF_FLAG, p_ENABLE_WF_FLAG),
188: WORKFLOW_ITEM_TYPE = decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, WORKFLOW_ITEM_TYPE, p_WORKFLOW_ITEM_TYPE),
189: WORKFLOW_PROCESS = decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, WORKFLOW_PROCESS, p_WORKFLOW_PROCESS),
190: WF_SUCCESS_STATUS_CODE = decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, WF_SUCCESS_STATUS_CODE, p_WF_SUCCESS_STATUS_CODE),

Line 187: ENABLE_WF_FLAG = decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, ENABLE_WF_FLAG, p_ENABLE_WF_FLAG),

183: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
184: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
185: PREDEFINED_FLAG = decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, PREDEFINED_FLAG, p_PREDEFINED_FLAG),
186: STARTING_STATUS_FLAG = decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, STARTING_STATUS_FLAG, p_STARTING_STATUS_FLAG),
187: ENABLE_WF_FLAG = decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, ENABLE_WF_FLAG, p_ENABLE_WF_FLAG),
188: WORKFLOW_ITEM_TYPE = decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, WORKFLOW_ITEM_TYPE, p_WORKFLOW_ITEM_TYPE),
189: WORKFLOW_PROCESS = decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, WORKFLOW_PROCESS, p_WORKFLOW_PROCESS),
190: WF_SUCCESS_STATUS_CODE = decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, WF_SUCCESS_STATUS_CODE, p_WF_SUCCESS_STATUS_CODE),
191: WF_FAILURE_STATUS_CODE = decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, WF_FAILURE_STATUS_CODE, p_WF_FAILURE_STATUS_CODE),

Line 188: WORKFLOW_ITEM_TYPE = decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, WORKFLOW_ITEM_TYPE, p_WORKFLOW_ITEM_TYPE),

184: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
185: PREDEFINED_FLAG = decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, PREDEFINED_FLAG, p_PREDEFINED_FLAG),
186: STARTING_STATUS_FLAG = decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, STARTING_STATUS_FLAG, p_STARTING_STATUS_FLAG),
187: ENABLE_WF_FLAG = decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, ENABLE_WF_FLAG, p_ENABLE_WF_FLAG),
188: WORKFLOW_ITEM_TYPE = decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, WORKFLOW_ITEM_TYPE, p_WORKFLOW_ITEM_TYPE),
189: WORKFLOW_PROCESS = decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, WORKFLOW_PROCESS, p_WORKFLOW_PROCESS),
190: WF_SUCCESS_STATUS_CODE = decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, WF_SUCCESS_STATUS_CODE, p_WF_SUCCESS_STATUS_CODE),
191: WF_FAILURE_STATUS_CODE = decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, WF_FAILURE_STATUS_CODE, p_WF_FAILURE_STATUS_CODE),
192: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 189: WORKFLOW_PROCESS = decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, WORKFLOW_PROCESS, p_WORKFLOW_PROCESS),

185: PREDEFINED_FLAG = decode( p_PREDEFINED_FLAG, FND_API.G_MISS_CHAR, PREDEFINED_FLAG, p_PREDEFINED_FLAG),
186: STARTING_STATUS_FLAG = decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, STARTING_STATUS_FLAG, p_STARTING_STATUS_FLAG),
187: ENABLE_WF_FLAG = decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, ENABLE_WF_FLAG, p_ENABLE_WF_FLAG),
188: WORKFLOW_ITEM_TYPE = decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, WORKFLOW_ITEM_TYPE, p_WORKFLOW_ITEM_TYPE),
189: WORKFLOW_PROCESS = decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, WORKFLOW_PROCESS, p_WORKFLOW_PROCESS),
190: WF_SUCCESS_STATUS_CODE = decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, WF_SUCCESS_STATUS_CODE, p_WF_SUCCESS_STATUS_CODE),
191: WF_FAILURE_STATUS_CODE = decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, WF_FAILURE_STATUS_CODE, p_WF_FAILURE_STATUS_CODE),
192: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
193: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_CHAR, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 190: WF_SUCCESS_STATUS_CODE = decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, WF_SUCCESS_STATUS_CODE, p_WF_SUCCESS_STATUS_CODE),

186: STARTING_STATUS_FLAG = decode( p_STARTING_STATUS_FLAG, FND_API.G_MISS_CHAR, STARTING_STATUS_FLAG, p_STARTING_STATUS_FLAG),
187: ENABLE_WF_FLAG = decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, ENABLE_WF_FLAG, p_ENABLE_WF_FLAG),
188: WORKFLOW_ITEM_TYPE = decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, WORKFLOW_ITEM_TYPE, p_WORKFLOW_ITEM_TYPE),
189: WORKFLOW_PROCESS = decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, WORKFLOW_PROCESS, p_WORKFLOW_PROCESS),
190: WF_SUCCESS_STATUS_CODE = decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, WF_SUCCESS_STATUS_CODE, p_WF_SUCCESS_STATUS_CODE),
191: WF_FAILURE_STATUS_CODE = decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, WF_FAILURE_STATUS_CODE, p_WF_FAILURE_STATUS_CODE),
192: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
193: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_CHAR, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
194: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 191: WF_FAILURE_STATUS_CODE = decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, WF_FAILURE_STATUS_CODE, p_WF_FAILURE_STATUS_CODE),

187: ENABLE_WF_FLAG = decode( p_ENABLE_WF_FLAG, FND_API.G_MISS_CHAR, ENABLE_WF_FLAG, p_ENABLE_WF_FLAG),
188: WORKFLOW_ITEM_TYPE = decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, WORKFLOW_ITEM_TYPE, p_WORKFLOW_ITEM_TYPE),
189: WORKFLOW_PROCESS = decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, WORKFLOW_PROCESS, p_WORKFLOW_PROCESS),
190: WF_SUCCESS_STATUS_CODE = decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, WF_SUCCESS_STATUS_CODE, p_WF_SUCCESS_STATUS_CODE),
191: WF_FAILURE_STATUS_CODE = decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, WF_FAILURE_STATUS_CODE, p_WF_FAILURE_STATUS_CODE),
192: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
193: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_CHAR, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
194: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
195: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

Line 192: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

188: WORKFLOW_ITEM_TYPE = decode( p_WORKFLOW_ITEM_TYPE, FND_API.G_MISS_CHAR, WORKFLOW_ITEM_TYPE, p_WORKFLOW_ITEM_TYPE),
189: WORKFLOW_PROCESS = decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, WORKFLOW_PROCESS, p_WORKFLOW_PROCESS),
190: WF_SUCCESS_STATUS_CODE = decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, WF_SUCCESS_STATUS_CODE, p_WF_SUCCESS_STATUS_CODE),
191: WF_FAILURE_STATUS_CODE = decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, WF_FAILURE_STATUS_CODE, p_WF_FAILURE_STATUS_CODE),
192: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
193: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_CHAR, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
194: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
195: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
196: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

Line 193: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_CHAR, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

189: WORKFLOW_PROCESS = decode( p_WORKFLOW_PROCESS, FND_API.G_MISS_CHAR, WORKFLOW_PROCESS, p_WORKFLOW_PROCESS),
190: WF_SUCCESS_STATUS_CODE = decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, WF_SUCCESS_STATUS_CODE, p_WF_SUCCESS_STATUS_CODE),
191: WF_FAILURE_STATUS_CODE = decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, WF_FAILURE_STATUS_CODE, p_WF_FAILURE_STATUS_CODE),
192: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
193: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_CHAR, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
194: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
195: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
196: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
197: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

Line 194: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

190: WF_SUCCESS_STATUS_CODE = decode( p_WF_SUCCESS_STATUS_CODE, FND_API.G_MISS_CHAR, WF_SUCCESS_STATUS_CODE, p_WF_SUCCESS_STATUS_CODE),
191: WF_FAILURE_STATUS_CODE = decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, WF_FAILURE_STATUS_CODE, p_WF_FAILURE_STATUS_CODE),
192: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
193: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_CHAR, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
194: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
195: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
196: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
197: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
198: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

Line 195: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

191: WF_FAILURE_STATUS_CODE = decode( p_WF_FAILURE_STATUS_CODE, FND_API.G_MISS_CHAR, WF_FAILURE_STATUS_CODE, p_WF_FAILURE_STATUS_CODE),
192: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
193: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_CHAR, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
194: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
195: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
196: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
197: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
198: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
199: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

Line 196: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

192: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
193: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_CHAR, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
194: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
195: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
196: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
197: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
198: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
199: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
200: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

Line 197: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

193: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_CHAR, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
194: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
195: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
196: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
197: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
198: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
199: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
200: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
201: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

Line 198: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

194: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
195: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
196: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
197: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
198: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
199: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
200: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
201: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
202: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

Line 199: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

195: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
196: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
197: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
198: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
199: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
200: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
201: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
202: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
203: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

Line 200: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

196: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
197: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
198: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
199: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
200: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
201: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
202: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
203: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
204: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

Line 201: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

197: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
198: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
199: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
200: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
201: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
202: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
203: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
204: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
205: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

Line 202: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

198: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
199: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
200: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
201: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
202: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
203: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
204: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
205: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
206: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

Line 203: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

199: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
200: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
201: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
202: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
203: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
204: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
205: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
206: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
207: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

Line 204: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

200: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
201: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
202: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
203: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
204: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
205: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
206: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
207: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
208: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

Line 205: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

201: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
202: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
203: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
204: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
205: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
206: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
207: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
208: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
209: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

Line 206: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

202: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
203: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
204: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
205: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
206: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
207: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
208: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
209: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
210: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

Line 207: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

203: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
204: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
205: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
206: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
207: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
208: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
209: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
210: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
211: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

Line 208: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

204: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
205: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
206: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
207: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
208: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
209: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
210: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
211: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
212: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

Line 209: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

205: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
206: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
207: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
208: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
209: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
210: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
211: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
212: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
213: STATUS_TYPE = decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, STATUS_TYPE, p_STATUS_TYPE),

Line 210: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

206: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
207: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
208: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
209: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
210: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
211: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
212: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
213: STATUS_TYPE = decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, STATUS_TYPE, p_STATUS_TYPE),
214: NEXT_ALLOWABLE_STATUS_FLAG = decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NEXT_ALLOWABLE_STATUS_FLAG, p_NEXT_ALLOWABLE_STATUS_FLAG)

Line 211: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

207: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
208: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
209: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
210: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
211: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
212: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
213: STATUS_TYPE = decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, STATUS_TYPE, p_STATUS_TYPE),
214: NEXT_ALLOWABLE_STATUS_FLAG = decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NEXT_ALLOWABLE_STATUS_FLAG, p_NEXT_ALLOWABLE_STATUS_FLAG)
215: where PROJECT_STATUS_CODE = p_PROJECT_STATUS_CODE;

Line 212: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

208: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
209: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
210: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
211: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
212: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
213: STATUS_TYPE = decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, STATUS_TYPE, p_STATUS_TYPE),
214: NEXT_ALLOWABLE_STATUS_FLAG = decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NEXT_ALLOWABLE_STATUS_FLAG, p_NEXT_ALLOWABLE_STATUS_FLAG)
215: where PROJECT_STATUS_CODE = p_PROJECT_STATUS_CODE;
216:

Line 213: STATUS_TYPE = decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, STATUS_TYPE, p_STATUS_TYPE),

209: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
210: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
211: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
212: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
213: STATUS_TYPE = decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, STATUS_TYPE, p_STATUS_TYPE),
214: NEXT_ALLOWABLE_STATUS_FLAG = decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NEXT_ALLOWABLE_STATUS_FLAG, p_NEXT_ALLOWABLE_STATUS_FLAG)
215: where PROJECT_STATUS_CODE = p_PROJECT_STATUS_CODE;
216:
217: If (SQL%NOTFOUND) then

Line 214: NEXT_ALLOWABLE_STATUS_FLAG = decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NEXT_ALLOWABLE_STATUS_FLAG, p_NEXT_ALLOWABLE_STATUS_FLAG)

210: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
211: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
212: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
213: STATUS_TYPE = decode( p_STATUS_TYPE, FND_API.G_MISS_CHAR, STATUS_TYPE, p_STATUS_TYPE),
214: NEXT_ALLOWABLE_STATUS_FLAG = decode( p_NEXT_ALLOWABLE_STATUS_FLAG, FND_API.G_MISS_CHAR, NEXT_ALLOWABLE_STATUS_FLAG, p_NEXT_ALLOWABLE_STATUS_FLAG)
215: where PROJECT_STATUS_CODE = p_PROJECT_STATUS_CODE;
216:
217: If (SQL%NOTFOUND) then
218: RAISE NO_DATA_FOUND;