APPS.CSI_I_EXT_ATTRIB_PKG dependencies on FND_API

Line 53: IF (px_attribute_id IS NULL) OR (px_attribute_id = fnd_api.g_miss_num) THEN

49:
50: IS
51: CURSOR c2 IS SELECT csi_i_extended_attribs_s.NEXTVAL FROM sys.dual;
52: BEGIN
53: IF (px_attribute_id IS NULL) OR (px_attribute_id = fnd_api.g_miss_num) THEN
54: OPEN c2;
55: FETCH c2 into px_attribute_id;
56: CLOSE c2;
57: END IF;

Line 95: decode( p_attribute_level, fnd_api.g_miss_char, NULL, p_attribute_level),

91: last_update_login,
92: object_version_number
93: ) VALUES (
94: px_attribute_id,
95: decode( p_attribute_level, fnd_api.g_miss_char, NULL, p_attribute_level),
96: decode( p_master_organization_id, fnd_api.g_miss_num, NULL, p_master_organization_id),
97: decode( p_inventory_item_id, fnd_api.g_miss_num, NULL, p_inventory_item_id),
98: decode( p_item_category_id, fnd_api.g_miss_num, NULL, p_item_category_id),
99: decode( p_instance_id, fnd_api.g_miss_num, NULL, p_instance_id),

Line 96: decode( p_master_organization_id, fnd_api.g_miss_num, NULL, p_master_organization_id),

92: object_version_number
93: ) VALUES (
94: px_attribute_id,
95: decode( p_attribute_level, fnd_api.g_miss_char, NULL, p_attribute_level),
96: decode( p_master_organization_id, fnd_api.g_miss_num, NULL, p_master_organization_id),
97: decode( p_inventory_item_id, fnd_api.g_miss_num, NULL, p_inventory_item_id),
98: decode( p_item_category_id, fnd_api.g_miss_num, NULL, p_item_category_id),
99: decode( p_instance_id, fnd_api.g_miss_num, NULL, p_instance_id),
100: decode( p_attribute_code, fnd_api.g_miss_char, NULL, p_attribute_code),

Line 97: decode( p_inventory_item_id, fnd_api.g_miss_num, NULL, p_inventory_item_id),

93: ) VALUES (
94: px_attribute_id,
95: decode( p_attribute_level, fnd_api.g_miss_char, NULL, p_attribute_level),
96: decode( p_master_organization_id, fnd_api.g_miss_num, NULL, p_master_organization_id),
97: decode( p_inventory_item_id, fnd_api.g_miss_num, NULL, p_inventory_item_id),
98: decode( p_item_category_id, fnd_api.g_miss_num, NULL, p_item_category_id),
99: decode( p_instance_id, fnd_api.g_miss_num, NULL, p_instance_id),
100: decode( p_attribute_code, fnd_api.g_miss_char, NULL, p_attribute_code),
101: decode( p_attribute_name, fnd_api.g_miss_char, NULL, p_attribute_name),

Line 98: decode( p_item_category_id, fnd_api.g_miss_num, NULL, p_item_category_id),

94: px_attribute_id,
95: decode( p_attribute_level, fnd_api.g_miss_char, NULL, p_attribute_level),
96: decode( p_master_organization_id, fnd_api.g_miss_num, NULL, p_master_organization_id),
97: decode( p_inventory_item_id, fnd_api.g_miss_num, NULL, p_inventory_item_id),
98: decode( p_item_category_id, fnd_api.g_miss_num, NULL, p_item_category_id),
99: decode( p_instance_id, fnd_api.g_miss_num, NULL, p_instance_id),
100: decode( p_attribute_code, fnd_api.g_miss_char, NULL, p_attribute_code),
101: decode( p_attribute_name, fnd_api.g_miss_char, NULL, p_attribute_name),
102: decode( p_attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category),

Line 99: decode( p_instance_id, fnd_api.g_miss_num, NULL, p_instance_id),

95: decode( p_attribute_level, fnd_api.g_miss_char, NULL, p_attribute_level),
96: decode( p_master_organization_id, fnd_api.g_miss_num, NULL, p_master_organization_id),
97: decode( p_inventory_item_id, fnd_api.g_miss_num, NULL, p_inventory_item_id),
98: decode( p_item_category_id, fnd_api.g_miss_num, NULL, p_item_category_id),
99: decode( p_instance_id, fnd_api.g_miss_num, NULL, p_instance_id),
100: decode( p_attribute_code, fnd_api.g_miss_char, NULL, p_attribute_code),
101: decode( p_attribute_name, fnd_api.g_miss_char, NULL, p_attribute_name),
102: decode( p_attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category),
103: decode( p_description, fnd_api.g_miss_char, NULL, p_description),

Line 100: decode( p_attribute_code, fnd_api.g_miss_char, NULL, p_attribute_code),

96: decode( p_master_organization_id, fnd_api.g_miss_num, NULL, p_master_organization_id),
97: decode( p_inventory_item_id, fnd_api.g_miss_num, NULL, p_inventory_item_id),
98: decode( p_item_category_id, fnd_api.g_miss_num, NULL, p_item_category_id),
99: decode( p_instance_id, fnd_api.g_miss_num, NULL, p_instance_id),
100: decode( p_attribute_code, fnd_api.g_miss_char, NULL, p_attribute_code),
101: decode( p_attribute_name, fnd_api.g_miss_char, NULL, p_attribute_name),
102: decode( p_attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category),
103: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
104: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),

