APPS.WSH_UTIL_VALIDATE dependencies on AR_LOOKUPS

Line 4287: -- parameter is present in the AR lookups.If it is not present

4283: -- API name : VALIDATE_FOB
4284: -- Type : Public
4285: -- Pre-reqs : None.
4286: -- Function : This API is used to check whether the FOB supplied as the
4287: -- parameter is present in the AR lookups.If it is not present
4288: -- it creates the FOB under AR lookups.
4289: -- Lookup type is 'FOB' in AR_LOOKUPS
4290: -- Parameters :
4291: -- IN:

Line 4288: -- it creates the FOB under AR lookups.

4284: -- Type : Public
4285: -- Pre-reqs : None.
4286: -- Function : This API is used to check whether the FOB supplied as the
4287: -- parameter is present in the AR lookups.If it is not present
4288: -- it creates the FOB under AR lookups.
4289: -- Lookup type is 'FOB' in AR_LOOKUPS
4290: -- Parameters :
4291: -- IN:
4292: -- p_fob IN VARCHAR2

Line 4289: -- Lookup type is 'FOB' in AR_LOOKUPS

4285: -- Pre-reqs : None.
4286: -- Function : This API is used to check whether the FOB supplied as the
4287: -- parameter is present in the AR lookups.If it is not present
4288: -- it creates the FOB under AR lookups.
4289: -- Lookup type is 'FOB' in AR_LOOKUPS
4290: -- Parameters :
4291: -- IN:
4292: -- p_fob IN VARCHAR2
4293: -- IN OUT:

Line 4305: --Cursor to determine whether the given look up code is present in ar lookups.

4301: PROCEDURE validate_fob(
4302: p_fob IN VARCHAR2,
4303: x_return_status OUT NOCOPY VARCHAR2) IS
4304:
4305: --Cursor to determine whether the given look up code is present in ar lookups.
4306: Cursor c_fob(p_lookup_code VARCHAR2) IS
4307: SELECT 1
4308: FROM
4309: ar_lookups

Line 4309: ar_lookups

4305: --Cursor to determine whether the given look up code is present in ar lookups.
4306: Cursor c_fob(p_lookup_code VARCHAR2) IS
4307: SELECT 1
4308: FROM
4309: ar_lookups
4310: WHERE
4311: lookup_type = 'FOB' AND
4312: lookup_code = p_lookup_code AND
4313: nvl(start_date_active,SYSDATE) <= SYSDATE AND

Line 4362: -- from FND lookups and inserts the same into AR lookups.

4358: OPEN c_fob(p_fob);
4359: FETCH c_fob INTO l_fob;
4360:
4361: -- If True -> the given FOB is not in AR lokups. Then it gets the details of the FOB
4362: -- from FND lookups and inserts the same into AR lookups.
4363: IF c_fob%NOTFOUND THEN
4364: OPEN c_po_fob(p_fob);
4365: FETCH c_po_fob INTO l_meaning,l_desc;
4366: CLOSE c_po_fob;