DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_RANKS_PVT dependencies on AS_ACCESSES_ALL

Line 794: -- as_accesses_all.lead_rank_score

790: IF l_min_score <> p_sales_lead_rank_rec.min_score
791: THEN
792: -- Run concurrent program for the rank.
793: -- Update as_sales_leads.lead_rank_score and
794: -- as_accesses_all.lead_rank_score
795: l_request_id := FND_REQUEST.SUBMIT_REQUEST('AS',
796: 'ASXSLRS',
797: 'Update LEAD_RANK_SCORE',
798: '',

Line 1035: --Update the as_accesses_all.lead_rank_score

1031: , sl.last_updated_by = fnd_global.user_id
1032: , sl.last_update_login = fnd_global.conc_login_id
1033: WHERE sl.lead_rank_id = x_lead_rank_id;
1034:
1035: --Update the as_accesses_all.lead_rank_score
1036: Write_log (1, 'Updating the as_accesses_all.lead_rank_score');
1037: UPDATE AS_ACCESSES_ALL acc
1038: SET acc.lead_rank_score = x_lead_rank_score
1039: , acc.last_update_date = sysdate

Line 1036: Write_log (1, 'Updating the as_accesses_all.lead_rank_score');

1032: , sl.last_update_login = fnd_global.conc_login_id
1033: WHERE sl.lead_rank_id = x_lead_rank_id;
1034:
1035: --Update the as_accesses_all.lead_rank_score
1036: Write_log (1, 'Updating the as_accesses_all.lead_rank_score');
1037: UPDATE AS_ACCESSES_ALL acc
1038: SET acc.lead_rank_score = x_lead_rank_score
1039: , acc.last_update_date = sysdate
1040: , acc.last_updated_by = fnd_global.user_id

Line 1037: UPDATE AS_ACCESSES_ALL acc

1033: WHERE sl.lead_rank_id = x_lead_rank_id;
1034:
1035: --Update the as_accesses_all.lead_rank_score
1036: Write_log (1, 'Updating the as_accesses_all.lead_rank_score');
1037: UPDATE AS_ACCESSES_ALL acc
1038: SET acc.lead_rank_score = x_lead_rank_score
1039: , acc.last_update_date = sysdate
1040: , acc.last_updated_by = fnd_global.user_id
1041: , acc.last_update_login = fnd_global.conc_login_id