APPS.AMS_IBA_PL_PLACEMENTS_B_PKG dependencies on FND_API

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

90: last_update_date,
91: last_update_login,
92: object_version_number
93: ) VALUES (
94: DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
95: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
96: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
97: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
98: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),

Line 95: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),

91: last_update_login,
92: object_version_number
93: ) VALUES (
94: DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
95: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
96: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
97: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
98: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
99: DECODE( p_location_code, FND_API.g_miss_char, NULL, p_location_code),

Line 96: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),

92: object_version_number
93: ) VALUES (
94: DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
95: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
96: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
97: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
98: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
99: DECODE( p_location_code, FND_API.g_miss_char, NULL, p_location_code),
100: DECODE( p_param1, FND_API.g_miss_char, NULL, p_param1),

Line 97: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),

93: ) VALUES (
94: DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
95: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
96: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
97: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
98: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
99: DECODE( p_location_code, FND_API.g_miss_char, NULL, p_location_code),
100: DECODE( p_param1, FND_API.g_miss_char, NULL, p_param1),
101: DECODE( p_param2, FND_API.g_miss_char, NULL, p_param2),

Line 98: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),

94: DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
95: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
96: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
97: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
98: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
99: DECODE( p_location_code, FND_API.g_miss_char, NULL, p_location_code),
100: DECODE( p_param1, FND_API.g_miss_char, NULL, p_param1),
101: DECODE( p_param2, FND_API.g_miss_char, NULL, p_param2),
102: DECODE( p_param3, FND_API.g_miss_char, NULL, p_param3),

Line 99: DECODE( p_location_code, FND_API.g_miss_char, NULL, p_location_code),

95: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
96: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
97: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
98: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
99: DECODE( p_location_code, FND_API.g_miss_char, NULL, p_location_code),
100: DECODE( p_param1, FND_API.g_miss_char, NULL, p_param1),
101: DECODE( p_param2, FND_API.g_miss_char, NULL, p_param2),
102: DECODE( p_param3, FND_API.g_miss_char, NULL, p_param3),
103: DECODE( p_param4, FND_API.g_miss_char, NULL, p_param4),

Line 100: DECODE( p_param1, FND_API.g_miss_char, NULL, p_param1),

96: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
97: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
98: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
99: DECODE( p_location_code, FND_API.g_miss_char, NULL, p_location_code),
100: DECODE( p_param1, FND_API.g_miss_char, NULL, p_param1),
101: DECODE( p_param2, FND_API.g_miss_char, NULL, p_param2),
102: DECODE( p_param3, FND_API.g_miss_char, NULL, p_param3),
103: DECODE( p_param4, FND_API.g_miss_char, NULL, p_param4),
104: DECODE( p_param5, FND_API.g_miss_char, NULL, p_param5),

Line 101: DECODE( p_param2, FND_API.g_miss_char, NULL, p_param2),

97: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
98: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
99: DECODE( p_location_code, FND_API.g_miss_char, NULL, p_location_code),
100: DECODE( p_param1, FND_API.g_miss_char, NULL, p_param1),
101: DECODE( p_param2, FND_API.g_miss_char, NULL, p_param2),
102: DECODE( p_param3, FND_API.g_miss_char, NULL, p_param3),
103: DECODE( p_param4, FND_API.g_miss_char, NULL, p_param4),
104: DECODE( p_param5, FND_API.g_miss_char, NULL, p_param5),
105: DECODE( p_stylesheet_id, FND_API.g_miss_num, NULL, p_stylesheet_id),

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

98: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
99: DECODE( p_location_code, FND_API.g_miss_char, NULL, p_location_code),
100: DECODE( p_param1, FND_API.g_miss_char, NULL, p_param1),
101: DECODE( p_param2, FND_API.g_miss_char, NULL, p_param2),
102: DECODE( p_param3, FND_API.g_miss_char, NULL, p_param3),
103: DECODE( p_param4, FND_API.g_miss_char, NULL, p_param4),
104: DECODE( p_param5, FND_API.g_miss_char, NULL, p_param5),
105: DECODE( p_stylesheet_id, FND_API.g_miss_num, NULL, p_stylesheet_id),
106: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),

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

