APPS.AMS_IBA_PS_POSTINGS_B_PKG dependencies on FND_API

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

90: attribute14,
91: attribute15
92:
93: ) VALUES (
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

91: attribute15
92:
93: ) VALUES (
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

92:
93: ) VALUES (
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),

Line 97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

93: ) VALUES (
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),

Line 98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),

Line 99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),

Line 100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),

96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),

Line 101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),

97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

Line 102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),

98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

Line 103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),

99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
107: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

Line 104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),

100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
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_status_code, FND_API.g_miss_char, NULL, p_status_code),

101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
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_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
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_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
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_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
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_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
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_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
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:

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:
123:

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:
123:
124: INSERT INTO ams_iba_ps_postings_tl (

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:
123:
124: INSERT INTO ams_iba_ps_postings_tl (
125: created_by,

Line 143: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

139: SYSDATE,
140: SYSDATE,
141: FND_GLOBAL.conc_login_id,
142: FND_GLOBAL.conc_login_id,
143: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
144: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
145: decode( p_posting_name, FND_API.G_MISS_CHAR, NULL, p_posting_name),
146: decode( p_display_name, FND_API.G_MISS_CHAR, NULL, p_display_name),
147: decode( p_posting_description, FND_API.G_MISS_CHAR, NULL, p_posting_description),

Line 144: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),

140: SYSDATE,
141: FND_GLOBAL.conc_login_id,
142: FND_GLOBAL.conc_login_id,
143: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
144: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
145: decode( p_posting_name, FND_API.G_MISS_CHAR, NULL, p_posting_name),
146: decode( p_display_name, FND_API.G_MISS_CHAR, NULL, p_display_name),
147: decode( p_posting_description, FND_API.G_MISS_CHAR, NULL, p_posting_description),
148: l.language_code,

Line 145: decode( p_posting_name, FND_API.G_MISS_CHAR, NULL, p_posting_name),

141: FND_GLOBAL.conc_login_id,
142: FND_GLOBAL.conc_login_id,
143: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
144: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
145: decode( p_posting_name, FND_API.G_MISS_CHAR, NULL, p_posting_name),
146: decode( p_display_name, FND_API.G_MISS_CHAR, NULL, p_display_name),
147: decode( p_posting_description, FND_API.G_MISS_CHAR, NULL, p_posting_description),
148: l.language_code,
149: USERENV('LANG')

Line 146: decode( p_display_name, FND_API.G_MISS_CHAR, NULL, p_display_name),

142: FND_GLOBAL.conc_login_id,
143: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
144: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
145: decode( p_posting_name, FND_API.G_MISS_CHAR, NULL, p_posting_name),
146: decode( p_display_name, FND_API.G_MISS_CHAR, NULL, p_display_name),
147: decode( p_posting_description, FND_API.G_MISS_CHAR, NULL, p_posting_description),
148: l.language_code,
149: USERENV('LANG')
150: FROM fnd_languages l

Line 147: decode( p_posting_description, FND_API.G_MISS_CHAR, NULL, p_posting_description),

143: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
144: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
145: decode( p_posting_name, FND_API.G_MISS_CHAR, NULL, p_posting_name),
146: decode( p_display_name, FND_API.G_MISS_CHAR, NULL, p_display_name),
147: decode( p_posting_description, FND_API.G_MISS_CHAR, NULL, p_posting_description),
148: l.language_code,
149: USERENV('LANG')
150: FROM fnd_languages l
151: WHERE l.installed_flag IN ('I', 'B')

Line 155: WHERE t.posting_id = DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id)

151: WHERE l.installed_flag IN ('I', 'B')
152: AND NOT EXISTS
153: (SELECT null
154: FROM ams_iba_ps_postings_tl t
155: WHERE t.posting_id = DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id)
156: AND t.language = l.language_code);
157:
158: END Insert_Row;
159:

Line 214: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

210: IS
211: BEGIN
212: Update AMS_IBA_PS_POSTINGS_B
213: SET
214: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

211: BEGIN
212: Update AMS_IBA_PS_POSTINGS_B
213: SET
214: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

