DBA Data[Home] [Help]

APPS.PO_COMPARE_REVISIONS dependencies on FND_PROFILE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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