APPS.XTR_XTRUPREP_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

        SELECT
          CFREQ.PARTY_CODE,
          CFREQ.ACCOUNT_NO_FROM,
          CFREQ.ACCOUNT_NO_TO,
          CFREQ.DEAL_TYPE,
          CFREQ.DEAL_NUMBER_FROM,
          CFREQ.DEAL_NUMBER_TO,
          CFREQ.CREATION_DATE,
          CFREQ.STARTING_CFLOW_DATE,
          CFREQ.ENDING_CFLOW_DATE,
          CFREQ.INCLUDE_JOURNALIZED_FLAG
        INTO P_PARTY_CODE,P_OLD_ACCOUNT,P_NEW_ACCOUNT,P_DEAL_TYPE,P_STARTING_DEAL_NO,P_ENDING_DEAL_NO,P_EXECUTION_DATE,P_STARTING_DATE,P_ENDING_DATE,P_INCLUDE_JOURNALIZED
        FROM
          XTR_CFLOW_REQUEST_DETAILS CFREQ
        WHERE CFREQ.CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID;

Line: 33

          P_NO_RECORDS_UPDATED := 'Y';

Line: 35

      IF (P_NO_RECORDS_UPDATED = 'N') THEN
        BEGIN
          SELECT
            count(*)
          INTO L_COUNT
          FROM
            XTR_CFLOW_UPDATED_RECORDS
          WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID;

Line: 48

            P_NO_RECORDS_UPDATED := 'Y';

Line: 54

          P_NO_RECORDS_UPDATED := 'Y';

Line: 57

      IF (P_NO_RECORDS_UPDATED = 'N') THEN
        BEGIN
          SELECT
            'Y'
          INTO P_NO_RECORDS_UPDATED
          FROM
            XTR_CFLOW_UPDATED_RECORDS
          WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID
            AND MESSAGE_NAME = 'XTR_CFLOW_ACCT_UNAUTHORIZED';

Line: 66

          IF (NVL(P_NO_RECORDS_UPDATED
             ,'N') = 'Y') THEN
            FND_MESSAGE.SET_NAME('XTR'
                                ,'XTR_CFLOW_ACCT_UNAUTHORIZED');

Line: 76

            P_NO_RECORDS_UPDATED := 'N';

Line: 79

      IF (P_NO_RECORDS_UPDATED = 'N') THEN
        BEGIN
          SELECT
            'Y'
          INTO P_NO_RECORDS_UPDATED
          FROM
            XTR_CFLOW_UPDATED_RECORDS
          WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID
            AND MESSAGE_NAME = 'XTR_CFLOW_CURRENCY_MISMATCH';

Line: 88

          IF (NVL(P_NO_RECORDS_UPDATED
             ,'N') = 'Y') THEN
            FND_MESSAGE.SET_NAME('XTR'
                                ,'XTR_CFLOW_CURRENCY_MISMATCH');

Line: 96

            P_NO_RECORDS_UPDATED := 'N';

Line: 99

      IF (P_NO_RECORDS_UPDATED = 'N') THEN
        FND_MESSAGE.SET_NAME('XTR'
                            ,'XTR_CFLOW_UPDATED');

Line: 104

        P_MESSAGE_CODE_FOR_UPDATE := FND_MESSAGE.GET;

Line: 106

                            ,'XTR_CFLOW_NOT_UPDATED');