APPS.OKS_UPGRADE_PRECHECK dependencies on CS_TRANSACTION_TYPES

Line 646: SELECT count(*) from CS_TRANSACTION_TYPES

642: x_Return_Msg OUT NOCOPY Varchar2)
643: IS
644:
645: CURSOR Cur_Txn_type_cnt IS
646: SELECT count(*) from CS_TRANSACTION_TYPES
647: WHERE NAME='SERVICE_CONTRACTS_UPGRADE_TXN';
648:
649: CURSOR Cur_Txntype_max IS
650: SELECT max(TRANSACTION_TYPE_ID)+1

Line 651: FROM CS_TRANSACTION_TYPES;

647: WHERE NAME='SERVICE_CONTRACTS_UPGRADE_TXN';
648:
649: CURSOR Cur_Txntype_max IS
650: SELECT max(TRANSACTION_TYPE_ID)+1
651: FROM CS_TRANSACTION_TYPES;
652:
653: l_txnb_rec_in CS_TXNBTYPE_PVT.TXNBTYPE_REC_TYPE;
654:
655: l_txntype_id NUMBER;

Line 738: CS_TRANSACTION_TYPES_PKG.INSERT_ROW (

734: l_LAST_UPDATED_BY :=1;
735: l_LAST_UPDATE_LOGIN :=0;
736: /*
737:
738: CS_TRANSACTION_TYPES_PKG.INSERT_ROW (
739: X_ROWID =>L_ROWID ,
740: X_TRANSACTION_TYPE_ID => l_TXNTYPE_ID,
741: X_SEEDED_FLAG => L_SEEDED_FLAG ,
742: X_REVISION_FLAG => L_REVISION_FLAG ,