APPS.GMPMPACT dependencies on FND_PROFILE

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

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

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

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

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

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

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

1671: X_workfield3 VARCHAR2(40);
1672: exclude_internal_omso NUMBER := 0; -- TKW Added for B3865101
1673:
1674: BEGIN
1675: exclude_internal_omso := TO_NUMBER(FND_PROFILE.VALUE('GMP_EXCLUDE_INTERNAL_OMSO')); /* B3865101 */
1676:
1677: --Retrieve sales order details.
1678: /* nsinghi MPSCONV Start */
1679: /* OPSO txns will no longer supported. So commenting the code. */