eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PARTNER_PROGRAM_PKG dependencies on FND_API

Line 177: DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)

173: ,created_by
174: ,last_update_login
175: ,object_version_number
176: ) VALUES (
177: DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
178: ,DECODE( p_PROGRAM_TYPE_ID, NULL, p_PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)
179: ,DECODE( p_custom_setup_id, NULL,p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id)
180: ,DECODE( p_program_level_code, NULL, p_program_level_code, FND_API.g_miss_char, NULL, p_program_level_code)
181: ,DECODE( p_program_parent_id, NULL, p_program_parent_id,FND_API.g_miss_num, NULL, p_program_parent_id)

Line 178: ,DECODE( p_PROGRAM_TYPE_ID, NULL, p_PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)

174: ,last_update_login
175: ,object_version_number
176: ) VALUES (
177: DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
178: ,DECODE( p_PROGRAM_TYPE_ID, NULL, p_PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)
179: ,DECODE( p_custom_setup_id, NULL,p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id)
180: ,DECODE( p_program_level_code, NULL, p_program_level_code, FND_API.g_miss_char, NULL, p_program_level_code)
181: ,DECODE( p_program_parent_id, NULL, p_program_parent_id,FND_API.g_miss_num, NULL, p_program_parent_id)
182: ,DECODE( p_program_owner_resource_id, NULL, p_program_owner_resource_id,FND_API.g_miss_num, NULL, p_program_owner_resource_id)

Line 179: ,DECODE( p_custom_setup_id, NULL,p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id)

175: ,object_version_number
176: ) VALUES (
177: DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
178: ,DECODE( p_PROGRAM_TYPE_ID, NULL, p_PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)
179: ,DECODE( p_custom_setup_id, NULL,p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id)
180: ,DECODE( p_program_level_code, NULL, p_program_level_code, FND_API.g_miss_char, NULL, p_program_level_code)
181: ,DECODE( p_program_parent_id, NULL, p_program_parent_id,FND_API.g_miss_num, NULL, p_program_parent_id)
182: ,DECODE( p_program_owner_resource_id, NULL, p_program_owner_resource_id,FND_API.g_miss_num, NULL, p_program_owner_resource_id)
183: ,DECODE( p_program_start_date, NULL, p_program_start_date, FND_API.g_miss_date, NULL, p_program_start_date)

Line 180: ,DECODE( p_program_level_code, NULL, p_program_level_code, FND_API.g_miss_char, NULL, p_program_level_code)

176: ) VALUES (
177: DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
178: ,DECODE( p_PROGRAM_TYPE_ID, NULL, p_PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)
179: ,DECODE( p_custom_setup_id, NULL,p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id)
180: ,DECODE( p_program_level_code, NULL, p_program_level_code, FND_API.g_miss_char, NULL, p_program_level_code)
181: ,DECODE( p_program_parent_id, NULL, p_program_parent_id,FND_API.g_miss_num, NULL, p_program_parent_id)
182: ,DECODE( p_program_owner_resource_id, NULL, p_program_owner_resource_id,FND_API.g_miss_num, NULL, p_program_owner_resource_id)
183: ,DECODE( p_program_start_date, NULL, p_program_start_date, FND_API.g_miss_date, NULL, p_program_start_date)
184: ,DECODE( p_program_end_date, NULL, p_program_end_date,FND_API.g_miss_date, NULL, p_program_end_date)

Line 181: ,DECODE( p_program_parent_id, NULL, p_program_parent_id,FND_API.g_miss_num, NULL, p_program_parent_id)

177: DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
178: ,DECODE( p_PROGRAM_TYPE_ID, NULL, p_PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)
179: ,DECODE( p_custom_setup_id, NULL,p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id)
180: ,DECODE( p_program_level_code, NULL, p_program_level_code, FND_API.g_miss_char, NULL, p_program_level_code)
181: ,DECODE( p_program_parent_id, NULL, p_program_parent_id,FND_API.g_miss_num, NULL, p_program_parent_id)
182: ,DECODE( p_program_owner_resource_id, NULL, p_program_owner_resource_id,FND_API.g_miss_num, NULL, p_program_owner_resource_id)
183: ,DECODE( p_program_start_date, NULL, p_program_start_date, FND_API.g_miss_date, NULL, p_program_start_date)
184: ,DECODE( p_program_end_date, NULL, p_program_end_date,FND_API.g_miss_date, NULL, p_program_end_date)
185: ,DECODE( p_allow_enrl_until_date, NULL, p_allow_enrl_until_date,FND_API.g_miss_date, NULL, p_allow_enrl_until_date)

Line 182: ,DECODE( p_program_owner_resource_id, NULL, p_program_owner_resource_id,FND_API.g_miss_num, NULL, p_program_owner_resource_id)

178: ,DECODE( p_PROGRAM_TYPE_ID, NULL, p_PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)
179: ,DECODE( p_custom_setup_id, NULL,p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id)
180: ,DECODE( p_program_level_code, NULL, p_program_level_code, FND_API.g_miss_char, NULL, p_program_level_code)
181: ,DECODE( p_program_parent_id, NULL, p_program_parent_id,FND_API.g_miss_num, NULL, p_program_parent_id)
182: ,DECODE( p_program_owner_resource_id, NULL, p_program_owner_resource_id,FND_API.g_miss_num, NULL, p_program_owner_resource_id)
183: ,DECODE( p_program_start_date, NULL, p_program_start_date, FND_API.g_miss_date, NULL, p_program_start_date)
184: ,DECODE( p_program_end_date, NULL, p_program_end_date,FND_API.g_miss_date, NULL, p_program_end_date)
185: ,DECODE( p_allow_enrl_until_date, NULL, p_allow_enrl_until_date,FND_API.g_miss_date, NULL, p_allow_enrl_until_date)
186: ,DECODE( p_citem_version_id , NULL, p_citem_version_id , FND_API.g_miss_num, NULL, p_citem_version_id)

Line 183: ,DECODE( p_program_start_date, NULL, p_program_start_date, FND_API.g_miss_date, NULL, p_program_start_date)

179: ,DECODE( p_custom_setup_id, NULL,p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id)
180: ,DECODE( p_program_level_code, NULL, p_program_level_code, FND_API.g_miss_char, NULL, p_program_level_code)
181: ,DECODE( p_program_parent_id, NULL, p_program_parent_id,FND_API.g_miss_num, NULL, p_program_parent_id)
182: ,DECODE( p_program_owner_resource_id, NULL, p_program_owner_resource_id,FND_API.g_miss_num, NULL, p_program_owner_resource_id)
183: ,DECODE( p_program_start_date, NULL, p_program_start_date, FND_API.g_miss_date, NULL, p_program_start_date)
184: ,DECODE( p_program_end_date, NULL, p_program_end_date,FND_API.g_miss_date, NULL, p_program_end_date)
185: ,DECODE( p_allow_enrl_until_date, NULL, p_allow_enrl_until_date,FND_API.g_miss_date, NULL, p_allow_enrl_until_date)
186: ,DECODE( p_citem_version_id , NULL, p_citem_version_id , FND_API.g_miss_num, NULL, p_citem_version_id)
187: ,DECODE( p_membership_valid_period, NULL, p_membership_valid_period, FND_API.g_miss_num, NULL, p_membership_valid_period)

Line 184: ,DECODE( p_program_end_date, NULL, p_program_end_date,FND_API.g_miss_date, NULL, p_program_end_date)

180: ,DECODE( p_program_level_code, NULL, p_program_level_code, FND_API.g_miss_char, NULL, p_program_level_code)
181: ,DECODE( p_program_parent_id, NULL, p_program_parent_id,FND_API.g_miss_num, NULL, p_program_parent_id)
182: ,DECODE( p_program_owner_resource_id, NULL, p_program_owner_resource_id,FND_API.g_miss_num, NULL, p_program_owner_resource_id)
183: ,DECODE( p_program_start_date, NULL, p_program_start_date, FND_API.g_miss_date, NULL, p_program_start_date)
184: ,DECODE( p_program_end_date, NULL, p_program_end_date,FND_API.g_miss_date, NULL, p_program_end_date)
185: ,DECODE( p_allow_enrl_until_date, NULL, p_allow_enrl_until_date,FND_API.g_miss_date, NULL, p_allow_enrl_until_date)
186: ,DECODE( p_citem_version_id , NULL, p_citem_version_id , FND_API.g_miss_num, NULL, p_citem_version_id)
187: ,DECODE( p_membership_valid_period, NULL, p_membership_valid_period, FND_API.g_miss_num, NULL, p_membership_valid_period)
188: ,DECODE( p_membership_period_unit, NULL, p_membership_period_unit,FND_API.g_miss_char, NULL, p_membership_period_unit)

Line 185: ,DECODE( p_allow_enrl_until_date, NULL, p_allow_enrl_until_date,FND_API.g_miss_date, NULL, p_allow_enrl_until_date)

181: ,DECODE( p_program_parent_id, NULL, p_program_parent_id,FND_API.g_miss_num, NULL, p_program_parent_id)
182: ,DECODE( p_program_owner_resource_id, NULL, p_program_owner_resource_id,FND_API.g_miss_num, NULL, p_program_owner_resource_id)
183: ,DECODE( p_program_start_date, NULL, p_program_start_date, FND_API.g_miss_date, NULL, p_program_start_date)
184: ,DECODE( p_program_end_date, NULL, p_program_end_date,FND_API.g_miss_date, NULL, p_program_end_date)
185: ,DECODE( p_allow_enrl_until_date, NULL, p_allow_enrl_until_date,FND_API.g_miss_date, NULL, p_allow_enrl_until_date)
186: ,DECODE( p_citem_version_id , NULL, p_citem_version_id , FND_API.g_miss_num, NULL, p_citem_version_id)
187: ,DECODE( p_membership_valid_period, NULL, p_membership_valid_period, FND_API.g_miss_num, NULL, p_membership_valid_period)
188: ,DECODE( p_membership_period_unit, NULL, p_membership_period_unit,FND_API.g_miss_char, NULL, p_membership_period_unit)
189: ,DECODE( p_process_rule_id, NULL, p_process_rule_id, FND_API.g_miss_num, NULL, p_process_rule_id)

Line 186: ,DECODE( p_citem_version_id , NULL, p_citem_version_id , FND_API.g_miss_num, NULL, p_citem_version_id)

182: ,DECODE( p_program_owner_resource_id, NULL, p_program_owner_resource_id,FND_API.g_miss_num, NULL, p_program_owner_resource_id)
183: ,DECODE( p_program_start_date, NULL, p_program_start_date, FND_API.g_miss_date, NULL, p_program_start_date)
184: ,DECODE( p_program_end_date, NULL, p_program_end_date,FND_API.g_miss_date, NULL, p_program_end_date)
185: ,DECODE( p_allow_enrl_until_date, NULL, p_allow_enrl_until_date,FND_API.g_miss_date, NULL, p_allow_enrl_until_date)
186: ,DECODE( p_citem_version_id , NULL, p_citem_version_id , FND_API.g_miss_num, NULL, p_citem_version_id)
187: ,DECODE( p_membership_valid_period, NULL, p_membership_valid_period, FND_API.g_miss_num, NULL, p_membership_valid_period)
188: ,DECODE( p_membership_period_unit, NULL, p_membership_period_unit,FND_API.g_miss_char, NULL, p_membership_period_unit)
189: ,DECODE( p_process_rule_id, NULL, p_process_rule_id, FND_API.g_miss_num, NULL, p_process_rule_id)
190: ,DECODE( p_prereq_process_rule_Id, NULL, p_prereq_process_rule_Id, FND_API.g_miss_num, NULL, p_prereq_process_rule_Id)

Line 187: ,DECODE( p_membership_valid_period, NULL, p_membership_valid_period, FND_API.g_miss_num, NULL, p_membership_valid_period)

183: ,DECODE( p_program_start_date, NULL, p_program_start_date, FND_API.g_miss_date, NULL, p_program_start_date)
184: ,DECODE( p_program_end_date, NULL, p_program_end_date,FND_API.g_miss_date, NULL, p_program_end_date)
185: ,DECODE( p_allow_enrl_until_date, NULL, p_allow_enrl_until_date,FND_API.g_miss_date, NULL, p_allow_enrl_until_date)
186: ,DECODE( p_citem_version_id , NULL, p_citem_version_id , FND_API.g_miss_num, NULL, p_citem_version_id)
187: ,DECODE( p_membership_valid_period, NULL, p_membership_valid_period, FND_API.g_miss_num, NULL, p_membership_valid_period)
188: ,DECODE( p_membership_period_unit, NULL, p_membership_period_unit,FND_API.g_miss_char, NULL, p_membership_period_unit)
189: ,DECODE( p_process_rule_id, NULL, p_process_rule_id, FND_API.g_miss_num, NULL, p_process_rule_id)
190: ,DECODE( p_prereq_process_rule_Id, NULL, p_prereq_process_rule_Id, FND_API.g_miss_num, NULL, p_prereq_process_rule_Id)
191: ,DECODE( p_program_status_code, NULL, p_program_status_code,FND_API.g_miss_char, NULL, p_program_status_code)

Line 188: ,DECODE( p_membership_period_unit, NULL, p_membership_period_unit,FND_API.g_miss_char, NULL, p_membership_period_unit)

184: ,DECODE( p_program_end_date, NULL, p_program_end_date,FND_API.g_miss_date, NULL, p_program_end_date)
185: ,DECODE( p_allow_enrl_until_date, NULL, p_allow_enrl_until_date,FND_API.g_miss_date, NULL, p_allow_enrl_until_date)
186: ,DECODE( p_citem_version_id , NULL, p_citem_version_id , FND_API.g_miss_num, NULL, p_citem_version_id)
187: ,DECODE( p_membership_valid_period, NULL, p_membership_valid_period, FND_API.g_miss_num, NULL, p_membership_valid_period)
188: ,DECODE( p_membership_period_unit, NULL, p_membership_period_unit,FND_API.g_miss_char, NULL, p_membership_period_unit)
189: ,DECODE( p_process_rule_id, NULL, p_process_rule_id, FND_API.g_miss_num, NULL, p_process_rule_id)
190: ,DECODE( p_prereq_process_rule_Id, NULL, p_prereq_process_rule_Id, FND_API.g_miss_num, NULL, p_prereq_process_rule_Id)
191: ,DECODE( p_program_status_code, NULL, p_program_status_code,FND_API.g_miss_char, NULL, p_program_status_code)
192: ,DECODE( p_submit_child_nodes, NULL, p_submit_child_nodes,FND_API.g_miss_char, NULL, p_submit_child_nodes)

Line 189: ,DECODE( p_process_rule_id, NULL, p_process_rule_id, FND_API.g_miss_num, NULL, p_process_rule_id)

185: ,DECODE( p_allow_enrl_until_date, NULL, p_allow_enrl_until_date,FND_API.g_miss_date, NULL, p_allow_enrl_until_date)
186: ,DECODE( p_citem_version_id , NULL, p_citem_version_id , FND_API.g_miss_num, NULL, p_citem_version_id)
187: ,DECODE( p_membership_valid_period, NULL, p_membership_valid_period, FND_API.g_miss_num, NULL, p_membership_valid_period)
188: ,DECODE( p_membership_period_unit, NULL, p_membership_period_unit,FND_API.g_miss_char, NULL, p_membership_period_unit)
189: ,DECODE( p_process_rule_id, NULL, p_process_rule_id, FND_API.g_miss_num, NULL, p_process_rule_id)
190: ,DECODE( p_prereq_process_rule_Id, NULL, p_prereq_process_rule_Id, FND_API.g_miss_num, NULL, p_prereq_process_rule_Id)
191: ,DECODE( p_program_status_code, NULL, p_program_status_code,FND_API.g_miss_char, NULL, p_program_status_code)
192: ,DECODE( p_submit_child_nodes, NULL, p_submit_child_nodes,FND_API.g_miss_char, NULL, p_submit_child_nodes)
193: ,DECODE( p_inventory_item_id, NULL, p_inventory_item_id,FND_API.g_miss_num, NULL, p_inventory_item_id)

Line 190: ,DECODE( p_prereq_process_rule_Id, NULL, p_prereq_process_rule_Id, FND_API.g_miss_num, NULL, p_prereq_process_rule_Id)

186: ,DECODE( p_citem_version_id , NULL, p_citem_version_id , FND_API.g_miss_num, NULL, p_citem_version_id)
187: ,DECODE( p_membership_valid_period, NULL, p_membership_valid_period, FND_API.g_miss_num, NULL, p_membership_valid_period)
188: ,DECODE( p_membership_period_unit, NULL, p_membership_period_unit,FND_API.g_miss_char, NULL, p_membership_period_unit)
189: ,DECODE( p_process_rule_id, NULL, p_process_rule_id, FND_API.g_miss_num, NULL, p_process_rule_id)
190: ,DECODE( p_prereq_process_rule_Id, NULL, p_prereq_process_rule_Id, FND_API.g_miss_num, NULL, p_prereq_process_rule_Id)
191: ,DECODE( p_program_status_code, NULL, p_program_status_code,FND_API.g_miss_char, NULL, p_program_status_code)
192: ,DECODE( p_submit_child_nodes, NULL, p_submit_child_nodes,FND_API.g_miss_char, NULL, p_submit_child_nodes)
193: ,DECODE( p_inventory_item_id, NULL, p_inventory_item_id,FND_API.g_miss_num, NULL, p_inventory_item_id)
194: ,DECODE( p_inventory_item_org_id, NULL, p_inventory_item_org_id,FND_API.g_miss_num, NULL, p_inventory_item_org_id)

Line 191: ,DECODE( p_program_status_code, NULL, p_program_status_code,FND_API.g_miss_char, NULL, p_program_status_code)

187: ,DECODE( p_membership_valid_period, NULL, p_membership_valid_period, FND_API.g_miss_num, NULL, p_membership_valid_period)
188: ,DECODE( p_membership_period_unit, NULL, p_membership_period_unit,FND_API.g_miss_char, NULL, p_membership_period_unit)
189: ,DECODE( p_process_rule_id, NULL, p_process_rule_id, FND_API.g_miss_num, NULL, p_process_rule_id)
190: ,DECODE( p_prereq_process_rule_Id, NULL, p_prereq_process_rule_Id, FND_API.g_miss_num, NULL, p_prereq_process_rule_Id)
191: ,DECODE( p_program_status_code, NULL, p_program_status_code,FND_API.g_miss_char, NULL, p_program_status_code)
192: ,DECODE( p_submit_child_nodes, NULL, p_submit_child_nodes,FND_API.g_miss_char, NULL, p_submit_child_nodes)
193: ,DECODE( p_inventory_item_id, NULL, p_inventory_item_id,FND_API.g_miss_num, NULL, p_inventory_item_id)
194: ,DECODE( p_inventory_item_org_id, NULL, p_inventory_item_org_id,FND_API.g_miss_num, NULL, p_inventory_item_org_id)
195: ,DECODE( p_bus_user_resp_id, NULL, p_bus_user_resp_id,FND_API.g_miss_num, NULL, p_bus_user_resp_id)

Line 192: ,DECODE( p_submit_child_nodes, NULL, p_submit_child_nodes,FND_API.g_miss_char, NULL, p_submit_child_nodes)

188: ,DECODE( p_membership_period_unit, NULL, p_membership_period_unit,FND_API.g_miss_char, NULL, p_membership_period_unit)
189: ,DECODE( p_process_rule_id, NULL, p_process_rule_id, FND_API.g_miss_num, NULL, p_process_rule_id)
190: ,DECODE( p_prereq_process_rule_Id, NULL, p_prereq_process_rule_Id, FND_API.g_miss_num, NULL, p_prereq_process_rule_Id)
191: ,DECODE( p_program_status_code, NULL, p_program_status_code,FND_API.g_miss_char, NULL, p_program_status_code)
192: ,DECODE( p_submit_child_nodes, NULL, p_submit_child_nodes,FND_API.g_miss_char, NULL, p_submit_child_nodes)
193: ,DECODE( p_inventory_item_id, NULL, p_inventory_item_id,FND_API.g_miss_num, NULL, p_inventory_item_id)
194: ,DECODE( p_inventory_item_org_id, NULL, p_inventory_item_org_id,FND_API.g_miss_num, NULL, p_inventory_item_org_id)
195: ,DECODE( p_bus_user_resp_id, NULL, p_bus_user_resp_id,FND_API.g_miss_num, NULL, p_bus_user_resp_id)
196: ,DECODE( p_admin_resp_id, NULL, p_admin_resp_id,FND_API.g_miss_num, NULL, p_admin_resp_id)

Line 193: ,DECODE( p_inventory_item_id, NULL, p_inventory_item_id,FND_API.g_miss_num, NULL, p_inventory_item_id)

189: ,DECODE( p_process_rule_id, NULL, p_process_rule_id, FND_API.g_miss_num, NULL, p_process_rule_id)
190: ,DECODE( p_prereq_process_rule_Id, NULL, p_prereq_process_rule_Id, FND_API.g_miss_num, NULL, p_prereq_process_rule_Id)
191: ,DECODE( p_program_status_code, NULL, p_program_status_code,FND_API.g_miss_char, NULL, p_program_status_code)
192: ,DECODE( p_submit_child_nodes, NULL, p_submit_child_nodes,FND_API.g_miss_char, NULL, p_submit_child_nodes)
193: ,DECODE( p_inventory_item_id, NULL, p_inventory_item_id,FND_API.g_miss_num, NULL, p_inventory_item_id)
194: ,DECODE( p_inventory_item_org_id, NULL, p_inventory_item_org_id,FND_API.g_miss_num, NULL, p_inventory_item_org_id)
195: ,DECODE( p_bus_user_resp_id, NULL, p_bus_user_resp_id,FND_API.g_miss_num, NULL, p_bus_user_resp_id)
196: ,DECODE( p_admin_resp_id, NULL, p_admin_resp_id,FND_API.g_miss_num, NULL, p_admin_resp_id)
197: ,DECODE( p_no_fee_flag, NULL, p_no_fee_flag,FND_API.g_miss_char, NULL, p_no_fee_flag)

Line 194: ,DECODE( p_inventory_item_org_id, NULL, p_inventory_item_org_id,FND_API.g_miss_num, NULL, p_inventory_item_org_id)

190: ,DECODE( p_prereq_process_rule_Id, NULL, p_prereq_process_rule_Id, FND_API.g_miss_num, NULL, p_prereq_process_rule_Id)
191: ,DECODE( p_program_status_code, NULL, p_program_status_code,FND_API.g_miss_char, NULL, p_program_status_code)
192: ,DECODE( p_submit_child_nodes, NULL, p_submit_child_nodes,FND_API.g_miss_char, NULL, p_submit_child_nodes)
193: ,DECODE( p_inventory_item_id, NULL, p_inventory_item_id,FND_API.g_miss_num, NULL, p_inventory_item_id)
194: ,DECODE( p_inventory_item_org_id, NULL, p_inventory_item_org_id,FND_API.g_miss_num, NULL, p_inventory_item_org_id)
195: ,DECODE( p_bus_user_resp_id, NULL, p_bus_user_resp_id,FND_API.g_miss_num, NULL, p_bus_user_resp_id)
196: ,DECODE( p_admin_resp_id, NULL, p_admin_resp_id,FND_API.g_miss_num, NULL, p_admin_resp_id)
197: ,DECODE( p_no_fee_flag, NULL, p_no_fee_flag,FND_API.g_miss_char, NULL, p_no_fee_flag)
198: ,DECODE( p_vad_invite_allow_flag, NULL, p_vad_invite_allow_flag,FND_API.g_miss_char, NULL, p_vad_invite_allow_flag)

Line 195: ,DECODE( p_bus_user_resp_id, NULL, p_bus_user_resp_id,FND_API.g_miss_num, NULL, p_bus_user_resp_id)

191: ,DECODE( p_program_status_code, NULL, p_program_status_code,FND_API.g_miss_char, NULL, p_program_status_code)
192: ,DECODE( p_submit_child_nodes, NULL, p_submit_child_nodes,FND_API.g_miss_char, NULL, p_submit_child_nodes)
193: ,DECODE( p_inventory_item_id, NULL, p_inventory_item_id,FND_API.g_miss_num, NULL, p_inventory_item_id)
194: ,DECODE( p_inventory_item_org_id, NULL, p_inventory_item_org_id,FND_API.g_miss_num, NULL, p_inventory_item_org_id)
195: ,DECODE( p_bus_user_resp_id, NULL, p_bus_user_resp_id,FND_API.g_miss_num, NULL, p_bus_user_resp_id)
196: ,DECODE( p_admin_resp_id, NULL, p_admin_resp_id,FND_API.g_miss_num, NULL, p_admin_resp_id)
197: ,DECODE( p_no_fee_flag, NULL, p_no_fee_flag,FND_API.g_miss_char, NULL, p_no_fee_flag)
198: ,DECODE( p_vad_invite_allow_flag, NULL, p_vad_invite_allow_flag,FND_API.g_miss_char, NULL, p_vad_invite_allow_flag)
199: ,DECODE( p_global_mmbr_reqd_flag, NULL, p_global_mmbr_reqd_flag,FND_API.g_miss_char, NULL, p_global_mmbr_reqd_flag)

Line 196: ,DECODE( p_admin_resp_id, NULL, p_admin_resp_id,FND_API.g_miss_num, NULL, p_admin_resp_id)

192: ,DECODE( p_submit_child_nodes, NULL, p_submit_child_nodes,FND_API.g_miss_char, NULL, p_submit_child_nodes)
193: ,DECODE( p_inventory_item_id, NULL, p_inventory_item_id,FND_API.g_miss_num, NULL, p_inventory_item_id)
194: ,DECODE( p_inventory_item_org_id, NULL, p_inventory_item_org_id,FND_API.g_miss_num, NULL, p_inventory_item_org_id)
195: ,DECODE( p_bus_user_resp_id, NULL, p_bus_user_resp_id,FND_API.g_miss_num, NULL, p_bus_user_resp_id)
196: ,DECODE( p_admin_resp_id, NULL, p_admin_resp_id,FND_API.g_miss_num, NULL, p_admin_resp_id)
197: ,DECODE( p_no_fee_flag, NULL, p_no_fee_flag,FND_API.g_miss_char, NULL, p_no_fee_flag)
198: ,DECODE( p_vad_invite_allow_flag, NULL, p_vad_invite_allow_flag,FND_API.g_miss_char, NULL, p_vad_invite_allow_flag)
199: ,DECODE( p_global_mmbr_reqd_flag, NULL, p_global_mmbr_reqd_flag,FND_API.g_miss_char, NULL, p_global_mmbr_reqd_flag)
200: ,DECODE( p_waive_subsidiary_fee_flag, NULL, p_waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL, p_waive_subsidiary_fee_flag)

Line 197: ,DECODE( p_no_fee_flag, NULL, p_no_fee_flag,FND_API.g_miss_char, NULL, p_no_fee_flag)

193: ,DECODE( p_inventory_item_id, NULL, p_inventory_item_id,FND_API.g_miss_num, NULL, p_inventory_item_id)
194: ,DECODE( p_inventory_item_org_id, NULL, p_inventory_item_org_id,FND_API.g_miss_num, NULL, p_inventory_item_org_id)
195: ,DECODE( p_bus_user_resp_id, NULL, p_bus_user_resp_id,FND_API.g_miss_num, NULL, p_bus_user_resp_id)
196: ,DECODE( p_admin_resp_id, NULL, p_admin_resp_id,FND_API.g_miss_num, NULL, p_admin_resp_id)
197: ,DECODE( p_no_fee_flag, NULL, p_no_fee_flag,FND_API.g_miss_char, NULL, p_no_fee_flag)
198: ,DECODE( p_vad_invite_allow_flag, NULL, p_vad_invite_allow_flag,FND_API.g_miss_char, NULL, p_vad_invite_allow_flag)
199: ,DECODE( p_global_mmbr_reqd_flag, NULL, p_global_mmbr_reqd_flag,FND_API.g_miss_char, NULL, p_global_mmbr_reqd_flag)
200: ,DECODE( p_waive_subsidiary_fee_flag, NULL, p_waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL, p_waive_subsidiary_fee_flag)
201: ,DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL, p_qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_ttl_all_page_dsp_flag )

