eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_COND_ASSIGNMENT_PUB SQL Statements

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

Line: 85


PROCEDURE do_update_COND_ASSIGNMENT (
    p_COND_ASSIGNMENT_rec        IN OUT NOCOPY COND_ASSIGNMENT_REC_TYPE,
    p_object_version_number  IN OUT NOCOPY NUMBER,
    x_return_status          IN OUT NOCOPY VARCHAR2
);

Line: 91


PROCEDURE do_delete_COND_ASSIGNMENT (
    p_COND_ASSIGNMENT_id        IN NUMBER,
    x_return_status          IN OUT NOCOPY VARCHAR2
);

Line: 147


            SELECT 'Y'
            INTO   l_dummy
            FROM   LNS_COND_ASSIGNMENTS
            WHERE  cond_assignment_id = l_COND_ASSIGNMENT_id;

Line: 166


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Insert_Row');

Line: 170


    LNS_COND_ASSIGNMENTS_PKG.Insert_Row (
	  X_COND_ASSIGNMENT_ID		=> p_COND_ASSIGNMENT_rec.cond_assignment_id,
	  P_OBJECT_VERSION_NUMBER	=> 1,
	  P_LOAN_ID			=> p_COND_ASSIGNMENT_rec.loan_id,
	  P_CONDITION_ID		=> p_COND_ASSIGNMENT_rec.condition_id,
	  P_CONDITION_DESCRIPTION	=> p_COND_ASSIGNMENT_rec.condition_description,
	  P_CONDITION_MET_FLAG		=> p_COND_ASSIGNMENT_rec.condition_met_flag,
	  P_FULFILLMENT_DATE 	=> p_COND_ASSIGNMENT_rec.fulfillment_date,
	  P_FULFILLMENT_UPDATED_BY		=> p_COND_ASSIGNMENT_rec.fulfillment_updated_by,
	  P_MANDATORY_FLAG 		=> p_COND_ASSIGNMENT_rec.mandatory_flag,
	  P_CREATED_BY			=> p_COND_ASSIGNMENT_rec.created_by,
	  P_CREATION_DATE		=> p_COND_ASSIGNMENT_rec.creation_date,
	  P_LAST_UPDATED_BY		=> p_COND_ASSIGNMENT_rec.last_updated_by,
	  P_LAST_UPDATE_DATE		=> p_COND_ASSIGNMENT_rec.last_update_date,
	  P_LAST_UPDATE_LOGIN		=> p_COND_ASSIGNMENT_rec.last_update_login,
	  P_START_DATE_ACTIVE		=> sysdate,
	  P_END_DATE_ACTIVE		=> null,
	  P_DISB_HEADER_ID		=> p_COND_ASSIGNMENT_rec.DISB_HEADER_ID,
	  P_DELETE_DISABLED_FLAG	=> p_COND_ASSIGNMENT_rec.DELETE_DISABLED_FLAG,
	  P_OWNER_OBJECT_ID		=> p_COND_ASSIGNMENT_rec.OWNER_OBJECT_ID,
	  P_OWNER_TABLE	        => p_COND_ASSIGNMENT_rec.OWNER_TABLE

	);

Line: 198


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENT.Insert_Row');

Line: 206


 |              do_update_COND_ASSIGNMENT
 |
 | DESCRIPTION
 |              Updates condition assignment.
 |
 | SCOPE - PRIVATE
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |              OUT:
 |              IN/OUT:
 |                    p_COND_ASSIGNMENT_rec
 |		      p_object_version_number
 |                    x_return_status
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |
 |   22-APR-2004     Bernice Lam       Created.
 +===========================================================================*/

PROCEDURE do_update_COND_ASSIGNMENT(
    p_COND_ASSIGNMENT_rec          IN OUT NOCOPY COND_ASSIGNMENT_REC_TYPE,
    p_object_version_number   IN OUT NOCOPY NUMBER,
    x_return_status           IN OUT NOCOPY VARCHAR2
) IS

    l_object_version_number         NUMBER;

Line: 244


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_update_COND_ASSIGNMENT procedure');

Line: 249


        SELECT OBJECT_VERSION_NUMBER
        INTO   l_object_version_number
        FROM   LNS_COND_ASSIGNMENTS
        WHERE  COND_ASSIGNMENT_ID = p_COND_ASSIGNMENT_rec.cond_assignment_id
        FOR UPDATE OF COND_ASSIGNMENT_ID NOWAIT;

Line: 284


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');

Line: 293


    LNS_COND_ASSIGNMENTS_PKG.Update_Row (
	  P_COND_ASSIGNMENT_ID		=> p_COND_ASSIGNMENT_rec.cond_assignment_id,
	  P_OBJECT_VERSION_NUMBER	=> p_OBJECT_VERSION_NUMBER,
	  P_LOAN_ID			=> p_COND_ASSIGNMENT_rec.LOAN_ID,
	  P_CONDITION_ID		=> p_COND_ASSIGNMENT_rec.CONDITION_ID,
	  P_CONDITION_DESCRIPTION	=> p_COND_ASSIGNMENT_rec.CONDITION_DESCRIPTION,
	  P_CONDITION_MET_FLAG		=> p_COND_ASSIGNMENT_rec.CONDITION_MET_FLAG,
	  P_FULFILLMENT_DATE		=> p_COND_ASSIGNMENT_rec.FULFILLMENT_DATE,
	  P_FULFILLMENT_UPDATED_BY	=> p_COND_ASSIGNMENT_rec.FULFILLMENT_UPDATED_BY,
	  P_MANDATORY_FLAG 		=> p_COND_ASSIGNMENT_rec.MANDATORY_FLAG,
	  P_LAST_UPDATED_BY		=> NULL,
	  P_LAST_UPDATE_DATE		=> NULL,
	  P_LAST_UPDATE_LOGIN		=> NULL,
	  P_START_DATE_ACTIVE		=> NULL,
	  P_END_DATE_ACTIVE		=> NULL,
	  P_DISB_HEADER_ID		=> p_COND_ASSIGNMENT_rec.DISB_HEADER_ID,
	  P_DELETE_DISABLED_FLAG	=> p_COND_ASSIGNMENT_rec.DELETE_DISABLED_FLAG,
	  P_OWNER_OBJECT_ID		=> p_COND_ASSIGNMENT_rec.OWNER_OBJECT_ID,
	  P_OWNER_TABLE	        => p_COND_ASSIGNMENT_rec.OWNER_TABLE
);

Line: 321


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');

Line: 324


END do_update_COND_ASSIGNMENT;

Line: 328


 |              do_delete_COND_ASSIGNMENT
 |
 | DESCRIPTION
 |              Deletes cond assignment.
 |
 | SCOPE - PRIVATE
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |              OUT:
 |              IN/OUT:
 |                    p_COND_ASSIGNMENT_id
 |		      p_object_version_number
 |                    x_return_status
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |
 |   06-Jan-2004     Bernice Lam       Created.
 +===========================================================================*/

PROCEDURE do_delete_COND_ASSIGNMENT(
    p_COND_ASSIGNMENT_id           NUMBER,
    x_return_status           IN OUT NOCOPY VARCHAR2
) IS

    l_loan_id		    NUMBER;

Line: 365


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_delete_COND_ASSIGNMENT procedure');

Line: 373


        SELECT loan_id, object_version_number
        INTO   l_loan_id, l_object_version_num
        FROM   LNS_COND_ASSIGNMENTS
        WHERE  COND_ASSIGNMENT_ID = p_COND_ASSIGNMENT_id
	FOR UPDATE NOWAIT;

Line: 391


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');

Line: 401


      UPDATE LNS_COND_ASSIGNMENTS
      SET END_DATE_ACTIVE = SYSDATE,
      OBJECT_VERSION_NUMBER = nvl(l_object_version_num, 1) + 1
      WHERE COND_ASSIGNMENT_ID = p_cond_assignment_id;

Line: 417


    LNS_COND_ASSIGNMENTS_PKG.Update_Row (
	  P_COND_ASSIGNMENT_ID		=> p_COND_ASSIGNMENT_ID,
	  P_OBJECT_VERSION_NUMBER	=> null,
	  P_LOAN_ID			=> p_COND_ASSIGNMENT_rec.LOAN_ID,
	  P_CONDITION_ID		=> p_COND_ASSIGNMENT_rec.CONDITION_ID,
	  P_CONDITION_DESCRIPTION	=> p_COND_ASSIGNMENT_rec.CONDITION_DESCRIPTION,
	  P_CONDITION_MET_FLAG		=> p_COND_ASSIGNMENT_rec.CONDITION_MET_FLAG,
	  P_FULFILLMENT_DATE		=> p_COND_ASSIGNMENT_rec.FULFILLMENT_DATE,
	  P_FULFILLMENT_UPDATED_BY	=> p_COND_ASSIGNMENT_rec.FULFILLMENT_UPDATED_BY,
	  P_MANDATORY_FLAG 		=> p_COND_ASSIGNMENT_rec.MANDATORY_FLAG,
	  P_LAST_UPDATED_BY		=> NULL,
	  P_LAST_UPDATE_DATE		=> NULL,
	  P_LAST_UPDATE_LOGIN		=> NULL,
	  P_START_DATE_ACTIVE		=> NULL,
	  P_END_DATE_ACTIVE		=> sysdate
    );

Line: 441


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');

Line: 444


END do_delete_COND_ASSIGNMENT;

Line: 560


 |              update_COND_ASSIGNMENT
 |
 | DESCRIPTION
 |              Updates condition assignment.
 |
 | SCOPE - PUBLIC
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |                    p_init_msg_list
 |                    p_COND_ASSIGNMENT_rec
 |              OUT:
 |                    x_return_status
 |                    x_msg_count
 |                    x_msg_data
 |              IN/OUT:
 |		      p_object_version_number
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |   22-APR-2004     Bernice Lam		Created
 +===========================================================================*/

PROCEDURE update_COND_ASSIGNMENT (
    p_init_msg_list         IN      VARCHAR2,
    p_COND_ASSIGNMENT_rec        IN      COND_ASSIGNMENT_REC_TYPE,
    p_object_version_number IN OUT NOCOPY  NUMBER,
    x_return_status         OUT NOCOPY     VARCHAR2,
    x_msg_count             OUT NOCOPY     NUMBER,
    x_msg_data              OUT NOCOPY     VARCHAR2
) IS

    l_api_name            CONSTANT VARCHAR2(30) := 'update_COND_ASSIGNMENT';

Line: 604


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Update_COND_ASSIGNMENT procedure');

Line: 608


    SAVEPOINT update_COND_ASSIGNMENT;

Line: 633


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_COND_ASSIGNMENT procedure: Before call to do_update_COND_ASSIGNMENT proc');

Line: 637


    do_update_COND_ASSIGNMENT(
                   l_COND_ASSIGNMENT_rec,
                   p_object_version_number,
                   x_return_status
                  );

Line: 644


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_COND_ASSIGNMENT procedure: After call to do_update_COND_ASSIGNMENT proc');

Line: 649


        ROLLBACK TO update_COND_ASSIGNMENT;

Line: 657


        ROLLBACK TO update_COND_ASSIGNMENT;

Line: 665


        ROLLBACK TO update_COND_ASSIGNMENT;

Line: 676


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_COND_ASSIGNMENT procedure');

Line: 679


END update_COND_ASSIGNMENT;

Line: 683


 |              delete_COND_ASSIGNMENT
 |
 | DESCRIPTION
 |              Deletes assignment.
 |
 | SCOPE - PUBLIC
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |                    p_init_msg_list
 |                    p_COND_ASSIGNMENT_id
 |              OUT:
 |                    x_return_status
 |                    x_msg_count
 |                    x_msg_data
 |              IN/OUT:
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |   22-APR-2004     Bernice Lam       Created.
 +===========================================================================*/

PROCEDURE delete_COND_ASSIGNMENT (
    p_init_msg_list   IN      VARCHAR2,
    p_COND_ASSIGNMENT_id         IN     NUMBER,
    x_return_status   OUT NOCOPY     VARCHAR2,
    x_msg_count       OUT NOCOPY     NUMBER,
    x_msg_data        OUT NOCOPY     VARCHAR2
) IS

    l_api_name        CONSTANT VARCHAR2(30) := 'delete_COND_ASSIGNMENT';

Line: 724


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Delete_COND_ASSIGNMENT procedure');

Line: 728


    SAVEPOINT delete_COND_ASSIGNMENT;

Line: 739


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_COND_ASSIGNMENT procedure: Before call to do_delete_COND_ASSIGNMENT proc');

Line: 743


    do_delete_COND_ASSIGNMENT(
                   l_COND_ASSIGNMENT_id,
                   x_return_status
                  );

Line: 749


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_COND_ASSIGNMENT procedure: After call to do_delete_COND_ASSIGNMENT proc');

Line: 754


        ROLLBACK TO delete_COND_ASSIGNMENT;

Line: 762


        ROLLBACK TO delete_COND_ASSIGNMENT;

Line: 770


        ROLLBACK TO delete_COND_ASSIGNMENT;

Line: 781


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Delete_COND_ASSIGNMENT procedure');

Line: 784


END delete_COND_ASSIGNMENT;

Line: 791


    select LNS_COND_ASSIGNMENTS_S.NEXTVAL COND_ASSIGNMENT_ID,
    LnsLoanHeaders.LOAN_ID,
    LnsConditions.CONDITION_ID,
    LnsConditions.CONDITION_DESCRIPTION,
    LnsLoanProductLines.MANDATORY_FLAG

FROM LNS_CONDITIONS LnsConditions ,
LNS_LOAN_HEADERS LnsLoanHeaders ,
LNS_LOAN_PRODUCT_LINES LnsLoanProductLines

WHERE LnsLoanHeaders.LOAN_ID = c_loan_id
AND LnsLoanHeaders.PRODUCT_ID = LnsLoanProductLines.LOAN_PRODUCT_ID
AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'CONDITION'
AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsCOnditions.CONDITION_ID ;

Line: 808


  SELECT LOAN_STATUS , CURRENT_PHASE
  FROM LNS_LOAN_HEADERS LnsLoanHeaders
  WHERE LnsLoanHeaders.LOAN_ID = c_loan_id ;

Line: 814


  SELECT count(COND_ASSIGNMENT_ID)
  FROM LNS_COND_ASSIGNMENTS_VL LnsCondAssignments
    WHERE LnsCondAssignments.LOAN_ID = c_loan_id ;

Line: 906


l_cond_assignment_rec.FULFILLMENT_UPDATED_BY  := NULL ;

Line: 910


l_cond_assignment_rec.LAST_UPDATED_BY := NULL ;

Line: 911


l_cond_assignment_rec.LAST_UPDATE_DATE := NULL ;

Line: 912


l_cond_assignment_rec.LAST_UPDATE_LOGIN := NULL ;

Line: 915


l_cond_assignment_rec.DELETE_DISABLED_FLAG := l_mandatory_flag ;

Line: 961


        select LnsConditions.CONDITION_ID,
            LnsConditions.CONDITION_DESCRIPTION,
            LnsLoanProductLines.MANDATORY_FLAG
        FROM LNS_CONDITIONS_VL LnsConditions ,
            LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
        WHERE LnsLoanProductLines.PARENT_PRODUCT_LINES_ID = c_loan_prod_line_id
            AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'DISB_CONDITION'
            AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsCOnditions.CONDITION_ID
        UNION
        select LnsConditions.CONDITION_ID,
            LnsConditions.CONDITION_DESCRIPTION,
            LnsLoanProductLines.MANDATORY_FLAG
        FROM LNS_CONDITIONS_VL LnsConditions ,
            LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
        WHERE LnsLoanProductLines.loan_product_id =
                (SELECT loan_product_id FROM LNS_LOAN_PRODUCT_LINES WHERE loan_product_lines_id = c_loan_prod_line_id)
            AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'CONDITION'
            AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsCOnditions.CONDITION_ID
            and LnsCOnditions.condition_type = 'DISBURSEMENT';

