APPS.WSH_UTIL_VALIDATE dependencies on AR_LOOKUPS

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

4327: -- API name : VALIDATE_FOB
4328: -- Type : Public
4329: -- Pre-reqs : None.
4330: -- Function : This API is used to check whether the FOB supplied as the
4331: -- parameter is present in the AR lookups.If it is not present
4332: -- it creates the FOB under AR lookups.
4333: -- Lookup type is 'FOB' in AR_LOOKUPS
4334: -- Parameters :
4335: -- IN:

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

4328: -- Type : Public
4329: -- Pre-reqs : None.
4330: -- Function : This API is used to check whether the FOB supplied as the
4331: -- parameter is present in the AR lookups.If it is not present
4332: -- it creates the FOB under AR lookups.
4333: -- Lookup type is 'FOB' in AR_LOOKUPS
4334: -- Parameters :
4335: -- IN:
4336: -- p_fob IN VARCHAR2

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

4329: -- Pre-reqs : None.
4330: -- Function : This API is used to check whether the FOB supplied as the
4331: -- parameter is present in the AR lookups.If it is not present
4332: -- it creates the FOB under AR lookups.
4333: -- Lookup type is 'FOB' in AR_LOOKUPS
4334: -- Parameters :
4335: -- IN:
4336: -- p_fob IN VARCHAR2
4337: -- IN OUT:

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

4345: PROCEDURE validate_fob(
4346: p_fob IN VARCHAR2,
4347: x_return_status OUT NOCOPY VARCHAR2) IS
4348:
4349: --Cursor to determine whether the given look up code is present in ar lookups.
4350: Cursor c_fob(p_lookup_code VARCHAR2) IS
4351: SELECT 1
4352: FROM
4353: ar_lookups

Line 4353: ar_lookups

4349: --Cursor to determine whether the given look up code is present in ar lookups.
4350: Cursor c_fob(p_lookup_code VARCHAR2) IS
4351: SELECT 1
4352: FROM
4353: ar_lookups
4354: WHERE
4355: lookup_type = 'FOB' AND
4356: lookup_code = p_lookup_code AND
4357: nvl(start_date_active,SYSDATE) <= SYSDATE AND

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

4402: OPEN c_fob(p_fob);
4403: FETCH c_fob INTO l_fob;
4404:
4405: -- If True -> the given FOB is not in AR lokups. Then it gets the details of the FOB
4406: -- from FND lookups and inserts the same into AR lookups.
4407: IF c_fob%NOTFOUND THEN
4408: OPEN c_po_fob(p_fob);
4409: FETCH c_po_fob INTO l_meaning,l_desc;
4410: CLOSE c_po_fob;