APPS.PSP_GENERAL dependencies on PA_TRANSACTION_SOURCES

Line 750: v_flag pa_transaction_sources.purgeable_flag%TYPE;

746: RETURN(0);
747: END;
748: ----
749: PROCEDURE TRANSACTION_CHANGE_PURGEBLE IS
750: v_flag pa_transaction_sources.purgeable_flag%TYPE;
751:
752: BEGIN
753: -- 2431917: changed OLD to GOLD, introduced GOLDE
754: BEGIN

Line 756: FROM pa_transaction_sources

752: BEGIN
753: -- 2431917: changed OLD to GOLD, introduced GOLDE
754: BEGIN
755: SELECT purgeable_flag INTO v_flag
756: FROM pa_transaction_sources
757: WHERE transaction_source = 'GOLDE'
758: FOR UPDATE OF purgeable_flag ;
759:
760: IF v_flag='Y' THEN

Line 762: UPDATE pa_transaction_sources

758: FOR UPDATE OF purgeable_flag ;
759:
760: IF v_flag='Y' THEN
761: --v_flag :='N';
762: UPDATE pa_transaction_sources
763: SET purgeable_flag = 'N' --- v_flag
764: WHERE transaction_source = 'GOLDE';
765: COMMIT;
766: END IF;

Line 773: FROM pa_transaction_sources

769: NULL;
770: END;
771:
772: SELECT purgeable_flag INTO v_flag
773: FROM pa_transaction_sources
774: WHERE transaction_source = 'GOLD'
775: FOR UPDATE OF purgeable_flag ;
776:
777: IF v_flag='Y' THEN

Line 779: UPDATE pa_transaction_sources

775: FOR UPDATE OF purgeable_flag ;
776:
777: IF v_flag='Y' THEN
778: ---v_flag :='N';
779: UPDATE pa_transaction_sources
780: SET purgeable_flag = 'N' ---v_flag
781: WHERE transaction_source = 'GOLD';
782: COMMIT;
783: END IF;