APPS.PV_WORKFLOW_PUB dependencies on FND_GLOBAL

Line 374: last_updated_by = FND_GLOBAL.user_id,

370: set resource_response = pv_assignment_pub.g_la_status_cm_timeout,
371: response_date = sysdate,
372: object_version_number = object_version_number + 1,
373: last_update_date = sysdate,
374: last_updated_by = FND_GLOBAL.user_id,
375: last_update_login = FND_GLOBAL.login_id
376: where lead_assignment_id = l_assignment_id_tbl(i)
377: and resource_response is null
378: and notification_type = pv_assignment_pub.g_notify_type_matched_to;

Line 375: last_update_login = FND_GLOBAL.login_id

371: response_date = sysdate,
372: object_version_number = object_version_number + 1,
373: last_update_date = sysdate,
374: last_updated_by = FND_GLOBAL.user_id,
375: last_update_login = FND_GLOBAL.login_id
376: where lead_assignment_id = l_assignment_id_tbl(i)
377: and resource_response is null
378: and notification_type = pv_assignment_pub.g_notify_type_matched_to;
379:

Line 2701: lpad(l_prod_rec.amount, l_max_length_amount) || fnd_global.local_chr(10);

2697: l_products_list := l_products_list || '' || l_prod_rec.concat_cat_parentage ||
2698: '' || l_prod_rec.amount || '';
2699: elsif display_type = 'text/plain' then
2700: l_products_list := l_products_list || rpad(l_prod_rec.concat_cat_parentage, l_max_length_products + 5) ||
2701: lpad(l_prod_rec.amount, l_max_length_amount) || fnd_global.local_chr(10);
2702: end if;
2703: end loop;
2704:
2705: if l_has_products and display_type = 'text/html' then

Line 2711: fnd_global.local_chr(10) || l_products_list;

2707: l_label_amount || '' || l_products_list || '';
2708:
2709: elsif l_has_products and display_type = 'text/plain' then
2710: l_products_list := rpad(l_label_products, l_max_length_products+2) || lpad(l_label_amount, l_max_length_amount+2) ||
2711: fnd_global.local_chr(10) || l_products_list;
2712: end if;
2713:
2714: document := l_products_list;
2715:

Line 2806: ' ' || l_contact_rec.primaryContact || fnd_global.local_chr(10);

2802: rpad( nvl(l_contact_rec.title,' ') , l_max_length_title+2) ||
2803: rpad( nvl(l_contact_rec.fullName,' ') , l_max_length_name+2) ||
2804: rpad( nvl(l_contact_rec.phoneNumber,' ') , l_max_length_phone+2) ||
2805: rpad( nvl(l_contact_rec.emailAddress,' ') , l_max_length_email+2) ||
2806: ' ' || l_contact_rec.primaryContact || fnd_global.local_chr(10);
2807: end if;
2808: end loop;
2809:
2810: if l_has_contacts and display_type = 'text/html' then

Line 2819: l_label_primary || fnd_global.local_chr(10) || l_contacts_list;

2815:
2816: elsif l_has_contacts and display_type = 'text/plain' then
2817: l_contacts_list := rpad(l_label_title, l_max_length_title+2) || rpad(l_label_name, l_max_length_name+2) ||
2818: rpad(l_label_phone, l_max_length_phone+2) || rpad(l_label_email, l_max_length_email+2) ||
2819: l_label_primary || fnd_global.local_chr(10) || l_contacts_list;
2820: end if;
2821:
2822: document := l_contacts_list;
2823:

Line 2931: l_notes_list := l_notes_list || l_notes_line || l_notes_frag || fnd_global.local_chr(10);

2927:
2928: l_notes_frag := substr(l_notes_varchar, 1, l_notes_break_pos-1);
2929:
2930: if l_first_line then
2931: l_notes_list := l_notes_list || l_notes_line || l_notes_frag || fnd_global.local_chr(10);
2932: else
2933: l_notes_list := l_notes_list || lpad(l_notes_frag, length(l_notes_line)+length(l_notes_frag)) || fnd_global.local_chr(10);
2934: end if;
2935:

Line 2933: l_notes_list := l_notes_list || lpad(l_notes_frag, length(l_notes_line)+length(l_notes_frag)) || fnd_global.local_chr(10);

2929:
2930: if l_first_line then
2931: l_notes_list := l_notes_list || l_notes_line || l_notes_frag || fnd_global.local_chr(10);
2932: else
2933: l_notes_list := l_notes_list || lpad(l_notes_frag, length(l_notes_line)+length(l_notes_frag)) || fnd_global.local_chr(10);
2934: end if;
2935:
2936: l_notes_varchar := substr(l_notes_varchar, l_notes_break_pos+1);
2937:

Line 2955: l_label_note || fnd_global.local_chr(10) || l_notes_list;

2951: l_label_name || '' || l_label_note || '' || l_notes_list || '';
2952:
2953: elsif l_has_notes and display_type = 'text/plain' then
2954: l_notes_list := rpad(l_label_date, l_max_length_date+2) || rpad(l_label_name, l_max_length_name+2) ||
2955: l_label_note || fnd_global.local_chr(10) || l_notes_list;
2956: end if;
2957: document := l_notes_list;
2958:
2959: end;