Line 198: ,DECODE( p_vad_invite_allow_flag, NULL, p_vad_invite_allow_flag,FND_API.g_miss_char, NULL, p_vad_invite_allow_flag)

194: ,DECODE( p_inventory_item_org_id, NULL, p_inventory_item_org_id,FND_API.g_miss_num, NULL, p_inventory_item_org_id)
195: ,DECODE( p_bus_user_resp_id, NULL, p_bus_user_resp_id,FND_API.g_miss_num, NULL, p_bus_user_resp_id)
196: ,DECODE( p_admin_resp_id, NULL, p_admin_resp_id,FND_API.g_miss_num, NULL, p_admin_resp_id)
197: ,DECODE( p_no_fee_flag, NULL, p_no_fee_flag,FND_API.g_miss_char, NULL, p_no_fee_flag)
198: ,DECODE( p_vad_invite_allow_flag, NULL, p_vad_invite_allow_flag,FND_API.g_miss_char, NULL, p_vad_invite_allow_flag)
199: ,DECODE( p_global_mmbr_reqd_flag, NULL, p_global_mmbr_reqd_flag,FND_API.g_miss_char, NULL, p_global_mmbr_reqd_flag)
200: ,DECODE( p_waive_subsidiary_fee_flag, NULL, p_waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL, p_waive_subsidiary_fee_flag)
201: ,DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL, p_qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_ttl_all_page_dsp_flag )
202: ,DECODE( p_qsnr_hdr_all_page_dsp_flag , NULL, p_qsnr_hdr_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_hdr_all_page_dsp_flag )

Line 199: ,DECODE( p_global_mmbr_reqd_flag, NULL, p_global_mmbr_reqd_flag,FND_API.g_miss_char, NULL, p_global_mmbr_reqd_flag)

195: ,DECODE( p_bus_user_resp_id, NULL, p_bus_user_resp_id,FND_API.g_miss_num, NULL, p_bus_user_resp_id)
196: ,DECODE( p_admin_resp_id, NULL, p_admin_resp_id,FND_API.g_miss_num, NULL, p_admin_resp_id)
197: ,DECODE( p_no_fee_flag, NULL, p_no_fee_flag,FND_API.g_miss_char, NULL, p_no_fee_flag)
198: ,DECODE( p_vad_invite_allow_flag, NULL, p_vad_invite_allow_flag,FND_API.g_miss_char, NULL, p_vad_invite_allow_flag)
199: ,DECODE( p_global_mmbr_reqd_flag, NULL, p_global_mmbr_reqd_flag,FND_API.g_miss_char, NULL, p_global_mmbr_reqd_flag)
200: ,DECODE( p_waive_subsidiary_fee_flag, NULL, p_waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL, p_waive_subsidiary_fee_flag)
201: ,DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL, p_qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_ttl_all_page_dsp_flag )
202: ,DECODE( p_qsnr_hdr_all_page_dsp_flag , NULL, p_qsnr_hdr_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_hdr_all_page_dsp_flag )
203: ,DECODE( p_qsnr_ftr_all_page_dsp_flag, NULL, p_qsnr_ftr_all_page_dsp_flag,FND_API.g_miss_char, NULL, p_qsnr_ftr_all_page_dsp_flag)

Line 200: ,DECODE( p_waive_subsidiary_fee_flag, NULL, p_waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL, p_waive_subsidiary_fee_flag)

196: ,DECODE( p_admin_resp_id, NULL, p_admin_resp_id,FND_API.g_miss_num, NULL, p_admin_resp_id)
197: ,DECODE( p_no_fee_flag, NULL, p_no_fee_flag,FND_API.g_miss_char, NULL, p_no_fee_flag)
198: ,DECODE( p_vad_invite_allow_flag, NULL, p_vad_invite_allow_flag,FND_API.g_miss_char, NULL, p_vad_invite_allow_flag)
199: ,DECODE( p_global_mmbr_reqd_flag, NULL, p_global_mmbr_reqd_flag,FND_API.g_miss_char, NULL, p_global_mmbr_reqd_flag)
200: ,DECODE( p_waive_subsidiary_fee_flag, NULL, p_waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL, p_waive_subsidiary_fee_flag)
201: ,DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL, p_qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_ttl_all_page_dsp_flag )
202: ,DECODE( p_qsnr_hdr_all_page_dsp_flag , NULL, p_qsnr_hdr_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_hdr_all_page_dsp_flag )
203: ,DECODE( p_qsnr_ftr_all_page_dsp_flag, NULL, p_qsnr_ftr_all_page_dsp_flag,FND_API.g_miss_char, NULL, p_qsnr_ftr_all_page_dsp_flag)
204: ,DECODE( p_allow_enrl_wout_chklst_flag, NULL, p_allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL, p_allow_enrl_wout_chklst_flag)

Line 201: ,DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL, p_qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_ttl_all_page_dsp_flag )

197: ,DECODE( p_no_fee_flag, NULL, p_no_fee_flag,FND_API.g_miss_char, NULL, p_no_fee_flag)
198: ,DECODE( p_vad_invite_allow_flag, NULL, p_vad_invite_allow_flag,FND_API.g_miss_char, NULL, p_vad_invite_allow_flag)
199: ,DECODE( p_global_mmbr_reqd_flag, NULL, p_global_mmbr_reqd_flag,FND_API.g_miss_char, NULL, p_global_mmbr_reqd_flag)
200: ,DECODE( p_waive_subsidiary_fee_flag, NULL, p_waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL, p_waive_subsidiary_fee_flag)
201: ,DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL, p_qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_ttl_all_page_dsp_flag )
202: ,DECODE( p_qsnr_hdr_all_page_dsp_flag , NULL, p_qsnr_hdr_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_hdr_all_page_dsp_flag )
203: ,DECODE( p_qsnr_ftr_all_page_dsp_flag, NULL, p_qsnr_ftr_all_page_dsp_flag,FND_API.g_miss_char, NULL, p_qsnr_ftr_all_page_dsp_flag)
204: ,DECODE( p_allow_enrl_wout_chklst_flag, NULL, p_allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL, p_allow_enrl_wout_chklst_flag)
205: ,DECODE( p_user_status_id, NULL, p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id)

Line 202: ,DECODE( p_qsnr_hdr_all_page_dsp_flag , NULL, p_qsnr_hdr_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_hdr_all_page_dsp_flag )

198: ,DECODE( p_vad_invite_allow_flag, NULL, p_vad_invite_allow_flag,FND_API.g_miss_char, NULL, p_vad_invite_allow_flag)
199: ,DECODE( p_global_mmbr_reqd_flag, NULL, p_global_mmbr_reqd_flag,FND_API.g_miss_char, NULL, p_global_mmbr_reqd_flag)
200: ,DECODE( p_waive_subsidiary_fee_flag, NULL, p_waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL, p_waive_subsidiary_fee_flag)
201: ,DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL, p_qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_ttl_all_page_dsp_flag )
202: ,DECODE( p_qsnr_hdr_all_page_dsp_flag , NULL, p_qsnr_hdr_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_hdr_all_page_dsp_flag )
203: ,DECODE( p_qsnr_ftr_all_page_dsp_flag, NULL, p_qsnr_ftr_all_page_dsp_flag,FND_API.g_miss_char, NULL, p_qsnr_ftr_all_page_dsp_flag)
204: ,DECODE( p_allow_enrl_wout_chklst_flag, NULL, p_allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL, p_allow_enrl_wout_chklst_flag)
205: ,DECODE( p_user_status_id, NULL, p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id)
206: ,DECODE( p_enabled_flag, NULL, p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)

Line 203: ,DECODE( p_qsnr_ftr_all_page_dsp_flag, NULL, p_qsnr_ftr_all_page_dsp_flag,FND_API.g_miss_char, NULL, p_qsnr_ftr_all_page_dsp_flag)

199: ,DECODE( p_global_mmbr_reqd_flag, NULL, p_global_mmbr_reqd_flag,FND_API.g_miss_char, NULL, p_global_mmbr_reqd_flag)
200: ,DECODE( p_waive_subsidiary_fee_flag, NULL, p_waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL, p_waive_subsidiary_fee_flag)
201: ,DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL, p_qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_ttl_all_page_dsp_flag )
202: ,DECODE( p_qsnr_hdr_all_page_dsp_flag , NULL, p_qsnr_hdr_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_hdr_all_page_dsp_flag )
203: ,DECODE( p_qsnr_ftr_all_page_dsp_flag, NULL, p_qsnr_ftr_all_page_dsp_flag,FND_API.g_miss_char, NULL, p_qsnr_ftr_all_page_dsp_flag)
204: ,DECODE( p_allow_enrl_wout_chklst_flag, NULL, p_allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL, p_allow_enrl_wout_chklst_flag)
205: ,DECODE( p_user_status_id, NULL, p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id)
206: ,DECODE( p_enabled_flag, NULL, p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
207: ,DECODE( p_attribute_category, NULL, p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category)

Line 204: ,DECODE( p_allow_enrl_wout_chklst_flag, NULL, p_allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL, p_allow_enrl_wout_chklst_flag)

200: ,DECODE( p_waive_subsidiary_fee_flag, NULL, p_waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL, p_waive_subsidiary_fee_flag)
201: ,DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL, p_qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_ttl_all_page_dsp_flag )
202: ,DECODE( p_qsnr_hdr_all_page_dsp_flag , NULL, p_qsnr_hdr_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_hdr_all_page_dsp_flag )
203: ,DECODE( p_qsnr_ftr_all_page_dsp_flag, NULL, p_qsnr_ftr_all_page_dsp_flag,FND_API.g_miss_char, NULL, p_qsnr_ftr_all_page_dsp_flag)
204: ,DECODE( p_allow_enrl_wout_chklst_flag, NULL, p_allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL, p_allow_enrl_wout_chklst_flag)
205: ,DECODE( p_user_status_id, NULL, p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id)
206: ,DECODE( p_enabled_flag, NULL, p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
207: ,DECODE( p_attribute_category, NULL, p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category)
208: ,DECODE( p_attribute1, NULL, p_attribute1, FND_API.g_miss_char, NULL, p_attribute1)

Line 205: ,DECODE( p_user_status_id, NULL, p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id)

201: ,DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL, p_qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_ttl_all_page_dsp_flag )
202: ,DECODE( p_qsnr_hdr_all_page_dsp_flag , NULL, p_qsnr_hdr_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_hdr_all_page_dsp_flag )
203: ,DECODE( p_qsnr_ftr_all_page_dsp_flag, NULL, p_qsnr_ftr_all_page_dsp_flag,FND_API.g_miss_char, NULL, p_qsnr_ftr_all_page_dsp_flag)
204: ,DECODE( p_allow_enrl_wout_chklst_flag, NULL, p_allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL, p_allow_enrl_wout_chklst_flag)
205: ,DECODE( p_user_status_id, NULL, p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id)
206: ,DECODE( p_enabled_flag, NULL, p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
207: ,DECODE( p_attribute_category, NULL, p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category)
208: ,DECODE( p_attribute1, NULL, p_attribute1, FND_API.g_miss_char, NULL, p_attribute1)
209: ,DECODE( p_attribute2, NULL, p_attribute2, FND_API.g_miss_char, NULL, p_attribute2)

Line 206: ,DECODE( p_enabled_flag, NULL, p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)

202: ,DECODE( p_qsnr_hdr_all_page_dsp_flag , NULL, p_qsnr_hdr_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_hdr_all_page_dsp_flag )
203: ,DECODE( p_qsnr_ftr_all_page_dsp_flag, NULL, p_qsnr_ftr_all_page_dsp_flag,FND_API.g_miss_char, NULL, p_qsnr_ftr_all_page_dsp_flag)
204: ,DECODE( p_allow_enrl_wout_chklst_flag, NULL, p_allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL, p_allow_enrl_wout_chklst_flag)
205: ,DECODE( p_user_status_id, NULL, p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id)
206: ,DECODE( p_enabled_flag, NULL, p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
207: ,DECODE( p_attribute_category, NULL, p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category)
208: ,DECODE( p_attribute1, NULL, p_attribute1, FND_API.g_miss_char, NULL, p_attribute1)
209: ,DECODE( p_attribute2, NULL, p_attribute2, FND_API.g_miss_char, NULL, p_attribute2)
210: ,DECODE( p_attribute3, NULL, p_attribute3, FND_API.g_miss_char, NULL, p_attribute3)

Line 207: ,DECODE( p_attribute_category, NULL, p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category)

203: ,DECODE( p_qsnr_ftr_all_page_dsp_flag, NULL, p_qsnr_ftr_all_page_dsp_flag,FND_API.g_miss_char, NULL, p_qsnr_ftr_all_page_dsp_flag)
204: ,DECODE( p_allow_enrl_wout_chklst_flag, NULL, p_allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL, p_allow_enrl_wout_chklst_flag)
205: ,DECODE( p_user_status_id, NULL, p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id)
206: ,DECODE( p_enabled_flag, NULL, p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
207: ,DECODE( p_attribute_category, NULL, p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category)
208: ,DECODE( p_attribute1, NULL, p_attribute1, FND_API.g_miss_char, NULL, p_attribute1)
209: ,DECODE( p_attribute2, NULL, p_attribute2, FND_API.g_miss_char, NULL, p_attribute2)
210: ,DECODE( p_attribute3, NULL, p_attribute3, FND_API.g_miss_char, NULL, p_attribute3)
211: ,DECODE( p_attribute4, NULL, p_attribute4 , FND_API.g_miss_char, NULL, p_attribute4)

Line 208: ,DECODE( p_attribute1, NULL, p_attribute1, FND_API.g_miss_char, NULL, p_attribute1)

204: ,DECODE( p_allow_enrl_wout_chklst_flag, NULL, p_allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL, p_allow_enrl_wout_chklst_flag)
205: ,DECODE( p_user_status_id, NULL, p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id)
206: ,DECODE( p_enabled_flag, NULL, p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
207: ,DECODE( p_attribute_category, NULL, p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category)
208: ,DECODE( p_attribute1, NULL, p_attribute1, FND_API.g_miss_char, NULL, p_attribute1)
209: ,DECODE( p_attribute2, NULL, p_attribute2, FND_API.g_miss_char, NULL, p_attribute2)
210: ,DECODE( p_attribute3, NULL, p_attribute3, FND_API.g_miss_char, NULL, p_attribute3)
211: ,DECODE( p_attribute4, NULL, p_attribute4 , FND_API.g_miss_char, NULL, p_attribute4)
212: ,DECODE( p_attribute5, NULL, p_attribute5, FND_API.g_miss_char, NULL, p_attribute5)

Line 209: ,DECODE( p_attribute2, NULL, p_attribute2, FND_API.g_miss_char, NULL, p_attribute2)

205: ,DECODE( p_user_status_id, NULL, p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id)
206: ,DECODE( p_enabled_flag, NULL, p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
207: ,DECODE( p_attribute_category, NULL, p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category)
208: ,DECODE( p_attribute1, NULL, p_attribute1, FND_API.g_miss_char, NULL, p_attribute1)
209: ,DECODE( p_attribute2, NULL, p_attribute2, FND_API.g_miss_char, NULL, p_attribute2)
210: ,DECODE( p_attribute3, NULL, p_attribute3, FND_API.g_miss_char, NULL, p_attribute3)
211: ,DECODE( p_attribute4, NULL, p_attribute4 , FND_API.g_miss_char, NULL, p_attribute4)
212: ,DECODE( p_attribute5, NULL, p_attribute5, FND_API.g_miss_char, NULL, p_attribute5)
213: ,DECODE( p_attribute6, NULL, p_attribute6, FND_API.g_miss_char, NULL, p_attribute6)

Line 210: ,DECODE( p_attribute3, NULL, p_attribute3, FND_API.g_miss_char, NULL, p_attribute3)

206: ,DECODE( p_enabled_flag, NULL, p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
207: ,DECODE( p_attribute_category, NULL, p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category)
208: ,DECODE( p_attribute1, NULL, p_attribute1, FND_API.g_miss_char, NULL, p_attribute1)
209: ,DECODE( p_attribute2, NULL, p_attribute2, FND_API.g_miss_char, NULL, p_attribute2)
210: ,DECODE( p_attribute3, NULL, p_attribute3, FND_API.g_miss_char, NULL, p_attribute3)
211: ,DECODE( p_attribute4, NULL, p_attribute4 , FND_API.g_miss_char, NULL, p_attribute4)
212: ,DECODE( p_attribute5, NULL, p_attribute5, FND_API.g_miss_char, NULL, p_attribute5)
213: ,DECODE( p_attribute6, NULL, p_attribute6, FND_API.g_miss_char, NULL, p_attribute6)
214: ,DECODE( p_attribute7, NULL, p_attribute7, FND_API.g_miss_char, NULL, p_attribute7)

Line 211: ,DECODE( p_attribute4, NULL, p_attribute4 , FND_API.g_miss_char, NULL, p_attribute4)

207: ,DECODE( p_attribute_category, NULL, p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category)
208: ,DECODE( p_attribute1, NULL, p_attribute1, FND_API.g_miss_char, NULL, p_attribute1)
209: ,DECODE( p_attribute2, NULL, p_attribute2, FND_API.g_miss_char, NULL, p_attribute2)
210: ,DECODE( p_attribute3, NULL, p_attribute3, FND_API.g_miss_char, NULL, p_attribute3)
211: ,DECODE( p_attribute4, NULL, p_attribute4 , FND_API.g_miss_char, NULL, p_attribute4)
212: ,DECODE( p_attribute5, NULL, p_attribute5, FND_API.g_miss_char, NULL, p_attribute5)
213: ,DECODE( p_attribute6, NULL, p_attribute6, FND_API.g_miss_char, NULL, p_attribute6)
214: ,DECODE( p_attribute7, NULL, p_attribute7, FND_API.g_miss_char, NULL, p_attribute7)
215: ,DECODE( p_attribute8, NULL, p_attribute8, FND_API.g_miss_char, NULL, p_attribute8)

Line 212: ,DECODE( p_attribute5, NULL, p_attribute5, FND_API.g_miss_char, NULL, p_attribute5)

208: ,DECODE( p_attribute1, NULL, p_attribute1, FND_API.g_miss_char, NULL, p_attribute1)
209: ,DECODE( p_attribute2, NULL, p_attribute2, FND_API.g_miss_char, NULL, p_attribute2)
210: ,DECODE( p_attribute3, NULL, p_attribute3, FND_API.g_miss_char, NULL, p_attribute3)
211: ,DECODE( p_attribute4, NULL, p_attribute4 , FND_API.g_miss_char, NULL, p_attribute4)
212: ,DECODE( p_attribute5, NULL, p_attribute5, FND_API.g_miss_char, NULL, p_attribute5)
213: ,DECODE( p_attribute6, NULL, p_attribute6, FND_API.g_miss_char, NULL, p_attribute6)
214: ,DECODE( p_attribute7, NULL, p_attribute7, FND_API.g_miss_char, NULL, p_attribute7)
215: ,DECODE( p_attribute8, NULL, p_attribute8, FND_API.g_miss_char, NULL, p_attribute8)
216: ,DECODE( p_attribute9, NULL, p_attribute9, FND_API.g_miss_char, NULL, p_attribute9)

Line 213: ,DECODE( p_attribute6, NULL, p_attribute6, FND_API.g_miss_char, NULL, p_attribute6)

209: ,DECODE( p_attribute2, NULL, p_attribute2, FND_API.g_miss_char, NULL, p_attribute2)
210: ,DECODE( p_attribute3, NULL, p_attribute3, FND_API.g_miss_char, NULL, p_attribute3)
211: ,DECODE( p_attribute4, NULL, p_attribute4 , FND_API.g_miss_char, NULL, p_attribute4)
212: ,DECODE( p_attribute5, NULL, p_attribute5, FND_API.g_miss_char, NULL, p_attribute5)
213: ,DECODE( p_attribute6, NULL, p_attribute6, FND_API.g_miss_char, NULL, p_attribute6)
214: ,DECODE( p_attribute7, NULL, p_attribute7, FND_API.g_miss_char, NULL, p_attribute7)
215: ,DECODE( p_attribute8, NULL, p_attribute8, FND_API.g_miss_char, NULL, p_attribute8)
216: ,DECODE( p_attribute9, NULL, p_attribute9, FND_API.g_miss_char, NULL, p_attribute9)
217: ,DECODE( p_attribute10, NULL, p_attribute10, FND_API.g_miss_char, NULL, p_attribute10)

Line 214: ,DECODE( p_attribute7, NULL, p_attribute7, FND_API.g_miss_char, NULL, p_attribute7)

210: ,DECODE( p_attribute3, NULL, p_attribute3, FND_API.g_miss_char, NULL, p_attribute3)
211: ,DECODE( p_attribute4, NULL, p_attribute4 , FND_API.g_miss_char, NULL, p_attribute4)
212: ,DECODE( p_attribute5, NULL, p_attribute5, FND_API.g_miss_char, NULL, p_attribute5)
213: ,DECODE( p_attribute6, NULL, p_attribute6, FND_API.g_miss_char, NULL, p_attribute6)
214: ,DECODE( p_attribute7, NULL, p_attribute7, FND_API.g_miss_char, NULL, p_attribute7)
215: ,DECODE( p_attribute8, NULL, p_attribute8, FND_API.g_miss_char, NULL, p_attribute8)
216: ,DECODE( p_attribute9, NULL, p_attribute9, FND_API.g_miss_char, NULL, p_attribute9)
217: ,DECODE( p_attribute10, NULL, p_attribute10, FND_API.g_miss_char, NULL, p_attribute10)
218: ,DECODE( p_attribute11, NULL, p_attribute11, FND_API.g_miss_char, NULL, p_attribute11)

Line 215: ,DECODE( p_attribute8, NULL, p_attribute8, FND_API.g_miss_char, NULL, p_attribute8)

211: ,DECODE( p_attribute4, NULL, p_attribute4 , FND_API.g_miss_char, NULL, p_attribute4)
212: ,DECODE( p_attribute5, NULL, p_attribute5, FND_API.g_miss_char, NULL, p_attribute5)
213: ,DECODE( p_attribute6, NULL, p_attribute6, FND_API.g_miss_char, NULL, p_attribute6)
214: ,DECODE( p_attribute7, NULL, p_attribute7, FND_API.g_miss_char, NULL, p_attribute7)
215: ,DECODE( p_attribute8, NULL, p_attribute8, FND_API.g_miss_char, NULL, p_attribute8)
216: ,DECODE( p_attribute9, NULL, p_attribute9, FND_API.g_miss_char, NULL, p_attribute9)
217: ,DECODE( p_attribute10, NULL, p_attribute10, FND_API.g_miss_char, NULL, p_attribute10)
218: ,DECODE( p_attribute11, NULL, p_attribute11, FND_API.g_miss_char, NULL, p_attribute11)
219: ,DECODE( p_attribute12, NULL, p_attribute12, FND_API.g_miss_char, NULL, p_attribute12)

Line 216: ,DECODE( p_attribute9, NULL, p_attribute9, FND_API.g_miss_char, NULL, p_attribute9)

212: ,DECODE( p_attribute5, NULL, p_attribute5, FND_API.g_miss_char, NULL, p_attribute5)
213: ,DECODE( p_attribute6, NULL, p_attribute6, FND_API.g_miss_char, NULL, p_attribute6)
214: ,DECODE( p_attribute7, NULL, p_attribute7, FND_API.g_miss_char, NULL, p_attribute7)
215: ,DECODE( p_attribute8, NULL, p_attribute8, FND_API.g_miss_char, NULL, p_attribute8)
216: ,DECODE( p_attribute9, NULL, p_attribute9, FND_API.g_miss_char, NULL, p_attribute9)
217: ,DECODE( p_attribute10, NULL, p_attribute10, FND_API.g_miss_char, NULL, p_attribute10)
218: ,DECODE( p_attribute11, NULL, p_attribute11, FND_API.g_miss_char, NULL, p_attribute11)
219: ,DECODE( p_attribute12, NULL, p_attribute12, FND_API.g_miss_char, NULL, p_attribute12)
220: ,DECODE( p_attribute13, NULL, p_attribute13, FND_API.g_miss_char, NULL, p_attribute13)

Line 217: ,DECODE( p_attribute10, NULL, p_attribute10, FND_API.g_miss_char, NULL, p_attribute10)

213: ,DECODE( p_attribute6, NULL, p_attribute6, FND_API.g_miss_char, NULL, p_attribute6)
214: ,DECODE( p_attribute7, NULL, p_attribute7, FND_API.g_miss_char, NULL, p_attribute7)
215: ,DECODE( p_attribute8, NULL, p_attribute8, FND_API.g_miss_char, NULL, p_attribute8)
216: ,DECODE( p_attribute9, NULL, p_attribute9, FND_API.g_miss_char, NULL, p_attribute9)
217: ,DECODE( p_attribute10, NULL, p_attribute10, FND_API.g_miss_char, NULL, p_attribute10)
218: ,DECODE( p_attribute11, NULL, p_attribute11, FND_API.g_miss_char, NULL, p_attribute11)
219: ,DECODE( p_attribute12, NULL, p_attribute12, FND_API.g_miss_char, NULL, p_attribute12)
220: ,DECODE( p_attribute13, NULL, p_attribute13, FND_API.g_miss_char, NULL, p_attribute13)
221: ,DECODE( p_attribute14, NULL, p_attribute14, FND_API.g_miss_char, NULL, p_attribute14)

Line 218: ,DECODE( p_attribute11, NULL, p_attribute11, FND_API.g_miss_char, NULL, p_attribute11)

214: ,DECODE( p_attribute7, NULL, p_attribute7, FND_API.g_miss_char, NULL, p_attribute7)
215: ,DECODE( p_attribute8, NULL, p_attribute8, FND_API.g_miss_char, NULL, p_attribute8)
216: ,DECODE( p_attribute9, NULL, p_attribute9, FND_API.g_miss_char, NULL, p_attribute9)
217: ,DECODE( p_attribute10, NULL, p_attribute10, FND_API.g_miss_char, NULL, p_attribute10)
218: ,DECODE( p_attribute11, NULL, p_attribute11, FND_API.g_miss_char, NULL, p_attribute11)
219: ,DECODE( p_attribute12, NULL, p_attribute12, FND_API.g_miss_char, NULL, p_attribute12)
220: ,DECODE( p_attribute13, NULL, p_attribute13, FND_API.g_miss_char, NULL, p_attribute13)
221: ,DECODE( p_attribute14, NULL, p_attribute14, FND_API.g_miss_char, NULL, p_attribute14)
222: ,DECODE( p_attribute15, NULL, p_attribute15, FND_API.g_miss_char, NULL, p_attribute15)

Line 219: ,DECODE( p_attribute12, NULL, p_attribute12, FND_API.g_miss_char, NULL, p_attribute12)

215: ,DECODE( p_attribute8, NULL, p_attribute8, FND_API.g_miss_char, NULL, p_attribute8)
216: ,DECODE( p_attribute9, NULL, p_attribute9, FND_API.g_miss_char, NULL, p_attribute9)
217: ,DECODE( p_attribute10, NULL, p_attribute10, FND_API.g_miss_char, NULL, p_attribute10)
218: ,DECODE( p_attribute11, NULL, p_attribute11, FND_API.g_miss_char, NULL, p_attribute11)
219: ,DECODE( p_attribute12, NULL, p_attribute12, FND_API.g_miss_char, NULL, p_attribute12)
220: ,DECODE( p_attribute13, NULL, p_attribute13, FND_API.g_miss_char, NULL, p_attribute13)
221: ,DECODE( p_attribute14, NULL, p_attribute14, FND_API.g_miss_char, NULL, p_attribute14)
222: ,DECODE( p_attribute15, NULL, p_attribute15, FND_API.g_miss_char, NULL, p_attribute15)
223: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)

Line 220: ,DECODE( p_attribute13, NULL, p_attribute13, FND_API.g_miss_char, NULL, p_attribute13)

216: ,DECODE( p_attribute9, NULL, p_attribute9, FND_API.g_miss_char, NULL, p_attribute9)
217: ,DECODE( p_attribute10, NULL, p_attribute10, FND_API.g_miss_char, NULL, p_attribute10)
218: ,DECODE( p_attribute11, NULL, p_attribute11, FND_API.g_miss_char, NULL, p_attribute11)
219: ,DECODE( p_attribute12, NULL, p_attribute12, FND_API.g_miss_char, NULL, p_attribute12)
220: ,DECODE( p_attribute13, NULL, p_attribute13, FND_API.g_miss_char, NULL, p_attribute13)
221: ,DECODE( p_attribute14, NULL, p_attribute14, FND_API.g_miss_char, NULL, p_attribute14)
222: ,DECODE( p_attribute15, NULL, p_attribute15, FND_API.g_miss_char, NULL, p_attribute15)
223: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
224: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)

Line 221: ,DECODE( p_attribute14, NULL, p_attribute14, FND_API.g_miss_char, NULL, p_attribute14)

217: ,DECODE( p_attribute10, NULL, p_attribute10, FND_API.g_miss_char, NULL, p_attribute10)
218: ,DECODE( p_attribute11, NULL, p_attribute11, FND_API.g_miss_char, NULL, p_attribute11)
219: ,DECODE( p_attribute12, NULL, p_attribute12, FND_API.g_miss_char, NULL, p_attribute12)
220: ,DECODE( p_attribute13, NULL, p_attribute13, FND_API.g_miss_char, NULL, p_attribute13)
221: ,DECODE( p_attribute14, NULL, p_attribute14, FND_API.g_miss_char, NULL, p_attribute14)
222: ,DECODE( p_attribute15, NULL, p_attribute15, FND_API.g_miss_char, NULL, p_attribute15)
223: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
224: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
225: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)

Line 222: ,DECODE( p_attribute15, NULL, p_attribute15, FND_API.g_miss_char, NULL, p_attribute15)

218: ,DECODE( p_attribute11, NULL, p_attribute11, FND_API.g_miss_char, NULL, p_attribute11)
219: ,DECODE( p_attribute12, NULL, p_attribute12, FND_API.g_miss_char, NULL, p_attribute12)
220: ,DECODE( p_attribute13, NULL, p_attribute13, FND_API.g_miss_char, NULL, p_attribute13)
221: ,DECODE( p_attribute14, NULL, p_attribute14, FND_API.g_miss_char, NULL, p_attribute14)
222: ,DECODE( p_attribute15, NULL, p_attribute15, FND_API.g_miss_char, NULL, p_attribute15)
223: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
224: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
225: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
226: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)

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

219: ,DECODE( p_attribute12, NULL, p_attribute12, FND_API.g_miss_char, NULL, p_attribute12)
220: ,DECODE( p_attribute13, NULL, p_attribute13, FND_API.g_miss_char, NULL, p_attribute13)
221: ,DECODE( p_attribute14, NULL, p_attribute14, FND_API.g_miss_char, NULL, p_attribute14)
222: ,DECODE( p_attribute15, NULL, p_attribute15, FND_API.g_miss_char, NULL, p_attribute15)
223: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
224: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
225: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
226: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
227: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)

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

220: ,DECODE( p_attribute13, NULL, p_attribute13, FND_API.g_miss_char, NULL, p_attribute13)
221: ,DECODE( p_attribute14, NULL, p_attribute14, FND_API.g_miss_char, NULL, p_attribute14)
222: ,DECODE( p_attribute15, NULL, p_attribute15, FND_API.g_miss_char, NULL, p_attribute15)
223: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
224: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
225: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
226: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
227: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
228: ,DECODE( p_object_version_number,NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)

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

221: ,DECODE( p_attribute14, NULL, p_attribute14, FND_API.g_miss_char, NULL, p_attribute14)
222: ,DECODE( p_attribute15, NULL, p_attribute15, FND_API.g_miss_char, NULL, p_attribute15)
223: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
224: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
225: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
226: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
227: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
228: ,DECODE( p_object_version_number,NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
229: );

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

222: ,DECODE( p_attribute15, NULL, p_attribute15, FND_API.g_miss_char, NULL, p_attribute15)
223: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
224: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
225: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
226: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
227: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
228: ,DECODE( p_object_version_number,NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
229: );
230:

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

223: ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
224: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
225: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
226: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
227: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
228: ,DECODE( p_object_version_number,NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
229: );
230:
231: INSERT INTO PV_PARTNER_PROGRAM_TL(

Line 228: ,DECODE( p_object_version_number,NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)

224: ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
225: ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
226: ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
227: ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
228: ,DECODE( p_object_version_number,NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
229: );
230:
231: INSERT INTO PV_PARTNER_PROGRAM_TL(
232: program_id

Line 248: DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)

244: ,qsnr_footer
245:
246: )
247: SELECT
248: DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
249: --DECODE( px_program_id, FND_API.g_miss_num, NULL, px_program_id)
250: ,SYSDATE
251: ,FND_GLOBAL.user_id
252: ,SYSDATE

Line 249: --DECODE( px_program_id, FND_API.g_miss_num, NULL, px_program_id)

245:
246: )
247: SELECT
248: DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
249: --DECODE( px_program_id, FND_API.g_miss_num, NULL, px_program_id)
250: ,SYSDATE
251: ,FND_GLOBAL.user_id
252: ,SYSDATE
253: ,FND_GLOBAL.user_id

Line 257: ,DECODE( p_program_name, NULL, p_program_name, FND_API.g_miss_char, NULL, p_program_name)

253: ,FND_GLOBAL.user_id
254: ,FND_GLOBAL.conc_login_id
255: ,l.language_code
256: ,USERENV('LANG')
257: ,DECODE( p_program_name, NULL, p_program_name, FND_API.g_miss_char, NULL, p_program_name)
258: ,DECODE( p_program_description,NULL, p_program_description, FND_API.g_miss_char, NULL, p_program_description)
259: ,DECODE( p_qsnr_title, NULL, p_qsnr_title, FND_API.g_miss_char, NULL, p_qsnr_title)
260: ,DECODE( p_qsnr_header,NULL, p_qsnr_header, FND_API.g_miss_char, NULL,p_qsnr_header)
261: ,DECODE( p_qsnr_footer, NULL, p_qsnr_footer, FND_API.g_miss_char, NULL,p_qsnr_footer)

Line 258: ,DECODE( p_program_description,NULL, p_program_description, FND_API.g_miss_char, NULL, p_program_description)

254: ,FND_GLOBAL.conc_login_id
255: ,l.language_code
256: ,USERENV('LANG')
257: ,DECODE( p_program_name, NULL, p_program_name, FND_API.g_miss_char, NULL, p_program_name)
258: ,DECODE( p_program_description,NULL, p_program_description, FND_API.g_miss_char, NULL, p_program_description)
259: ,DECODE( p_qsnr_title, NULL, p_qsnr_title, FND_API.g_miss_char, NULL, p_qsnr_title)
260: ,DECODE( p_qsnr_header,NULL, p_qsnr_header, FND_API.g_miss_char, NULL,p_qsnr_header)
261: ,DECODE( p_qsnr_footer, NULL, p_qsnr_footer, FND_API.g_miss_char, NULL,p_qsnr_footer)
262: FROM FND_LANGUAGES l

Line 259: ,DECODE( p_qsnr_title, NULL, p_qsnr_title, FND_API.g_miss_char, NULL, p_qsnr_title)

255: ,l.language_code
256: ,USERENV('LANG')
257: ,DECODE( p_program_name, NULL, p_program_name, FND_API.g_miss_char, NULL, p_program_name)
258: ,DECODE( p_program_description,NULL, p_program_description, FND_API.g_miss_char, NULL, p_program_description)
259: ,DECODE( p_qsnr_title, NULL, p_qsnr_title, FND_API.g_miss_char, NULL, p_qsnr_title)
260: ,DECODE( p_qsnr_header,NULL, p_qsnr_header, FND_API.g_miss_char, NULL,p_qsnr_header)
261: ,DECODE( p_qsnr_footer, NULL, p_qsnr_footer, FND_API.g_miss_char, NULL,p_qsnr_footer)
262: FROM FND_LANGUAGES l
263: WHERE l.installed_flag in ('I', 'B')

Line 260: ,DECODE( p_qsnr_header,NULL, p_qsnr_header, FND_API.g_miss_char, NULL,p_qsnr_header)

256: ,USERENV('LANG')
257: ,DECODE( p_program_name, NULL, p_program_name, FND_API.g_miss_char, NULL, p_program_name)
258: ,DECODE( p_program_description,NULL, p_program_description, FND_API.g_miss_char, NULL, p_program_description)
259: ,DECODE( p_qsnr_title, NULL, p_qsnr_title, FND_API.g_miss_char, NULL, p_qsnr_title)
260: ,DECODE( p_qsnr_header,NULL, p_qsnr_header, FND_API.g_miss_char, NULL,p_qsnr_header)
261: ,DECODE( p_qsnr_footer, NULL, p_qsnr_footer, FND_API.g_miss_char, NULL,p_qsnr_footer)
262: FROM FND_LANGUAGES l
263: WHERE l.installed_flag in ('I', 'B')
264: AND NOT EXISTS(

Line 261: ,DECODE( p_qsnr_footer, NULL, p_qsnr_footer, FND_API.g_miss_char, NULL,p_qsnr_footer)

257: ,DECODE( p_program_name, NULL, p_program_name, FND_API.g_miss_char, NULL, p_program_name)
258: ,DECODE( p_program_description,NULL, p_program_description, FND_API.g_miss_char, NULL, p_program_description)
259: ,DECODE( p_qsnr_title, NULL, p_qsnr_title, FND_API.g_miss_char, NULL, p_qsnr_title)
260: ,DECODE( p_qsnr_header,NULL, p_qsnr_header, FND_API.g_miss_char, NULL,p_qsnr_header)
261: ,DECODE( p_qsnr_footer, NULL, p_qsnr_footer, FND_API.g_miss_char, NULL,p_qsnr_footer)
262: FROM FND_LANGUAGES l
263: WHERE l.installed_flag in ('I', 'B')
264: AND NOT EXISTS(
265: SELECT NULL

Line 267: --WHERE t.program_id = DECODE( px_program_id, FND_API.g_miss_num, NULL, px_program_id)

263: WHERE l.installed_flag in ('I', 'B')
264: AND NOT EXISTS(
265: SELECT NULL
266: FROM PV_PARTNER_PROGRAM_TL t
267: --WHERE t.program_id = DECODE( px_program_id, FND_API.g_miss_num, NULL, px_program_id)
268: WHERE t.program_id = DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
269: AND t.language = l.language_code );
270:
271: END Insert_Row;

Line 268: WHERE t.program_id = DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)

264: AND NOT EXISTS(
265: SELECT NULL
266: FROM PV_PARTNER_PROGRAM_TL t
267: --WHERE t.program_id = DECODE( px_program_id, FND_API.g_miss_num, NULL, px_program_id)
268: WHERE t.program_id = DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
269: AND t.language = l.language_code );
270:
271: END Insert_Row;
272:

Line 365: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)

361:
362: UPDATE PV_PARTNER_PROGRAM_B
363: SET
364:
365: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)
366: ,PROGRAM_TYPE_ID = DECODE( p_PROGRAM_TYPE_ID, NULL ,PROGRAM_TYPE_ID,FND_API.g_miss_num, NULL , p_PROGRAM_TYPE_ID)
367: ,custom_setup_id = DECODE( p_custom_setup_id, NULL ,custom_setup_id, FND_API.g_miss_num, NULL , p_custom_setup_id)
368: ,program_level_code = DECODE( p_program_level_code, NULL , program_level_code, FND_API.g_miss_char, NULL , p_program_level_code)
369: ,program_parent_id = DECODE( p_program_parent_id, NULL , program_parent_id, FND_API.g_miss_num, NULL , p_program_parent_id)

Line 366: ,PROGRAM_TYPE_ID = DECODE( p_PROGRAM_TYPE_ID, NULL ,PROGRAM_TYPE_ID,FND_API.g_miss_num, NULL , p_PROGRAM_TYPE_ID)

362: UPDATE PV_PARTNER_PROGRAM_B
363: SET
364:
365: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)
366: ,PROGRAM_TYPE_ID = DECODE( p_PROGRAM_TYPE_ID, NULL ,PROGRAM_TYPE_ID,FND_API.g_miss_num, NULL , p_PROGRAM_TYPE_ID)
367: ,custom_setup_id = DECODE( p_custom_setup_id, NULL ,custom_setup_id, FND_API.g_miss_num, NULL , p_custom_setup_id)
368: ,program_level_code = DECODE( p_program_level_code, NULL , program_level_code, FND_API.g_miss_char, NULL , p_program_level_code)
369: ,program_parent_id = DECODE( p_program_parent_id, NULL , program_parent_id, FND_API.g_miss_num, NULL , p_program_parent_id)
370: ,program_owner_resource_id = DECODE( p_program_owner_resource_id, NULL , program_owner_resource_id, FND_API.g_miss_num, NULL ,p_program_owner_resource_id)

Line 367: ,custom_setup_id = DECODE( p_custom_setup_id, NULL ,custom_setup_id, FND_API.g_miss_num, NULL , p_custom_setup_id)

363: SET
364:
365: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)
366: ,PROGRAM_TYPE_ID = DECODE( p_PROGRAM_TYPE_ID, NULL ,PROGRAM_TYPE_ID,FND_API.g_miss_num, NULL , p_PROGRAM_TYPE_ID)
367: ,custom_setup_id = DECODE( p_custom_setup_id, NULL ,custom_setup_id, FND_API.g_miss_num, NULL , p_custom_setup_id)
368: ,program_level_code = DECODE( p_program_level_code, NULL , program_level_code, FND_API.g_miss_char, NULL , p_program_level_code)
369: ,program_parent_id = DECODE( p_program_parent_id, NULL , program_parent_id, FND_API.g_miss_num, NULL , p_program_parent_id)
370: ,program_owner_resource_id = DECODE( p_program_owner_resource_id, NULL , program_owner_resource_id, FND_API.g_miss_num, NULL ,p_program_owner_resource_id)
371: ,program_start_date = DECODE( p_program_start_date, NULL , program_start_date, FND_API.g_miss_date, NULL , p_program_start_date)

Line 368: ,program_level_code = DECODE( p_program_level_code, NULL , program_level_code, FND_API.g_miss_char, NULL , p_program_level_code)

364:
365: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)
366: ,PROGRAM_TYPE_ID = DECODE( p_PROGRAM_TYPE_ID, NULL ,PROGRAM_TYPE_ID,FND_API.g_miss_num, NULL , p_PROGRAM_TYPE_ID)
367: ,custom_setup_id = DECODE( p_custom_setup_id, NULL ,custom_setup_id, FND_API.g_miss_num, NULL , p_custom_setup_id)
368: ,program_level_code = DECODE( p_program_level_code, NULL , program_level_code, FND_API.g_miss_char, NULL , p_program_level_code)
369: ,program_parent_id = DECODE( p_program_parent_id, NULL , program_parent_id, FND_API.g_miss_num, NULL , p_program_parent_id)
370: ,program_owner_resource_id = DECODE( p_program_owner_resource_id, NULL , program_owner_resource_id, FND_API.g_miss_num, NULL ,p_program_owner_resource_id)
371: ,program_start_date = DECODE( p_program_start_date, NULL , program_start_date, FND_API.g_miss_date, NULL , p_program_start_date)
372: ,program_end_date = DECODE( p_program_end_date, NULL , program_end_date, FND_API.g_miss_date, NULL ,p_program_end_date)

Line 369: ,program_parent_id = DECODE( p_program_parent_id, NULL , program_parent_id, FND_API.g_miss_num, NULL , p_program_parent_id)

365: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)
366: ,PROGRAM_TYPE_ID = DECODE( p_PROGRAM_TYPE_ID, NULL ,PROGRAM_TYPE_ID,FND_API.g_miss_num, NULL , p_PROGRAM_TYPE_ID)
367: ,custom_setup_id = DECODE( p_custom_setup_id, NULL ,custom_setup_id, FND_API.g_miss_num, NULL , p_custom_setup_id)
368: ,program_level_code = DECODE( p_program_level_code, NULL , program_level_code, FND_API.g_miss_char, NULL , p_program_level_code)
369: ,program_parent_id = DECODE( p_program_parent_id, NULL , program_parent_id, FND_API.g_miss_num, NULL , p_program_parent_id)
370: ,program_owner_resource_id = DECODE( p_program_owner_resource_id, NULL , program_owner_resource_id, FND_API.g_miss_num, NULL ,p_program_owner_resource_id)
371: ,program_start_date = DECODE( p_program_start_date, NULL , program_start_date, FND_API.g_miss_date, NULL , p_program_start_date)
372: ,program_end_date = DECODE( p_program_end_date, NULL , program_end_date, FND_API.g_miss_date, NULL ,p_program_end_date)
373: ,allow_enrl_until_date = DECODE( p_allow_enrl_until_date, NULL , allow_enrl_until_date, FND_API.g_miss_date, NULL ,p_allow_enrl_until_date)