Line 101: decode( p_attribute_name, fnd_api.g_miss_char, NULL, p_attribute_name),

97: decode( p_inventory_item_id, fnd_api.g_miss_num, NULL, p_inventory_item_id),
98: decode( p_item_category_id, fnd_api.g_miss_num, NULL, p_item_category_id),
99: decode( p_instance_id, fnd_api.g_miss_num, NULL, p_instance_id),
100: decode( p_attribute_code, fnd_api.g_miss_char, NULL, p_attribute_code),
101: decode( p_attribute_name, fnd_api.g_miss_char, NULL, p_attribute_name),
102: decode( p_attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category),
103: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
104: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
105: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),

Line 102: decode( p_attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category),

98: decode( p_item_category_id, fnd_api.g_miss_num, NULL, p_item_category_id),
99: decode( p_instance_id, fnd_api.g_miss_num, NULL, p_instance_id),
100: decode( p_attribute_code, fnd_api.g_miss_char, NULL, p_attribute_code),
101: decode( p_attribute_name, fnd_api.g_miss_char, NULL, p_attribute_name),
102: decode( p_attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category),
103: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
104: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
105: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
106: decode( p_context, fnd_api.g_miss_char, NULL, p_context),

Line 103: decode( p_description, fnd_api.g_miss_char, NULL, p_description),

99: decode( p_instance_id, fnd_api.g_miss_num, NULL, p_instance_id),
100: decode( p_attribute_code, fnd_api.g_miss_char, NULL, p_attribute_code),
101: decode( p_attribute_name, fnd_api.g_miss_char, NULL, p_attribute_name),
102: decode( p_attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category),
103: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
104: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
105: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
106: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
107: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),

Line 104: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),

100: decode( p_attribute_code, fnd_api.g_miss_char, NULL, p_attribute_code),
101: decode( p_attribute_name, fnd_api.g_miss_char, NULL, p_attribute_name),
102: decode( p_attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category),
103: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
104: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
105: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
106: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
107: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
108: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),

Line 105: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),

101: decode( p_attribute_name, fnd_api.g_miss_char, NULL, p_attribute_name),
102: decode( p_attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category),
103: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
104: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
105: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
106: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
107: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
108: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
109: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),

Line 106: decode( p_context, fnd_api.g_miss_char, NULL, p_context),

102: decode( p_attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category),
103: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
104: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
105: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
106: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
107: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
108: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
109: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
110: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),

Line 107: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),

103: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
104: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
105: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
106: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
107: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
108: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
109: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
110: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
111: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),

Line 108: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),

104: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
105: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
106: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
107: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
108: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
109: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
110: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
111: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
112: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),

Line 109: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),

105: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
106: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
107: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
108: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
109: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
110: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
111: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
112: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
113: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),

Line 110: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),

106: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
107: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
108: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
109: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
110: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
111: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
112: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
113: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
114: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),

Line 111: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),

107: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
108: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
109: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
110: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
111: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
112: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
113: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
114: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
115: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),

Line 112: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),

108: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
109: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
110: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
111: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
112: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
113: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
114: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
115: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
116: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),

Line 113: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),

109: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
110: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
111: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
112: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
113: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
114: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
115: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
116: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
117: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),

