DBA Data[Home] [Help]

APPS.PO_COMPARE_REVISIONS dependencies on FND_PROFILE

Line 1360: to_char(p_po_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),

1356: c_distribution_num,
1357: c_level_altered,
1358: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
1359: 'ICX_ACCEPTANCE_DUE_DATE',
1360: to_char(p_po_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1361: to_char(p_po_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1362: );
1363: END IF;
1364:

Line 1361: to_char(p_po_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))

1357: c_level_altered,
1358: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
1359: 'ICX_ACCEPTANCE_DUE_DATE',
1360: to_char(p_po_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1361: to_char(p_po_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1362: );
1363: END IF;
1364:
1365: v_progress := '280';

Line 1414: to_char(p_po_from.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),

1410: c_distribution_num,
1411: c_level_altered,
1412: --fnd_message.get_String('PO', 'POS_EFFECTIVE_DATE'),
1413: 'ICX_EFFECTIVE_DATE',
1414: to_char(p_po_from.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1415: to_char(p_po_to.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1416: );
1417: END IF;
1418:

Line 1415: to_char(p_po_to.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))

1411: c_level_altered,
1412: --fnd_message.get_String('PO', 'POS_EFFECTIVE_DATE'),
1413: 'ICX_EFFECTIVE_DATE',
1414: to_char(p_po_from.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1415: to_char(p_po_to.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1416: );
1417: END IF;
1418:
1419: v_progress := '300';

Line 1442: to_char(p_po_from.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),

1438: c_distribution_num,
1439: c_level_altered,
1440: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
1441: 'ICX_EXPIRATION_DATE',
1442: to_char(p_po_from.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1443: to_char(p_po_to.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1444: );
1445: END IF;
1446:

Line 1443: to_char(p_po_to.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))

1439: c_level_altered,
1440: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
1441: 'ICX_EXPIRATION_DATE',
1442: to_char(p_po_from.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1443: to_char(p_po_to.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1444: );
1445: END IF;
1446:
1447: v_progress := '310';

Line 1724: to_char(p_release_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),

1720: c_distribution_num,
1721: c_level_altered,
1722: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
1723: 'ICX_ACCEPTANCE_DUE_DATE',
1724: to_char(p_release_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1725: to_char(p_release_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1726: );
1727: END IF;
1728:

Line 1725: to_char(p_release_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))

1721: c_level_altered,
1722: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
1723: 'ICX_ACCEPTANCE_DUE_DATE',
1724: to_char(p_release_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1725: to_char(p_release_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1726: );
1727: END IF;
1728:
1729: v_progress := '380';

Line 1804: to_char(p_release_from.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),

1800: c_distribution_num,
1801: c_level_altered,
1802: --fnd_message.get_String('PO', 'POS_RELEASE_DATE'),
1803: 'ICX_RELEASE_DATE',
1804: to_char(p_release_from.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1805: to_char(p_release_to.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1806: );
1807: END IF;
1808:

Line 1805: to_char(p_release_to.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))

1801: c_level_altered,
1802: --fnd_message.get_String('PO', 'POS_RELEASE_DATE'),
1803: 'ICX_RELEASE_DATE',
1804: to_char(p_release_from.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1805: to_char(p_release_to.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1806: );
1807: END IF;
1808:
1809: EXCEPTION

Line 2519: to_char(p_line_from.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),

2515: c_distribution_num,
2516: c_level_altered,
2517: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
2518: 'ICX_EXPIRATION_DATE',
2519: to_char(p_line_from.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2520: to_char(p_line_to.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2521: );
2522: END IF;
2523:

Line 2520: to_char(p_line_to.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))

2516: c_level_altered,
2517: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
2518: 'ICX_EXPIRATION_DATE',
2519: to_char(p_line_from.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2520: to_char(p_line_to.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2521: );
2522: END IF;
2523:
2524: EXCEPTION

Line 2802: to_char(p_loc_from.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),

2798: c_distribution_num,
2799: c_level_altered,
2800: --fnd_message.get_String('PO', 'POS_PROMISED_DATE'),
2801: 'ICX_PROMISED_DATE',
2802: to_char(p_loc_from.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2803: to_char(p_loc_to.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2804:
2805: );
2806: END IF;

Line 2803: to_char(p_loc_to.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))

2799: c_level_altered,
2800: --fnd_message.get_String('PO', 'POS_PROMISED_DATE'),
2801: 'ICX_PROMISED_DATE',
2802: to_char(p_loc_from.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2803: to_char(p_loc_to.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2804:
2805: );
2806: END IF;
2807:

Line 2831: to_char(p_loc_from.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),

2827: c_distribution_num,
2828: c_level_altered,
2829: --fnd_message.get_String('PO', 'POS_NEED_BY_DATE'),
2830: 'ICX_NEED_BY_DATE',
2831: to_char(p_loc_from.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2832: to_char(p_loc_to.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2833: );
2834: END IF;
2835:

Line 2832: to_char(p_loc_to.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))

2828: c_level_altered,
2829: --fnd_message.get_String('PO', 'POS_NEED_BY_DATE'),
2830: 'ICX_NEED_BY_DATE',
2831: to_char(p_loc_from.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2832: to_char(p_loc_to.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2833: );
2834: END IF;
2835:
2836: v_progress := '670';

Line 2859: to_char(p_loc_from.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),

2855: c_distribution_num,
2856: c_level_altered,
2857: --fnd_message.get_String('PO', 'POS_LAST_ACCEPT_DATE'),
2858: 'ICX_LAST_ACCEPT_DATE',
2859: to_char(p_loc_from.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2860: to_char(p_loc_to.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2861: );
2862: END IF;
2863:

Line 2860: to_char(p_loc_to.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))

2856: c_level_altered,
2857: --fnd_message.get_String('PO', 'POS_LAST_ACCEPT_DATE'),
2858: 'ICX_LAST_ACCEPT_DATE',
2859: to_char(p_loc_from.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2860: to_char(p_loc_to.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2861: );
2862: END IF;
2863:
2864: v_progress := '680';