[Home] [Help]
739: l_query_string := l_query_string || ' AND chr.id IN ( ';
740: IF p_in_transit_category = 'ONLINE_RBK'
741: THEN
742: -- Online Rebook not Activated
743: l_query_string := l_query_string || ' SELECT trx.khr_id orig_contract_id FROM okl_trx_contracts trx '
744: || ' WHERE trx.khr_id_new IS NOT NULL AND trx.tsu_code = ''ENTERED'' AND trx.rbr_code is NOT NULL '
745: || ' AND trx.tcn_type = ''TRBK'' AND trx.representation_type = ''PRIMARY'' ';
746: ELSIF p_in_transit_category = 'ONLINE_MASS_RBK'
747: THEN
861: AND opp.assigned_process = TO_CHAR(l_seq_next)
862: AND opp.khr_id IN
863: (
864: SELECT trx.khr_id orig_contract_id
865: FROM okl_trx_contracts trx
866: WHERE trx.khr_id_new IS NOT NULL
867: AND trx.tsu_code = 'ENTERED'
868: AND trx.rbr_code IS NOT NULL
869: AND trx.tcn_type = 'TRBK'
934: and NVL(q.consolidated_yn,'N') = 'N'
935: and q.partial_yn = 'Y'
936: and q.qst_code = 'ACCEPTED'
937: and q.khr_id = opp.khr_id
938: and q.id not in (select t.qte_id from okl_trx_contracts_all t where q.id = t.qte_id)
939: );
940:
941: log_msg(FND_FILE.LOG, 'Checking: TQ accepted and fails before trx created - End : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
942:
950: AND opp.assigned_process = TO_CHAR(l_seq_next)
951: AND exists
952: (
953: select q.khr_id
954: from okl_trx_quotes_b q, okl_trx_contracts_all t
955: where q.qtp_code like 'TER%'
956: and NVL(q.consolidated_yn,'N') = 'N'
957: and q.partial_yn = 'Y'
958: and q.khr_id = opp.khr_id
973: AND opp.assigned_process = TO_CHAR(l_seq_next)
974: AND exists
975: (
976: SELECT 1
977: FROM okl_trx_contracts ktrx
978: where ktrx.khr_id = opp.khr_id
979: AND ktrx.khr_id_new IS NULL
980: AND ktrx.tsu_code = 'ENTERED'
981: AND ktrx.rbr_code IS NOT NULL