212: Update AMS_IBA_PS_POSTINGS_B
213: SET
214: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),

Line 217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

213: SET
214: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),

Line 218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

214: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),

Line 219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),

Line 220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),

216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),

Line 221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),

217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),

Line 222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),

218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

Line 223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),

219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),

Line 224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),

220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),

Line 225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),

221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),

Line 226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),

Line 227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),

223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),

Line 228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),

224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),

Line 229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),

225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),

Line 230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),

226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),

Line 231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),

227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),

Line 232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),

228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),

Line 233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),

229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),

Line 234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),

230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),

Line 235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),

231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),

Line 236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),

232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),

Line 237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),

233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
241: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)

Line 238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),

234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
241: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
242:

Line 239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),

235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
241: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
242:
243: WHERE posting_id = p_posting_id

Line 240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),

236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
241: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
242:
243: WHERE posting_id = p_posting_id
244: AND object_version_number = p_object_version_number;

Line 241: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)

237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
241: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
242:
243: WHERE posting_id = p_posting_id
244: AND object_version_number = p_object_version_number;
245:

Line 247: RAISE FND_API.G_EXC_ERROR;

243: WHERE posting_id = p_posting_id
244: AND object_version_number = p_object_version_number;
245:
246: IF (SQL%NOTFOUND) THEN
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249:
250:
251: UPDATE ams_iba_ps_postings_tl SET

Line 252: posting_name = decode( p_posting_name, FND_API.G_MISS_CHAR, posting_name, p_posting_name),

248: END IF;
249:
250:
251: UPDATE ams_iba_ps_postings_tl SET
252: posting_name = decode( p_posting_name, FND_API.G_MISS_CHAR, posting_name, p_posting_name),
253: display_name = decode( p_display_name, FND_API.G_MISS_CHAR, display_name, p_posting_name),
254: posting_description = decode( p_posting_description, FND_API.G_MISS_CHAR, posting_description, p_posting_description),
255: last_update_date = SYSDATE,
256: last_updated_by = FND_GLOBAL.user_id,

Line 253: display_name = decode( p_display_name, FND_API.G_MISS_CHAR, display_name, p_posting_name),

249:
250:
251: UPDATE ams_iba_ps_postings_tl SET
252: posting_name = decode( p_posting_name, FND_API.G_MISS_CHAR, posting_name, p_posting_name),
253: display_name = decode( p_display_name, FND_API.G_MISS_CHAR, display_name, p_posting_name),
254: posting_description = decode( p_posting_description, FND_API.G_MISS_CHAR, posting_description, p_posting_description),
255: last_update_date = SYSDATE,
256: last_updated_by = FND_GLOBAL.user_id,
257: last_update_login = FND_GLOBAL.conc_login_id,

Line 254: posting_description = decode( p_posting_description, FND_API.G_MISS_CHAR, posting_description, p_posting_description),

250:
251: UPDATE ams_iba_ps_postings_tl SET
252: posting_name = decode( p_posting_name, FND_API.G_MISS_CHAR, posting_name, p_posting_name),
253: display_name = decode( p_display_name, FND_API.G_MISS_CHAR, display_name, p_posting_name),
254: posting_description = decode( p_posting_description, FND_API.G_MISS_CHAR, posting_description, p_posting_description),
255: last_update_date = SYSDATE,
256: last_updated_by = FND_GLOBAL.user_id,
257: last_update_login = FND_GLOBAL.conc_login_id,
258: source_lang = USERENV('LANG')

Line 263: RAISE FND_API.G_EXC_ERROR;

259: WHERE posting_id = p_posting_id
260: AND USERENV('LANG') IN (language, source_lang);
261:
262: IF (SQL%NOTFOUND) THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: END Update_Row;
267:

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

287: BEGIN
288: DELETE FROM AMS_IBA_PS_POSTINGS_B
289: WHERE POSTING_ID = p_POSTING_ID;
290: If (SQL%NOTFOUND) then
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: End If;
293: END Delete_Row ;
294:
295: