APPS.OM_SETUP_VALID_PKG dependencies on OE_SYS_PARAMETERS

Line 745: -- Table OE_SYSTEM_PARAMETERS_ALL is replace by OE_SYS_PARAMETERS_ALL

741: FUNCTION checkForOmOu( oper_unit NUMBER ) RETURN BOOLEAN AS
742: orgcount NUMBER;
743: BEGIN
744: -- Sys Param Change
745: -- Table OE_SYSTEM_PARAMETERS_ALL is replace by OE_SYS_PARAMETERS_ALL
746: SELECT COUNT(ORG_ID)
747: INTO orgcount
748: FROM OE_SYS_PARAMETERS_ALL
749: WHERE ORG_ID = oper_unit;

Line 748: FROM OE_SYS_PARAMETERS_ALL

744: -- Sys Param Change
745: -- Table OE_SYSTEM_PARAMETERS_ALL is replace by OE_SYS_PARAMETERS_ALL
746: SELECT COUNT(ORG_ID)
747: INTO orgcount
748: FROM OE_SYS_PARAMETERS_ALL
749: WHERE ORG_ID = oper_unit;
750: IF orgcount = 0 THEN
751: RETURN FALSE;
752: ELSE

Line 1650: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(oulist(i));

1646: FROM AR_SYSTEM_PARAMETERS_ALL aspa, GL_SETS_OF_BOOKS gsob
1647: WHERE aspa.ORG_ID = oulist(i)
1648: AND gsob.SET_OF_BOOKS_ID = aspa.SET_OF_BOOKS_ID;
1649: ELSE
1650: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(oulist(i));
1651: l_sob_id := l_AR_Sys_Param_Rec.set_of_books_id;
1652: SELECT gsob.NAME
1653: INTO sobar
1654: FROM GL_SETS_OF_BOOKS gsob

Line 1756: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', oulist(j));

1752: END;
1753: */
1754:
1755: mstrorg:=
1756: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', oulist(j));
1757: -- END Sys Param Change
1758: /*
1759: -- Commented out for bug 2888807
1760: mstrorgib := getProfileOptionValue( 10001, null, 1000227 );

Line 2521: oe_sys_parameters.value('MASTER_ORGANIZATION_ID',oulist(i));

2517: mstrorg := null;
2518: END;
2519: */
2520: mstrorg :=
2521: oe_sys_parameters.value('MASTER_ORGANIZATION_ID',oulist(i));
2522: -- End Sys Param Change
2523: IF mstrorg IS NOT NULL THEN
2524: IF arstatus = 'I' THEN
2525: SELECT COUNT(INVENTORY_ITEM_ID)

Line 3006: -- Table oe_system_parameters_all is replaced by oe_sys_parameters_all

3002: END IF;
3003: FOR i IN 1..oulist.COUNT
3004: LOOP
3005: -- Sys param Change
3006: -- Table oe_system_parameters_all is replaced by oe_sys_parameters_all
3007: SELECT COUNT(*)
3008: INTO omcnt
3009: FROM OE_SYS_PARAMETERS_ALL
3010: WHERE ORG_ID = oulist(i);

Line 3009: FROM OE_SYS_PARAMETERS_ALL

3005: -- Sys param Change
3006: -- Table oe_system_parameters_all is replaced by oe_sys_parameters_all
3007: SELECT COUNT(*)
3008: INTO omcnt
3009: FROM OE_SYS_PARAMETERS_ALL
3010: WHERE ORG_ID = oulist(i);
3011: IF omcnt > 0 THEN
3012: BEGIN
3013: SELECT SET_OF_BOOKS_ID