APPS.IBY_INSTRREG_PUB dependencies on IBY_INSTRHOLDER

Line 1117: IBY_INSTRHOLDER_PKG.deleteHolderInstr( NULL,

1113: -- Returns message 'Mandatory field(s) missing'
1114: END IF;
1115:
1116: -- Call the procedure that will delete the instrument.
1117: IBY_INSTRHOLDER_PKG.deleteHolderInstr( NULL,
1118: g_owner_type,
1119: p_payer_id,
1120: NULL,
1121: p_instr_id

Line 1291: FROM IBY_INSTRHOLDER

1287:
1288: -- Check whether the payer exists.If not,
1289: -- then we don't even try to fetch the records.
1290: SELECT count(*) INTO l_count
1291: FROM IBY_INSTRHOLDER
1292: WHERE ownerid = p_payer_id
1293: AND activestatus = 1;
1294:
1295: -- If nothing is found throw an error.

Line 1487: FROM IBY_INSTRHOLDER

1483:
1484: -- Check whether the payer exists.
1485: -- If not, then we don't even try to fetch the records.
1486: SELECT count(*) INTO l_count
1487: FROM IBY_INSTRHOLDER
1488: WHERE ownerid = p_payer_id
1489: AND activestatus = 1;
1490:
1491: -- Throw an exception when payer not found.

Line 1502: FROM IBY_INSTRHOLDER

1498:
1499: -- Check whether the instrument exists.
1500: -- If not, then we don't even try to fetch the records.
1501: SELECT count(*) INTO l_count
1502: FROM IBY_INSTRHOLDER
1503: WHERE instrid = p_instr_id
1504: AND activestatus = 1;
1505:
1506: -- Throw an exception.

Line 1517: FROM IBY_INSTRHOLDER

1513:
1514: -- Check whether the payer holds the instrument.
1515: -- If not, then we don't even try to fetch the records.
1516: SELECT count(*) INTO l_count
1517: FROM IBY_INSTRHOLDER
1518: WHERE instrid = p_instr_id
1519: AND ownerid = p_payer_id
1520: AND activestatus = 1;
1521: