APPS.IBY_VALIDATIONSETS_CALLS_PUB dependencies on DUAL

Line 11407: FROM dual;

11403: raise e_kid_feil;
11404: END IF;
11405: SELECT lpad(v_kid_nr,v_kid_lengde,0)
11406: INTO v_kid
11407: FROM dual;
11408: -- uni_lpad_p(v_kid_nr, v_kid_lengde, v_kid);
11409: /* Modulus 10 control */
11410: /* Calculates product and digitsum for each digit,
11411: from right towards left */

Line 11433: /* is residual unlike controldigit, the kid_nr is invalid */

11429: WHILE v_sum_10 > 10 loop
11430: v_sum_10 := v_sum_10 - 10;
11431: END LOOP;
11432: v_rest_10 := 10 - v_sum_10;
11433: /* is residual unlike controldigit, the kid_nr is invalid */
11434: if ((substr(v_kid,25,1)) <> '-') then
11435: if (to_number(substr(v_kid,25,1)) <> v_rest_10) then
11436: v_status_10 := 1;
11437: end if;

Line 11471: /* is residual like 1, must the kid ends with '-' */

11467: /* calculate mod 11 of v_sum_11 */
11468: while v_sum_11 > 11 loop
11469: v_sum_11 := v_sum_11 - 11;
11470: end loop;
11471: /* is residual like 1, must the kid ends with '-' */
11472: if (((v_sum_11 = 1)
11473: and (substr(v_kid,25,1) <> '-'))
11474: or ((v_sum_11 <> 1)
11475: and (substr(v_kid,25,1) = '-'))) then

Line 11479: /* is residual unlike control digit, the kid_nr is invalid */

11475: and (substr(v_kid,25,1) = '-'))) then
11476: v_status_11 := 1;
11477: elsif ((substr(v_kid,25,1)) <> '-') then
11478: v_rest_11 := 11 - v_sum_11;
11479: /* is residual unlike control digit, the kid_nr is invalid */
11480: if (to_number(substr(v_kid,25,1)) <> v_rest_11) then
11481: v_status_11 := 1;
11482: end if;
11483: end if;

Line 12064: DUAL

12060: IBY_TRANSACTION_ERRORS_S.NEXTVAL
12061: INTO
12062: l_transaction_error_id
12063: FROM
12064: DUAL
12065: ;
12066:
12067: l_docErrorRec.transaction_error_id := l_transaction_error_id;
12068:

Line 12101: DUAL

12097: IBY_TRANSACTION_ERRORS_S.NEXTVAL
12098: INTO
12099: l_transaction_error_id
12100: FROM
12101: DUAL
12102: ;
12103:
12104: l_docErrorRec.transaction_error_id := l_transaction_error_id;
12105:

Line 12202: DUAL

12198: IBY_TRANSACTION_ERRORS_S.NEXTVAL
12199: INTO
12200: l_transaction_error_id
12201: FROM
12202: DUAL
12203: ;
12204:
12205: l_docErrorRec.transaction_error_id := l_transaction_error_id;
12206:

Line 12324: FROM DUAL;

12320:
12321: -- Sequence value will be used for AP IBY completion validation simulation
12322: SELECT IBY_COMPLETED_PMTS_GROUP_S.NEXTVAL
12323: INTO l_completion_id
12324: FROM DUAL;
12325:
12326: -- Mark all documents and payments which will be used by AP to apply validations
12327: UPDATE IBY_PAYMENTS_ALL pmt
12328: SET pmt.completed_pmts_group_id = l_completion_id