APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTY_WEBADI_RESOURCES

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

1190:
1191: l_header := 'RSC';
1192:
1193: forall i IN p_terr_rec.terr_id.FIRST .. p_terr_rec.terr_id.LAST
1194: INSERT INTO jty_webadi_resources(user_sequence, interface_type, header, terr_id, terr_rsc_id,
1195: resource_name, resource_group, resource_role, resource_id, group_id, role_code,
1196: resource_type, res_start_date, res_end_date, email, attribute_category, attribute1,
1197: attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8,
1198: attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15,

Line 1363: FROM jty_webadi_resources jwr

1359: p_user_id,
1360: l_today_date,
1361: p_user_id,
1362: p_user_id
1363: FROM jty_webadi_resources jwr
1364: WHERE jwr.user_sequence = p_user_sequence
1365: AND jwr.interface_type = p_interface_type
1366: AND jwr.header = l_header
1367: AND jwr.terr_id = p_terr_rec.terr_id(i);

Line 1673: DELETE FROM jty_webadi_resources jwr

1669: WHERE
1670: -- user_id = p_user_id AND
1671: creation_date <= sysdate -3;
1672:
1673: DELETE FROM jty_webadi_resources jwr
1674: WHERE NOT EXISTS
1675: (SELECT 1
1676: FROM jty_webadi_oth_terr_intf jwot
1677: WHERE jwot.user_sequence = jwr.user_sequence)