Line 370: ,program_owner_resource_id = DECODE( p_program_owner_resource_id, NULL , program_owner_resource_id, FND_API.g_miss_num, NULL ,p_program_owner_resource_id)

366: ,PROGRAM_TYPE_ID = DECODE( p_PROGRAM_TYPE_ID, NULL ,PROGRAM_TYPE_ID,FND_API.g_miss_num, NULL , p_PROGRAM_TYPE_ID)
367: ,custom_setup_id = DECODE( p_custom_setup_id, NULL ,custom_setup_id, FND_API.g_miss_num, NULL , p_custom_setup_id)
368: ,program_level_code = DECODE( p_program_level_code, NULL , program_level_code, FND_API.g_miss_char, NULL , p_program_level_code)
369: ,program_parent_id = DECODE( p_program_parent_id, NULL , program_parent_id, FND_API.g_miss_num, NULL , p_program_parent_id)
370: ,program_owner_resource_id = DECODE( p_program_owner_resource_id, NULL , program_owner_resource_id, FND_API.g_miss_num, NULL ,p_program_owner_resource_id)
371: ,program_start_date = DECODE( p_program_start_date, NULL , program_start_date, FND_API.g_miss_date, NULL , p_program_start_date)
372: ,program_end_date = DECODE( p_program_end_date, NULL , program_end_date, FND_API.g_miss_date, NULL ,p_program_end_date)
373: ,allow_enrl_until_date = DECODE( p_allow_enrl_until_date, NULL , allow_enrl_until_date, FND_API.g_miss_date, NULL ,p_allow_enrl_until_date)
374: ,citem_version_id = DECODE( p_citem_version_id, NULL ,citem_version_id, FND_API.g_miss_num, NULL , p_citem_version_id)

Line 371: ,program_start_date = DECODE( p_program_start_date, NULL , program_start_date, FND_API.g_miss_date, NULL , p_program_start_date)

367: ,custom_setup_id = DECODE( p_custom_setup_id, NULL ,custom_setup_id, FND_API.g_miss_num, NULL , p_custom_setup_id)
368: ,program_level_code = DECODE( p_program_level_code, NULL , program_level_code, FND_API.g_miss_char, NULL , p_program_level_code)
369: ,program_parent_id = DECODE( p_program_parent_id, NULL , program_parent_id, FND_API.g_miss_num, NULL , p_program_parent_id)
370: ,program_owner_resource_id = DECODE( p_program_owner_resource_id, NULL , program_owner_resource_id, FND_API.g_miss_num, NULL ,p_program_owner_resource_id)
371: ,program_start_date = DECODE( p_program_start_date, NULL , program_start_date, FND_API.g_miss_date, NULL , p_program_start_date)
372: ,program_end_date = DECODE( p_program_end_date, NULL , program_end_date, FND_API.g_miss_date, NULL ,p_program_end_date)
373: ,allow_enrl_until_date = DECODE( p_allow_enrl_until_date, NULL , allow_enrl_until_date, FND_API.g_miss_date, NULL ,p_allow_enrl_until_date)
374: ,citem_version_id = DECODE( p_citem_version_id, NULL ,citem_version_id, FND_API.g_miss_num, NULL , p_citem_version_id)
375: ,membership_valid_period = DECODE( p_membership_valid_period, NULL ,membership_valid_period, FND_API.g_miss_num, NULL , p_membership_valid_period)

Line 372: ,program_end_date = DECODE( p_program_end_date, NULL , program_end_date, FND_API.g_miss_date, NULL ,p_program_end_date)

368: ,program_level_code = DECODE( p_program_level_code, NULL , program_level_code, FND_API.g_miss_char, NULL , p_program_level_code)
369: ,program_parent_id = DECODE( p_program_parent_id, NULL , program_parent_id, FND_API.g_miss_num, NULL , p_program_parent_id)
370: ,program_owner_resource_id = DECODE( p_program_owner_resource_id, NULL , program_owner_resource_id, FND_API.g_miss_num, NULL ,p_program_owner_resource_id)
371: ,program_start_date = DECODE( p_program_start_date, NULL , program_start_date, FND_API.g_miss_date, NULL , p_program_start_date)
372: ,program_end_date = DECODE( p_program_end_date, NULL , program_end_date, FND_API.g_miss_date, NULL ,p_program_end_date)
373: ,allow_enrl_until_date = DECODE( p_allow_enrl_until_date, NULL , allow_enrl_until_date, FND_API.g_miss_date, NULL ,p_allow_enrl_until_date)
374: ,citem_version_id = DECODE( p_citem_version_id, NULL ,citem_version_id, FND_API.g_miss_num, NULL , p_citem_version_id)
375: ,membership_valid_period = DECODE( p_membership_valid_period, NULL ,membership_valid_period, FND_API.g_miss_num, NULL , p_membership_valid_period)
376: ,membership_period_unit = DECODE( p_membership_period_unit, NULL , membership_period_unit, FND_API.g_miss_char, NULL , p_membership_period_unit)

Line 373: ,allow_enrl_until_date = DECODE( p_allow_enrl_until_date, NULL , allow_enrl_until_date, FND_API.g_miss_date, NULL ,p_allow_enrl_until_date)

369: ,program_parent_id = DECODE( p_program_parent_id, NULL , program_parent_id, FND_API.g_miss_num, NULL , p_program_parent_id)
370: ,program_owner_resource_id = DECODE( p_program_owner_resource_id, NULL , program_owner_resource_id, FND_API.g_miss_num, NULL ,p_program_owner_resource_id)
371: ,program_start_date = DECODE( p_program_start_date, NULL , program_start_date, FND_API.g_miss_date, NULL , p_program_start_date)
372: ,program_end_date = DECODE( p_program_end_date, NULL , program_end_date, FND_API.g_miss_date, NULL ,p_program_end_date)
373: ,allow_enrl_until_date = DECODE( p_allow_enrl_until_date, NULL , allow_enrl_until_date, FND_API.g_miss_date, NULL ,p_allow_enrl_until_date)
374: ,citem_version_id = DECODE( p_citem_version_id, NULL ,citem_version_id, FND_API.g_miss_num, NULL , p_citem_version_id)
375: ,membership_valid_period = DECODE( p_membership_valid_period, NULL ,membership_valid_period, FND_API.g_miss_num, NULL , p_membership_valid_period)
376: ,membership_period_unit = DECODE( p_membership_period_unit, NULL , membership_period_unit, FND_API.g_miss_char, NULL , p_membership_period_unit)
377: ,process_rule_id = DECODE( p_process_rule_id, NULL ,process_rule_id, FND_API.g_miss_num, NULL , p_process_rule_id)

Line 374: ,citem_version_id = DECODE( p_citem_version_id, NULL ,citem_version_id, FND_API.g_miss_num, NULL , p_citem_version_id)

370: ,program_owner_resource_id = DECODE( p_program_owner_resource_id, NULL , program_owner_resource_id, FND_API.g_miss_num, NULL ,p_program_owner_resource_id)
371: ,program_start_date = DECODE( p_program_start_date, NULL , program_start_date, FND_API.g_miss_date, NULL , p_program_start_date)
372: ,program_end_date = DECODE( p_program_end_date, NULL , program_end_date, FND_API.g_miss_date, NULL ,p_program_end_date)
373: ,allow_enrl_until_date = DECODE( p_allow_enrl_until_date, NULL , allow_enrl_until_date, FND_API.g_miss_date, NULL ,p_allow_enrl_until_date)
374: ,citem_version_id = DECODE( p_citem_version_id, NULL ,citem_version_id, FND_API.g_miss_num, NULL , p_citem_version_id)
375: ,membership_valid_period = DECODE( p_membership_valid_period, NULL ,membership_valid_period, FND_API.g_miss_num, NULL , p_membership_valid_period)
376: ,membership_period_unit = DECODE( p_membership_period_unit, NULL , membership_period_unit, FND_API.g_miss_char, NULL , p_membership_period_unit)
377: ,process_rule_id = DECODE( p_process_rule_id, NULL ,process_rule_id, FND_API.g_miss_num, NULL , p_process_rule_id)
378: ,prereq_process_rule_Id = DECODE( p_prereq_process_rule_Id, NULL ,prereq_process_rule_Id, FND_API.g_miss_num, NULL , p_prereq_process_rule_Id)

Line 375: ,membership_valid_period = DECODE( p_membership_valid_period, NULL ,membership_valid_period, FND_API.g_miss_num, NULL , p_membership_valid_period)

371: ,program_start_date = DECODE( p_program_start_date, NULL , program_start_date, FND_API.g_miss_date, NULL , p_program_start_date)
372: ,program_end_date = DECODE( p_program_end_date, NULL , program_end_date, FND_API.g_miss_date, NULL ,p_program_end_date)
373: ,allow_enrl_until_date = DECODE( p_allow_enrl_until_date, NULL , allow_enrl_until_date, FND_API.g_miss_date, NULL ,p_allow_enrl_until_date)
374: ,citem_version_id = DECODE( p_citem_version_id, NULL ,citem_version_id, FND_API.g_miss_num, NULL , p_citem_version_id)
375: ,membership_valid_period = DECODE( p_membership_valid_period, NULL ,membership_valid_period, FND_API.g_miss_num, NULL , p_membership_valid_period)
376: ,membership_period_unit = DECODE( p_membership_period_unit, NULL , membership_period_unit, FND_API.g_miss_char, NULL , p_membership_period_unit)
377: ,process_rule_id = DECODE( p_process_rule_id, NULL ,process_rule_id, FND_API.g_miss_num, NULL , p_process_rule_id)
378: ,prereq_process_rule_Id = DECODE( p_prereq_process_rule_Id, NULL ,prereq_process_rule_Id, FND_API.g_miss_num, NULL , p_prereq_process_rule_Id)
379: ,program_status_code = DECODE( p_program_status_code, NULL ,program_status_code,FND_API.g_miss_char, NULL , p_program_status_code)

Line 376: ,membership_period_unit = DECODE( p_membership_period_unit, NULL , membership_period_unit, FND_API.g_miss_char, NULL , p_membership_period_unit)

372: ,program_end_date = DECODE( p_program_end_date, NULL , program_end_date, FND_API.g_miss_date, NULL ,p_program_end_date)
373: ,allow_enrl_until_date = DECODE( p_allow_enrl_until_date, NULL , allow_enrl_until_date, FND_API.g_miss_date, NULL ,p_allow_enrl_until_date)
374: ,citem_version_id = DECODE( p_citem_version_id, NULL ,citem_version_id, FND_API.g_miss_num, NULL , p_citem_version_id)
375: ,membership_valid_period = DECODE( p_membership_valid_period, NULL ,membership_valid_period, FND_API.g_miss_num, NULL , p_membership_valid_period)
376: ,membership_period_unit = DECODE( p_membership_period_unit, NULL , membership_period_unit, FND_API.g_miss_char, NULL , p_membership_period_unit)
377: ,process_rule_id = DECODE( p_process_rule_id, NULL ,process_rule_id, FND_API.g_miss_num, NULL , p_process_rule_id)
378: ,prereq_process_rule_Id = DECODE( p_prereq_process_rule_Id, NULL ,prereq_process_rule_Id, FND_API.g_miss_num, NULL , p_prereq_process_rule_Id)
379: ,program_status_code = DECODE( p_program_status_code, NULL ,program_status_code,FND_API.g_miss_char, NULL , p_program_status_code)
380: ,submit_child_nodes = DECODE( p_submit_child_nodes, NULL ,submit_child_nodes,FND_API.g_miss_char, NULL , p_submit_child_nodes)

Line 377: ,process_rule_id = DECODE( p_process_rule_id, NULL ,process_rule_id, FND_API.g_miss_num, NULL , p_process_rule_id)

373: ,allow_enrl_until_date = DECODE( p_allow_enrl_until_date, NULL , allow_enrl_until_date, FND_API.g_miss_date, NULL ,p_allow_enrl_until_date)
374: ,citem_version_id = DECODE( p_citem_version_id, NULL ,citem_version_id, FND_API.g_miss_num, NULL , p_citem_version_id)
375: ,membership_valid_period = DECODE( p_membership_valid_period, NULL ,membership_valid_period, FND_API.g_miss_num, NULL , p_membership_valid_period)
376: ,membership_period_unit = DECODE( p_membership_period_unit, NULL , membership_period_unit, FND_API.g_miss_char, NULL , p_membership_period_unit)
377: ,process_rule_id = DECODE( p_process_rule_id, NULL ,process_rule_id, FND_API.g_miss_num, NULL , p_process_rule_id)
378: ,prereq_process_rule_Id = DECODE( p_prereq_process_rule_Id, NULL ,prereq_process_rule_Id, FND_API.g_miss_num, NULL , p_prereq_process_rule_Id)
379: ,program_status_code = DECODE( p_program_status_code, NULL ,program_status_code,FND_API.g_miss_char, NULL , p_program_status_code)
380: ,submit_child_nodes = DECODE( p_submit_child_nodes, NULL ,submit_child_nodes,FND_API.g_miss_char, NULL , p_submit_child_nodes)
381: ,inventory_item_id = DECODE( p_inventory_item_id, NULL , inventory_item_id, FND_API.g_miss_num, NULL , p_inventory_item_id)

Line 378: ,prereq_process_rule_Id = DECODE( p_prereq_process_rule_Id, NULL ,prereq_process_rule_Id, FND_API.g_miss_num, NULL , p_prereq_process_rule_Id)

374: ,citem_version_id = DECODE( p_citem_version_id, NULL ,citem_version_id, FND_API.g_miss_num, NULL , p_citem_version_id)
375: ,membership_valid_period = DECODE( p_membership_valid_period, NULL ,membership_valid_period, FND_API.g_miss_num, NULL , p_membership_valid_period)
376: ,membership_period_unit = DECODE( p_membership_period_unit, NULL , membership_period_unit, FND_API.g_miss_char, NULL , p_membership_period_unit)
377: ,process_rule_id = DECODE( p_process_rule_id, NULL ,process_rule_id, FND_API.g_miss_num, NULL , p_process_rule_id)
378: ,prereq_process_rule_Id = DECODE( p_prereq_process_rule_Id, NULL ,prereq_process_rule_Id, FND_API.g_miss_num, NULL , p_prereq_process_rule_Id)
379: ,program_status_code = DECODE( p_program_status_code, NULL ,program_status_code,FND_API.g_miss_char, NULL , p_program_status_code)
380: ,submit_child_nodes = DECODE( p_submit_child_nodes, NULL ,submit_child_nodes,FND_API.g_miss_char, NULL , p_submit_child_nodes)
381: ,inventory_item_id = DECODE( p_inventory_item_id, NULL , inventory_item_id, FND_API.g_miss_num, NULL , p_inventory_item_id)
382: ,inventory_item_org_id = DECODE( p_inventory_item_org_id, NULL , inventory_item_org_id, FND_API.g_miss_num, NULL , p_inventory_item_org_id)

Line 379: ,program_status_code = DECODE( p_program_status_code, NULL ,program_status_code,FND_API.g_miss_char, NULL , p_program_status_code)

375: ,membership_valid_period = DECODE( p_membership_valid_period, NULL ,membership_valid_period, FND_API.g_miss_num, NULL , p_membership_valid_period)
376: ,membership_period_unit = DECODE( p_membership_period_unit, NULL , membership_period_unit, FND_API.g_miss_char, NULL , p_membership_period_unit)
377: ,process_rule_id = DECODE( p_process_rule_id, NULL ,process_rule_id, FND_API.g_miss_num, NULL , p_process_rule_id)
378: ,prereq_process_rule_Id = DECODE( p_prereq_process_rule_Id, NULL ,prereq_process_rule_Id, FND_API.g_miss_num, NULL , p_prereq_process_rule_Id)
379: ,program_status_code = DECODE( p_program_status_code, NULL ,program_status_code,FND_API.g_miss_char, NULL , p_program_status_code)
380: ,submit_child_nodes = DECODE( p_submit_child_nodes, NULL ,submit_child_nodes,FND_API.g_miss_char, NULL , p_submit_child_nodes)
381: ,inventory_item_id = DECODE( p_inventory_item_id, NULL , inventory_item_id, FND_API.g_miss_num, NULL , p_inventory_item_id)
382: ,inventory_item_org_id = DECODE( p_inventory_item_org_id, NULL , inventory_item_org_id, FND_API.g_miss_num, NULL , p_inventory_item_org_id)
383: ,bus_user_resp_id = DECODE( p_bus_user_resp_id, NULL , bus_user_resp_id, FND_API.g_miss_num, NULL , p_bus_user_resp_id)

Line 380: ,submit_child_nodes = DECODE( p_submit_child_nodes, NULL ,submit_child_nodes,FND_API.g_miss_char, NULL , p_submit_child_nodes)

376: ,membership_period_unit = DECODE( p_membership_period_unit, NULL , membership_period_unit, FND_API.g_miss_char, NULL , p_membership_period_unit)
377: ,process_rule_id = DECODE( p_process_rule_id, NULL ,process_rule_id, FND_API.g_miss_num, NULL , p_process_rule_id)
378: ,prereq_process_rule_Id = DECODE( p_prereq_process_rule_Id, NULL ,prereq_process_rule_Id, FND_API.g_miss_num, NULL , p_prereq_process_rule_Id)
379: ,program_status_code = DECODE( p_program_status_code, NULL ,program_status_code,FND_API.g_miss_char, NULL , p_program_status_code)
380: ,submit_child_nodes = DECODE( p_submit_child_nodes, NULL ,submit_child_nodes,FND_API.g_miss_char, NULL , p_submit_child_nodes)
381: ,inventory_item_id = DECODE( p_inventory_item_id, NULL , inventory_item_id, FND_API.g_miss_num, NULL , p_inventory_item_id)
382: ,inventory_item_org_id = DECODE( p_inventory_item_org_id, NULL , inventory_item_org_id, FND_API.g_miss_num, NULL , p_inventory_item_org_id)
383: ,bus_user_resp_id = DECODE( p_bus_user_resp_id, NULL , bus_user_resp_id, FND_API.g_miss_num, NULL , p_bus_user_resp_id)
384: ,admin_resp_id = DECODE( p_admin_resp_id, NULL , admin_resp_id, FND_API.g_miss_num, NULL , p_admin_resp_id)

Line 381: ,inventory_item_id = DECODE( p_inventory_item_id, NULL , inventory_item_id, FND_API.g_miss_num, NULL , p_inventory_item_id)

377: ,process_rule_id = DECODE( p_process_rule_id, NULL ,process_rule_id, FND_API.g_miss_num, NULL , p_process_rule_id)
378: ,prereq_process_rule_Id = DECODE( p_prereq_process_rule_Id, NULL ,prereq_process_rule_Id, FND_API.g_miss_num, NULL , p_prereq_process_rule_Id)
379: ,program_status_code = DECODE( p_program_status_code, NULL ,program_status_code,FND_API.g_miss_char, NULL , p_program_status_code)
380: ,submit_child_nodes = DECODE( p_submit_child_nodes, NULL ,submit_child_nodes,FND_API.g_miss_char, NULL , p_submit_child_nodes)
381: ,inventory_item_id = DECODE( p_inventory_item_id, NULL , inventory_item_id, FND_API.g_miss_num, NULL , p_inventory_item_id)
382: ,inventory_item_org_id = DECODE( p_inventory_item_org_id, NULL , inventory_item_org_id, FND_API.g_miss_num, NULL , p_inventory_item_org_id)
383: ,bus_user_resp_id = DECODE( p_bus_user_resp_id, NULL , bus_user_resp_id, FND_API.g_miss_num, NULL , p_bus_user_resp_id)
384: ,admin_resp_id = DECODE( p_admin_resp_id, NULL , admin_resp_id, FND_API.g_miss_num, NULL , p_admin_resp_id)
385: ,no_fee_flag = DECODE( p_no_fee_flag, NULL ,no_fee_flag,FND_API.g_miss_char, NULL , p_no_fee_flag)

Line 382: ,inventory_item_org_id = DECODE( p_inventory_item_org_id, NULL , inventory_item_org_id, FND_API.g_miss_num, NULL , p_inventory_item_org_id)

378: ,prereq_process_rule_Id = DECODE( p_prereq_process_rule_Id, NULL ,prereq_process_rule_Id, FND_API.g_miss_num, NULL , p_prereq_process_rule_Id)
379: ,program_status_code = DECODE( p_program_status_code, NULL ,program_status_code,FND_API.g_miss_char, NULL , p_program_status_code)
380: ,submit_child_nodes = DECODE( p_submit_child_nodes, NULL ,submit_child_nodes,FND_API.g_miss_char, NULL , p_submit_child_nodes)
381: ,inventory_item_id = DECODE( p_inventory_item_id, NULL , inventory_item_id, FND_API.g_miss_num, NULL , p_inventory_item_id)
382: ,inventory_item_org_id = DECODE( p_inventory_item_org_id, NULL , inventory_item_org_id, FND_API.g_miss_num, NULL , p_inventory_item_org_id)
383: ,bus_user_resp_id = DECODE( p_bus_user_resp_id, NULL , bus_user_resp_id, FND_API.g_miss_num, NULL , p_bus_user_resp_id)
384: ,admin_resp_id = DECODE( p_admin_resp_id, NULL , admin_resp_id, FND_API.g_miss_num, NULL , p_admin_resp_id)
385: ,no_fee_flag = DECODE( p_no_fee_flag, NULL ,no_fee_flag,FND_API.g_miss_char, NULL , p_no_fee_flag)
386: ,vad_invite_allow_flag = DECODE( p_vad_invite_allow_flag, NULL ,vad_invite_allow_flag,FND_API.g_miss_char, NULL , p_vad_invite_allow_flag)

Line 383: ,bus_user_resp_id = DECODE( p_bus_user_resp_id, NULL , bus_user_resp_id, FND_API.g_miss_num, NULL , p_bus_user_resp_id)

379: ,program_status_code = DECODE( p_program_status_code, NULL ,program_status_code,FND_API.g_miss_char, NULL , p_program_status_code)
380: ,submit_child_nodes = DECODE( p_submit_child_nodes, NULL ,submit_child_nodes,FND_API.g_miss_char, NULL , p_submit_child_nodes)
381: ,inventory_item_id = DECODE( p_inventory_item_id, NULL , inventory_item_id, FND_API.g_miss_num, NULL , p_inventory_item_id)
382: ,inventory_item_org_id = DECODE( p_inventory_item_org_id, NULL , inventory_item_org_id, FND_API.g_miss_num, NULL , p_inventory_item_org_id)
383: ,bus_user_resp_id = DECODE( p_bus_user_resp_id, NULL , bus_user_resp_id, FND_API.g_miss_num, NULL , p_bus_user_resp_id)
384: ,admin_resp_id = DECODE( p_admin_resp_id, NULL , admin_resp_id, FND_API.g_miss_num, NULL , p_admin_resp_id)
385: ,no_fee_flag = DECODE( p_no_fee_flag, NULL ,no_fee_flag,FND_API.g_miss_char, NULL , p_no_fee_flag)
386: ,vad_invite_allow_flag = DECODE( p_vad_invite_allow_flag, NULL ,vad_invite_allow_flag,FND_API.g_miss_char, NULL , p_vad_invite_allow_flag)
387: ,global_mmbr_reqd_flag = DECODE( p_global_mmbr_reqd_flag, NULL ,global_mmbr_reqd_flag,FND_API.g_miss_char, NULL , p_global_mmbr_reqd_flag)

Line 384: ,admin_resp_id = DECODE( p_admin_resp_id, NULL , admin_resp_id, FND_API.g_miss_num, NULL , p_admin_resp_id)

380: ,submit_child_nodes = DECODE( p_submit_child_nodes, NULL ,submit_child_nodes,FND_API.g_miss_char, NULL , p_submit_child_nodes)
381: ,inventory_item_id = DECODE( p_inventory_item_id, NULL , inventory_item_id, FND_API.g_miss_num, NULL , p_inventory_item_id)
382: ,inventory_item_org_id = DECODE( p_inventory_item_org_id, NULL , inventory_item_org_id, FND_API.g_miss_num, NULL , p_inventory_item_org_id)
383: ,bus_user_resp_id = DECODE( p_bus_user_resp_id, NULL , bus_user_resp_id, FND_API.g_miss_num, NULL , p_bus_user_resp_id)
384: ,admin_resp_id = DECODE( p_admin_resp_id, NULL , admin_resp_id, FND_API.g_miss_num, NULL , p_admin_resp_id)
385: ,no_fee_flag = DECODE( p_no_fee_flag, NULL ,no_fee_flag,FND_API.g_miss_char, NULL , p_no_fee_flag)
386: ,vad_invite_allow_flag = DECODE( p_vad_invite_allow_flag, NULL ,vad_invite_allow_flag,FND_API.g_miss_char, NULL , p_vad_invite_allow_flag)
387: ,global_mmbr_reqd_flag = DECODE( p_global_mmbr_reqd_flag, NULL ,global_mmbr_reqd_flag,FND_API.g_miss_char, NULL , p_global_mmbr_reqd_flag)
388: ,waive_subsidiary_fee_flag = DECODE( p_waive_subsidiary_fee_flag, NULL ,waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL , p_waive_subsidiary_fee_flag)

Line 385: ,no_fee_flag = DECODE( p_no_fee_flag, NULL ,no_fee_flag,FND_API.g_miss_char, NULL , p_no_fee_flag)

381: ,inventory_item_id = DECODE( p_inventory_item_id, NULL , inventory_item_id, FND_API.g_miss_num, NULL , p_inventory_item_id)
382: ,inventory_item_org_id = DECODE( p_inventory_item_org_id, NULL , inventory_item_org_id, FND_API.g_miss_num, NULL , p_inventory_item_org_id)
383: ,bus_user_resp_id = DECODE( p_bus_user_resp_id, NULL , bus_user_resp_id, FND_API.g_miss_num, NULL , p_bus_user_resp_id)
384: ,admin_resp_id = DECODE( p_admin_resp_id, NULL , admin_resp_id, FND_API.g_miss_num, NULL , p_admin_resp_id)
385: ,no_fee_flag = DECODE( p_no_fee_flag, NULL ,no_fee_flag,FND_API.g_miss_char, NULL , p_no_fee_flag)
386: ,vad_invite_allow_flag = DECODE( p_vad_invite_allow_flag, NULL ,vad_invite_allow_flag,FND_API.g_miss_char, NULL , p_vad_invite_allow_flag)
387: ,global_mmbr_reqd_flag = DECODE( p_global_mmbr_reqd_flag, NULL ,global_mmbr_reqd_flag,FND_API.g_miss_char, NULL , p_global_mmbr_reqd_flag)
388: ,waive_subsidiary_fee_flag = DECODE( p_waive_subsidiary_fee_flag, NULL ,waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL , p_waive_subsidiary_fee_flag)
389: ,qsnr_ttl_all_page_dsp_flag = DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL ,qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ttl_all_page_dsp_flag )

Line 386: ,vad_invite_allow_flag = DECODE( p_vad_invite_allow_flag, NULL ,vad_invite_allow_flag,FND_API.g_miss_char, NULL , p_vad_invite_allow_flag)

382: ,inventory_item_org_id = DECODE( p_inventory_item_org_id, NULL , inventory_item_org_id, FND_API.g_miss_num, NULL , p_inventory_item_org_id)
383: ,bus_user_resp_id = DECODE( p_bus_user_resp_id, NULL , bus_user_resp_id, FND_API.g_miss_num, NULL , p_bus_user_resp_id)
384: ,admin_resp_id = DECODE( p_admin_resp_id, NULL , admin_resp_id, FND_API.g_miss_num, NULL , p_admin_resp_id)
385: ,no_fee_flag = DECODE( p_no_fee_flag, NULL ,no_fee_flag,FND_API.g_miss_char, NULL , p_no_fee_flag)
386: ,vad_invite_allow_flag = DECODE( p_vad_invite_allow_flag, NULL ,vad_invite_allow_flag,FND_API.g_miss_char, NULL , p_vad_invite_allow_flag)
387: ,global_mmbr_reqd_flag = DECODE( p_global_mmbr_reqd_flag, NULL ,global_mmbr_reqd_flag,FND_API.g_miss_char, NULL , p_global_mmbr_reqd_flag)
388: ,waive_subsidiary_fee_flag = DECODE( p_waive_subsidiary_fee_flag, NULL ,waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL , p_waive_subsidiary_fee_flag)
389: ,qsnr_ttl_all_page_dsp_flag = DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL ,qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ttl_all_page_dsp_flag )
390: ,qsnr_hdr_all_page_dsp_flag = DECODE( p_qsnr_hdr_all_page_dsp_flag, NULL ,qsnr_hdr_all_page_dsp_flag,FND_API.g_miss_char, NULL , p_qsnr_hdr_all_page_dsp_flag)

Line 387: ,global_mmbr_reqd_flag = DECODE( p_global_mmbr_reqd_flag, NULL ,global_mmbr_reqd_flag,FND_API.g_miss_char, NULL , p_global_mmbr_reqd_flag)

383: ,bus_user_resp_id = DECODE( p_bus_user_resp_id, NULL , bus_user_resp_id, FND_API.g_miss_num, NULL , p_bus_user_resp_id)
384: ,admin_resp_id = DECODE( p_admin_resp_id, NULL , admin_resp_id, FND_API.g_miss_num, NULL , p_admin_resp_id)
385: ,no_fee_flag = DECODE( p_no_fee_flag, NULL ,no_fee_flag,FND_API.g_miss_char, NULL , p_no_fee_flag)
386: ,vad_invite_allow_flag = DECODE( p_vad_invite_allow_flag, NULL ,vad_invite_allow_flag,FND_API.g_miss_char, NULL , p_vad_invite_allow_flag)
387: ,global_mmbr_reqd_flag = DECODE( p_global_mmbr_reqd_flag, NULL ,global_mmbr_reqd_flag,FND_API.g_miss_char, NULL , p_global_mmbr_reqd_flag)
388: ,waive_subsidiary_fee_flag = DECODE( p_waive_subsidiary_fee_flag, NULL ,waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL , p_waive_subsidiary_fee_flag)
389: ,qsnr_ttl_all_page_dsp_flag = DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL ,qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ttl_all_page_dsp_flag )
390: ,qsnr_hdr_all_page_dsp_flag = DECODE( p_qsnr_hdr_all_page_dsp_flag, NULL ,qsnr_hdr_all_page_dsp_flag,FND_API.g_miss_char, NULL , p_qsnr_hdr_all_page_dsp_flag)
391: ,qsnr_ftr_all_page_dsp_flag = DECODE( p_qsnr_ftr_all_page_dsp_flag , NULL ,qsnr_ftr_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ftr_all_page_dsp_flag )

Line 388: ,waive_subsidiary_fee_flag = DECODE( p_waive_subsidiary_fee_flag, NULL ,waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL , p_waive_subsidiary_fee_flag)

384: ,admin_resp_id = DECODE( p_admin_resp_id, NULL , admin_resp_id, FND_API.g_miss_num, NULL , p_admin_resp_id)
385: ,no_fee_flag = DECODE( p_no_fee_flag, NULL ,no_fee_flag,FND_API.g_miss_char, NULL , p_no_fee_flag)
386: ,vad_invite_allow_flag = DECODE( p_vad_invite_allow_flag, NULL ,vad_invite_allow_flag,FND_API.g_miss_char, NULL , p_vad_invite_allow_flag)
387: ,global_mmbr_reqd_flag = DECODE( p_global_mmbr_reqd_flag, NULL ,global_mmbr_reqd_flag,FND_API.g_miss_char, NULL , p_global_mmbr_reqd_flag)
388: ,waive_subsidiary_fee_flag = DECODE( p_waive_subsidiary_fee_flag, NULL ,waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL , p_waive_subsidiary_fee_flag)
389: ,qsnr_ttl_all_page_dsp_flag = DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL ,qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ttl_all_page_dsp_flag )
390: ,qsnr_hdr_all_page_dsp_flag = DECODE( p_qsnr_hdr_all_page_dsp_flag, NULL ,qsnr_hdr_all_page_dsp_flag,FND_API.g_miss_char, NULL , p_qsnr_hdr_all_page_dsp_flag)
391: ,qsnr_ftr_all_page_dsp_flag = DECODE( p_qsnr_ftr_all_page_dsp_flag , NULL ,qsnr_ftr_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ftr_all_page_dsp_flag )
392: ,allow_enrl_wout_chklst_flag= DECODE( p_allow_enrl_wout_chklst_flag, NULL ,allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL , p_allow_enrl_wout_chklst_flag)

Line 389: ,qsnr_ttl_all_page_dsp_flag = DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL ,qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ttl_all_page_dsp_flag )

385: ,no_fee_flag = DECODE( p_no_fee_flag, NULL ,no_fee_flag,FND_API.g_miss_char, NULL , p_no_fee_flag)
386: ,vad_invite_allow_flag = DECODE( p_vad_invite_allow_flag, NULL ,vad_invite_allow_flag,FND_API.g_miss_char, NULL , p_vad_invite_allow_flag)
387: ,global_mmbr_reqd_flag = DECODE( p_global_mmbr_reqd_flag, NULL ,global_mmbr_reqd_flag,FND_API.g_miss_char, NULL , p_global_mmbr_reqd_flag)
388: ,waive_subsidiary_fee_flag = DECODE( p_waive_subsidiary_fee_flag, NULL ,waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL , p_waive_subsidiary_fee_flag)
389: ,qsnr_ttl_all_page_dsp_flag = DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL ,qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ttl_all_page_dsp_flag )
390: ,qsnr_hdr_all_page_dsp_flag = DECODE( p_qsnr_hdr_all_page_dsp_flag, NULL ,qsnr_hdr_all_page_dsp_flag,FND_API.g_miss_char, NULL , p_qsnr_hdr_all_page_dsp_flag)
391: ,qsnr_ftr_all_page_dsp_flag = DECODE( p_qsnr_ftr_all_page_dsp_flag , NULL ,qsnr_ftr_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ftr_all_page_dsp_flag )
392: ,allow_enrl_wout_chklst_flag= DECODE( p_allow_enrl_wout_chklst_flag, NULL ,allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL , p_allow_enrl_wout_chklst_flag)
393: ,user_status_id = DECODE( p_user_status_id, NULL ,user_status_id, FND_API.g_miss_num, NULL , p_user_status_id)

Line 390: ,qsnr_hdr_all_page_dsp_flag = DECODE( p_qsnr_hdr_all_page_dsp_flag, NULL ,qsnr_hdr_all_page_dsp_flag,FND_API.g_miss_char, NULL , p_qsnr_hdr_all_page_dsp_flag)

386: ,vad_invite_allow_flag = DECODE( p_vad_invite_allow_flag, NULL ,vad_invite_allow_flag,FND_API.g_miss_char, NULL , p_vad_invite_allow_flag)
387: ,global_mmbr_reqd_flag = DECODE( p_global_mmbr_reqd_flag, NULL ,global_mmbr_reqd_flag,FND_API.g_miss_char, NULL , p_global_mmbr_reqd_flag)
388: ,waive_subsidiary_fee_flag = DECODE( p_waive_subsidiary_fee_flag, NULL ,waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL , p_waive_subsidiary_fee_flag)
389: ,qsnr_ttl_all_page_dsp_flag = DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL ,qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ttl_all_page_dsp_flag )
390: ,qsnr_hdr_all_page_dsp_flag = DECODE( p_qsnr_hdr_all_page_dsp_flag, NULL ,qsnr_hdr_all_page_dsp_flag,FND_API.g_miss_char, NULL , p_qsnr_hdr_all_page_dsp_flag)
391: ,qsnr_ftr_all_page_dsp_flag = DECODE( p_qsnr_ftr_all_page_dsp_flag , NULL ,qsnr_ftr_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ftr_all_page_dsp_flag )
392: ,allow_enrl_wout_chklst_flag= DECODE( p_allow_enrl_wout_chklst_flag, NULL ,allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL , p_allow_enrl_wout_chklst_flag)
393: ,user_status_id = DECODE( p_user_status_id, NULL ,user_status_id, FND_API.g_miss_num, NULL , p_user_status_id)
394: ,enabled_flag = DECODE( p_enabled_flag, NULL ,enabled_flag,FND_API.g_miss_char, NULL , p_enabled_flag)

Line 391: ,qsnr_ftr_all_page_dsp_flag = DECODE( p_qsnr_ftr_all_page_dsp_flag , NULL ,qsnr_ftr_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ftr_all_page_dsp_flag )

387: ,global_mmbr_reqd_flag = DECODE( p_global_mmbr_reqd_flag, NULL ,global_mmbr_reqd_flag,FND_API.g_miss_char, NULL , p_global_mmbr_reqd_flag)
388: ,waive_subsidiary_fee_flag = DECODE( p_waive_subsidiary_fee_flag, NULL ,waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL , p_waive_subsidiary_fee_flag)
389: ,qsnr_ttl_all_page_dsp_flag = DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL ,qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ttl_all_page_dsp_flag )
390: ,qsnr_hdr_all_page_dsp_flag = DECODE( p_qsnr_hdr_all_page_dsp_flag, NULL ,qsnr_hdr_all_page_dsp_flag,FND_API.g_miss_char, NULL , p_qsnr_hdr_all_page_dsp_flag)
391: ,qsnr_ftr_all_page_dsp_flag = DECODE( p_qsnr_ftr_all_page_dsp_flag , NULL ,qsnr_ftr_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ftr_all_page_dsp_flag )
392: ,allow_enrl_wout_chklst_flag= DECODE( p_allow_enrl_wout_chklst_flag, NULL ,allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL , p_allow_enrl_wout_chklst_flag)
393: ,user_status_id = DECODE( p_user_status_id, NULL ,user_status_id, FND_API.g_miss_num, NULL , p_user_status_id)
394: ,enabled_flag = DECODE( p_enabled_flag, NULL ,enabled_flag,FND_API.g_miss_char, NULL , p_enabled_flag)
395: ,attribute_category = DECODE( p_attribute_category, attribute_category, FND_API.g_miss_char, NULL , p_attribute_category)

Line 392: ,allow_enrl_wout_chklst_flag= DECODE( p_allow_enrl_wout_chklst_flag, NULL ,allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL , p_allow_enrl_wout_chklst_flag)

388: ,waive_subsidiary_fee_flag = DECODE( p_waive_subsidiary_fee_flag, NULL ,waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL , p_waive_subsidiary_fee_flag)
389: ,qsnr_ttl_all_page_dsp_flag = DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL ,qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ttl_all_page_dsp_flag )
390: ,qsnr_hdr_all_page_dsp_flag = DECODE( p_qsnr_hdr_all_page_dsp_flag, NULL ,qsnr_hdr_all_page_dsp_flag,FND_API.g_miss_char, NULL , p_qsnr_hdr_all_page_dsp_flag)
391: ,qsnr_ftr_all_page_dsp_flag = DECODE( p_qsnr_ftr_all_page_dsp_flag , NULL ,qsnr_ftr_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ftr_all_page_dsp_flag )
392: ,allow_enrl_wout_chklst_flag= DECODE( p_allow_enrl_wout_chklst_flag, NULL ,allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL , p_allow_enrl_wout_chklst_flag)
393: ,user_status_id = DECODE( p_user_status_id, NULL ,user_status_id, FND_API.g_miss_num, NULL , p_user_status_id)
394: ,enabled_flag = DECODE( p_enabled_flag, NULL ,enabled_flag,FND_API.g_miss_char, NULL , p_enabled_flag)
395: ,attribute_category = DECODE( p_attribute_category, attribute_category, FND_API.g_miss_char, NULL , p_attribute_category)
396: ,attribute1 = DECODE( p_attribute1, NULL , attribute1,FND_API.g_miss_char, NULL , p_attribute1)

Line 393: ,user_status_id = DECODE( p_user_status_id, NULL ,user_status_id, FND_API.g_miss_num, NULL , p_user_status_id)

389: ,qsnr_ttl_all_page_dsp_flag = DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL ,qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ttl_all_page_dsp_flag )
390: ,qsnr_hdr_all_page_dsp_flag = DECODE( p_qsnr_hdr_all_page_dsp_flag, NULL ,qsnr_hdr_all_page_dsp_flag,FND_API.g_miss_char, NULL , p_qsnr_hdr_all_page_dsp_flag)
391: ,qsnr_ftr_all_page_dsp_flag = DECODE( p_qsnr_ftr_all_page_dsp_flag , NULL ,qsnr_ftr_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ftr_all_page_dsp_flag )
392: ,allow_enrl_wout_chklst_flag= DECODE( p_allow_enrl_wout_chklst_flag, NULL ,allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL , p_allow_enrl_wout_chklst_flag)
393: ,user_status_id = DECODE( p_user_status_id, NULL ,user_status_id, FND_API.g_miss_num, NULL , p_user_status_id)
394: ,enabled_flag = DECODE( p_enabled_flag, NULL ,enabled_flag,FND_API.g_miss_char, NULL , p_enabled_flag)
395: ,attribute_category = DECODE( p_attribute_category, attribute_category, FND_API.g_miss_char, NULL , p_attribute_category)
396: ,attribute1 = DECODE( p_attribute1, NULL , attribute1,FND_API.g_miss_char, NULL , p_attribute1)
397: ,attribute2 = DECODE( p_attribute2, NULL ,attribute2, FND_API.g_miss_char, NULL , p_attribute2)

Line 394: ,enabled_flag = DECODE( p_enabled_flag, NULL ,enabled_flag,FND_API.g_miss_char, NULL , p_enabled_flag)

390: ,qsnr_hdr_all_page_dsp_flag = DECODE( p_qsnr_hdr_all_page_dsp_flag, NULL ,qsnr_hdr_all_page_dsp_flag,FND_API.g_miss_char, NULL , p_qsnr_hdr_all_page_dsp_flag)
391: ,qsnr_ftr_all_page_dsp_flag = DECODE( p_qsnr_ftr_all_page_dsp_flag , NULL ,qsnr_ftr_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ftr_all_page_dsp_flag )
392: ,allow_enrl_wout_chklst_flag= DECODE( p_allow_enrl_wout_chklst_flag, NULL ,allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL , p_allow_enrl_wout_chklst_flag)
393: ,user_status_id = DECODE( p_user_status_id, NULL ,user_status_id, FND_API.g_miss_num, NULL , p_user_status_id)
394: ,enabled_flag = DECODE( p_enabled_flag, NULL ,enabled_flag,FND_API.g_miss_char, NULL , p_enabled_flag)
395: ,attribute_category = DECODE( p_attribute_category, attribute_category, FND_API.g_miss_char, NULL , p_attribute_category)
396: ,attribute1 = DECODE( p_attribute1, NULL , attribute1,FND_API.g_miss_char, NULL , p_attribute1)
397: ,attribute2 = DECODE( p_attribute2, NULL ,attribute2, FND_API.g_miss_char, NULL , p_attribute2)
398: ,attribute3 = DECODE( p_attribute3, NULL , attribute3, FND_API.g_miss_char, NULL , p_attribute3)

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

391: ,qsnr_ftr_all_page_dsp_flag = DECODE( p_qsnr_ftr_all_page_dsp_flag , NULL ,qsnr_ftr_all_page_dsp_flag ,FND_API.g_miss_char, NULL , p_qsnr_ftr_all_page_dsp_flag )
392: ,allow_enrl_wout_chklst_flag= DECODE( p_allow_enrl_wout_chklst_flag, NULL ,allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL , p_allow_enrl_wout_chklst_flag)
393: ,user_status_id = DECODE( p_user_status_id, NULL ,user_status_id, FND_API.g_miss_num, NULL , p_user_status_id)
394: ,enabled_flag = DECODE( p_enabled_flag, NULL ,enabled_flag,FND_API.g_miss_char, NULL , p_enabled_flag)
395: ,attribute_category = DECODE( p_attribute_category, attribute_category, FND_API.g_miss_char, NULL , p_attribute_category)
396: ,attribute1 = DECODE( p_attribute1, NULL , attribute1,FND_API.g_miss_char, NULL , p_attribute1)
397: ,attribute2 = DECODE( p_attribute2, NULL ,attribute2, FND_API.g_miss_char, NULL , p_attribute2)
398: ,attribute3 = DECODE( p_attribute3, NULL , attribute3, FND_API.g_miss_char, NULL , p_attribute3)
399: ,attribute4 = DECODE( p_attribute4, NULL ,attribute4, FND_API.g_miss_char, NULL , p_attribute4)

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

392: ,allow_enrl_wout_chklst_flag= DECODE( p_allow_enrl_wout_chklst_flag, NULL ,allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL , p_allow_enrl_wout_chklst_flag)
393: ,user_status_id = DECODE( p_user_status_id, NULL ,user_status_id, FND_API.g_miss_num, NULL , p_user_status_id)
394: ,enabled_flag = DECODE( p_enabled_flag, NULL ,enabled_flag,FND_API.g_miss_char, NULL , p_enabled_flag)
395: ,attribute_category = DECODE( p_attribute_category, attribute_category, FND_API.g_miss_char, NULL , p_attribute_category)
396: ,attribute1 = DECODE( p_attribute1, NULL , attribute1,FND_API.g_miss_char, NULL , p_attribute1)
397: ,attribute2 = DECODE( p_attribute2, NULL ,attribute2, FND_API.g_miss_char, NULL , p_attribute2)
398: ,attribute3 = DECODE( p_attribute3, NULL , attribute3, FND_API.g_miss_char, NULL , p_attribute3)
399: ,attribute4 = DECODE( p_attribute4, NULL ,attribute4, FND_API.g_miss_char, NULL , p_attribute4)
400: ,attribute5 = DECODE( p_attribute5, NULL , attribute5, FND_API.g_miss_char, NULL ,p_attribute5)

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

393: ,user_status_id = DECODE( p_user_status_id, NULL ,user_status_id, FND_API.g_miss_num, NULL , p_user_status_id)
394: ,enabled_flag = DECODE( p_enabled_flag, NULL ,enabled_flag,FND_API.g_miss_char, NULL , p_enabled_flag)
395: ,attribute_category = DECODE( p_attribute_category, attribute_category, FND_API.g_miss_char, NULL , p_attribute_category)
396: ,attribute1 = DECODE( p_attribute1, NULL , attribute1,FND_API.g_miss_char, NULL , p_attribute1)
397: ,attribute2 = DECODE( p_attribute2, NULL ,attribute2, FND_API.g_miss_char, NULL , p_attribute2)
398: ,attribute3 = DECODE( p_attribute3, NULL , attribute3, FND_API.g_miss_char, NULL , p_attribute3)
399: ,attribute4 = DECODE( p_attribute4, NULL ,attribute4, FND_API.g_miss_char, NULL , p_attribute4)
400: ,attribute5 = DECODE( p_attribute5, NULL , attribute5, FND_API.g_miss_char, NULL ,p_attribute5)
401: ,attribute6 = DECODE( p_attribute6, NULL ,attribute6, FND_API.g_miss_char, NULL ,p_attribute6)

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

394: ,enabled_flag = DECODE( p_enabled_flag, NULL ,enabled_flag,FND_API.g_miss_char, NULL , p_enabled_flag)
395: ,attribute_category = DECODE( p_attribute_category, attribute_category, FND_API.g_miss_char, NULL , p_attribute_category)
396: ,attribute1 = DECODE( p_attribute1, NULL , attribute1,FND_API.g_miss_char, NULL , p_attribute1)
397: ,attribute2 = DECODE( p_attribute2, NULL ,attribute2, FND_API.g_miss_char, NULL , p_attribute2)
398: ,attribute3 = DECODE( p_attribute3, NULL , attribute3, FND_API.g_miss_char, NULL , p_attribute3)
399: ,attribute4 = DECODE( p_attribute4, NULL ,attribute4, FND_API.g_miss_char, NULL , p_attribute4)
400: ,attribute5 = DECODE( p_attribute5, NULL , attribute5, FND_API.g_miss_char, NULL ,p_attribute5)
401: ,attribute6 = DECODE( p_attribute6, NULL ,attribute6, FND_API.g_miss_char, NULL ,p_attribute6)
402: ,attribute7 = DECODE( p_attribute7, NULL ,attribute7, FND_API.g_miss_char, NULL , p_attribute7)

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

395: ,attribute_category = DECODE( p_attribute_category, attribute_category, FND_API.g_miss_char, NULL , p_attribute_category)
396: ,attribute1 = DECODE( p_attribute1, NULL , attribute1,FND_API.g_miss_char, NULL , p_attribute1)
397: ,attribute2 = DECODE( p_attribute2, NULL ,attribute2, FND_API.g_miss_char, NULL , p_attribute2)
398: ,attribute3 = DECODE( p_attribute3, NULL , attribute3, FND_API.g_miss_char, NULL , p_attribute3)
399: ,attribute4 = DECODE( p_attribute4, NULL ,attribute4, FND_API.g_miss_char, NULL , p_attribute4)
400: ,attribute5 = DECODE( p_attribute5, NULL , attribute5, FND_API.g_miss_char, NULL ,p_attribute5)
401: ,attribute6 = DECODE( p_attribute6, NULL ,attribute6, FND_API.g_miss_char, NULL ,p_attribute6)
402: ,attribute7 = DECODE( p_attribute7, NULL ,attribute7, FND_API.g_miss_char, NULL , p_attribute7)
403: ,attribute8 = DECODE( p_attribute8, NULL ,attribute8, FND_API.g_miss_char, NULL , p_attribute8)

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

396: ,attribute1 = DECODE( p_attribute1, NULL , attribute1,FND_API.g_miss_char, NULL , p_attribute1)
397: ,attribute2 = DECODE( p_attribute2, NULL ,attribute2, FND_API.g_miss_char, NULL , p_attribute2)
398: ,attribute3 = DECODE( p_attribute3, NULL , attribute3, FND_API.g_miss_char, NULL , p_attribute3)
399: ,attribute4 = DECODE( p_attribute4, NULL ,attribute4, FND_API.g_miss_char, NULL , p_attribute4)
400: ,attribute5 = DECODE( p_attribute5, NULL , attribute5, FND_API.g_miss_char, NULL ,p_attribute5)
401: ,attribute6 = DECODE( p_attribute6, NULL ,attribute6, FND_API.g_miss_char, NULL ,p_attribute6)
402: ,attribute7 = DECODE( p_attribute7, NULL ,attribute7, FND_API.g_miss_char, NULL , p_attribute7)
403: ,attribute8 = DECODE( p_attribute8, NULL ,attribute8, FND_API.g_miss_char, NULL , p_attribute8)
404: ,attribute9 = DECODE( p_attribute9, NULL ,attribute9, FND_API.g_miss_char, NULL , p_attribute9)

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

397: ,attribute2 = DECODE( p_attribute2, NULL ,attribute2, FND_API.g_miss_char, NULL , p_attribute2)
398: ,attribute3 = DECODE( p_attribute3, NULL , attribute3, FND_API.g_miss_char, NULL , p_attribute3)
399: ,attribute4 = DECODE( p_attribute4, NULL ,attribute4, FND_API.g_miss_char, NULL , p_attribute4)
400: ,attribute5 = DECODE( p_attribute5, NULL , attribute5, FND_API.g_miss_char, NULL ,p_attribute5)
401: ,attribute6 = DECODE( p_attribute6, NULL ,attribute6, FND_API.g_miss_char, NULL ,p_attribute6)
402: ,attribute7 = DECODE( p_attribute7, NULL ,attribute7, FND_API.g_miss_char, NULL , p_attribute7)
403: ,attribute8 = DECODE( p_attribute8, NULL ,attribute8, FND_API.g_miss_char, NULL , p_attribute8)
404: ,attribute9 = DECODE( p_attribute9, NULL ,attribute9, FND_API.g_miss_char, NULL , p_attribute9)
405: ,attribute10 = DECODE( p_attribute10, NULL ,attribute10, FND_API.g_miss_char, NULL , p_attribute10)

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

398: ,attribute3 = DECODE( p_attribute3, NULL , attribute3, FND_API.g_miss_char, NULL , p_attribute3)
399: ,attribute4 = DECODE( p_attribute4, NULL ,attribute4, FND_API.g_miss_char, NULL , p_attribute4)
400: ,attribute5 = DECODE( p_attribute5, NULL , attribute5, FND_API.g_miss_char, NULL ,p_attribute5)
401: ,attribute6 = DECODE( p_attribute6, NULL ,attribute6, FND_API.g_miss_char, NULL ,p_attribute6)
402: ,attribute7 = DECODE( p_attribute7, NULL ,attribute7, FND_API.g_miss_char, NULL , p_attribute7)
403: ,attribute8 = DECODE( p_attribute8, NULL ,attribute8, FND_API.g_miss_char, NULL , p_attribute8)
404: ,attribute9 = DECODE( p_attribute9, NULL ,attribute9, FND_API.g_miss_char, NULL , p_attribute9)
405: ,attribute10 = DECODE( p_attribute10, NULL ,attribute10, FND_API.g_miss_char, NULL , p_attribute10)
406: ,attribute11 = DECODE( p_attribute11, NULL ,attribute11,FND_API.g_miss_char, NULL , p_attribute11)

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

399: ,attribute4 = DECODE( p_attribute4, NULL ,attribute4, FND_API.g_miss_char, NULL , p_attribute4)
400: ,attribute5 = DECODE( p_attribute5, NULL , attribute5, FND_API.g_miss_char, NULL ,p_attribute5)
401: ,attribute6 = DECODE( p_attribute6, NULL ,attribute6, FND_API.g_miss_char, NULL ,p_attribute6)
402: ,attribute7 = DECODE( p_attribute7, NULL ,attribute7, FND_API.g_miss_char, NULL , p_attribute7)
403: ,attribute8 = DECODE( p_attribute8, NULL ,attribute8, FND_API.g_miss_char, NULL , p_attribute8)
404: ,attribute9 = DECODE( p_attribute9, NULL ,attribute9, FND_API.g_miss_char, NULL , p_attribute9)
405: ,attribute10 = DECODE( p_attribute10, NULL ,attribute10, FND_API.g_miss_char, NULL , p_attribute10)
406: ,attribute11 = DECODE( p_attribute11, NULL ,attribute11,FND_API.g_miss_char, NULL , p_attribute11)
407: ,attribute12 = DECODE( p_attribute12, NULL ,attribute12, FND_API.g_miss_char, NULL , p_attribute12)

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

400: ,attribute5 = DECODE( p_attribute5, NULL , attribute5, FND_API.g_miss_char, NULL ,p_attribute5)
401: ,attribute6 = DECODE( p_attribute6, NULL ,attribute6, FND_API.g_miss_char, NULL ,p_attribute6)
402: ,attribute7 = DECODE( p_attribute7, NULL ,attribute7, FND_API.g_miss_char, NULL , p_attribute7)
403: ,attribute8 = DECODE( p_attribute8, NULL ,attribute8, FND_API.g_miss_char, NULL , p_attribute8)
404: ,attribute9 = DECODE( p_attribute9, NULL ,attribute9, FND_API.g_miss_char, NULL , p_attribute9)
405: ,attribute10 = DECODE( p_attribute10, NULL ,attribute10, FND_API.g_miss_char, NULL , p_attribute10)
406: ,attribute11 = DECODE( p_attribute11, NULL ,attribute11,FND_API.g_miss_char, NULL , p_attribute11)
407: ,attribute12 = DECODE( p_attribute12, NULL ,attribute12, FND_API.g_miss_char, NULL , p_attribute12)
408: ,attribute13 = DECODE( p_attribute13, NULL ,attribute13, FND_API.g_miss_char, NULL , p_attribute13)

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

401: ,attribute6 = DECODE( p_attribute6, NULL ,attribute6, FND_API.g_miss_char, NULL ,p_attribute6)
402: ,attribute7 = DECODE( p_attribute7, NULL ,attribute7, FND_API.g_miss_char, NULL , p_attribute7)
403: ,attribute8 = DECODE( p_attribute8, NULL ,attribute8, FND_API.g_miss_char, NULL , p_attribute8)
404: ,attribute9 = DECODE( p_attribute9, NULL ,attribute9, FND_API.g_miss_char, NULL , p_attribute9)
405: ,attribute10 = DECODE( p_attribute10, NULL ,attribute10, FND_API.g_miss_char, NULL , p_attribute10)
406: ,attribute11 = DECODE( p_attribute11, NULL ,attribute11,FND_API.g_miss_char, NULL , p_attribute11)
407: ,attribute12 = DECODE( p_attribute12, NULL ,attribute12, FND_API.g_miss_char, NULL , p_attribute12)
408: ,attribute13 = DECODE( p_attribute13, NULL ,attribute13, FND_API.g_miss_char, NULL , p_attribute13)
409: ,attribute14 = DECODE( p_attribute14, NULL ,attribute14, FND_API.g_miss_char, NULL , p_attribute14)

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

402: ,attribute7 = DECODE( p_attribute7, NULL ,attribute7, FND_API.g_miss_char, NULL , p_attribute7)
403: ,attribute8 = DECODE( p_attribute8, NULL ,attribute8, FND_API.g_miss_char, NULL , p_attribute8)
404: ,attribute9 = DECODE( p_attribute9, NULL ,attribute9, FND_API.g_miss_char, NULL , p_attribute9)
405: ,attribute10 = DECODE( p_attribute10, NULL ,attribute10, FND_API.g_miss_char, NULL , p_attribute10)
406: ,attribute11 = DECODE( p_attribute11, NULL ,attribute11,FND_API.g_miss_char, NULL , p_attribute11)
407: ,attribute12 = DECODE( p_attribute12, NULL ,attribute12, FND_API.g_miss_char, NULL , p_attribute12)
408: ,attribute13 = DECODE( p_attribute13, NULL ,attribute13, FND_API.g_miss_char, NULL , p_attribute13)
409: ,attribute14 = DECODE( p_attribute14, NULL ,attribute14, FND_API.g_miss_char, NULL , p_attribute14)
410: ,attribute15 = DECODE( p_attribute15, NULL , attribute15, FND_API.g_miss_char, NULL , p_attribute15)

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

403: ,attribute8 = DECODE( p_attribute8, NULL ,attribute8, FND_API.g_miss_char, NULL , p_attribute8)
404: ,attribute9 = DECODE( p_attribute9, NULL ,attribute9, FND_API.g_miss_char, NULL , p_attribute9)
405: ,attribute10 = DECODE( p_attribute10, NULL ,attribute10, FND_API.g_miss_char, NULL , p_attribute10)
406: ,attribute11 = DECODE( p_attribute11, NULL ,attribute11,FND_API.g_miss_char, NULL , p_attribute11)
407: ,attribute12 = DECODE( p_attribute12, NULL ,attribute12, FND_API.g_miss_char, NULL , p_attribute12)
408: ,attribute13 = DECODE( p_attribute13, NULL ,attribute13, FND_API.g_miss_char, NULL , p_attribute13)
409: ,attribute14 = DECODE( p_attribute14, NULL ,attribute14, FND_API.g_miss_char, NULL , p_attribute14)
410: ,attribute15 = DECODE( p_attribute15, NULL , attribute15, FND_API.g_miss_char, NULL , p_attribute15)
411: ,last_update_date = DECODE( p_last_update_date, NULL , last_update_date, FND_API.g_miss_date, NULL , p_last_update_date)

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

404: ,attribute9 = DECODE( p_attribute9, NULL ,attribute9, FND_API.g_miss_char, NULL , p_attribute9)
405: ,attribute10 = DECODE( p_attribute10, NULL ,attribute10, FND_API.g_miss_char, NULL , p_attribute10)
406: ,attribute11 = DECODE( p_attribute11, NULL ,attribute11,FND_API.g_miss_char, NULL , p_attribute11)
407: ,attribute12 = DECODE( p_attribute12, NULL ,attribute12, FND_API.g_miss_char, NULL , p_attribute12)
408: ,attribute13 = DECODE( p_attribute13, NULL ,attribute13, FND_API.g_miss_char, NULL , p_attribute13)
409: ,attribute14 = DECODE( p_attribute14, NULL ,attribute14, FND_API.g_miss_char, NULL , p_attribute14)
410: ,attribute15 = DECODE( p_attribute15, NULL , attribute15, FND_API.g_miss_char, NULL , p_attribute15)
411: ,last_update_date = DECODE( p_last_update_date, NULL , last_update_date, FND_API.g_miss_date, NULL , p_last_update_date)
412: ,last_updated_by = DECODE( p_last_updated_by, NULL ,last_updated_by, FND_API.g_miss_num, NULL , p_last_updated_by)

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

405: ,attribute10 = DECODE( p_attribute10, NULL ,attribute10, FND_API.g_miss_char, NULL , p_attribute10)
406: ,attribute11 = DECODE( p_attribute11, NULL ,attribute11,FND_API.g_miss_char, NULL , p_attribute11)
407: ,attribute12 = DECODE( p_attribute12, NULL ,attribute12, FND_API.g_miss_char, NULL , p_attribute12)
408: ,attribute13 = DECODE( p_attribute13, NULL ,attribute13, FND_API.g_miss_char, NULL , p_attribute13)
409: ,attribute14 = DECODE( p_attribute14, NULL ,attribute14, FND_API.g_miss_char, NULL , p_attribute14)
410: ,attribute15 = DECODE( p_attribute15, NULL , attribute15, FND_API.g_miss_char, NULL , p_attribute15)
411: ,last_update_date = DECODE( p_last_update_date, NULL , last_update_date, FND_API.g_miss_date, NULL , p_last_update_date)
412: ,last_updated_by = DECODE( p_last_updated_by, NULL ,last_updated_by, FND_API.g_miss_num, NULL , p_last_updated_by)
413: ,last_update_login = DECODE( p_last_update_login, NULL , last_update_login, FND_API.g_miss_num, NULL , p_last_update_login)

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

406: ,attribute11 = DECODE( p_attribute11, NULL ,attribute11,FND_API.g_miss_char, NULL , p_attribute11)
407: ,attribute12 = DECODE( p_attribute12, NULL ,attribute12, FND_API.g_miss_char, NULL , p_attribute12)
408: ,attribute13 = DECODE( p_attribute13, NULL ,attribute13, FND_API.g_miss_char, NULL , p_attribute13)
409: ,attribute14 = DECODE( p_attribute14, NULL ,attribute14, FND_API.g_miss_char, NULL , p_attribute14)
410: ,attribute15 = DECODE( p_attribute15, NULL , attribute15, FND_API.g_miss_char, NULL , p_attribute15)
411: ,last_update_date = DECODE( p_last_update_date, NULL , last_update_date, FND_API.g_miss_date, NULL , p_last_update_date)
412: ,last_updated_by = DECODE( p_last_updated_by, NULL ,last_updated_by, FND_API.g_miss_num, NULL , p_last_updated_by)
413: ,last_update_login = DECODE( p_last_update_login, NULL , last_update_login, FND_API.g_miss_num, NULL , p_last_update_login)
414: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)

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

407: ,attribute12 = DECODE( p_attribute12, NULL ,attribute12, FND_API.g_miss_char, NULL , p_attribute12)
408: ,attribute13 = DECODE( p_attribute13, NULL ,attribute13, FND_API.g_miss_char, NULL , p_attribute13)
409: ,attribute14 = DECODE( p_attribute14, NULL ,attribute14, FND_API.g_miss_char, NULL , p_attribute14)
410: ,attribute15 = DECODE( p_attribute15, NULL , attribute15, FND_API.g_miss_char, NULL , p_attribute15)
411: ,last_update_date = DECODE( p_last_update_date, NULL , last_update_date, FND_API.g_miss_date, NULL , p_last_update_date)
412: ,last_updated_by = DECODE( p_last_updated_by, NULL ,last_updated_by, FND_API.g_miss_num, NULL , p_last_updated_by)
413: ,last_update_login = DECODE( p_last_update_login, NULL , last_update_login, FND_API.g_miss_num, NULL , p_last_update_login)
414: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)
415:

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

408: ,attribute13 = DECODE( p_attribute13, NULL ,attribute13, FND_API.g_miss_char, NULL , p_attribute13)
409: ,attribute14 = DECODE( p_attribute14, NULL ,attribute14, FND_API.g_miss_char, NULL , p_attribute14)
410: ,attribute15 = DECODE( p_attribute15, NULL , attribute15, FND_API.g_miss_char, NULL , p_attribute15)
411: ,last_update_date = DECODE( p_last_update_date, NULL , last_update_date, FND_API.g_miss_date, NULL , p_last_update_date)
412: ,last_updated_by = DECODE( p_last_updated_by, NULL ,last_updated_by, FND_API.g_miss_num, NULL , p_last_updated_by)
413: ,last_update_login = DECODE( p_last_update_login, NULL , last_update_login, FND_API.g_miss_num, NULL , p_last_update_login)
414: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)
415:
416:

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

409: ,attribute14 = DECODE( p_attribute14, NULL ,attribute14, FND_API.g_miss_char, NULL , p_attribute14)
410: ,attribute15 = DECODE( p_attribute15, NULL , attribute15, FND_API.g_miss_char, NULL , p_attribute15)
411: ,last_update_date = DECODE( p_last_update_date, NULL , last_update_date, FND_API.g_miss_date, NULL , p_last_update_date)
412: ,last_updated_by = DECODE( p_last_updated_by, NULL ,last_updated_by, FND_API.g_miss_num, NULL , p_last_updated_by)
413: ,last_update_login = DECODE( p_last_update_login, NULL , last_update_login, FND_API.g_miss_num, NULL , p_last_update_login)
414: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)
415:
416:
417: WHERE PROGRAM_ID = p_program_id

Line 414: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)

410: ,attribute15 = DECODE( p_attribute15, NULL , attribute15, FND_API.g_miss_char, NULL , p_attribute15)
411: ,last_update_date = DECODE( p_last_update_date, NULL , last_update_date, FND_API.g_miss_date, NULL , p_last_update_date)
412: ,last_updated_by = DECODE( p_last_updated_by, NULL ,last_updated_by, FND_API.g_miss_num, NULL , p_last_updated_by)
413: ,last_update_login = DECODE( p_last_update_login, NULL , last_update_login, FND_API.g_miss_num, NULL , p_last_update_login)
414: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)
415:
416:
417: WHERE PROGRAM_ID = p_program_id
418: AND object_version_number = p_object_version_number;

Line 425: RAISE FND_API.g_exc_error;

421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
422: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
423: FND_MSG_PUB.add;
424: END IF;
425: RAISE FND_API.g_exc_error;
426: END IF;
427:
428: Update PV_PARTNER_PROGRAM_TL
429: SET

Line 434: ,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)

430: last_update_date = SYSDATE
431: ,last_updated_by = FND_GLOBAL.user_id
432: ,last_update_login = FND_GLOBAL.conc_login_id
433: ,source_lang = USERENV('LANG')
434: ,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
435: ,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)
436: ,qsnr_title = DECODE( p_qsnr_title, NULL, qsnr_title , FND_API.g_miss_char, NULL, p_qsnr_title )
437: ,qsnr_header = DECODE( p_qsnr_header, NULL, qsnr_header, FND_API.g_miss_char, NULL, p_qsnr_header)
438: ,qsnr_footer = DECODE( p_qsnr_footer, NULL,qsnr_footer, FND_API.g_miss_char, NULL, p_qsnr_footer)

Line 435: ,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)

431: ,last_updated_by = FND_GLOBAL.user_id
432: ,last_update_login = FND_GLOBAL.conc_login_id
433: ,source_lang = USERENV('LANG')
434: ,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
435: ,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)
436: ,qsnr_title = DECODE( p_qsnr_title, NULL, qsnr_title , FND_API.g_miss_char, NULL, p_qsnr_title )
437: ,qsnr_header = DECODE( p_qsnr_header, NULL, qsnr_header, FND_API.g_miss_char, NULL, p_qsnr_header)
438: ,qsnr_footer = DECODE( p_qsnr_footer, NULL,qsnr_footer, FND_API.g_miss_char, NULL, p_qsnr_footer)
439: WHERE PROGRAM_ID = p_program_id

Line 436: ,qsnr_title = DECODE( p_qsnr_title, NULL, qsnr_title , FND_API.g_miss_char, NULL, p_qsnr_title )

432: ,last_update_login = FND_GLOBAL.conc_login_id
433: ,source_lang = USERENV('LANG')
434: ,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
435: ,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)
436: ,qsnr_title = DECODE( p_qsnr_title, NULL, qsnr_title , FND_API.g_miss_char, NULL, p_qsnr_title )
437: ,qsnr_header = DECODE( p_qsnr_header, NULL, qsnr_header, FND_API.g_miss_char, NULL, p_qsnr_header)
438: ,qsnr_footer = DECODE( p_qsnr_footer, NULL,qsnr_footer, FND_API.g_miss_char, NULL, p_qsnr_footer)
439: WHERE PROGRAM_ID = p_program_id
440: AND USERENV('LANG') IN (language, source_lang);

Line 437: ,qsnr_header = DECODE( p_qsnr_header, NULL, qsnr_header, FND_API.g_miss_char, NULL, p_qsnr_header)

433: ,source_lang = USERENV('LANG')
434: ,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
435: ,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)
436: ,qsnr_title = DECODE( p_qsnr_title, NULL, qsnr_title , FND_API.g_miss_char, NULL, p_qsnr_title )
437: ,qsnr_header = DECODE( p_qsnr_header, NULL, qsnr_header, FND_API.g_miss_char, NULL, p_qsnr_header)
438: ,qsnr_footer = DECODE( p_qsnr_footer, NULL,qsnr_footer, FND_API.g_miss_char, NULL, p_qsnr_footer)
439: WHERE PROGRAM_ID = p_program_id
440: AND USERENV('LANG') IN (language, source_lang);
441:

Line 438: ,qsnr_footer = DECODE( p_qsnr_footer, NULL,qsnr_footer, FND_API.g_miss_char, NULL, p_qsnr_footer)

434: ,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
435: ,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)
436: ,qsnr_title = DECODE( p_qsnr_title, NULL, qsnr_title , FND_API.g_miss_char, NULL, p_qsnr_title )
437: ,qsnr_header = DECODE( p_qsnr_header, NULL, qsnr_header, FND_API.g_miss_char, NULL, p_qsnr_header)
438: ,qsnr_footer = DECODE( p_qsnr_footer, NULL,qsnr_footer, FND_API.g_miss_char, NULL, p_qsnr_footer)
439: WHERE PROGRAM_ID = p_program_id
440: AND USERENV('LANG') IN (language, source_lang);
441:
442: IF (SQL%NOTFOUND) THEN

Line 447: RAISE FND_API.g_exc_error;

443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
444: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
445: FND_MSG_PUB.add;
446: END IF;
447: RAISE FND_API.g_exc_error;
448: END IF;
449:
450: END Update_Row;
451:

Line 477: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)

473:
474: UPDATE PV_PARTNER_PROGRAM_B
475: SET
476:
477: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)
478: ,enabled_flag ='N'
479: ,last_update_date = SYSDATE
480: ,last_updated_by = FND_GLOBAL.user_id
481: ,last_update_login = FND_GLOBAL.conc_login_id

Line 482: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)

478: ,enabled_flag ='N'
479: ,last_update_date = SYSDATE
480: ,last_updated_by = FND_GLOBAL.user_id
481: ,last_update_login = FND_GLOBAL.conc_login_id
482: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)
483:
484:
485: WHERE PROGRAM_ID = p_program_id
486: AND object_version_number = p_object_version_number;

Line 493: RAISE FND_API.g_exc_error;

489: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
490: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
491: FND_MSG_PUB.add;
492: END IF;
493: RAISE FND_API.g_exc_error;
494: END IF;
495:
496: Update PV_PARTNER_PROGRAM_TL
497: SET

Line 502: --,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)

498: last_update_date = SYSDATE
499: ,last_updated_by = FND_GLOBAL.user_id
500: ,last_update_login = FND_GLOBAL.conc_login_id
501: ,source_lang = USERENV('LANG')
502: --,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
503: --,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)
504: WHERE PROGRAM_ID = p_program_id
505: AND USERENV('LANG') IN (language, source_lang);
506:

Line 503: --,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)

499: ,last_updated_by = FND_GLOBAL.user_id
500: ,last_update_login = FND_GLOBAL.conc_login_id
501: ,source_lang = USERENV('LANG')
502: --,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
503: --,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)
504: WHERE PROGRAM_ID = p_program_id
505: AND USERENV('LANG') IN (language, source_lang);
506:
507: IF (SQL%NOTFOUND) THEN

Line 512: RAISE FND_API.g_exc_error;

508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
509: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
510: FND_MSG_PUB.add;
511: END IF;
512: RAISE FND_API.g_exc_error;
513: END IF;
514:
515:
516: END Delete_Row ;