APPS.AS_ISSUE_LISTING_IDFR_PKG dependencies on FND_API

Line 47: IF (p_issue_listing_idfr_id IS NULL) OR (p_issue_listing_idfr_id = FND_API.G_MISS_NUM) THEN

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;

Line 83: (DECODE(p_issue_listing_idfr_id, FND_API.G_MISS_NUM, NULL, p_issue_listing_idfr_id),

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

Line 84: DECODE(p_exchange_id, FND_API.G_MISS_NUM, NULL, p_exchange_id),

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

Line 85: DECODE(p_issue_id, FND_API.G_MISS_NUM, NULL, p_issue_id),

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

Line 86: DECODE(p_scheme, FND_API.G_MISS_CHAR, NULL, p_scheme),

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

Line 87: DECODE(p_value, FND_API.G_MISS_CHAR, NULL, p_value),

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

Line 88: DECODE(p_search_code, FND_API.G_MISS_CHAR, NULL, p_search_code),

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

Line 89: DECODE(p_country_code, FND_API.G_MISS_CHAR, NULL, p_country_code),

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

Line 90: DECODE(p_listing_flag, FND_API.G_MISS_CHAR, NULL, p_listing_flag),

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

Line 91: DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),

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

Line 92: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

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

Line 93: DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),

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

Line 94: DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),

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

Line 95: DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login),

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

Line 96: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),

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

Line 97: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),

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

Line 98: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),

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

Line 99: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),

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

Line 100: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

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

Line 101: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

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

Line 102: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

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

Line 103: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

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

Line 104: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

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

Line 105: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

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

Line 106: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

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

Line 107: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

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

Line 108: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

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:

Line 109: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

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: /*

Line 110: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

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;

Line 111: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15));

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;

Line 158: exchange_id = DECODE(p_exchange_id, FND_API.G_MISS_NUM, exchange_id, p_exchange_id),

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

Line 159: issue_id = DECODE(p_issue_id, FND_API.G_MISS_NUM, issue_id, p_issue_id),

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

Line 160: scheme = DECODE(p_scheme, FND_API.G_MISS_CHAR, scheme, p_scheme),

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

Line 161: value = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),

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

Line 162: search_code = DECODE(p_search_code, FND_API.G_MISS_CHAR, search_code, p_search_code),

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

Line 163: country_code = DECODE(p_country_code, FND_API.G_MISS_CHAR, country_code, p_country_code),

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

Line 164: listing_flag = DECODE(p_listing_flag, FND_API.G_MISS_CHAR, listing_flag, p_listing_flag),

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

Line 165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),

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

Line 166: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),

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

Line 167: creation_date = DECODE(p_creation_date, FND_API.G_MISS_DATE, creation_date, p_creation_date),

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

Line 168: created_by = DECODE(p_created_by, FND_API.G_MISS_NUM, created_by, p_created_by),

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

Line 169: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),

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

Line 170: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),

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

Line 171: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),

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

Line 172: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),

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

Line 173: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),

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

Line 174: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),

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

Line 175: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),

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

Line 176: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),

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

Line 177: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),

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

Line 178: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),

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

Line 179: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),

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

Line 180: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),

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

Line 181: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),

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)

Line 182: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),

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;

Line 183: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),

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:

Line 184: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),

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

Line 185: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)

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;