APPS.IBY_INSTRREG_PUB dependencies on IBY_INSTRHOLDER

Line 1028: IBY_INSTRHOLDER_PKG.deleteHolderInstr( NULL,

1024: -- Returns message 'Mandatory field(s) missing'
1025: END IF;
1026:
1027: -- Call the procedure that will delete the instrument.
1028: IBY_INSTRHOLDER_PKG.deleteHolderInstr( NULL,
1029: g_owner_type,
1030: p_payer_id,
1031: NULL,
1032: p_instr_id

Line 1202: FROM IBY_INSTRHOLDER

1198:
1199: -- Check whether the payer exists.If not,
1200: -- then we don't even try to fetch the records.
1201: SELECT count(*) INTO l_count
1202: FROM IBY_INSTRHOLDER
1203: WHERE ownerid = p_payer_id
1204: AND activestatus = 1;
1205:
1206: -- If nothing is found throw an error.

Line 1398: FROM IBY_INSTRHOLDER

1394:
1395: -- Check whether the payer exists.
1396: -- If not, then we don't even try to fetch the records.
1397: SELECT count(*) INTO l_count
1398: FROM IBY_INSTRHOLDER
1399: WHERE ownerid = p_payer_id
1400: AND activestatus = 1;
1401:
1402: -- Throw an exception when payer not found.

Line 1413: FROM IBY_INSTRHOLDER

1409:
1410: -- Check whether the instrument exists.
1411: -- If not, then we don't even try to fetch the records.
1412: SELECT count(*) INTO l_count
1413: FROM IBY_INSTRHOLDER
1414: WHERE instrid = p_instr_id
1415: AND activestatus = 1;
1416:
1417: -- Throw an exception.

Line 1428: FROM IBY_INSTRHOLDER

1424:
1425: -- Check whether the payer holds the instrument.
1426: -- If not, then we don't even try to fetch the records.
1427: SELECT count(*) INTO l_count
1428: FROM IBY_INSTRHOLDER
1429: WHERE instrid = p_instr_id
1430: AND ownerid = p_payer_id
1431: AND activestatus = 1;
1432: