APPS.OKE_POOL_PVT dependencies on OKE_FUNDING_POOLS

Line 445: FROM OKE_FUNDING_POOLS a

441: ATTRIBUTE14 ,
442: ATTRIBUTE15
443:
444:
445: FROM OKE_FUNDING_POOLS a
446: WHERE (a.funding_pool_id = p_funding_pool_id);
447:
448: l_pool_pk pool_pk_csr%ROWTYPE;
449: l_pool_rec pool_rec_type;

Line 499: -- will create using nextVal from sequence oke_funding_pools_s

495:
496:
497:
498: -- row level insert
499: -- will create using nextVal from sequence oke_funding_pools_s
500:
501: PROCEDURE insert_row(
502: p_api_version IN NUMBER,
503: p_init_msg_list IN VARCHAR2 ,

Line 631: SELECT OKE_FUNDING_POOLS_S.nextval INTO l_seq FROM dual;

627: END IF;
628:
629: --oke_debug.debug('record validated for insert');
630:
631: SELECT OKE_FUNDING_POOLS_S.nextval INTO l_seq FROM dual;
632:
633: OKE_FUNDING_POOLS_PKG.Insert_Row
634: (l_row_id,
635: l_seq,

Line 633: OKE_FUNDING_POOLS_PKG.Insert_Row

629: --oke_debug.debug('record validated for insert');
630:
631: SELECT OKE_FUNDING_POOLS_S.nextval INTO l_seq FROM dual;
632:
633: OKE_FUNDING_POOLS_PKG.Insert_Row
634: (l_row_id,
635: l_seq,
636: l_def_pool_rec.NAME,
637: l_def_pool_rec.DESCRIPTION,

Line 832: from oke_funding_pools

828: l_temp NUMBER;
829:
830: Cursor l_csr_id IS
831: select funding_pool_id
832: from oke_funding_pools
833: where funding_pool_id=p_pool_rec.funding_pool_id;
834:
835: -------------------------------
836: -- FUNCTION fill_who_columns --

Line 1103: OKE_FUNDING_POOLS_PKG.update_row(

1099:
1100: --oke_debug.debug('update base table');
1101:
1102:
1103: OKE_FUNDING_POOLS_PKG.update_row(
1104: l_def_pool_rec.FUNDING_POOL_ID,
1105: l_def_pool_rec.NAME,
1106: l_def_pool_rec.DESCRIPTION,
1107: l_def_pool_rec.CONTACT_PERSON_ID,

Line 1288: from oke_funding_pools

1284: l_temp NUMBER;
1285:
1286: Cursor l_csr_id IS
1287: select funding_pool_id
1288: from oke_funding_pools
1289: where funding_pool_id=p_pool_rec.funding_pool_id;
1290:
1291: BEGIN
1292: --oke_debug.debug('start call oke_pool_pvt.delete_row');

Line 1333: DELETE FROM OKE_FUNDING_POOLS

1329: END IF;
1330: CLOSE l_csr_id;
1331:
1332:
1333: DELETE FROM OKE_FUNDING_POOLS
1334: WHERE FUNDING_POOL_ID = p_pool_rec.FUNDING_POOL_ID;
1335:
1336: --oke_debug.debug('end call oke_pool_pvt.delete_row');
1337: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1492: SELECT funding_pool_id FROM oke_funding_pools a

1488: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1489:
1490:
1491: CURSOR lock_csr (p IN pool_rec_type) IS
1492: SELECT funding_pool_id FROM oke_funding_pools a
1493: WHERE
1494: a.funding_pool_id = p.funding_pool_id
1495: FOR UPDATE NOWAIT;
1496: