eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_UPDATE_USER_PREF_PUB dependencies on FND_BUSINESS_PURPOSES_B

Line 31: from fnd_business_purposes_b

27: Cursor c_bus_purp
28: IS
29: select purpose_code,
30: purpose_default_code
31: from fnd_business_purposes_b
32: where purpose_code <> 'ALL';
33:
34:
35: CURSOR c_cont_pref(l_party_id in number,

Line 58: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES

54: FROM HZ_CONTACT_PREFERENCES pref
55: WHERE pref.CONTACT_LEVEL_TABLE_ID = l_party_id
56: AND pref.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
57: AND pref.preference_topic_type_code = l_purpose_code -- this will be l_purpose_code
58: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES
59: AND pref.contact_type = 'PRIV_PREF'
60: -- AND sysdate between pref.preference_start_date and nvl(pref.preference_end_date, sysdate +1)
61: AND status = 'A';
62:

Line 146: l_contact_preference_record.preference_topic_type := 'FND_BUSINESS_PURPOSES_B';

142: l_contact_preference_record.contact_level_table := 'HZ_PARTIES';
143: l_contact_preference_record.contact_level_table_id := l_party_id;
144: l_contact_preference_record.contact_type := 'PRIV_PREF';
145: l_contact_preference_record.preference_code := 'DO_NOT';
146: l_contact_preference_record.preference_topic_type := 'FND_BUSINESS_PURPOSES_B';
147: --l_contact_preference_record.preference_topic_type_id := 'ALL';
148: l_contact_preference_record.preference_topic_type_code := 'ALL';
149: l_contact_preference_record.preference_start_date := trunc(sysdate);
150: l_contact_preference_record.preference_end_date := null ;

Line 226: l_contact_preference_record.preference_topic_type := 'FND_BUSINESS_PURPOSES_B';

222: l_contact_preference_record.contact_level_table := 'HZ_PARTIES';
223: l_contact_preference_record.contact_level_table_id := l_party_id;
224: l_contact_preference_record.contact_type := 'PRIV_PREF';
225: l_contact_preference_record.preference_code := 'DO_NOT';
226: l_contact_preference_record.preference_topic_type := 'FND_BUSINESS_PURPOSES_B';
227: --l_contact_preference_record.preference_topic_type_id := r_bus_purp.purpose_code;
228: l_contact_preference_record.preference_topic_type_code := r_bus_purp.purpose_code;
229: l_contact_preference_record.preference_start_date := trunc(sysdate);
230: l_contact_preference_record.preference_end_date := null ;

Line 404: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B'

400: preferences will have to be removed */
401: delete HZ_CONTACT_PREFERENCES pref
402: WHERE pref.CONTACT_LEVEL_TABLE_ID = l_party_id
403: AND pref.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
404: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B'
405: AND pref.contact_type = 'PRIV_PREF';
406:
407: END IF; -- end of p_party_id check
408:

Line 495: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B'

491: WHERE pref.CONTACT_LEVEL_TABLE_ID = l_party_id
492: AND pref.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
493: --AND pref.preference_topic_type_id = l_purpose_code
494: AND pref.preference_topic_type_code = l_purpose_code
495: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B'
496: AND pref.contact_type = 'PRIV_PREF'
497: AND status = 'A';
498:
499: r_cont_pref c_cont_pref%rowtype;

Line 580: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B'

576:
577: delete HZ_CONTACT_PREFERENCES pref
578: WHERE pref.CONTACT_LEVEL_TABLE_ID = l_party_id
579: AND pref.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
580: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B'
581: AND pref.contact_type = 'PRIV_PREF'
582: AND pref.preference_topic_type_code = p_option(i).purpose_code;
583:
584: END IF;

Line 614: l_contact_preference_record.preference_topic_type := 'FND_BUSINESS_PURPOSES_B';

610: l_contact_preference_record.contact_level_table := 'HZ_PARTIES';
611: l_contact_preference_record.contact_level_table_id := l_party_id;
612: l_contact_preference_record.contact_type := 'PRIV_PREF';
613: l_contact_preference_record.preference_code := 'DO';
614: l_contact_preference_record.preference_topic_type := 'FND_BUSINESS_PURPOSES_B';
615: --l_contact_preference_record.preference_topic_type_id := p_option(i).purpose_code;
616: l_contact_preference_record.preference_topic_type_code := p_option(i).purpose_code;
617: l_contact_preference_record.preference_start_date := trunc(sysdate);
618: l_contact_preference_record.preference_end_date := null ;

Line 677: l_contact_preference_record.preference_topic_type := 'FND_BUSINESS_PURPOSES_B';

673: l_contact_preference_record.contact_level_table := 'HZ_PARTIES';
674: l_contact_preference_record.contact_level_table_id := l_party_id;
675: l_contact_preference_record.contact_type := 'PRIV_PREF';
676: l_contact_preference_record.preference_code := 'DO_NOT';
677: l_contact_preference_record.preference_topic_type := 'FND_BUSINESS_PURPOSES_B';
678: --l_contact_preference_record.preference_topic_type_id := p_option(i).purpose_code;
679: l_contact_preference_record.preference_topic_type_code := p_option(i).purpose_code;
680: l_contact_preference_record.preference_start_date := trunc(sysdate);
681: l_contact_preference_record.preference_end_date := null ;

Line 727: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B'

723: THEN
724: delete HZ_CONTACT_PREFERENCES pref
725: WHERE pref.CONTACT_LEVEL_TABLE_ID = l_party_id
726: AND pref.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
727: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B'
728: AND pref.contact_type = 'PRIV_PREF'
729: AND pref.preference_topic_type_code = 'ALL';
730:
731: END IF;