APPS.OM_SETUP_VALID_PKG dependencies on WSH_SHIPPING_PARAMETERS

Line 405: FROM WSH_SHIPPING_PARAMETERS

401: ind NUMBER := 1;
402: /* Cursor Variables */
403: CURSOR shorgs(ou NUMBER) IS
404: SELECT ORGANIZATION_ID
405: FROM WSH_SHIPPING_PARAMETERS
406: WHERE ORGANIZATION_ID IN (
407: SELECT HOU.ORGANIZATION_ID ORGANIZATION_ID
408: FROM HR_ORGANIZATION_UNITS HOU,
409: HR_ORGANIZATION_INFORMATION HOI,

Line 2751: FROM WSH_SHIPPING_PARAMETERS

2747: FOR j IN 1..shiporgs.COUNT
2748: LOOP
2749: SELECT COUNT(ORGANIZATION_ID)
2750: INTO shorgscnt
2751: FROM WSH_SHIPPING_PARAMETERS
2752: WHERE ORGANIZATION_ID = shiporgs(j);
2753: IF shorgscnt > 0 THEN
2754: EXIT;
2755: END IF;

Line 2768: FROM WSH_SHIPPING_PARAMETERS

2764: FOR j IN 1..shiporgs.COUNT
2765: LOOP
2766: SELECT COUNT(ORGANIZATION_ID)
2767: INTO shorgscnt
2768: FROM WSH_SHIPPING_PARAMETERS
2769: WHERE ORGANIZATION_ID = shiporgs(j);
2770: IF ( shorgscnt = 0 AND checkForOmOu(oulist(i)) = TRUE) THEN
2771: error_type := 'WARNING';
2772: mesg_name := 'ONT_SETVAL_INVALID_SHIP_OMORG';

Line 2784: FROM WSH_SHIPPING_PARAMETERS

2780: LOOP
2781: BEGIN
2782: SELECT DEFAULT_STAGE_SUBINVENTORY
2783: INTO dftstgsub
2784: FROM WSH_SHIPPING_PARAMETERS
2785: WHERE ORGANIZATION_ID = shiporgs(j);
2786: EXCEPTION
2787: WHEN NO_DATA_FOUND THEN
2788: dftstgsub := null;

Line 2820: FROM WSH_SHIPPING_PARAMETERS

2816: FOR j IN 1..shiporgs.COUNT
2817: LOOP
2818: SELECT COUNT(ORGANIZATION_ID)
2819: INTO pickcnt
2820: FROM WSH_SHIPPING_PARAMETERS
2821: WHERE ORGANIZATION_ID = shiporgs(j)
2822: AND PICK_SEQUENCE_RULE_ID IS NOT NULL
2823: AND PICK_GROUPING_RULE_ID IS NOT NULL;
2824: IF pickcnt = 0 THEN