APPS.GMPMPACT dependencies on FND_PROFILE

Line 745: exclude_internal_omso := TO_NUMBER(FND_PROFILE.VALUE('GMP_EXCLUDE_INTERNAL_OMSO')); /* B3865101 */

741: OPEN get_order_ind_cur;
742: FETCH get_order_ind_cur INTO l_ord_ind;
743: CLOSE get_order_ind_cur;
744:
745: exclude_internal_omso := TO_NUMBER(FND_PROFILE.VALUE('GMP_EXCLUDE_INTERNAL_OMSO')); /* B3865101 */
746:
747: get_onhand_qty(V_item_id, V_organization_id);
748:
749: -- G_start_balance := balance1;

Line 852: ' and ((TO_NUMBER(FND_PROFILE.VALUE('||''''||'GMP_EXCLUDE_INTERNAL_OMSO'||''''||')) = 1 ' ||

848: ' and dtl.ship_from_org_id = org.organization_id '||
849: ' AND mtl.requirement_date >= nvl(:start_date, mtl.requirement_date - 1) '||
850: ' AND mtl.requirement_date <= nvl(:end_date, mtl.requirement_date + 1) '||
851: ' and org.process_enabled_flag = '||''''||'Y'||''''||
852: ' and ((TO_NUMBER(FND_PROFILE.VALUE('||''''||'GMP_EXCLUDE_INTERNAL_OMSO'||''''||')) = 1 ' ||
853: ' and nvl(dtl.source_document_type_id, 0) <> 10 ' ||
854: ' ) ' ||
855: ' or TO_NUMBER(FND_PROFILE.VALUE('||''''||'GMP_EXCLUDE_INTERNAL_OMSO'||''''||')) = 0 ' ||
856: ' ) ' ||

Line 855: ' or TO_NUMBER(FND_PROFILE.VALUE('||''''||'GMP_EXCLUDE_INTERNAL_OMSO'||''''||')) = 0 ' ||

851: ' and org.process_enabled_flag = '||''''||'Y'||''''||
852: ' and ((TO_NUMBER(FND_PROFILE.VALUE('||''''||'GMP_EXCLUDE_INTERNAL_OMSO'||''''||')) = 1 ' ||
853: ' and nvl(dtl.source_document_type_id, 0) <> 10 ' ||
854: ' ) ' ||
855: ' or TO_NUMBER(FND_PROFILE.VALUE('||''''||'GMP_EXCLUDE_INTERNAL_OMSO'||''''||')) = 0 ' ||
856: ' ) ' ||
857: ' and NOT EXISTS '||
858: ' (SELECT 1 '||
859: ' FROM so_lines_all sl, '||

Line 1693: exclude_internal_omso := TO_NUMBER(FND_PROFILE.VALUE('GMP_EXCLUDE_INTERNAL_OMSO')); /* B3865101 */

1689: X_workfield3 VARCHAR2(40);
1690: exclude_internal_omso NUMBER := 0; -- TKW Added for B3865101
1691:
1692: BEGIN
1693: exclude_internal_omso := TO_NUMBER(FND_PROFILE.VALUE('GMP_EXCLUDE_INTERNAL_OMSO')); /* B3865101 */
1694:
1695: --Retrieve sales order details.
1696: /* nsinghi MPSCONV Start */
1697: /* OPSO txns will no longer supported. So commenting the code. */

Line 1807: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');

1803:
1804: -- B7481907 Rajesh Patangya starts
1805: -- The following line of code ensures that XML data
1806: -- generated here uses the right encoding
1807: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
1808: l_xml_header := '';
1809: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_xml_header - '||l_xml_header);
1810: -- B7481907 Rajesh Patangya starts
1811: