DBA Data[Home] [Help]

APPS.AML_INTERACTION_ENGINE dependencies on FND_PROFILE

Line 475: NVL(TO_NUMBER(FND_PROFILE.Value('AS_LAST_INTERACTION_ID')), 0);

471: END IF;
472:
473: -- Find all the interactions after the last interaction engine run.
474: l_last_interaction_id :=
475: NVL(TO_NUMBER(FND_PROFILE.Value('AS_LAST_INTERACTION_ID')), 0);
476: l_lead_interaction_lookback :=
477: NVL(TO_NUMBER(FND_PROFILE.Value('AS_LEAD_INTERACTION_LOOKBACK')), 0);
478: l_default_source_code :=
479: FND_PROFILE.Value('AS_DEFAULT_SOURCE_FOR_INTERENG');

Line 477: NVL(TO_NUMBER(FND_PROFILE.Value('AS_LEAD_INTERACTION_LOOKBACK')), 0);

473: -- Find all the interactions after the last interaction engine run.
474: l_last_interaction_id :=
475: NVL(TO_NUMBER(FND_PROFILE.Value('AS_LAST_INTERACTION_ID')), 0);
476: l_lead_interaction_lookback :=
477: NVL(TO_NUMBER(FND_PROFILE.Value('AS_LEAD_INTERACTION_LOOKBACK')), 0);
478: l_default_source_code :=
479: FND_PROFILE.Value('AS_DEFAULT_SOURCE_FOR_INTERENG');
480: AML_DEBUG('l_last_interaction_id=' || l_last_interaction_id);
481: AML_DEBUG('l_lead_interaction_lookback=' || l_lead_interaction_lookback);

Line 479: FND_PROFILE.Value('AS_DEFAULT_SOURCE_FOR_INTERENG');

475: NVL(TO_NUMBER(FND_PROFILE.Value('AS_LAST_INTERACTION_ID')), 0);
476: l_lead_interaction_lookback :=
477: NVL(TO_NUMBER(FND_PROFILE.Value('AS_LEAD_INTERACTION_LOOKBACK')), 0);
478: l_default_source_code :=
479: FND_PROFILE.Value('AS_DEFAULT_SOURCE_FOR_INTERENG');
480: AML_DEBUG('l_last_interaction_id=' || l_last_interaction_id);
481: AML_DEBUG('l_lead_interaction_lookback=' || l_lead_interaction_lookback);
482: AML_DEBUG('l_default_source_code=' || l_default_source_code);
483:

Line 489: NVL(TO_NUMBER(FND_PROFILE.Value('AS_INTERACTION_LOOKBACK')), 0);

485: -- interaction created in N days.
486: IF l_last_interaction_id = 0
487: THEN
488: l_interaction_lookback :=
489: NVL(TO_NUMBER(FND_PROFILE.Value('AS_INTERACTION_LOOKBACK')), 0);
490: AML_DEBUG('l_interaction_lookback=' || l_interaction_lookback);
491: -- Pick the first interaction created in N days.
492: OPEN c_get_last_interaction_id(l_interaction_lookback);
493: FETCH c_get_last_interaction_id INTO l_last_interaction_id;

Line 518: l_save_profile := fnd_profile.save('AS_LAST_INTERACTION_ID',

514: FETCH C_Get_Batch_ID INTO l_batch_id;
515: CLOSE C_Get_Batch_ID;
516: AML_DEBUG('batch_id=' || l_batch_id);
517:
518: l_save_profile := fnd_profile.save('AS_LAST_INTERACTION_ID',
519: TO_CHAR(l_interaction_id_tbl(l_interaction_id_tbl.count)), 'SITE');
520:
521: l_default_interaction_score :=
522: NVL(TO_NUMBER(FND_PROFILE.Value('AS_DEFAULT_INTERACTION_SCORE')),0);

Line 522: NVL(TO_NUMBER(FND_PROFILE.Value('AS_DEFAULT_INTERACTION_SCORE')),0);

518: l_save_profile := fnd_profile.save('AS_LAST_INTERACTION_ID',
519: TO_CHAR(l_interaction_id_tbl(l_interaction_id_tbl.count)), 'SITE');
520:
521: l_default_interaction_score :=
522: NVL(TO_NUMBER(FND_PROFILE.Value('AS_DEFAULT_INTERACTION_SCORE')),0);
523: AML_DEBUG('default score=' || l_default_interaction_score);
524:
525: -- If the attribute Interaction Score is not used in
526: -- qualification, rating, channel selection rules, lead

Line 596: IF FND_PROFILE.Value('AS_INTR_MATCH_B2B_LEAD_CONTACT') = 'Y' AND

592:
593: AML_DEBUG('l_interaction_score=' || l_interaction_score);
594: l_sales_lead_id := NULL;
595: -- l_lead_interaction_score := NULL;
596: IF FND_PROFILE.Value('AS_INTR_MATCH_B2B_LEAD_CONTACT') = 'Y' AND
597: l_contact_party_id_tbl(i) IS NOT NULL
598: THEN
599: -- match organization party_id and contact
600: AML_DEBUG('Match lead party and contact');

Line 704: fnd_profile.value('AS_DEFAULT_RESOURCE_ID');

700: IF (C_get_current_resource%NOTFOUND)
701: THEN
702: AML_DEBUG('No current resource found! Get default');
703: l_identity_salesforce_id :=
704: fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
705: END IF;
706: CLOSE C_get_current_resource;
707:
708: AML_DEBUG('l_i_sf_id=' || l_identity_salesforce_id);

Line 786: IF FND_PROFILE.Value('AS_INTR_MATCH_B2B_LEAD_CONTACT') = 'Y' AND

782: -- Find matched record in as_import_interface, if no open lead
783: -- matched
784: l_import_interface_id := NULL;
785:
786: IF FND_PROFILE.Value('AS_INTR_MATCH_B2B_LEAD_CONTACT') = 'Y' AND
787: l_contact_party_id_tbl(i) IS NOT NULL
788: THEN
789: -- match organization party_id and contact
790: AML_DEBUG('Match response party and contact');

Line 925: NVL(TO_NUMBER(FND_PROFILE.Value('AS_INTERACTION_SCORE_THRESHOLD')), 0);

921: -- need to process this record. Therefore, set batch_id to NULL,
922: -- so lead import program won't pick up this record, and interaction
923: -- engine can match this interaction again next time.
924: l_interaction_score_threshold :=
925: NVL(TO_NUMBER(FND_PROFILE.Value('AS_INTERACTION_SCORE_THRESHOLD')), 0);
926: AML_DEBUG('intr score threshold: ' || l_interaction_score_threshold);
927: UPDATE as_import_interface
928: SET last_update_date = SYSDATE,
929: last_updated_by = fnd_global.user_id,