Line 114: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),

110: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
111: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
112: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
113: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
114: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
115: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
116: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
117: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
118: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),

Line 115: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),

111: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
112: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
113: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
114: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
115: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
116: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
117: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
118: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
119: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),

Line 116: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),

112: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
113: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
114: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
115: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
116: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
117: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
118: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
119: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
120: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),

Line 117: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),

113: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
114: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
115: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
116: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
117: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
118: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
119: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
120: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
121: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),

Line 118: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),

114: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
115: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
116: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
117: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
118: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
119: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
120: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
121: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
122: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

Line 119: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),

115: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
116: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
117: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
118: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
119: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
120: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
121: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
122: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
123: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

Line 120: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),

116: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
117: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
118: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
119: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
120: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
121: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
122: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
123: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
124: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

Line 121: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),

117: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
118: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
119: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
120: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
121: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
122: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
123: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
124: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
125: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

Line 122: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

118: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
119: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
120: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
121: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
122: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
123: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
124: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
125: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
126: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

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

119: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
120: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
121: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
122: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
123: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
124: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
125: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
126: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
127: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));

Line 124: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

120: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
121: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
122: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
123: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
124: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
125: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
126: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
127: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
128: END insert_row;

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

121: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
122: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
123: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
124: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
125: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
126: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
127: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
128: END insert_row;
129:

Line 126: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

122: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
123: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
124: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
125: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
126: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
127: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
128: END insert_row;
129:
130: PROCEDURE update_row(

Line 127: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));

123: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
124: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
125: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
126: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
127: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
128: END insert_row;
129:
130: PROCEDURE update_row(
131: p_attribute_id NUMBER ,

Line 170: attribute_level = decode( p_attribute_level, fnd_api.g_miss_char, attribute_level, p_attribute_level),

166: IS
167: BEGIN
168: UPDATE csi_i_extended_attribs
169: SET
170: attribute_level = decode( p_attribute_level, fnd_api.g_miss_char, attribute_level, p_attribute_level),
171: master_organization_id = decode( p_master_organization_id, fnd_api.g_miss_num, master_organization_id, p_master_organization_id),
172: inventory_item_id = decode( p_inventory_item_id, fnd_api.g_miss_num, inventory_item_id, p_inventory_item_id),
173: item_category_id = decode( p_item_category_id, fnd_api.g_miss_num, item_category_id, p_item_category_id),
174: instance_id = decode( p_instance_id, fnd_api.g_miss_num, instance_id, p_instance_id),

Line 171: master_organization_id = decode( p_master_organization_id, fnd_api.g_miss_num, master_organization_id, p_master_organization_id),

167: BEGIN
168: UPDATE csi_i_extended_attribs
169: SET
170: attribute_level = decode( p_attribute_level, fnd_api.g_miss_char, attribute_level, p_attribute_level),
171: master_organization_id = decode( p_master_organization_id, fnd_api.g_miss_num, master_organization_id, p_master_organization_id),
172: inventory_item_id = decode( p_inventory_item_id, fnd_api.g_miss_num, inventory_item_id, p_inventory_item_id),
173: item_category_id = decode( p_item_category_id, fnd_api.g_miss_num, item_category_id, p_item_category_id),
174: instance_id = decode( p_instance_id, fnd_api.g_miss_num, instance_id, p_instance_id),
175: attribute_code = decode( p_attribute_code, fnd_api.g_miss_char, attribute_code, p_attribute_code),

Line 172: inventory_item_id = decode( p_inventory_item_id, fnd_api.g_miss_num, inventory_item_id, p_inventory_item_id),

168: UPDATE csi_i_extended_attribs
169: SET
170: attribute_level = decode( p_attribute_level, fnd_api.g_miss_char, attribute_level, p_attribute_level),
171: master_organization_id = decode( p_master_organization_id, fnd_api.g_miss_num, master_organization_id, p_master_organization_id),
172: inventory_item_id = decode( p_inventory_item_id, fnd_api.g_miss_num, inventory_item_id, p_inventory_item_id),
173: item_category_id = decode( p_item_category_id, fnd_api.g_miss_num, item_category_id, p_item_category_id),
174: instance_id = decode( p_instance_id, fnd_api.g_miss_num, instance_id, p_instance_id),
175: attribute_code = decode( p_attribute_code, fnd_api.g_miss_char, attribute_code, p_attribute_code),
176: attribute_name = decode( p_attribute_name, fnd_api.g_miss_char, attribute_name, p_attribute_name),

Line 173: item_category_id = decode( p_item_category_id, fnd_api.g_miss_num, item_category_id, p_item_category_id),

169: SET
170: attribute_level = decode( p_attribute_level, fnd_api.g_miss_char, attribute_level, p_attribute_level),
171: master_organization_id = decode( p_master_organization_id, fnd_api.g_miss_num, master_organization_id, p_master_organization_id),
172: inventory_item_id = decode( p_inventory_item_id, fnd_api.g_miss_num, inventory_item_id, p_inventory_item_id),
173: item_category_id = decode( p_item_category_id, fnd_api.g_miss_num, item_category_id, p_item_category_id),
174: instance_id = decode( p_instance_id, fnd_api.g_miss_num, instance_id, p_instance_id),
175: attribute_code = decode( p_attribute_code, fnd_api.g_miss_char, attribute_code, p_attribute_code),
176: attribute_name = decode( p_attribute_name, fnd_api.g_miss_char, attribute_name, p_attribute_name),
177: attribute_category = decode( p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category),

Line 174: instance_id = decode( p_instance_id, fnd_api.g_miss_num, instance_id, p_instance_id),

170: attribute_level = decode( p_attribute_level, fnd_api.g_miss_char, attribute_level, p_attribute_level),
171: master_organization_id = decode( p_master_organization_id, fnd_api.g_miss_num, master_organization_id, p_master_organization_id),
172: inventory_item_id = decode( p_inventory_item_id, fnd_api.g_miss_num, inventory_item_id, p_inventory_item_id),
173: item_category_id = decode( p_item_category_id, fnd_api.g_miss_num, item_category_id, p_item_category_id),
174: instance_id = decode( p_instance_id, fnd_api.g_miss_num, instance_id, p_instance_id),
175: attribute_code = decode( p_attribute_code, fnd_api.g_miss_char, attribute_code, p_attribute_code),
176: attribute_name = decode( p_attribute_name, fnd_api.g_miss_char, attribute_name, p_attribute_name),
177: attribute_category = decode( p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category),
178: description = decode( p_description, fnd_api.g_miss_char, description, p_description),

Line 175: attribute_code = decode( p_attribute_code, fnd_api.g_miss_char, attribute_code, p_attribute_code),

171: master_organization_id = decode( p_master_organization_id, fnd_api.g_miss_num, master_organization_id, p_master_organization_id),
172: inventory_item_id = decode( p_inventory_item_id, fnd_api.g_miss_num, inventory_item_id, p_inventory_item_id),
173: item_category_id = decode( p_item_category_id, fnd_api.g_miss_num, item_category_id, p_item_category_id),
174: instance_id = decode( p_instance_id, fnd_api.g_miss_num, instance_id, p_instance_id),
175: attribute_code = decode( p_attribute_code, fnd_api.g_miss_char, attribute_code, p_attribute_code),
176: attribute_name = decode( p_attribute_name, fnd_api.g_miss_char, attribute_name, p_attribute_name),
177: attribute_category = decode( p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category),
178: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
179: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),

Line 176: attribute_name = decode( p_attribute_name, fnd_api.g_miss_char, attribute_name, p_attribute_name),

172: inventory_item_id = decode( p_inventory_item_id, fnd_api.g_miss_num, inventory_item_id, p_inventory_item_id),
173: item_category_id = decode( p_item_category_id, fnd_api.g_miss_num, item_category_id, p_item_category_id),
174: instance_id = decode( p_instance_id, fnd_api.g_miss_num, instance_id, p_instance_id),
175: attribute_code = decode( p_attribute_code, fnd_api.g_miss_char, attribute_code, p_attribute_code),
176: attribute_name = decode( p_attribute_name, fnd_api.g_miss_char, attribute_name, p_attribute_name),
177: attribute_category = decode( p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category),
178: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
179: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
180: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),

Line 177: attribute_category = decode( p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category),

