APPS.POS_ASN_NOTIF dependencies on FND_GLOBAL

Line 397: NL VARCHAR2(1) := fnd_global.newline;

393: x_invoice_date date;
394: x_invoice_ts varchar2(150);
395: x_tax_amount NUMBER;
396: l_document1 VARCHAR2(32000) := '';
397: NL VARCHAR2(1) := fnd_global.newline;
398: x_display_type VARCHAR2(60);
399: x_buyer_user_name VARCHAR2(320);
400: x_buyer_user_displayname VARCHAR2(360);
401: l_nid NUMBER;

Line 501: To_char(poh.shipped_date,fnd_profile.Value_specific('ICX_DATE_FORMAT_MASK',fnd_global.user_id),

497:
498: SELECT DISTINCT poh.shipment_num,
499: pov.vendor_name,
500: poh.shipped_date,
501: To_char(poh.shipped_date,fnd_profile.Value_specific('ICX_DATE_FORMAT_MASK',fnd_global.user_id),
502: 'NLS_CALENDAR = '''
503: ||Nvl(fnd_profile.Value_specific('FND_FORMS_USER_CALENDAR',fnd_global.user_id),
504: 'GREGORIAN')
505: ||''''),

Line 503: ||Nvl(fnd_profile.Value_specific('FND_FORMS_USER_CALENDAR',fnd_global.user_id),

499: pov.vendor_name,
500: poh.shipped_date,
501: To_char(poh.shipped_date,fnd_profile.Value_specific('ICX_DATE_FORMAT_MASK',fnd_global.user_id),
502: 'NLS_CALENDAR = '''
503: ||Nvl(fnd_profile.Value_specific('FND_FORMS_USER_CALENDAR',fnd_global.user_id),
504: 'GREGORIAN')
505: ||''''),
506: poh.expected_receipt_date,
507: To_char(poh.expected_receipt_date,fnd_profile.Value_specific('ICX_DATE_FORMAT_MASK',fnd_global.user_id),

Line 507: To_char(poh.expected_receipt_date,fnd_profile.Value_specific('ICX_DATE_FORMAT_MASK',fnd_global.user_id),

503: ||Nvl(fnd_profile.Value_specific('FND_FORMS_USER_CALENDAR',fnd_global.user_id),
504: 'GREGORIAN')
505: ||''''),
506: poh.expected_receipt_date,
507: To_char(poh.expected_receipt_date,fnd_profile.Value_specific('ICX_DATE_FORMAT_MASK',fnd_global.user_id),
508: 'NLS_CALENDAR = '''
509: ||Nvl(fnd_profile.Value_specific('FND_FORMS_USER_CALENDAR',fnd_global.user_id),
510: 'GREGORIAN')
511: ||''''),

Line 509: ||Nvl(fnd_profile.Value_specific('FND_FORMS_USER_CALENDAR',fnd_global.user_id),

505: ||''''),
506: poh.expected_receipt_date,
507: To_char(poh.expected_receipt_date,fnd_profile.Value_specific('ICX_DATE_FORMAT_MASK',fnd_global.user_id),
508: 'NLS_CALENDAR = '''
509: ||Nvl(fnd_profile.Value_specific('FND_FORMS_USER_CALENDAR',fnd_global.user_id),
510: 'GREGORIAN')
511: ||''''),
512: poh.invoice_num,
513: poh.total_invoice_amount,

Line 514: To_char(poh.invoice_date,fnd_profile.Value_specific('ICX_DATE_FORMAT_MASK',fnd_global.user_id),

510: 'GREGORIAN')
511: ||''''),
512: poh.invoice_num,
513: poh.total_invoice_amount,
514: To_char(poh.invoice_date,fnd_profile.Value_specific('ICX_DATE_FORMAT_MASK',fnd_global.user_id),
515: 'NLS_CALENDAR = '''
516: ||Nvl(fnd_profile.Value_specific('FND_FORMS_USER_CALENDAR',fnd_global.user_id),
517: 'GREGORIAN')
518: ||''''),

Line 516: ||Nvl(fnd_profile.Value_specific('FND_FORMS_USER_CALENDAR',fnd_global.user_id),

512: poh.invoice_num,
513: poh.total_invoice_amount,
514: To_char(poh.invoice_date,fnd_profile.Value_specific('ICX_DATE_FORMAT_MASK',fnd_global.user_id),
515: 'NLS_CALENDAR = '''
516: ||Nvl(fnd_profile.Value_specific('FND_FORMS_USER_CALENDAR',fnd_global.user_id),
517: 'GREGORIAN')
518: ||''''),
519: poh.tax_amount,
520: poh.asn_type

Line 800: NL VARCHAR2(1) := fnd_global.newline;

796: ship_to rcv_transactions_interface.ship_to_location_code%type,
797: ship_to_org org_organization_definitions.ORGANIZATION_CODE%type
798: );
799:
800: NL VARCHAR2(1) := fnd_global.newline;
801: l_document VARCHAR2(32000) := '';
802: l_asn_lines asn_lines_record;
803: x_shipment_num pos_lines_v.shipment_num%TYPE;
804: x_buyer_id NUMBER;