APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on FV_TP_TS_AMT_DATA

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

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

Line 491: FROM FV_TP_TS_AMT_DATA

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

Line 502: FV_TP_TS_AMT_DATA(treasury_symbol,

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

Line 517: FV_TP_TS_AMT_DATA

513:
514:
515: ELSE
516: UPDATE
517: FV_TP_TS_AMT_DATA
518: SET
519: amount = amount + l_dist_sob_rec.amount
520: WHERE
521: treasury_symbol=l_tas_rec.treasury_symbol

Line 602: FROM FV_TP_TS_AMT_DATA

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

Line 620: FROM FV_TP_TS_AMT_DATA

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