APPS.LNS_LOAN_PUB dependencies on DUAL

Line 1160: -- Only if bothe Contact (rel and Person) are not NULL and individually both are correct but incorrect when combined

1156: l_valid_contact_rel := 'Y';
1157: END IF;
1158: END IF;
1159:
1160: -- Only if bothe Contact (rel and Person) are not NULL and individually both are correct but incorrect when combined
1161: IF (((P_Loan_Details_Rec.contact_rel_party_id IS NOT NULL) AND (P_Loan_Details_Rec.contact_pers_party_id IS NOT NULL)) AND
1162: ((l_valid_contact_rel <> 'Y') OR (l_valid_contact_pers <> 'Y'))) THEN
1163: logerrors(p_message_name => 'LNS_LCREATE_INVALID_ATTRIBUTE',
1164: p_token1 => 'P_Loan_Details_Rec.contact_pers_party_id',

Line 2105: -- Only if bothe Contact (rel and Person) are not NULL and individually both are correct but incorrect when combined

2101: l_valid_contact_rel := 'Y';
2102: END IF;
2103: END IF;
2104:
2105: -- Only if bothe Contact (rel and Person) are not NULL and individually both are correct but incorrect when combined
2106: IF (((P_LOAN_PART_TBL(l_count).contact_rel_party_id IS NOT NULL) AND (P_LOAN_PART_TBL(l_count).contact_pers_party_id IS NOT NULL)) AND ((l_valid_contact_rel <> 'Y') OR (l_valid_contact_pers <> 'Y'))) THEN
2107: logerrors(p_message_name => 'LNS_LCREATE_INVALID_ATTRIBUTE',
2108: p_token1 => 'P_LOAN_PART_TBL(l_count).contact_pers_party_id and ',
2109: p_token2 => P_LOAN_PART_TBL(l_count).contact_pers_party_id);

Line 2559: FROM DUAL

2555:
2556:
2557: CURSOR loan_fee_exists ( c_loan_id NUMBER ) IS
2558: SELECT 'Y'
2559: FROM DUAL
2560: WHERE
2561: EXISTS
2562: (SELECT NULL FROM LNS_FEE_ASSIGNMENTS LnsFeeAssignments
2563: WHERE LnsFeeAssignments.LOAN_ID = c_loan_id)

Line 3157: from dual;

3153: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Setting l_loan_rec record...');
3154:
3155: select LNS_LOAN_HEADERS_S.nextval
3156: into l_loan_rec.loan_id
3157: from dual;
3158: l_loan_rec.product_id := P_Loan_Details_Rec.product_id;
3159:
3160: -- Validate Loan Number
3161: -- If Profile not set to Autogenerate make Loan Number Mandatory.

Line 3175: from dual;

3171:
3172: IF l_generate_loan_number = 'Y' THEN
3173: select 'L' || LNS_LOAN_NUMBER_S.nextval
3174: into P_Loan_Details_Rec.loan_number
3175: from dual;
3176: END IF;
3177: l_loan_rec.loan_number := P_Loan_Details_Rec.loan_number;
3178: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_rec.loan_number = ' || l_loan_rec.loan_number);
3179:

Line 3360: from dual;

3356: l_term_rec.loan_id := l_loan_rec.loan_id;
3357:
3358: select LNS_TERMS_S.nextval
3359: into l_term_rec.term_id
3360: from dual;
3361: LogMessage(FND_LOG.LEVEL_STATEMENT, 'term_id = ' || l_term_rec.term_id);
3362:
3363: l_term_rec.rate_type := P_Loan_Details_Rec.RATE_TYPE;
3364: LogMessage(FND_LOG.LEVEL_STATEMENT, 'rate_type = ' || l_term_rec.rate_type);

Line 4054: select lns_disb_headers_s.NEXTVAL into l_DISB_HEADER_REC.DISB_HEADER_ID from dual;

4050:
4051: FOR l_count IN 1 .. P_DISB_TBL.COUNT LOOP
4052:
4053: -- create disb header
4054: select lns_disb_headers_s.NEXTVAL into l_DISB_HEADER_REC.DISB_HEADER_ID from dual;
4055:
4056: l_DISB_HEADER_REC.LOAN_ID := l_loan_rec.loan_id;
4057: l_DISB_HEADER_REC.HEADER_AMOUNT := P_DISB_TBL(l_count).AMOUNT;
4058: l_DISB_HEADER_REC.PAYMENT_REQUEST_DATE := P_DISB_TBL(l_count).DUE_DATE;

Line 4082: select lns_disb_lines_s.NEXTVAL into l_DISB_LINE_REC.DISB_LINE_ID from dual;

4078: RAISE fnd_api.g_exc_error;
4079: END IF;
4080:
4081: -- create disb line
4082: select lns_disb_lines_s.NEXTVAL into l_DISB_LINE_REC.DISB_LINE_ID from dual;
4083:
4084: l_DISB_LINE_REC.DISB_HEADER_ID := l_DISB_HEADER_REC.DISB_HEADER_ID;
4085: l_DISB_LINE_REC.DISB_LINE_NUMBER := 1;
4086: l_DISB_LINE_REC.LINE_AMOUNT := P_DISB_TBL(l_count).AMOUNT;