APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTY_WEBADI_RESOURCES

Line 739: INSERT INTO jty_webadi_resources(user_sequence, interface_type, header, terr_id, terr_rsc_id,

735:
736: l_header := 'RSC';
737:
738: forall i IN p_terr_rec.terr_id.FIRST .. p_terr_rec.terr_id.LAST
739: INSERT INTO jty_webadi_resources(user_sequence, interface_type, header, terr_id, terr_rsc_id,
740: resource_name, resource_group, resource_role, resource_id, group_id, role_code,
741: resource_type, res_start_date, res_end_date, email, attribute_category, attribute1,
742: attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8,
743: attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15,

Line 908: FROM jty_webadi_resources jwr

904: p_user_id,
905: l_today_date,
906: p_user_id,
907: p_user_id
908: FROM jty_webadi_resources jwr
909: WHERE jwr.user_sequence = p_user_sequence
910: AND jwr.interface_type = p_interface_type
911: AND jwr.header = l_header
912: AND jwr.terr_id = p_terr_rec.terr_id(i);

Line 1215: DELETE FROM jty_webadi_resources jwr

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
1216: WHERE NOT EXISTS
1217: (SELECT 1
1218: FROM jty_webadi_oth_terr_intf jwot
1219: WHERE jwot.user_sequence = jwr.user_sequence)