Line: 1010


	select LNS_COND_ASSIGNMENTS_S.NEXTVAL into l_temp_cond_assignment_id from DUAL;

Line: 1021


        l_cond_assignment_rec.FULFILLMENT_UPDATED_BY  := NULL ;

Line: 1025


        l_cond_assignment_rec.LAST_UPDATED_BY := NULL ;

Line: 1026


        l_cond_assignment_rec.LAST_UPDATE_DATE := NULL ;

Line: 1027


        l_cond_assignment_rec.LAST_UPDATE_LOGIN := NULL ;

Line: 1030


        l_cond_assignment_rec.DELETE_DISABLED_FLAG := l_mandatory_flag ;

Line: 1055


PROCEDURE delete_DISB_COND_ASSIGNMENT( P_DISB_HEADER_ID IN NUMBER ) IS

CURSOR loan_disb_cond ( c_disb_header_id NUMBER ) IS
    SELECT COND_ASSIGNMENT_ID
    FROM LNS_COND_ASSIGNMENTS LnsCondAssignments
    WHERE LnsCondAssignments.DISB_HEADER_ID = c_disb_header_id  ;

Line: 1069


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin delete_DISB_COND_ASSIGNMENT procedure');

Line: 1073


    SAVEPOINT delete_DISB_COND_ASSIGNMENT;

Line: 1077


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: Before opening cursor loan_disb_cond ');

Line: 1083


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: After opening cursor loan_disb_cond , no of conditions found is '||loan_disb_cond%ROWCOUNT);

Line: 1095


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: Before call to do_delete_COND_ASSIGNMENT proc for cond_assignment_id'|| l_cond_assignment_id);

Line: 1099


    do_delete_COND_ASSIGNMENT(l_cond_assignment_id ,
                           x_return_status ) ;

Line: 1103


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In delete_DISB_COND_ASSIGNMENT procedure: After call to do_delete_COND_ASSIGNMENT proc for cond_assignment_id'|| l_cond_assignment_id ||' , return status is' || x_return_status);

Line: 1115


        ROLLBACK TO delete_DISB_COND_ASSIGNMENT;

Line: 1117


END delete_DISB_COND_ASSIGNMENT ;

Line: 1126


  SELECT 'X' FROM DUAL
  WHERE EXISTS ( SELECT NULL FROM LNS_COND_ASSIGNMENTS
                  WHERE CONDITION_ID = X_COND_ID )
  OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES
              WHERE LINE_REFERENCE_ID = X_COND_ID
              AND ( LOAN_PRODUCT_LINE_TYPE = 'CONDITION' OR LOAN_PRODUCT_LINE_TYPE='DISB_CONDITION' )
              );

Line: 1193


        select cond_ass.COND_ASSIGNMENT_ID,
            cond.CONDITION_ID,
            cond.CONDITION_NAME,
            cond.CONDITION_DESCRIPTION,
            cond.CONDITION_TYPE,
            cond_ass.MANDATORY_FLAG,
            cond.CUSTOM_PROCEDURE
        from LNS_CONDITIONS_VL cond,
            LNS_COND_ASSIGNMENTS cond_ass
        where decode(P_CONDITION_TYPE, 'APPROVAL', cond_ass.LOAN_ID,
                                       'CONVERSION', cond_ass.LOAN_ID,
                                       'DISBURSEMENT', cond_ass.DISB_HEADER_ID,
                                       cond_ass.OWNER_OBJECT_ID) = P_OWNER_OBJECT_ID
            and cond.custom_procedure is not null
            and cond.condition_type = P_CONDITION_TYPE
            and cond.condition_id = cond_ass.condition_id
            and cond_ass.END_DATE_ACTIVE is null;

