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: 39


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: 45


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

Line: 101


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

Line: 120


    	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: 124


    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

	);

Line: 149


    	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: 157


 |              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: 195


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

Line: 200


        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: 235


    	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: 244


    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
);

Line: 270


    	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: 273


END do_update_COND_ASSIGNMENT;

Line: 277


 |              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: 314


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

Line: 322


        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: 340


    	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: 350


      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: 366


    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: 390


    	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: 393


END do_delete_COND_ASSIGNMENT;

Line: 509


 |              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: 553


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

Line: 557


    SAVEPOINT update_COND_ASSIGNMENT;

Line: 582


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

Line: 586


    do_update_COND_ASSIGNMENT(
                   l_COND_ASSIGNMENT_rec,
                   p_object_version_number,
                   x_return_status
                  );

Line: 593


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

Line: 598


        ROLLBACK TO update_COND_ASSIGNMENT;

Line: 606


        ROLLBACK TO update_COND_ASSIGNMENT;

Line: 614


        ROLLBACK TO update_COND_ASSIGNMENT;

Line: 625


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

Line: 628


END update_COND_ASSIGNMENT;

Line: 632


 |              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: 673


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

Line: 677


    SAVEPOINT delete_COND_ASSIGNMENT;

Line: 688


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

Line: 692


    do_delete_COND_ASSIGNMENT(
                   l_COND_ASSIGNMENT_id,
                   x_return_status
                  );

Line: 698


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

Line: 703


        ROLLBACK TO delete_COND_ASSIGNMENT;

Line: 711


        ROLLBACK TO delete_COND_ASSIGNMENT;

Line: 719


        ROLLBACK TO delete_COND_ASSIGNMENT;

Line: 730


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

Line: 733


END delete_COND_ASSIGNMENT;

Line: 740


    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: 757


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

Line: 763


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

Line: 855


l_cond_assignment_rec.FULFILLMENT_UPDATED_BY  := NULL ;

Line: 859


l_cond_assignment_rec.LAST_UPDATED_BY := NULL ;

Line: 860


l_cond_assignment_rec.LAST_UPDATE_DATE := NULL ;

Line: 861


l_cond_assignment_rec.LAST_UPDATE_LOGIN := NULL ;

Line: 864


l_cond_assignment_rec.DELETE_DISABLED_FLAG := l_mandatory_flag ;

Line: 905


    select LNS_COND_ASSIGNMENTS_S.NEXTVAL COND_ASSIGNMENT_ID,
    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 ;

Line: 959


l_cond_assignment_rec.FULFILLMENT_UPDATED_BY  := NULL ;

Line: 963


l_cond_assignment_rec.LAST_UPDATED_BY := NULL ;

Line: 964


l_cond_assignment_rec.LAST_UPDATE_DATE := NULL ;

Line: 965


l_cond_assignment_rec.LAST_UPDATE_LOGIN := NULL ;

Line: 968


l_cond_assignment_rec.DELETE_DISABLED_FLAG := l_mandatory_flag ;

Line: 1000


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: 1014


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

Line: 1018


    SAVEPOINT delete_DISB_COND_ASSIGNMENT;

Line: 1022


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

Line: 1028


    	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: 1040


    	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: 1044


    do_delete_COND_ASSIGNMENT(l_cond_assignment_id ,
                           x_return_status ) ;

Line: 1048


    	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: 1060


        ROLLBACK TO delete_DISB_COND_ASSIGNMENT;

Line: 1062


END delete_DISB_COND_ASSIGNMENT ;

Line: 1071


  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' )
              );