APPS.GMI_VALID_GRP dependencies on PO_VEND_MST

Line 2327: --| This function validates that Vendor exists on po_vend_mst |

2323: --| USAGE |
2324: --| Validates shipvendor_no |
2325: --| |
2326: --| DESCRIPTION |
2327: --| This function validates that Vendor exists on po_vend_mst |
2328: --| |
2329: --| PARAMETERS |
2330: --| p_shipvendor_no IN VARCHAR2(32) - Ship Vendor Code |
2331: --| |

Line 2341: ( p_shipvendor_no IN po_vend_mst.vendor_no%TYPE

2337: --| 11/13/1998 Mike Godfrey - Created |
2338: --| |
2339: --+==========================================================================+
2340: FUNCTION Validate_shipvendor_no
2341: ( p_shipvendor_no IN po_vend_mst.vendor_no%TYPE
2342: )
2343: RETURN NUMBER
2344: IS
2345: l_shipvendor_no po_vend_mst.vendor_no%TYPE;

Line 2345: l_shipvendor_no po_vend_mst.vendor_no%TYPE;

2341: ( p_shipvendor_no IN po_vend_mst.vendor_no%TYPE
2342: )
2343: RETURN NUMBER
2344: IS
2345: l_shipvendor_no po_vend_mst.vendor_no%TYPE;
2346: l_shipvendor_id ic_lots_mst.shipvend_id%TYPE;
2347:
2348: CURSOR po_vend_mst_c1 IS
2349: SELECT

Line 2348: CURSOR po_vend_mst_c1 IS

2344: IS
2345: l_shipvendor_no po_vend_mst.vendor_no%TYPE;
2346: l_shipvendor_id ic_lots_mst.shipvend_id%TYPE;
2347:
2348: CURSOR po_vend_mst_c1 IS
2349: SELECT
2350: vendor_no
2351: , vendor_id
2352: FROM

Line 2353: po_vend_mst

2349: SELECT
2350: vendor_no
2351: , vendor_id
2352: FROM
2353: po_vend_mst
2354: WHERE
2355: vendor_no = p_shipvendor_no
2356: AND delete_mark = 0;
2357:

Line 2364: OPEN po_vend_mst_c1;

2360: IF (p_shipvendor_no = ' ' OR p_shipvendor_no IS NULL)
2361: THEN
2362: RETURN 0;
2363: ELSE
2364: OPEN po_vend_mst_c1;
2365: FETCH po_vend_mst_c1 INTO l_shipvendor_no, l_shipvendor_id;
2366: IF (po_vend_mst_c1%NOTFOUND)
2367: THEN
2368: CLOSE po_vend_mst_c1;

Line 2365: FETCH po_vend_mst_c1 INTO l_shipvendor_no, l_shipvendor_id;

2361: THEN
2362: RETURN 0;
2363: ELSE
2364: OPEN po_vend_mst_c1;
2365: FETCH po_vend_mst_c1 INTO l_shipvendor_no, l_shipvendor_id;
2366: IF (po_vend_mst_c1%NOTFOUND)
2367: THEN
2368: CLOSE po_vend_mst_c1;
2369: RETURN 0;

Line 2366: IF (po_vend_mst_c1%NOTFOUND)

2362: RETURN 0;
2363: ELSE
2364: OPEN po_vend_mst_c1;
2365: FETCH po_vend_mst_c1 INTO l_shipvendor_no, l_shipvendor_id;
2366: IF (po_vend_mst_c1%NOTFOUND)
2367: THEN
2368: CLOSE po_vend_mst_c1;
2369: RETURN 0;
2370: ELSE

Line 2368: CLOSE po_vend_mst_c1;

2364: OPEN po_vend_mst_c1;
2365: FETCH po_vend_mst_c1 INTO l_shipvendor_no, l_shipvendor_id;
2366: IF (po_vend_mst_c1%NOTFOUND)
2367: THEN
2368: CLOSE po_vend_mst_c1;
2369: RETURN 0;
2370: ELSE
2371: CLOSE po_vend_mst_c1;
2372: RETURN l_shipvendor_id;

Line 2371: CLOSE po_vend_mst_c1;

2367: THEN
2368: CLOSE po_vend_mst_c1;
2369: RETURN 0;
2370: ELSE
2371: CLOSE po_vend_mst_c1;
2372: RETURN l_shipvendor_id;
2373: END IF;
2374: END IF;
2375: