APPS.EAM_CONSTRUCTION_UNIT_PKG dependencies on FND_API

Line 38: IF (px_cu_id IS NULL) OR (px_cu_id = FND_API.G_MISS_NUM) then

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;

Line 74: decode( px_cu_id, FND_API.G_MISS_NUM, NULL, px_cu_id),

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),

Line 75: decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),

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),

Line 76: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),

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),

Line 77: decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),

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),

Line 78: decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),

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),

Line 79: decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),

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),

Line 80: decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),

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),

Line 81: decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),

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),

Line 82: decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),

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),

Line 83: decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),

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),

Line 84: decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

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),

Line 85: decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

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),

Line 86: decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

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),

Line 87: decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

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),

Line 88: decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

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),

Line 89: decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

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),

Line 90: decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

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),

Line 91: decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

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),

Line 92: decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

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),

Line 93: decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

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),

Line 94: decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

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),

Line 95: decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),

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),

Line 96: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

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)

Line 97: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),

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: );

Line 98: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

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:

Line 99: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

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;

Line 100: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)

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:

Line 138: CU_NAME = decode( p_cu_name, FND_API.G_MISS_CHAR, NULL, p_cu_name),

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),

Line 139: DESCRIPTION = decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),

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),

Line 140: ORGANIZATION_ID = decode( p_organization_id, FND_API.G_MISS_NUM, NULL, p_organization_id),

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),

Line 141: CU_EFFECTIVE_FROM = decode( p_cu_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_from),

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),

Line 142: CU_EFFECTIVE_TO = decode( p_cu_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_effective_to),

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),

Line 143: ATTRIBUTE_CATEGORY = decode( p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),

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),

Line 144: ATTRIBUTE1 = decode( p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),

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),

Line 145: ATTRIBUTE2 = decode( p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),

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),

Line 146: ATTRIBUTE3 = decode( p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),

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),

Line 147: ATTRIBUTE4 = decode( p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

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),

Line 148: ATTRIBUTE5 = decode( p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

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),

Line 149: ATTRIBUTE6 = decode( p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

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),

Line 150: ATTRIBUTE7 = decode( p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

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),

Line 151: ATTRIBUTE8 = decode( p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

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),

Line 152: ATTRIBUTE9 = decode( p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

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),

Line 153: ATTRIBUTE10 = decode( p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

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),

Line 154: ATTRIBUTE11 = decode( p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

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),

Line 155: ATTRIBUTE12 = decode( p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

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),

Line 156: ATTRIBUTE13 = decode( p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

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),

Line 157: ATTRIBUTE14 = decode( p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

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)

Line 158: ATTRIBUTE15 = decode( p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),

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;

Line 159: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

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:

Line 160: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

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

Line 161: LAST_UPDATE_LOGIN = decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)

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;

Line 191: IF (px_cu_detail_id IS NULL) OR (px_cu_detail_id = FND_API.G_MISS_NUM) then

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;

Line 212: decode( px_cu_detail_id, FND_API.G_MISS_NUM, NULL, px_cu_detail_id),

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),

Line 213: decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),

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),

Line 214: decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),

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),

Line 215: decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),

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),

Line 216: decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),

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),

Line 217: decode( p_cu_activity_effective_from, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),

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),

Line 218: decode( p_cu_activity_effective_to, fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),

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),

Line 219: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

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)

Line 220: decode( p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),

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: );

Line 221: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

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;

Line 222: decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

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:

Line 223: decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)

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(

Line 244: CU_ID = decode( p_cu_id, FND_API.G_MISS_NUM, NULL, p_cu_id),

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,

Line 245: ACCT_CLASS_CODE = decode( p_acct_class_code, FND_API.G_MISS_CHAR, NULL, p_acct_class_code),

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),

Line 246: ACTIVITY_ID = decode( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),

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,

Line 247: CU_ACTIVITY_QTY = decode( p_cu_activity_qty, FND_API.G_MISS_NUM, NULL, p_cu_activity_qty),

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),

Line 249: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_from),

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),

Line 251: fnd_api.g_miss_date, to_date(NULL), p_cu_activity_effective_to),

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;

Line 252: LAST_UPDATE_DATE = decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

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:

Line 253: LAST_UPDATED_BY = decode( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

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

Line 254: LAST_UPDATE_LOGIN = decode( p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)

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;