[Home] [Help]
159: fnd_message.set_name('JTF', 'JTY_OTH_TERR_GEO_TYPE');
160: x_errbuf := fnd_message.GET();
161: ELSE
162: INSERT
163: INTO jty_webadi_oth_terr_intf(interface_type, org_id, usage_id, user_id, user_sequence,
164: qual1_value1, qual2_value1, qual3_value1, qual4_value1, qual5_value1, qual6_value1,
165: qual7_value1, qual8_value1, qual9_value1, qual10_value1, qual11_value1, qual12_value1,
166: qual13_value1, qual14_value1, qual15_value1, qual16_value1, qual17_value1, qual18_value1,
167: qual19_value1, qual20_value1, qual21_value1, qual22_value1, qual23_value1, qual24_value1,
404:
405: IF p_terr_rec.terr_id.COUNT > 0 THEN
406: l_header := 'TERR';
407: forall i IN p_terr_rec.terr_id.FIRST .. p_terr_rec.terr_id.LAST INSERT
408: INTO jty_webadi_oth_terr_intf(interface_type, action_flag, header, user_sequence, user_id, org_id,
409: org_name, usage_id, terr_id, terr_name, terr_type_name, terr_type_id, rank, num_winners,
410: terr_start_date, terr_end_date, parent_terr_id, hierarchy, attribute_category, attribute1,
411: attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8,
412: attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15,
425:
426: l_header := 'QUAL';
427:
428: forall i IN p_terr_rec.terr_id.FIRST .. p_terr_rec.terr_id.LAST INSERT
429: INTO jty_webadi_oth_terr_intf(interface_type, action_flag, header, user_sequence, user_id,
430: org_id, org_name, usage_id, terr_id, terr_name, terr_type_name, terr_type_id, rank,
431: num_winners, terr_start_date, terr_end_date, parent_terr_id, hierarchy, creation_date,
432: created_by, last_update_date, last_updated_by, last_update_login, row_id, qual1_value_id,
433: qual1_value1, qual1_value2, qual1_value3, qual2_value_id, qual2_value1, qual2_value2,
883: jtr.attribute15)
884: terr_rsc;
885:
886: forall i IN p_terr_rec.terr_id.FIRST .. p_terr_rec.terr_id.LAST
887: INSERT INTO jty_webadi_oth_terr_intf(interface_type, user_sequence, terr_rsc_id, action_flag,
888: header, user_id, org_id, org_name, usage_id, parent_terr_id, terr_id, terr_name,
889: hierarchy, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
890: SELECT jwr.interface_type,
891: jwr.user_sequence,
1202: l_mode := nvl(p_mode, 'NODE');
1203: l_view := nvl(p_view, 'TERR');
1204:
1205: BEGIN
1206: SELECT jty_webadi_oth_terr_intf_s.nextval
1207: INTO l_seq
1208: FROM dual;
1209: -- remove existing old data for this userid which is older than 3 days
1210:
1207: INTO l_seq
1208: FROM dual;
1209: -- remove existing old data for this userid which is older than 3 days
1210:
1211: DELETE FROM jty_webadi_oth_terr_intf
1212: WHERE user_id = p_user_id
1213: AND creation_date <= sysdate -3;
1214:
1215: DELETE FROM jty_webadi_resources jwr
1214:
1215: DELETE FROM jty_webadi_resources jwr
1216: WHERE NOT EXISTS
1217: (SELECT 1
1218: FROM jty_webadi_oth_terr_intf jwot
1219: WHERE jwot.user_sequence = jwr.user_sequence)
1220: ;
1221:
1222: COMMIT;