Line: 1281


                l_cond_assignment_tbl(i).FULFILLMENT_UPDATED_BY := lns_utility_pub.user_id;

Line: 1310


            select OBJECT_VERSION_NUMBER into l_version_number
            from LNS_COND_ASSIGNMENTS
            where COND_ASSIGNMENT_ID = l_cond_assignment_tbl(j).COND_ASSIGNMENT_ID;

Line: 1314


            update_COND_ASSIGNMENT (
                p_init_msg_list         => FND_API.G_FALSE,
                p_COND_ASSIGNMENT_rec   => l_cond_assignment_tbl(j),
                p_object_version_number => l_version_number,
                X_RETURN_STATUS		    => l_return_status,
                X_MSG_COUNT			    => l_msg_count,
                X_MSG_DATA	    		=> l_msg_data);

Line: 1408


        select cond.CONDITION_ID,
            cond.CONDITION_NAME,
            cond.CONDITION_DESCRIPTION,
            cond.CONDITION_TYPE,
            cond_ass.MANDATORY_FLAG,
            cond.CUSTOM_PROCEDURE
        from LNS_CONDITIONS_VL cond,
            LNS_COND_ASSIGNMENTS cond_ass
        where cond_ass.cond_assignment_id = P_COND_ASSIGNMENT_ID
            and cond.condition_id = cond_ass.condition_id
            and cond_ass.END_DATE_ACTIVE is null;

Line: 1565


        select cond_ass.CONDITION_ID,
            cond.CONDITION_NAME,
            cond.CONDITION_DESCRIPTION,
            cond_ass.MANDATORY_FLAG,
            cond_ass.DELETE_DISABLED_FLAG
        from LNS_CONDITIONS_VL cond,
            LNS_COND_ASSIGNMENTS cond_ass
        where cond_ass.LOAN_ID = P_LOAN_ID
            and cond.CONDITION_TYPE = P_CONDITION_TYPE
            and cond.condition_id = cond_ass.condition_id
            and decode(cond.CONDITION_TYPE, 'DISBURSEMENT', cond_ass.DISB_HEADER_ID, cond_ass.OWNER_OBJECT_ID) is null
            and cond_ass.END_DATE_ACTIVE is null;

Line: 1649


            l_cond_assignment_rec.DELETE_DISABLED_FLAG;

Line: 1656


        l_cond_assignment_rec.FULFILLMENT_UPDATED_BY  := NULL;

Line: 1659


        l_cond_assignment_rec.LAST_UPDATED_BY := NULL;

Line: 1660


        l_cond_assignment_rec.LAST_UPDATE_DATE := NULL;

Line: 1661


        l_cond_assignment_rec.LAST_UPDATE_LOGIN := NULL;

Line: 1684


        LogMessage(FND_LOG.LEVEL_STATEMENT, 'DELETE_DISABLED_FLAG = ' || l_cond_assignment_rec.DELETE_DISABLED_FLAG);

Line: 1765


        select count(1)
        from LNS_CONDITIONS_VL cond,
            LNS_COND_ASSIGNMENTS cond_ass
        where
            decode(P_CONDITION_TYPE, 'APPROVAL', cond_ass.LOAN_ID,
                                     'CONVERSION', cond_ass.LOAN_ID,
                                     'DISBURSEMENT', cond_ass.DISB_HEADER_ID,
                                     cond_ass.OWNER_OBJECT_ID) = P_OWNER_OBJECT_ID
            and cond.custom_procedure is null
            and cond.condition_type = P_CONDITION_TYPE
            and cond.condition_id = cond_ass.condition_id
            and cond_ass.END_DATE_ACTIVE is null
            and cond_ass.MANDATORY_FLAG = 'Y'
            and (cond_ass.CONDITION_MET_FLAG is null or cond_ass.CONDITION_MET_FLAG = 'N');