54: ELSE
55:
56: -- use padded and unpadded versions of appno as appno in cvnames may not have leading zero
57: -- alternate method would be to LPAD the where column of the query but this would remove indexing
58: l_appno_pad := LPAD(p_appno || igs_uc_mv_data_upld.get_check_digit(p_appno),9,0);
59: l_appno := p_appno || igs_uc_mv_data_upld.get_check_digit(p_appno);
60:
61: IF p_system_code = 'U' THEN
62:
55:
56: -- use padded and unpadded versions of appno as appno in cvnames may not have leading zero
57: -- alternate method would be to LPAD the where column of the query but this would remove indexing
58: l_appno_pad := LPAD(p_appno || igs_uc_mv_data_upld.get_check_digit(p_appno),9,0);
59: l_appno := p_appno || igs_uc_mv_data_upld.get_check_digit(p_appno);
60:
61: IF p_system_code = 'U' THEN
62:
63: IF p_type = 'CVNAMEDET' THEN -- Used this cursor in Enqdet block When New block instance procedure