99: DECODE( p_location_code, FND_API.g_miss_char, NULL, p_location_code),
100: DECODE( p_param1, FND_API.g_miss_char, NULL, p_param1),
101: DECODE( p_param2, FND_API.g_miss_char, NULL, p_param2),
102: DECODE( p_param3, FND_API.g_miss_char, NULL, p_param3),
103: DECODE( p_param4, FND_API.g_miss_char, NULL, p_param4),
104: DECODE( p_param5, FND_API.g_miss_char, NULL, p_param5),
105: DECODE( p_stylesheet_id, FND_API.g_miss_num, NULL, p_stylesheet_id),
106: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
107: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

Line 104: DECODE( p_param5, FND_API.g_miss_char, NULL, p_param5),

100: DECODE( p_param1, FND_API.g_miss_char, NULL, p_param1),
101: DECODE( p_param2, FND_API.g_miss_char, NULL, p_param2),
102: DECODE( p_param3, FND_API.g_miss_char, NULL, p_param3),
103: DECODE( p_param4, FND_API.g_miss_char, NULL, p_param4),
104: DECODE( p_param5, FND_API.g_miss_char, NULL, p_param5),
105: DECODE( p_stylesheet_id, FND_API.g_miss_num, NULL, p_stylesheet_id),
106: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
107: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
108: DECODE( p_track_events_flag, FND_API.g_miss_char, NULL, p_track_events_flag),

Line 105: DECODE( p_stylesheet_id, FND_API.g_miss_num, NULL, p_stylesheet_id),

101: DECODE( p_param2, FND_API.g_miss_char, NULL, p_param2),
102: DECODE( p_param3, FND_API.g_miss_char, NULL, p_param3),
103: DECODE( p_param4, FND_API.g_miss_char, NULL, p_param4),
104: DECODE( p_param5, FND_API.g_miss_char, NULL, p_param5),
105: DECODE( p_stylesheet_id, FND_API.g_miss_num, NULL, p_stylesheet_id),
106: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
107: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
108: DECODE( p_track_events_flag, FND_API.g_miss_char, NULL, p_track_events_flag),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 106: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),

102: DECODE( p_param3, FND_API.g_miss_char, NULL, p_param3),
103: DECODE( p_param4, FND_API.g_miss_char, NULL, p_param4),
104: DECODE( p_param5, FND_API.g_miss_char, NULL, p_param5),
105: DECODE( p_stylesheet_id, FND_API.g_miss_num, NULL, p_stylesheet_id),
106: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
107: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
108: DECODE( p_track_events_flag, FND_API.g_miss_char, NULL, p_track_events_flag),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 107: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

103: DECODE( p_param4, FND_API.g_miss_char, NULL, p_param4),
104: DECODE( p_param5, FND_API.g_miss_char, NULL, p_param5),
105: DECODE( p_stylesheet_id, FND_API.g_miss_num, NULL, p_stylesheet_id),
106: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
107: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
108: DECODE( p_track_events_flag, FND_API.g_miss_char, NULL, p_track_events_flag),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 108: DECODE( p_track_events_flag, FND_API.g_miss_char, NULL, p_track_events_flag),

104: DECODE( p_param5, FND_API.g_miss_char, NULL, p_param5),
105: DECODE( p_stylesheet_id, FND_API.g_miss_num, NULL, p_stylesheet_id),
106: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
107: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
108: DECODE( p_track_events_flag, FND_API.g_miss_char, NULL, p_track_events_flag),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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

105: DECODE( p_stylesheet_id, FND_API.g_miss_num, NULL, p_stylesheet_id),
106: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
107: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
108: DECODE( p_track_events_flag, FND_API.g_miss_char, NULL, p_track_events_flag),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

106: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
107: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
108: DECODE( p_track_events_flag, FND_API.g_miss_char, NULL, p_track_events_flag),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

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

107: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
108: DECODE( p_track_events_flag, FND_API.g_miss_char, NULL, p_track_events_flag),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
115:

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

108: DECODE( p_track_events_flag, FND_API.g_miss_char, NULL, p_track_events_flag),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
115:
116: insert into AMS_IBA_PL_PLACEMENTS_TL (

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

109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
115:
116: insert into AMS_IBA_PL_PLACEMENTS_TL (
117: PLACEMENT_ID,

Line 114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

110: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
115:
116: insert into AMS_IBA_PL_PLACEMENTS_TL (
117: PLACEMENT_ID,
118: NAME,

Line 129: DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),

125: OBJECT_VERSION_NUMBER,
126: LANGUAGE,
127: SOURCE_LANG
128: ) select
129: DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
130: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 130: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),

