43: WHERE issue_listing_idfr_id = p_issue_listing_idfr_id;
44:
45: BEGIN
46:
47: IF (p_issue_listing_idfr_id IS NULL) OR (p_issue_listing_idfr_id = FND_API.G_MISS_NUM) THEN
48: OPEN C1;
49: FETCH C1 INTO p_issue_listing_idfr_id;
50: CLOSE C1;
51: END IF;
79: attribute12,
80: attribute13,
81: attribute14,
82: attribute15) VALUES
83: (DECODE(p_issue_listing_idfr_id, FND_API.G_MISS_NUM, NULL, p_issue_listing_idfr_id),
84: DECODE(p_exchange_id, FND_API.G_MISS_NUM, NULL, p_exchange_id),
85: DECODE(p_issue_id, FND_API.G_MISS_NUM, NULL, p_issue_id),
86: DECODE(p_scheme, FND_API.G_MISS_CHAR, NULL, p_scheme),
87: DECODE(p_value, FND_API.G_MISS_CHAR, NULL, p_value),
80: attribute13,
81: attribute14,
82: attribute15) VALUES
83: (DECODE(p_issue_listing_idfr_id, FND_API.G_MISS_NUM, NULL, p_issue_listing_idfr_id),
84: DECODE(p_exchange_id, FND_API.G_MISS_NUM, NULL, p_exchange_id),
85: DECODE(p_issue_id, FND_API.G_MISS_NUM, NULL, p_issue_id),
86: DECODE(p_scheme, FND_API.G_MISS_CHAR, NULL, p_scheme),
87: DECODE(p_value, FND_API.G_MISS_CHAR, NULL, p_value),
88: DECODE(p_search_code, FND_API.G_MISS_CHAR, NULL, p_search_code),
81: attribute14,
82: attribute15) VALUES
83: (DECODE(p_issue_listing_idfr_id, FND_API.G_MISS_NUM, NULL, p_issue_listing_idfr_id),
84: DECODE(p_exchange_id, FND_API.G_MISS_NUM, NULL, p_exchange_id),
85: DECODE(p_issue_id, FND_API.G_MISS_NUM, NULL, p_issue_id),
86: DECODE(p_scheme, FND_API.G_MISS_CHAR, NULL, p_scheme),
87: DECODE(p_value, FND_API.G_MISS_CHAR, NULL, p_value),
88: DECODE(p_search_code, FND_API.G_MISS_CHAR, NULL, p_search_code),
89: DECODE(p_country_code, FND_API.G_MISS_CHAR, NULL, p_country_code),
82: attribute15) VALUES
83: (DECODE(p_issue_listing_idfr_id, FND_API.G_MISS_NUM, NULL, p_issue_listing_idfr_id),
84: DECODE(p_exchange_id, FND_API.G_MISS_NUM, NULL, p_exchange_id),
85: DECODE(p_issue_id, FND_API.G_MISS_NUM, NULL, p_issue_id),
86: DECODE(p_scheme, FND_API.G_MISS_CHAR, NULL, p_scheme),
87: DECODE(p_value, FND_API.G_MISS_CHAR, NULL, p_value),
88: DECODE(p_search_code, FND_API.G_MISS_CHAR, NULL, p_search_code),
89: DECODE(p_country_code, FND_API.G_MISS_CHAR, NULL, p_country_code),
90: DECODE(p_listing_flag, FND_API.G_MISS_CHAR, NULL, p_listing_flag),
83: (DECODE(p_issue_listing_idfr_id, FND_API.G_MISS_NUM, NULL, p_issue_listing_idfr_id),
84: DECODE(p_exchange_id, FND_API.G_MISS_NUM, NULL, p_exchange_id),
85: DECODE(p_issue_id, FND_API.G_MISS_NUM, NULL, p_issue_id),
86: DECODE(p_scheme, FND_API.G_MISS_CHAR, NULL, p_scheme),
87: DECODE(p_value, FND_API.G_MISS_CHAR, NULL, p_value),
88: DECODE(p_search_code, FND_API.G_MISS_CHAR, NULL, p_search_code),
89: DECODE(p_country_code, FND_API.G_MISS_CHAR, NULL, p_country_code),
90: DECODE(p_listing_flag, FND_API.G_MISS_CHAR, NULL, p_listing_flag),
91: DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
84: DECODE(p_exchange_id, FND_API.G_MISS_NUM, NULL, p_exchange_id),
85: DECODE(p_issue_id, FND_API.G_MISS_NUM, NULL, p_issue_id),
86: DECODE(p_scheme, FND_API.G_MISS_CHAR, NULL, p_scheme),
87: DECODE(p_value, FND_API.G_MISS_CHAR, NULL, p_value),
88: DECODE(p_search_code, FND_API.G_MISS_CHAR, NULL, p_search_code),
89: DECODE(p_country_code, FND_API.G_MISS_CHAR, NULL, p_country_code),
90: DECODE(p_listing_flag, FND_API.G_MISS_CHAR, NULL, p_listing_flag),
91: DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
92: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
85: DECODE(p_issue_id, FND_API.G_MISS_NUM, NULL, p_issue_id),
86: DECODE(p_scheme, FND_API.G_MISS_CHAR, NULL, p_scheme),
87: DECODE(p_value, FND_API.G_MISS_CHAR, NULL, p_value),
88: DECODE(p_search_code, FND_API.G_MISS_CHAR, NULL, p_search_code),
89: DECODE(p_country_code, FND_API.G_MISS_CHAR, NULL, p_country_code),
90: DECODE(p_listing_flag, FND_API.G_MISS_CHAR, NULL, p_listing_flag),
91: DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
92: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
93: DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
86: DECODE(p_scheme, FND_API.G_MISS_CHAR, NULL, p_scheme),
87: DECODE(p_value, FND_API.G_MISS_CHAR, NULL, p_value),
88: DECODE(p_search_code, FND_API.G_MISS_CHAR, NULL, p_search_code),
89: DECODE(p_country_code, FND_API.G_MISS_CHAR, NULL, p_country_code),
90: DECODE(p_listing_flag, FND_API.G_MISS_CHAR, NULL, p_listing_flag),
91: DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
92: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
93: DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
94: DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
87: DECODE(p_value, FND_API.G_MISS_CHAR, NULL, p_value),
88: DECODE(p_search_code, FND_API.G_MISS_CHAR, NULL, p_search_code),
89: DECODE(p_country_code, FND_API.G_MISS_CHAR, NULL, p_country_code),
90: DECODE(p_listing_flag, FND_API.G_MISS_CHAR, NULL, p_listing_flag),
91: DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
92: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
93: DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
94: DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
95: DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
88: DECODE(p_search_code, FND_API.G_MISS_CHAR, NULL, p_search_code),
89: DECODE(p_country_code, FND_API.G_MISS_CHAR, NULL, p_country_code),
90: DECODE(p_listing_flag, FND_API.G_MISS_CHAR, NULL, p_listing_flag),
91: DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
92: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
93: DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
94: DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
95: DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
96: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
89: DECODE(p_country_code, FND_API.G_MISS_CHAR, NULL, p_country_code),
90: DECODE(p_listing_flag, FND_API.G_MISS_CHAR, NULL, p_listing_flag),
91: DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
92: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
93: DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
94: DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
95: DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
96: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
97: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
90: DECODE(p_listing_flag, FND_API.G_MISS_CHAR, NULL, p_listing_flag),
91: DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
92: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
93: DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
94: DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
95: DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
96: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
97: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
98: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
91: DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
92: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
93: DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
94: DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
95: DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
96: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
97: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
98: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
99: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
92: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
93: DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
94: DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
95: DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
96: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
97: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
98: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
99: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
100: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
93: DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
94: DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
95: DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
96: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
97: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
98: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
99: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
100: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
101: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
94: DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
95: DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
96: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
97: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
98: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
99: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
100: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
101: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
102: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
95: DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),
96: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
97: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
98: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
99: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
100: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
101: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
102: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
103: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
96: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
97: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
98: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
99: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
100: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
101: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
102: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
103: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
104: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
97: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
98: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
99: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
100: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
101: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
102: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
103: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
104: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
105: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
98: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
99: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
100: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
101: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
102: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
103: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
104: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
105: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
106: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
99: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
100: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
101: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
102: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
103: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
104: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
105: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
106: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
107: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
100: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
101: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
102: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
103: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
104: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
105: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
106: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
107: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
108: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
101: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
102: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
103: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
104: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
105: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
106: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
107: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
108: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
109: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
102: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
103: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
104: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
105: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
106: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
107: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
108: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
109: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
110: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
103: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
104: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
105: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
106: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
107: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
108: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
109: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
110: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
111: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15));
104: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
105: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
106: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
107: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
108: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
109: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
110: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
111: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15));
112:
105: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
106: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
107: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
108: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
109: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
110: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
111: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15));
112:
113: /*
106: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
107: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
108: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
109: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
110: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
111: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15));
112:
113: /*
114: OPEN c2;
107: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
108: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
109: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
110: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
111: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15));
112:
113: /*
114: OPEN c2;
115: FETCH c2 INTO X_ROWID;
154:
155: BEGIN
156:
157: UPDATE AS_ISSUE_LISTING_IDFR SET
158: exchange_id = DECODE(p_exchange_id, FND_API.G_MISS_NUM, exchange_id, p_exchange_id),
159: issue_id = DECODE(p_issue_id, FND_API.G_MISS_NUM, issue_id, p_issue_id),
160: scheme = DECODE(p_scheme, FND_API.G_MISS_CHAR, scheme, p_scheme),
161: value = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),
162: search_code = DECODE(p_search_code, FND_API.G_MISS_CHAR, search_code, p_search_code),
155: BEGIN
156:
157: UPDATE AS_ISSUE_LISTING_IDFR SET
158: exchange_id = DECODE(p_exchange_id, FND_API.G_MISS_NUM, exchange_id, p_exchange_id),
159: issue_id = DECODE(p_issue_id, FND_API.G_MISS_NUM, issue_id, p_issue_id),
160: scheme = DECODE(p_scheme, FND_API.G_MISS_CHAR, scheme, p_scheme),
161: value = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),
162: search_code = DECODE(p_search_code, FND_API.G_MISS_CHAR, search_code, p_search_code),
163: country_code = DECODE(p_country_code, FND_API.G_MISS_CHAR, country_code, p_country_code),
156:
157: UPDATE AS_ISSUE_LISTING_IDFR SET
158: exchange_id = DECODE(p_exchange_id, FND_API.G_MISS_NUM, exchange_id, p_exchange_id),
159: issue_id = DECODE(p_issue_id, FND_API.G_MISS_NUM, issue_id, p_issue_id),
160: scheme = DECODE(p_scheme, FND_API.G_MISS_CHAR, scheme, p_scheme),
161: value = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),
162: search_code = DECODE(p_search_code, FND_API.G_MISS_CHAR, search_code, p_search_code),
163: country_code = DECODE(p_country_code, FND_API.G_MISS_CHAR, country_code, p_country_code),
164: listing_flag = DECODE(p_listing_flag, FND_API.G_MISS_CHAR, listing_flag, p_listing_flag),
157: UPDATE AS_ISSUE_LISTING_IDFR SET
158: exchange_id = DECODE(p_exchange_id, FND_API.G_MISS_NUM, exchange_id, p_exchange_id),
159: issue_id = DECODE(p_issue_id, FND_API.G_MISS_NUM, issue_id, p_issue_id),
160: scheme = DECODE(p_scheme, FND_API.G_MISS_CHAR, scheme, p_scheme),
161: value = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),
162: search_code = DECODE(p_search_code, FND_API.G_MISS_CHAR, search_code, p_search_code),
163: country_code = DECODE(p_country_code, FND_API.G_MISS_CHAR, country_code, p_country_code),
164: listing_flag = DECODE(p_listing_flag, FND_API.G_MISS_CHAR, listing_flag, p_listing_flag),
165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),
158: exchange_id = DECODE(p_exchange_id, FND_API.G_MISS_NUM, exchange_id, p_exchange_id),
159: issue_id = DECODE(p_issue_id, FND_API.G_MISS_NUM, issue_id, p_issue_id),
160: scheme = DECODE(p_scheme, FND_API.G_MISS_CHAR, scheme, p_scheme),
161: value = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),
162: search_code = DECODE(p_search_code, FND_API.G_MISS_CHAR, search_code, p_search_code),
163: country_code = DECODE(p_country_code, FND_API.G_MISS_CHAR, country_code, p_country_code),
164: listing_flag = DECODE(p_listing_flag, FND_API.G_MISS_CHAR, listing_flag, p_listing_flag),
165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
159: issue_id = DECODE(p_issue_id, FND_API.G_MISS_NUM, issue_id, p_issue_id),
160: scheme = DECODE(p_scheme, FND_API.G_MISS_CHAR, scheme, p_scheme),
161: value = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),
162: search_code = DECODE(p_search_code, FND_API.G_MISS_CHAR, search_code, p_search_code),
163: country_code = DECODE(p_country_code, FND_API.G_MISS_CHAR, country_code, p_country_code),
164: listing_flag = DECODE(p_listing_flag, FND_API.G_MISS_CHAR, listing_flag, p_listing_flag),
165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
167: creation_date = DECODE(p_creation_date, FND_API.G_MISS_DATE, creation_date, p_creation_date),
160: scheme = DECODE(p_scheme, FND_API.G_MISS_CHAR, scheme, p_scheme),
161: value = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),
162: search_code = DECODE(p_search_code, FND_API.G_MISS_CHAR, search_code, p_search_code),
163: country_code = DECODE(p_country_code, FND_API.G_MISS_CHAR, country_code, p_country_code),
164: listing_flag = DECODE(p_listing_flag, FND_API.G_MISS_CHAR, listing_flag, p_listing_flag),
165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
167: creation_date = DECODE(p_creation_date, FND_API.G_MISS_DATE, creation_date, p_creation_date),
168: created_by = DECODE(p_created_by, FND_API.G_MISS_NUM, created_by, p_created_by),
161: value = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),
162: search_code = DECODE(p_search_code, FND_API.G_MISS_CHAR, search_code, p_search_code),
163: country_code = DECODE(p_country_code, FND_API.G_MISS_CHAR, country_code, p_country_code),
164: listing_flag = DECODE(p_listing_flag, FND_API.G_MISS_CHAR, listing_flag, p_listing_flag),
165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
167: creation_date = DECODE(p_creation_date, FND_API.G_MISS_DATE, creation_date, p_creation_date),
168: created_by = DECODE(p_created_by, FND_API.G_MISS_NUM, created_by, p_created_by),
169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
162: search_code = DECODE(p_search_code, FND_API.G_MISS_CHAR, search_code, p_search_code),
163: country_code = DECODE(p_country_code, FND_API.G_MISS_CHAR, country_code, p_country_code),
164: listing_flag = DECODE(p_listing_flag, FND_API.G_MISS_CHAR, listing_flag, p_listing_flag),
165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
167: creation_date = DECODE(p_creation_date, FND_API.G_MISS_DATE, creation_date, p_creation_date),
168: created_by = DECODE(p_created_by, FND_API.G_MISS_NUM, created_by, p_created_by),
169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
170: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
163: country_code = DECODE(p_country_code, FND_API.G_MISS_CHAR, country_code, p_country_code),
164: listing_flag = DECODE(p_listing_flag, FND_API.G_MISS_CHAR, listing_flag, p_listing_flag),
165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
167: creation_date = DECODE(p_creation_date, FND_API.G_MISS_DATE, creation_date, p_creation_date),
168: created_by = DECODE(p_created_by, FND_API.G_MISS_NUM, created_by, p_created_by),
169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
170: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
171: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
164: listing_flag = DECODE(p_listing_flag, FND_API.G_MISS_CHAR, listing_flag, p_listing_flag),
165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
167: creation_date = DECODE(p_creation_date, FND_API.G_MISS_DATE, creation_date, p_creation_date),
168: created_by = DECODE(p_created_by, FND_API.G_MISS_NUM, created_by, p_created_by),
169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
170: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
171: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
172: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
167: creation_date = DECODE(p_creation_date, FND_API.G_MISS_DATE, creation_date, p_creation_date),
168: created_by = DECODE(p_created_by, FND_API.G_MISS_NUM, created_by, p_created_by),
169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
170: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
171: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
172: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
173: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
167: creation_date = DECODE(p_creation_date, FND_API.G_MISS_DATE, creation_date, p_creation_date),
168: created_by = DECODE(p_created_by, FND_API.G_MISS_NUM, created_by, p_created_by),
169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
170: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
171: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
172: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
173: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
174: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
167: creation_date = DECODE(p_creation_date, FND_API.G_MISS_DATE, creation_date, p_creation_date),
168: created_by = DECODE(p_created_by, FND_API.G_MISS_NUM, created_by, p_created_by),
169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
170: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
171: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
172: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
173: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
174: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
175: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
168: created_by = DECODE(p_created_by, FND_API.G_MISS_NUM, created_by, p_created_by),
169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
170: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
171: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
172: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
173: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
174: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
175: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
176: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
170: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
171: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
172: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
173: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
174: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
175: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
176: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
177: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
170: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
171: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
172: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
173: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
174: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
175: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
176: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
177: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
178: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
171: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
172: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
173: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
174: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
175: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
176: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
177: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
178: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
179: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
172: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
173: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
174: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
175: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
176: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
177: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
178: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
179: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
180: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
173: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
174: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
175: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
176: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
177: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
178: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
179: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
180: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
181: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
174: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
175: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
176: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
177: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
178: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
179: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
180: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
181: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
182: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
175: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
176: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
177: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
178: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
179: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
180: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
181: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
182: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
183: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
176: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
177: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
178: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
179: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
180: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
181: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
182: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
183: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
184: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
177: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
178: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
179: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
180: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
181: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
182: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
183: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
184: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
185: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
178: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
179: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
180: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
181: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
182: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
183: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
184: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
185: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
186: WHERE issue_listing_idfr_id = p_issue_listing_idfr_id;
179: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
180: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
181: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
182: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
183: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
184: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
185: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
186: WHERE issue_listing_idfr_id = p_issue_listing_idfr_id;
187:
180: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
181: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
182: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
183: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
184: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
185: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
186: WHERE issue_listing_idfr_id = p_issue_listing_idfr_id;
187:
188: IF (SQL%NOTFOUND) THEN
181: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
182: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
183: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
184: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
185: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
186: WHERE issue_listing_idfr_id = p_issue_listing_idfr_id;
187:
188: IF (SQL%NOTFOUND) THEN
189: RAISE NO_DATA_FOUND;