APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on FV_TP_TS_AMT_DATA

Line 346: This procedure is responsible to insert the treasury symbol into the table FV_TP_TS_AMT_DATA along with the amount.

342: /*
343:
344: PROCEDURE : TREASURY_SYMBOLS_PROCESS
345:
346: This procedure is responsible to insert the treasury symbol into the table FV_TP_TS_AMT_DATA along with the amount.
347: This table will later be used for the maximum treasury symbol validations.
348:
349: */
350:

Line 493: FROM FV_TP_TS_AMT_DATA

489:
490:
491:
492: SELECT count(*) INTO l_row_exist
493: FROM FV_TP_TS_AMT_DATA
494: WHERE
495: treasury_symbol=l_tas_rec.treasury_symbol
496: AND
497: payment_instruction_id= p_instruction_id;

Line 504: FV_TP_TS_AMT_DATA(treasury_symbol,

500:
501: IF l_row_exist=0 THEN
502:
503: INSERT INTO
504: FV_TP_TS_AMT_DATA(treasury_symbol,
505: amount,
506: payment_instruction_id,
507: org_id,
508: set_of_books_id)

Line 519: FV_TP_TS_AMT_DATA

515:
516:
517: ELSE
518: UPDATE
519: FV_TP_TS_AMT_DATA
520: SET
521: amount = amount + l_amt_id_rec.payment_amount -- changed from l_dist_sob_rec.amount(Bug 14542468)
522: WHERE
523: treasury_symbol=l_tas_rec.treasury_symbol

Line 604: FROM FV_TP_TS_AMT_DATA

600:
601: IF UPPER(l_lmt_blk_fmt_val)= 'Y' THEN
602:
603: SELECT COUNT(*) INTO l_count_tas
604: FROM FV_TP_TS_AMT_DATA
605: WHERE payment_instruction_id = p_instruction_id;
606:
607: IF l_count_tas > 10 THEN
608: x_error_mesg := 'Payment format aborts as it contains more than 10 Treasury symbols';

Line 622: FROM FV_TP_TS_AMT_DATA

618:
619: ELSIF p_format_name IN('FVSPCCD','FVSPCCDP','FVSPNCR','FVSPPPD','FVSPPPDP') THEN
620:
621: SELECT COUNT(*) INTO l_count_tas
622: FROM FV_TP_TS_AMT_DATA
623: WHERE payment_instruction_id = p_instruction_id;
624:
625: IF l_count_tas > 10 THEN
626: x_error_mesg := 'Payment format aborts as it contains more than 10 Treasury symbols';