126: LANGUAGE,
127: SOURCE_LANG
128: ) select
129: DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
130: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),

127: SOURCE_LANG
128: ) select
129: DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
130: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
135: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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

128: ) select
129: DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
130: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
135: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
136: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

129: DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
130: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
135: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
136: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
137: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

130: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
135: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
136: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
137: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
138: l.language_code,

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

131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
135: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
136: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
137: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
138: l.language_code,
139: userenv('LANG')

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

132: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
135: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
136: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
137: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
138: l.language_code,
139: userenv('LANG')
140: FROM fnd_languages l

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

133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
135: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
136: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
137: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
138: l.language_code,
139: userenv('LANG')
140: FROM fnd_languages l
141: WHERE l.installed_flag IN ('I', 'B')

Line 145: WHERE t.placement_id = DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id)

141: WHERE l.installed_flag IN ('I', 'B')
142: AND NOT EXISTS
143: (SELECT NULL
144: FROM ams_iba_pl_placements_tl t
145: WHERE t.placement_id = DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id)
146: AND t.language = l.language_code);
147:
148: END Insert_Row;
149:

Line 196: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),

192: IS
193: BEGIN
194: Update AMS_IBA_PL_PLACEMENTS_B
195: SET
196: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
197: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
198: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
199: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
200: location_code = DECODE( p_location_code, FND_API.g_miss_char, location_code, p_location_code),

Line 197: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),

193: BEGIN
194: Update AMS_IBA_PL_PLACEMENTS_B
195: SET
196: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
197: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
198: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
199: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
200: location_code = DECODE( p_location_code, FND_API.g_miss_char, location_code, p_location_code),
201: param1 = DECODE( p_param1, FND_API.g_miss_char, param1, p_param1),

Line 198: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),

194: Update AMS_IBA_PL_PLACEMENTS_B
195: SET
196: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
197: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
198: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
199: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
200: location_code = DECODE( p_location_code, FND_API.g_miss_char, location_code, p_location_code),
201: param1 = DECODE( p_param1, FND_API.g_miss_char, param1, p_param1),
202: param2 = DECODE( p_param2, FND_API.g_miss_char, param2, p_param2),

Line 199: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),

195: SET
196: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
197: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
198: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
199: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
200: location_code = DECODE( p_location_code, FND_API.g_miss_char, location_code, p_location_code),
201: param1 = DECODE( p_param1, FND_API.g_miss_char, param1, p_param1),
202: param2 = DECODE( p_param2, FND_API.g_miss_char, param2, p_param2),
203: param3 = DECODE( p_param3, FND_API.g_miss_char, param3, p_param3),

Line 200: location_code = DECODE( p_location_code, FND_API.g_miss_char, location_code, p_location_code),

196: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
197: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
198: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
199: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
200: location_code = DECODE( p_location_code, FND_API.g_miss_char, location_code, p_location_code),
201: param1 = DECODE( p_param1, FND_API.g_miss_char, param1, p_param1),
202: param2 = DECODE( p_param2, FND_API.g_miss_char, param2, p_param2),
203: param3 = DECODE( p_param3, FND_API.g_miss_char, param3, p_param3),
204: param4 = DECODE( p_param4, FND_API.g_miss_char, param4, p_param4),

Line 201: param1 = DECODE( p_param1, FND_API.g_miss_char, param1, p_param1),

197: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
198: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
199: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
200: location_code = DECODE( p_location_code, FND_API.g_miss_char, location_code, p_location_code),
201: param1 = DECODE( p_param1, FND_API.g_miss_char, param1, p_param1),
202: param2 = DECODE( p_param2, FND_API.g_miss_char, param2, p_param2),
203: param3 = DECODE( p_param3, FND_API.g_miss_char, param3, p_param3),
204: param4 = DECODE( p_param4, FND_API.g_miss_char, param4, p_param4),
205: param5 = DECODE( p_param5, FND_API.g_miss_char, param5, p_param5),

Line 202: param2 = DECODE( p_param2, FND_API.g_miss_char, param2, p_param2),

198: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
199: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
200: location_code = DECODE( p_location_code, FND_API.g_miss_char, location_code, p_location_code),
201: param1 = DECODE( p_param1, FND_API.g_miss_char, param1, p_param1),
202: param2 = DECODE( p_param2, FND_API.g_miss_char, param2, p_param2),
203: param3 = DECODE( p_param3, FND_API.g_miss_char, param3, p_param3),
204: param4 = DECODE( p_param4, FND_API.g_miss_char, param4, p_param4),
205: param5 = DECODE( p_param5, FND_API.g_miss_char, param5, p_param5),
206: stylesheet_id = DECODE( p_stylesheet_id, FND_API.g_miss_num, stylesheet_id, p_stylesheet_id),

Line 203: param3 = DECODE( p_param3, FND_API.g_miss_char, param3, p_param3),

199: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
200: location_code = DECODE( p_location_code, FND_API.g_miss_char, location_code, p_location_code),
201: param1 = DECODE( p_param1, FND_API.g_miss_char, param1, p_param1),
202: param2 = DECODE( p_param2, FND_API.g_miss_char, param2, p_param2),
203: param3 = DECODE( p_param3, FND_API.g_miss_char, param3, p_param3),
204: param4 = DECODE( p_param4, FND_API.g_miss_char, param4, p_param4),
205: param5 = DECODE( p_param5, FND_API.g_miss_char, param5, p_param5),
206: stylesheet_id = DECODE( p_stylesheet_id, FND_API.g_miss_num, stylesheet_id, p_stylesheet_id),
207: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),

Line 204: param4 = DECODE( p_param4, FND_API.g_miss_char, param4, p_param4),

200: location_code = DECODE( p_location_code, FND_API.g_miss_char, location_code, p_location_code),
201: param1 = DECODE( p_param1, FND_API.g_miss_char, param1, p_param1),
202: param2 = DECODE( p_param2, FND_API.g_miss_char, param2, p_param2),
203: param3 = DECODE( p_param3, FND_API.g_miss_char, param3, p_param3),
204: param4 = DECODE( p_param4, FND_API.g_miss_char, param4, p_param4),
205: param5 = DECODE( p_param5, FND_API.g_miss_char, param5, p_param5),
206: stylesheet_id = DECODE( p_stylesheet_id, FND_API.g_miss_num, stylesheet_id, p_stylesheet_id),
207: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
208: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),

Line 205: param5 = DECODE( p_param5, FND_API.g_miss_char, param5, p_param5),

201: param1 = DECODE( p_param1, FND_API.g_miss_char, param1, p_param1),
202: param2 = DECODE( p_param2, FND_API.g_miss_char, param2, p_param2),
203: param3 = DECODE( p_param3, FND_API.g_miss_char, param3, p_param3),
204: param4 = DECODE( p_param4, FND_API.g_miss_char, param4, p_param4),
205: param5 = DECODE( p_param5, FND_API.g_miss_char, param5, p_param5),
206: stylesheet_id = DECODE( p_stylesheet_id, FND_API.g_miss_num, stylesheet_id, p_stylesheet_id),
207: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
208: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
209: track_events_flag = DECODE( p_track_events_flag, FND_API.g_miss_char, track_events_flag, p_track_events_flag),

Line 206: stylesheet_id = DECODE( p_stylesheet_id, FND_API.g_miss_num, stylesheet_id, p_stylesheet_id),

202: param2 = DECODE( p_param2, FND_API.g_miss_char, param2, p_param2),
203: param3 = DECODE( p_param3, FND_API.g_miss_char, param3, p_param3),
204: param4 = DECODE( p_param4, FND_API.g_miss_char, param4, p_param4),
205: param5 = DECODE( p_param5, FND_API.g_miss_char, param5, p_param5),
206: stylesheet_id = DECODE( p_stylesheet_id, FND_API.g_miss_num, stylesheet_id, p_stylesheet_id),
207: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
208: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
209: track_events_flag = DECODE( p_track_events_flag, FND_API.g_miss_char, track_events_flag, p_track_events_flag),
210: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

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

203: param3 = DECODE( p_param3, FND_API.g_miss_char, param3, p_param3),
204: param4 = DECODE( p_param4, FND_API.g_miss_char, param4, p_param4),
205: param5 = DECODE( p_param5, FND_API.g_miss_char, param5, p_param5),
206: stylesheet_id = DECODE( p_stylesheet_id, FND_API.g_miss_num, stylesheet_id, p_stylesheet_id),
207: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
208: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
209: track_events_flag = DECODE( p_track_events_flag, FND_API.g_miss_char, track_events_flag, p_track_events_flag),
210: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
211: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

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

204: param4 = DECODE( p_param4, FND_API.g_miss_char, param4, p_param4),
205: param5 = DECODE( p_param5, FND_API.g_miss_char, param5, p_param5),
206: stylesheet_id = DECODE( p_stylesheet_id, FND_API.g_miss_num, stylesheet_id, p_stylesheet_id),
207: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
208: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
209: track_events_flag = DECODE( p_track_events_flag, FND_API.g_miss_char, track_events_flag, p_track_events_flag),
210: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
211: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
212: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 209: track_events_flag = DECODE( p_track_events_flag, FND_API.g_miss_char, track_events_flag, p_track_events_flag),

205: param5 = DECODE( p_param5, FND_API.g_miss_char, param5, p_param5),
206: stylesheet_id = DECODE( p_stylesheet_id, FND_API.g_miss_num, stylesheet_id, p_stylesheet_id),
207: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
208: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
209: track_events_flag = DECODE( p_track_events_flag, FND_API.g_miss_char, track_events_flag, p_track_events_flag),
210: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
211: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
212: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
213: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)

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

206: stylesheet_id = DECODE( p_stylesheet_id, FND_API.g_miss_num, stylesheet_id, p_stylesheet_id),
207: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
208: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
209: track_events_flag = DECODE( p_track_events_flag, FND_API.g_miss_char, track_events_flag, p_track_events_flag),
210: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
211: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
212: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
213: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
214: WHERE PLACEMENT_ID = p_PLACEMENT_ID

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

207: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
208: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
209: track_events_flag = DECODE( p_track_events_flag, FND_API.g_miss_char, track_events_flag, p_track_events_flag),
210: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
211: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
212: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
213: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
214: WHERE PLACEMENT_ID = p_PLACEMENT_ID
215: AND object_version_number = p_object_version_number;

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

208: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
209: track_events_flag = DECODE( p_track_events_flag, FND_API.g_miss_char, track_events_flag, p_track_events_flag),
210: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
211: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
212: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
213: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
214: WHERE PLACEMENT_ID = p_PLACEMENT_ID
215: AND object_version_number = p_object_version_number;
216:

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

209: track_events_flag = DECODE( p_track_events_flag, FND_API.g_miss_char, track_events_flag, p_track_events_flag),
210: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
211: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
212: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
213: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
214: WHERE PLACEMENT_ID = p_PLACEMENT_ID
215: AND object_version_number = p_object_version_number;
216:
217: IF (SQL%NOTFOUND) THEN

Line 218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

214: WHERE PLACEMENT_ID = p_PLACEMENT_ID
215: AND object_version_number = p_object_version_number;
216:
217: IF (SQL%NOTFOUND) THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220:
221: UPDATE ams_iba_pl_placements_tl SET
222: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),

Line 222: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),

218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220:
221: UPDATE ams_iba_pl_placements_tl SET
222: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
223: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 223: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),

219: END IF;
220:
221: UPDATE ams_iba_pl_placements_tl SET
222: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
223: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
227: source_lang = USERENV('LANG')

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

220:
221: UPDATE ams_iba_pl_placements_tl SET
222: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
223: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
227: source_lang = USERENV('LANG')
228: WHERE placement_id = p_placement_id

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

221: UPDATE ams_iba_pl_placements_tl SET
222: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
223: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
227: source_lang = USERENV('LANG')
228: WHERE placement_id = p_placement_id
229: AND USERENV('LANG') IN (language, source_lang);

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

222: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
223: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
226: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
227: source_lang = USERENV('LANG')
228: WHERE placement_id = p_placement_id
229: AND USERENV('LANG') IN (language, source_lang);
230:

Line 232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

228: WHERE placement_id = p_placement_id
229: AND USERENV('LANG') IN (language, source_lang);
230:
231: IF (SQL%NOTFOUND) THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:
235: END Update_Row;
236:

Line 263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

259: DELETE FROM ams_iba_pl_placements_tl
260: WHERE placement_id = p_placement_id;
261:
262: If (SQL%NOTFOUND) then
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: End If;
265:
266:
267: DELETE FROM ams_iba_pl_placements_b

Line 271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

267: DELETE FROM ams_iba_pl_placements_b
268: WHERE placement_id = p_placement_id;
269:
270: If (SQL%NOTFOUND) then
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: End If;
273:
274: END Delete_Row ;
275: