68: p_attribute14,
69: p_attribute15,
70: p_attribute_category,
71: SYSDATE,
72: fnd_global.user_id,
73: SYSDATE,
74: fnd_global.user_id,
75: fnd_global.login_id
76: );
70: p_attribute_category,
71: SYSDATE,
72: fnd_global.user_id,
73: SYSDATE,
74: fnd_global.user_id,
75: fnd_global.login_id
76: );
77:
78: -- standard check of p_commit
71: SYSDATE,
72: fnd_global.user_id,
73: SYSDATE,
74: fnd_global.user_id,
75: fnd_global.login_id
76: );
77:
78: -- standard check of p_commit
79: IF (fnd_api.to_boolean (p_commit))
186: p_attribute14,
187: p_attribute15,
188: p_attribute_category,
189: SYSDATE,
190: fnd_global.user_id,
191: fnd_global.login_id
192: );
193: x_object_version_number := x_object_version_number + 1;
194:
187: p_attribute15,
188: p_attribute_category,
189: SYSDATE,
190: fnd_global.user_id,
191: fnd_global.login_id
192: );
193: x_object_version_number := x_object_version_number + 1;
194:
195: -- standard check of p_commit
332: min_win_probability = p_min_win_probability,
333: template_id = p_sales_supplement_template,
334: stage_sequence = p_stage_sequence,
335: last_update_date = SYSDATE,
336: last_updated_by = fnd_global.user_id,
337: last_update_login = fnd_global.login_id
338: WHERE
339: sales_methodology_id = p_sales_methodology_id
340: AND
333: template_id = p_sales_supplement_template,
334: stage_sequence = p_stage_sequence,
335: last_update_date = SYSDATE,
336: last_updated_by = fnd_global.user_id,
337: last_update_login = fnd_global.login_id
338: WHERE
339: sales_methodology_id = p_sales_methodology_id
340: AND
341: sales_stage_id = p_sales_stage_id;
363: p_max_win_probability,
364: p_min_win_probability,
365: p_sales_supplement_template,
366: p_stage_sequence,
367: fnd_global.user_id,
368: SYSDATE,
369: fnd_global.user_id,
370: SYSDATE,
371: fnd_global.login_id
365: p_sales_supplement_template,
366: p_stage_sequence,
367: fnd_global.user_id,
368: SYSDATE,
369: fnd_global.user_id,
370: SYSDATE,
371: fnd_global.login_id
372: );
373:
367: fnd_global.user_id,
368: SYSDATE,
369: fnd_global.user_id,
370: SYSDATE,
371: fnd_global.login_id
372: );
373:
374: IF (SQL%NOTFOUND) THEN
375: RAISE no_data_found;