173: item_category_id = decode( p_item_category_id, fnd_api.g_miss_num, item_category_id, p_item_category_id),
174: instance_id = decode( p_instance_id, fnd_api.g_miss_num, instance_id, p_instance_id),
175: attribute_code = decode( p_attribute_code, fnd_api.g_miss_char, attribute_code, p_attribute_code),
176: attribute_name = decode( p_attribute_name, fnd_api.g_miss_char, attribute_name, p_attribute_name),
177: attribute_category = decode( p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category),
178: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
179: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
180: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
181: context = decode( p_context, fnd_api.g_miss_char, context, p_context),

Line 178: description = decode( p_description, fnd_api.g_miss_char, description, p_description),

174: instance_id = decode( p_instance_id, fnd_api.g_miss_num, instance_id, p_instance_id),
175: attribute_code = decode( p_attribute_code, fnd_api.g_miss_char, attribute_code, p_attribute_code),
176: attribute_name = decode( p_attribute_name, fnd_api.g_miss_char, attribute_name, p_attribute_name),
177: attribute_category = decode( p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category),
178: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
179: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
180: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
181: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
182: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),

Line 179: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),

175: attribute_code = decode( p_attribute_code, fnd_api.g_miss_char, attribute_code, p_attribute_code),
176: attribute_name = decode( p_attribute_name, fnd_api.g_miss_char, attribute_name, p_attribute_name),
177: attribute_category = decode( p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category),
178: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
179: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
180: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
181: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
182: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
183: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),

Line 180: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),

176: attribute_name = decode( p_attribute_name, fnd_api.g_miss_char, attribute_name, p_attribute_name),
177: attribute_category = decode( p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category),
178: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
179: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
180: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
181: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
182: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
183: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
184: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),

Line 181: context = decode( p_context, fnd_api.g_miss_char, context, p_context),

177: attribute_category = decode( p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category),
178: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
179: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
180: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
181: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
182: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
183: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
184: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
185: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),

Line 182: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),

178: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
179: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
180: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
181: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
182: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
183: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
184: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
185: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
186: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),

Line 183: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),

179: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
180: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
181: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
182: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
183: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
184: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
185: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
186: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
187: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),

Line 184: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),

180: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
181: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
182: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
183: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
184: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
185: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
186: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
187: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
188: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),

Line 185: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),

181: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
182: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
183: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
184: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
185: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
186: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
187: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
188: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
189: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),

Line 186: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),

182: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
183: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
184: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
185: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
186: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
187: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
188: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
189: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
190: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),

Line 187: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),

183: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
184: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
185: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
186: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
187: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
188: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
189: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
190: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
191: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),

Line 188: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),

184: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
185: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
186: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
187: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
188: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
189: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
190: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
191: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
192: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),

Line 189: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),

185: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
186: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
187: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
188: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
189: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
190: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
191: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
192: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
193: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),

Line 190: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),

186: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
187: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
188: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
189: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
190: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
191: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
192: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
193: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
194: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),

Line 191: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),

187: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
188: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
189: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
190: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
191: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
192: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
193: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
194: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
195: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),

Line 192: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),

188: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
189: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
190: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
191: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
192: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
193: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
194: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
195: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
196: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),

Line 193: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),

189: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
190: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
191: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
192: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
193: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
194: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
195: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
196: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
197: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

Line 194: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),

190: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
191: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
192: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
193: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
194: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
195: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
196: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
197: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
198: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

Line 195: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),

191: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
192: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
193: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
194: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
195: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
196: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
197: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
198: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
199: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

Line 196: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),

192: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
193: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
194: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
195: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
196: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
197: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
198: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
199: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
200: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

Line 197: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

193: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
194: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
195: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
196: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
197: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
198: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
199: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
200: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
201: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

Line 198: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

194: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
195: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
196: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
197: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
198: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
199: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
200: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
201: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
202: object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)

Line 199: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

195: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
196: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
197: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
198: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
199: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
200: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
201: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
202: object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
203: WHERE attribute_id = p_attribute_id;

Line 200: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

196: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
197: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
198: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
199: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
200: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
201: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
202: object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
203: WHERE attribute_id = p_attribute_id;
204:

Line 201: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

197: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
198: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
199: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
200: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
201: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
202: object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
203: WHERE attribute_id = p_attribute_id;
204:
205: IF (SQL%NOTFOUND) THEN

Line 202: object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)

198: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
199: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
200: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
201: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
202: object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
203: WHERE attribute_id = p_attribute_id;
204:
205: IF (SQL%NOTFOUND) THEN
206: RAISE no_data_found;