34: CURSOR C1 IS
35: SELECT EAM_CONSTRUCTION_UNITS_S.nextval
36: FROM dual;
37: BEGIN
38: IF (px_cu_id IS NULL) OR (px_cu_id = FND_API.G_MISS_NUM) then
39: OPEN C1;
40: FETCH C1 INTO px_cu_id;
41: CLOSE C1;
42: END IF;
70: LAST_UPDATED_BY,
71: LAST_UPDATE_LOGIN
72: )
73: VALUES(
74: decode( px_cu_id, FND_API.G_MISS_NUM, NULL, px_cu_id),
75: decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
76: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
77: decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
78: decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
71: LAST_UPDATE_LOGIN
72: )
73: VALUES(
74: decode( px_cu_id, FND_API.G_MISS_NUM, NULL, px_cu_id),
75: decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
76: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
77: decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
78: decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
79: decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
72: )
73: VALUES(
74: decode( px_cu_id, FND_API.G_MISS_NUM, NULL, px_cu_id),
75: decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
76: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
77: decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
78: decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
79: decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
80: decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
73: VALUES(
74: decode( px_cu_id, FND_API.G_MISS_NUM, NULL, px_cu_id),
75: decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
76: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
77: decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
78: decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
79: decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
80: decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
81: decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
74: decode( px_cu_id, FND_API.G_MISS_NUM, NULL, px_cu_id),
75: decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
76: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
77: decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
78: decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
79: decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
80: decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
81: decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
82: decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
75: decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
76: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
77: decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
78: decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
79: decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
80: decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
81: decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
82: decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
83: decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
76: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
77: decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
78: decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
79: decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
80: decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
81: decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
82: decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
83: decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
84: decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
77: decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
78: decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
79: decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
80: decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
81: decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
82: decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
83: decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
84: decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
85: decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
78: decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
79: decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
80: decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
81: decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
82: decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
83: decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
84: decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
85: decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
86: decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
79: decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
80: decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
81: decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
82: decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
83: decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
84: decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
85: decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
86: decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
87: decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
80: decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
81: decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
82: decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
83: decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
84: decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
85: decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
86: decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
87: decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
88: decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
81: decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
82: decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
83: decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
84: decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
85: decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
86: decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
87: decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
88: decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
89: decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
82: decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
83: decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
84: decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
85: decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
86: decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
87: decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
88: decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
89: decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
90: decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
83: decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
84: decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
85: decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
86: decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
87: decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
88: decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
89: decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
90: decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
91: decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
84: decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
85: decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
86: decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
87: decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
88: decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
89: decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
90: decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
91: decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
92: decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
85: decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
86: decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
87: decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
88: decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
89: decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
90: decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
91: decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
92: decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
93: decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
86: decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
87: decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
88: decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
89: decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
90: decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
91: decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
92: decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
93: decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
94: decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
87: decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
88: decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
89: decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
90: decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
91: decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
92: decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
93: decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
94: decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
95: decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
88: decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
89: decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
90: decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
91: decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
92: decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
93: decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
94: decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
95: decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
96: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
89: decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
90: decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
91: decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
92: decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
93: decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
94: decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
95: decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
96: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
97: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
90: decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
91: decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
92: decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
93: decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
94: decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
95: decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
96: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
97: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
98: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
91: decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
92: decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
93: decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
94: decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
95: decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
96: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
97: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
98: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
99: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
92: decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
93: decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
94: decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
95: decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
96: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
97: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
98: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
99: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
100: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
93: decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
94: decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
95: decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
96: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
97: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
98: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
99: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
100: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
101: );
94: decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
95: decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
96: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
97: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
98: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
99: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
100: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
101: );
102:
95: decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
96: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
97: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
98: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
99: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
100: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
101: );
102:
103: End Insert_CU_Row;
96: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
97: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
98: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
99: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
100: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
101: );
102:
103: End Insert_CU_Row;
104:
134: BEGIN
135:
136: UPDATE EAM_CONSTRUCTION_UNITS
137: SET
138: CU_NAME = decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
139: DESCRIPTION = decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
140: ORGANIZATION_ID = decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
141: CU_EFFECTIVE_FROM = decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
142: CU_EFFECTIVE_TO = decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
135:
136: UPDATE EAM_CONSTRUCTION_UNITS
137: SET
138: CU_NAME = decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
139: DESCRIPTION = decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
140: ORGANIZATION_ID = decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
141: CU_EFFECTIVE_FROM = decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
142: CU_EFFECTIVE_TO = decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
143: ATTRIBUTE_CATEGORY = decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
136: UPDATE EAM_CONSTRUCTION_UNITS
137: SET
138: CU_NAME = decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
139: DESCRIPTION = decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
140: ORGANIZATION_ID = decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
141: CU_EFFECTIVE_FROM = decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
142: CU_EFFECTIVE_TO = decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
143: ATTRIBUTE_CATEGORY = decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
144: ATTRIBUTE1 = decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
137: SET
138: CU_NAME = decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
139: DESCRIPTION = decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
140: ORGANIZATION_ID = decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
141: CU_EFFECTIVE_FROM = decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
142: CU_EFFECTIVE_TO = decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
143: ATTRIBUTE_CATEGORY = decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
144: ATTRIBUTE1 = decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
145: ATTRIBUTE2 = decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
138: CU_NAME = decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),
139: DESCRIPTION = decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
140: ORGANIZATION_ID = decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
141: CU_EFFECTIVE_FROM = decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
142: CU_EFFECTIVE_TO = decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
143: ATTRIBUTE_CATEGORY = decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
144: ATTRIBUTE1 = decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
145: ATTRIBUTE2 = decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
146: ATTRIBUTE3 = decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
139: DESCRIPTION = decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
140: ORGANIZATION_ID = decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
141: CU_EFFECTIVE_FROM = decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
142: CU_EFFECTIVE_TO = decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
143: ATTRIBUTE_CATEGORY = decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
144: ATTRIBUTE1 = decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
145: ATTRIBUTE2 = decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
146: ATTRIBUTE3 = decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
147: ATTRIBUTE4 = decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
140: ORGANIZATION_ID = decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),
141: CU_EFFECTIVE_FROM = decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
142: CU_EFFECTIVE_TO = decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
143: ATTRIBUTE_CATEGORY = decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
144: ATTRIBUTE1 = decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
145: ATTRIBUTE2 = decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
146: ATTRIBUTE3 = decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
147: ATTRIBUTE4 = decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
148: ATTRIBUTE5 = decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
141: CU_EFFECTIVE_FROM = decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),
142: CU_EFFECTIVE_TO = decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
143: ATTRIBUTE_CATEGORY = decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
144: ATTRIBUTE1 = decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
145: ATTRIBUTE2 = decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
146: ATTRIBUTE3 = decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
147: ATTRIBUTE4 = decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
148: ATTRIBUTE5 = decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
149: ATTRIBUTE6 = decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
142: CU_EFFECTIVE_TO = decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),
143: ATTRIBUTE_CATEGORY = decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
144: ATTRIBUTE1 = decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
145: ATTRIBUTE2 = decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
146: ATTRIBUTE3 = decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
147: ATTRIBUTE4 = decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
148: ATTRIBUTE5 = decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
149: ATTRIBUTE6 = decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
150: ATTRIBUTE7 = decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
143: ATTRIBUTE_CATEGORY = decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
144: ATTRIBUTE1 = decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
145: ATTRIBUTE2 = decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
146: ATTRIBUTE3 = decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
147: ATTRIBUTE4 = decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
148: ATTRIBUTE5 = decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
149: ATTRIBUTE6 = decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
150: ATTRIBUTE7 = decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
151: ATTRIBUTE8 = decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
144: ATTRIBUTE1 = decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
145: ATTRIBUTE2 = decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
146: ATTRIBUTE3 = decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
147: ATTRIBUTE4 = decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
148: ATTRIBUTE5 = decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
149: ATTRIBUTE6 = decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
150: ATTRIBUTE7 = decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
151: ATTRIBUTE8 = decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
152: ATTRIBUTE9 = decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
145: ATTRIBUTE2 = decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
146: ATTRIBUTE3 = decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
147: ATTRIBUTE4 = decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
148: ATTRIBUTE5 = decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
149: ATTRIBUTE6 = decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
150: ATTRIBUTE7 = decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
151: ATTRIBUTE8 = decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
152: ATTRIBUTE9 = decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
153: ATTRIBUTE10 = decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
146: ATTRIBUTE3 = decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
147: ATTRIBUTE4 = decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
148: ATTRIBUTE5 = decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
149: ATTRIBUTE6 = decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
150: ATTRIBUTE7 = decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
151: ATTRIBUTE8 = decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
152: ATTRIBUTE9 = decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
153: ATTRIBUTE10 = decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
154: ATTRIBUTE11 = decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
147: ATTRIBUTE4 = decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
148: ATTRIBUTE5 = decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
149: ATTRIBUTE6 = decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
150: ATTRIBUTE7 = decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
151: ATTRIBUTE8 = decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
152: ATTRIBUTE9 = decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
153: ATTRIBUTE10 = decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
154: ATTRIBUTE11 = decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
155: ATTRIBUTE12 = decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
148: ATTRIBUTE5 = decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
149: ATTRIBUTE6 = decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
150: ATTRIBUTE7 = decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
151: ATTRIBUTE8 = decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
152: ATTRIBUTE9 = decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
153: ATTRIBUTE10 = decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
154: ATTRIBUTE11 = decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
155: ATTRIBUTE12 = decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
156: ATTRIBUTE13 = decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
149: ATTRIBUTE6 = decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
150: ATTRIBUTE7 = decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
151: ATTRIBUTE8 = decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
152: ATTRIBUTE9 = decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
153: ATTRIBUTE10 = decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
154: ATTRIBUTE11 = decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
155: ATTRIBUTE12 = decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
156: ATTRIBUTE13 = decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
157: ATTRIBUTE14 = decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
150: ATTRIBUTE7 = decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
151: ATTRIBUTE8 = decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
152: ATTRIBUTE9 = decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
153: ATTRIBUTE10 = decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
154: ATTRIBUTE11 = decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
155: ATTRIBUTE12 = decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
156: ATTRIBUTE13 = decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
157: ATTRIBUTE14 = decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
158: ATTRIBUTE15 = decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
151: ATTRIBUTE8 = decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
152: ATTRIBUTE9 = decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
153: ATTRIBUTE10 = decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
154: ATTRIBUTE11 = decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
155: ATTRIBUTE12 = decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
156: ATTRIBUTE13 = decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
157: ATTRIBUTE14 = decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
158: ATTRIBUTE15 = decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
159: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
152: ATTRIBUTE9 = decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
153: ATTRIBUTE10 = decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
154: ATTRIBUTE11 = decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
155: ATTRIBUTE12 = decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
156: ATTRIBUTE13 = decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
157: ATTRIBUTE14 = decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
158: ATTRIBUTE15 = decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
159: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
160: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
153: ATTRIBUTE10 = decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
154: ATTRIBUTE11 = decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
155: ATTRIBUTE12 = decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
156: ATTRIBUTE13 = decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
157: ATTRIBUTE14 = decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
158: ATTRIBUTE15 = decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
159: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
160: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
161: LAST_UPDATE_LOGIN = decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
154: ATTRIBUTE11 = decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
155: ATTRIBUTE12 = decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
156: ATTRIBUTE13 = decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
157: ATTRIBUTE14 = decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
158: ATTRIBUTE15 = decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
159: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
160: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
161: LAST_UPDATE_LOGIN = decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
162: WHERE CU_ID = p_cu_id;
155: ATTRIBUTE12 = decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
156: ATTRIBUTE13 = decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
157: ATTRIBUTE14 = decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
158: ATTRIBUTE15 = decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
159: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
160: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
161: LAST_UPDATE_LOGIN = decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
162: WHERE CU_ID = p_cu_id;
163:
156: ATTRIBUTE13 = decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
157: ATTRIBUTE14 = decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
158: ATTRIBUTE15 = decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
159: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
160: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
161: LAST_UPDATE_LOGIN = decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
162: WHERE CU_ID = p_cu_id;
163:
164: If (SQL%NOTFOUND) then
157: ATTRIBUTE14 = decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
158: ATTRIBUTE15 = decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
159: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
160: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
161: LAST_UPDATE_LOGIN = decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
162: WHERE CU_ID = p_cu_id;
163:
164: If (SQL%NOTFOUND) then
165: RAISE NO_DATA_FOUND;
187: SELECT EAM_CONSTRUCTION_UNIT_DTLS_S.nextval
188: FROM dual;
189: BEGIN
190:
191: IF (px_cu_detail_id IS NULL) OR (px_cu_detail_id = FND_API.G_MISS_NUM) then
192: OPEN C2;
193: FETCH C2 INTO px_cu_detail_id;
194: CLOSE C2;
195: END IF;
208: LAST_UPDATED_BY,
209: LAST_UPDATE_LOGIN
210: )
211: VALUES(
212: decode( px_cu_detail_id, FND_API.G_MISS_NUM, NULL, px_cu_detail_id),
213: decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),
214: decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
215: decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
216: decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
209: LAST_UPDATE_LOGIN
210: )
211: VALUES(
212: decode( px_cu_detail_id, FND_API.G_MISS_NUM, NULL, px_cu_detail_id),
213: decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),
214: decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
215: decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
216: decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
217: decode( p_cu_activity_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
210: )
211: VALUES(
212: decode( px_cu_detail_id, FND_API.G_MISS_NUM, NULL, px_cu_detail_id),
213: decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),
214: decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
215: decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
216: decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
217: decode( p_cu_activity_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
218: decode( p_cu_activity_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
211: VALUES(
212: decode( px_cu_detail_id, FND_API.G_MISS_NUM, NULL, px_cu_detail_id),
213: decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),
214: decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
215: decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
216: decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
217: decode( p_cu_activity_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
218: decode( p_cu_activity_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
219: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
212: decode( px_cu_detail_id, FND_API.G_MISS_NUM, NULL, px_cu_detail_id),
213: decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),
214: decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
215: decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
216: decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
217: decode( p_cu_activity_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
218: decode( p_cu_activity_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
219: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
220: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
213: decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),
214: decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
215: decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
216: decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
217: decode( p_cu_activity_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
218: decode( p_cu_activity_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
219: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
220: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
221: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
214: decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
215: decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
216: decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
217: decode( p_cu_activity_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
218: decode( p_cu_activity_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
219: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
220: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
221: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
222: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
215: decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
216: decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
217: decode( p_cu_activity_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
218: decode( p_cu_activity_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
219: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
220: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
221: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
222: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
223: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
216: decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
217: decode( p_cu_activity_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
218: decode( p_cu_activity_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
219: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
220: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
221: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
222: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
223: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
224: );
217: decode( p_cu_activity_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
218: decode( p_cu_activity_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
219: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
220: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
221: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
222: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
223: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
224: );
225: End Insert_CU_Activity_Row;
218: decode( p_cu_activity_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
219: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
220: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
221: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
222: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
223: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
224: );
225: End Insert_CU_Activity_Row;
226:
219: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
220: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
221: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
222: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
223: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
224: );
225: End Insert_CU_Activity_Row;
226:
227: PROCEDURE Update_CU_Activity_Row(
240: BEGIN
241:
242: UPDATE EAM_CONSTRUCTION_UNIT_DETAILS
243: SET
244: CU_ID = decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),
245: ACCT_CLASS_CODE = decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
246: ACTIVITY_ID = decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
247: CU_ACTIVITY_QTY = decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
248: CU_ACTIVITY_EFFECTIVE_FROM = decode( p_cu_activity_effective_from,
241:
242: UPDATE EAM_CONSTRUCTION_UNIT_DETAILS
243: SET
244: CU_ID = decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),
245: ACCT_CLASS_CODE = decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
246: ACTIVITY_ID = decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
247: CU_ACTIVITY_QTY = decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
248: CU_ACTIVITY_EFFECTIVE_FROM = decode( p_cu_activity_effective_from,
249: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
242: UPDATE EAM_CONSTRUCTION_UNIT_DETAILS
243: SET
244: CU_ID = decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),
245: ACCT_CLASS_CODE = decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
246: ACTIVITY_ID = decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
247: CU_ACTIVITY_QTY = decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
248: CU_ACTIVITY_EFFECTIVE_FROM = decode( p_cu_activity_effective_from,
249: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
250: CU_ACTIVITY_EFFECTIVE_TO = decode( p_cu_activity_effective_to,
243: SET
244: CU_ID = decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),
245: ACCT_CLASS_CODE = decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
246: ACTIVITY_ID = decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
247: CU_ACTIVITY_QTY = decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
248: CU_ACTIVITY_EFFECTIVE_FROM = decode( p_cu_activity_effective_from,
249: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
250: CU_ACTIVITY_EFFECTIVE_TO = decode( p_cu_activity_effective_to,
251: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
245: ACCT_CLASS_CODE = decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),
246: ACTIVITY_ID = decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
247: CU_ACTIVITY_QTY = decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
248: CU_ACTIVITY_EFFECTIVE_FROM = decode( p_cu_activity_effective_from,
249: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
250: CU_ACTIVITY_EFFECTIVE_TO = decode( p_cu_activity_effective_to,
251: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
252: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
253: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
247: CU_ACTIVITY_QTY = decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),
248: CU_ACTIVITY_EFFECTIVE_FROM = decode( p_cu_activity_effective_from,
249: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
250: CU_ACTIVITY_EFFECTIVE_TO = decode( p_cu_activity_effective_to,
251: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
252: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
253: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
254: LAST_UPDATE_LOGIN = decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
255: WHERE CU_DETAIL_ID = p_cu_detail_id;
248: CU_ACTIVITY_EFFECTIVE_FROM = decode( p_cu_activity_effective_from,
249: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
250: CU_ACTIVITY_EFFECTIVE_TO = decode( p_cu_activity_effective_to,
251: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
252: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
253: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
254: LAST_UPDATE_LOGIN = decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
255: WHERE CU_DETAIL_ID = p_cu_detail_id;
256:
249: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),
250: CU_ACTIVITY_EFFECTIVE_TO = decode( p_cu_activity_effective_to,
251: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
252: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
253: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
254: LAST_UPDATE_LOGIN = decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
255: WHERE CU_DETAIL_ID = p_cu_detail_id;
256:
257: If (SQL%NOTFOUND) then
250: CU_ACTIVITY_EFFECTIVE_TO = decode( p_cu_activity_effective_to,
251: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),
252: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
253: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
254: LAST_UPDATE_LOGIN = decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
255: WHERE CU_DETAIL_ID = p_cu_detail_id;
256:
257: If (SQL%NOTFOUND) then
258: RAISE NO_DATA_FOUND;