DBA Data[Home] [Help]

APPS.PA_PROJ_PROGRESS_ATTR_PKG dependencies on PA_INTERFACE_UTILS_PUB

Line 109: OBJECT_TYPE = DECODE( X_OBJECT_TYPE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

105:
106: BEGIN
107: UPDATE PA_PROJ_PROGRESS_ATTR
108: SET
109: OBJECT_TYPE = DECODE( X_OBJECT_TYPE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
110: OBJECT_TYPE, X_OBJECT_TYPE )
111: ,OBJECT_ID = DECODE( X_OBJECT_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
112: OBJECT_ID, X_OBJECT_ID )
113: ,LAST_UPDATE_DATE = X_LAST_UPDATE_DATE

Line 111: ,OBJECT_ID = DECODE( X_OBJECT_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

107: UPDATE PA_PROJ_PROGRESS_ATTR
108: SET
109: OBJECT_TYPE = DECODE( X_OBJECT_TYPE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
110: OBJECT_TYPE, X_OBJECT_TYPE )
111: ,OBJECT_ID = DECODE( X_OBJECT_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
112: OBJECT_ID, X_OBJECT_ID )
113: ,LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
114: ,LAST_UPDATED_BY = X_LAST_UPDATED_BY
115: ,LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 116: ,PROJECT_ID = DECODE( X_PROJECT_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

112: OBJECT_ID, X_OBJECT_ID )
113: ,LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
114: ,LAST_UPDATED_BY = X_LAST_UPDATED_BY
115: ,LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
116: ,PROJECT_ID = DECODE( X_PROJECT_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
117: PROJECT_ID, X_PROJECT_ID )
118: ,PROGRESS_CYCLE_ID = DECODE( X_PROGRESS_CYCLE_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
119: PROGRESS_CYCLE_ID, X_PROGRESS_CYCLE_ID )
120: ,WQ_ENABLE_FLAG = DECODE( X_WQ_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 118: ,PROGRESS_CYCLE_ID = DECODE( X_PROGRESS_CYCLE_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

114: ,LAST_UPDATED_BY = X_LAST_UPDATED_BY
115: ,LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
116: ,PROJECT_ID = DECODE( X_PROJECT_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
117: PROJECT_ID, X_PROJECT_ID )
118: ,PROGRESS_CYCLE_ID = DECODE( X_PROGRESS_CYCLE_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
119: PROGRESS_CYCLE_ID, X_PROGRESS_CYCLE_ID )
120: ,WQ_ENABLE_FLAG = DECODE( X_WQ_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
121: WQ_ENABLE_FLAG, X_WQ_ENABLE_FLAG )
122: ,REMAIN_EFFORT_ENABLE_FLAG = DECODE( X_REMAIN_EFFORT_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 120: ,WQ_ENABLE_FLAG = DECODE( X_WQ_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

116: ,PROJECT_ID = DECODE( X_PROJECT_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
117: PROJECT_ID, X_PROJECT_ID )
118: ,PROGRESS_CYCLE_ID = DECODE( X_PROGRESS_CYCLE_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
119: PROGRESS_CYCLE_ID, X_PROGRESS_CYCLE_ID )
120: ,WQ_ENABLE_FLAG = DECODE( X_WQ_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
121: WQ_ENABLE_FLAG, X_WQ_ENABLE_FLAG )
122: ,REMAIN_EFFORT_ENABLE_FLAG = DECODE( X_REMAIN_EFFORT_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
123: REMAIN_EFFORT_ENABLE_FLAG, X_REMAIN_EFFORT_ENABLE_FLAG )
124: ,PERCENT_COMP_ENABLE_FLAG = DECODE( X_PERCENT_COMP_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 122: ,REMAIN_EFFORT_ENABLE_FLAG = DECODE( X_REMAIN_EFFORT_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

118: ,PROGRESS_CYCLE_ID = DECODE( X_PROGRESS_CYCLE_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
119: PROGRESS_CYCLE_ID, X_PROGRESS_CYCLE_ID )
120: ,WQ_ENABLE_FLAG = DECODE( X_WQ_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
121: WQ_ENABLE_FLAG, X_WQ_ENABLE_FLAG )
122: ,REMAIN_EFFORT_ENABLE_FLAG = DECODE( X_REMAIN_EFFORT_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
123: REMAIN_EFFORT_ENABLE_FLAG, X_REMAIN_EFFORT_ENABLE_FLAG )
124: ,PERCENT_COMP_ENABLE_FLAG = DECODE( X_PERCENT_COMP_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
125: PERCENT_COMP_ENABLE_FLAG, X_PERCENT_COMP_ENABLE_FLAG )
126: ,NEXT_PROGRESS_UPDATE_DATE = DECODE( X_NEXT_PROGRESS_UPDATE_DATE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 124: ,PERCENT_COMP_ENABLE_FLAG = DECODE( X_PERCENT_COMP_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

120: ,WQ_ENABLE_FLAG = DECODE( X_WQ_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
121: WQ_ENABLE_FLAG, X_WQ_ENABLE_FLAG )
122: ,REMAIN_EFFORT_ENABLE_FLAG = DECODE( X_REMAIN_EFFORT_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
123: REMAIN_EFFORT_ENABLE_FLAG, X_REMAIN_EFFORT_ENABLE_FLAG )
124: ,PERCENT_COMP_ENABLE_FLAG = DECODE( X_PERCENT_COMP_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
125: PERCENT_COMP_ENABLE_FLAG, X_PERCENT_COMP_ENABLE_FLAG )
126: ,NEXT_PROGRESS_UPDATE_DATE = DECODE( X_NEXT_PROGRESS_UPDATE_DATE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
127: NEXT_PROGRESS_UPDATE_DATE, X_NEXT_PROGRESS_UPDATE_DATE )
128: ,record_version_number = NVL( record_version_number, 1 ) + 1

Line 126: ,NEXT_PROGRESS_UPDATE_DATE = DECODE( X_NEXT_PROGRESS_UPDATE_DATE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

122: ,REMAIN_EFFORT_ENABLE_FLAG = DECODE( X_REMAIN_EFFORT_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
123: REMAIN_EFFORT_ENABLE_FLAG, X_REMAIN_EFFORT_ENABLE_FLAG )
124: ,PERCENT_COMP_ENABLE_FLAG = DECODE( X_PERCENT_COMP_ENABLE_FLAG, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
125: PERCENT_COMP_ENABLE_FLAG, X_PERCENT_COMP_ENABLE_FLAG )
126: ,NEXT_PROGRESS_UPDATE_DATE = DECODE( X_NEXT_PROGRESS_UPDATE_DATE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
127: NEXT_PROGRESS_UPDATE_DATE, X_NEXT_PROGRESS_UPDATE_DATE )
128: ,record_version_number = NVL( record_version_number, 1 ) + 1
129: ,TASK_WEIGHT_BASIS_CODE = DECODE(X_TASK_WEIGHT_BASIS_CODE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
130: TASK_WEIGHT_BASIS_CODE, X_TASK_WEIGHT_BASIS_CODE)

Line 129: ,TASK_WEIGHT_BASIS_CODE = DECODE(X_TASK_WEIGHT_BASIS_CODE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

125: PERCENT_COMP_ENABLE_FLAG, X_PERCENT_COMP_ENABLE_FLAG )
126: ,NEXT_PROGRESS_UPDATE_DATE = DECODE( X_NEXT_PROGRESS_UPDATE_DATE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
127: NEXT_PROGRESS_UPDATE_DATE, X_NEXT_PROGRESS_UPDATE_DATE )
128: ,record_version_number = NVL( record_version_number, 1 ) + 1
129: ,TASK_WEIGHT_BASIS_CODE = DECODE(X_TASK_WEIGHT_BASIS_CODE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
130: TASK_WEIGHT_BASIS_CODE, X_TASK_WEIGHT_BASIS_CODE)
131: ,ALLOW_COLLAB_PROG_ENTRY = DECODE(X_ALLOW_COLLAB_PROG_ENTRY, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
132: ALLOW_COLLAB_PROG_ENTRY, X_ALLOW_COLLAB_PROG_ENTRY)
133: ,ALLOW_PHY_PRCNT_CMP_OVERRIDES = DECODE(X_ALLW_PHY_PRCNT_CMP_OVERRIDES, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 131: ,ALLOW_COLLAB_PROG_ENTRY = DECODE(X_ALLOW_COLLAB_PROG_ENTRY, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

127: NEXT_PROGRESS_UPDATE_DATE, X_NEXT_PROGRESS_UPDATE_DATE )
128: ,record_version_number = NVL( record_version_number, 1 ) + 1
129: ,TASK_WEIGHT_BASIS_CODE = DECODE(X_TASK_WEIGHT_BASIS_CODE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
130: TASK_WEIGHT_BASIS_CODE, X_TASK_WEIGHT_BASIS_CODE)
131: ,ALLOW_COLLAB_PROG_ENTRY = DECODE(X_ALLOW_COLLAB_PROG_ENTRY, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
132: ALLOW_COLLAB_PROG_ENTRY, X_ALLOW_COLLAB_PROG_ENTRY)
133: ,ALLOW_PHY_PRCNT_CMP_OVERRIDES = DECODE(X_ALLW_PHY_PRCNT_CMP_OVERRIDES, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
134: ALLOW_PHY_PRCNT_CMP_OVERRIDES, X_ALLW_PHY_PRCNT_CMP_OVERRIDES)
135: ,STRUCTURE_TYPE = DECODE(X_STRUCTURE_TYPE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 133: ,ALLOW_PHY_PRCNT_CMP_OVERRIDES = DECODE(X_ALLW_PHY_PRCNT_CMP_OVERRIDES, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

129: ,TASK_WEIGHT_BASIS_CODE = DECODE(X_TASK_WEIGHT_BASIS_CODE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
130: TASK_WEIGHT_BASIS_CODE, X_TASK_WEIGHT_BASIS_CODE)
131: ,ALLOW_COLLAB_PROG_ENTRY = DECODE(X_ALLOW_COLLAB_PROG_ENTRY, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
132: ALLOW_COLLAB_PROG_ENTRY, X_ALLOW_COLLAB_PROG_ENTRY)
133: ,ALLOW_PHY_PRCNT_CMP_OVERRIDES = DECODE(X_ALLW_PHY_PRCNT_CMP_OVERRIDES, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
134: ALLOW_PHY_PRCNT_CMP_OVERRIDES, X_ALLW_PHY_PRCNT_CMP_OVERRIDES)
135: ,STRUCTURE_TYPE = DECODE(X_STRUCTURE_TYPE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
136: STRUCTURE_TYPE, X_STRUCTURE_TYPE)
137: WHERE PROJ_PROGRESS_ATTR_ID = X_PROJ_PROGRESS_ATTR_ID

Line 135: ,STRUCTURE_TYPE = DECODE(X_STRUCTURE_TYPE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

131: ,ALLOW_COLLAB_PROG_ENTRY = DECODE(X_ALLOW_COLLAB_PROG_ENTRY, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
132: ALLOW_COLLAB_PROG_ENTRY, X_ALLOW_COLLAB_PROG_ENTRY)
133: ,ALLOW_PHY_PRCNT_CMP_OVERRIDES = DECODE(X_ALLW_PHY_PRCNT_CMP_OVERRIDES, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
134: ALLOW_PHY_PRCNT_CMP_OVERRIDES, X_ALLW_PHY_PRCNT_CMP_OVERRIDES)
135: ,STRUCTURE_TYPE = DECODE(X_STRUCTURE_TYPE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
136: STRUCTURE_TYPE, X_STRUCTURE_TYPE)
137: WHERE PROJ_PROGRESS_ATTR_ID = X_PROJ_PROGRESS_ATTR_ID
138: AND record_version_number = X_RECORD_VERSION_NUMBER
139: ;