APPS.LNS_REP_UTILS dependencies on LNS_PARTICIPANTS

Line 1271: FROM LNS_PARTICIPANTS lp, HZ_PARTIES party, AR_LOOKUPS lkup, LNS_LOOKUPS lnslkup,

1267: )
1268: )
1269: )
1270: )
1271: FROM LNS_PARTICIPANTS lp, HZ_PARTIES party, AR_LOOKUPS lkup, LNS_LOOKUPS lnslkup,
1272: FND_TERRITORIES_TL ter, HZ_CONTACT_POINTS cp, HZ_PARTIES contact_person,
1273: HZ_PARTIES contact_party, HZ_CONTACT_POINTS con_phone
1274: WHERE party.party_id =lp.HZ_PARTY_ID
1275: AND party.party_type = lkup.lookup_code

Line 1366: LNS_PARTICIPANTS par

1362: LNS_LOOKUPS lkps4,
1363: LNS_LOOKUPS lkps5,
1364: LNS_LOOKUPS lkps6,
1365: HZ_PARTIES party,
1366: LNS_PARTICIPANTS par
1367: WHERE assetassign.asset_id = asset.asset_id and
1368: asset.asset_owner_id = par.hz_party_id and
1369: party.party_id = par.hz_party_id and
1370: assetassign.loan_id = par.loan_id and

Line 2533: l_participant_rec LNS_PARTICIPANTS_PUB.loan_participant_rec_type;

2529: l_ACCESS_LEVEL VARCHAR2(30);
2530: l_start DATE;
2531: l_end DATE;
2532:
2533: l_participant_rec LNS_PARTICIPANTS_PUB.loan_participant_rec_type;
2534:
2535: /*-----------------------------------------------------------------------+
2536: | Cursor Declarations |
2537: +-----------------------------------------------------------------------*/

Line 2546: from LNS_PARTICIPANTS parts,

2542: parts.LOAN_ID,
2543: loans.LOAN_NUMBER,
2544: parts.OBJECT_VERSION_NUMBER,
2545: parts.ACCESS_LEVEL
2546: from LNS_PARTICIPANTS parts,
2547: LNS_LOAN_HEADERS loans
2548: where loans.loan_id = parts.loan_id
2549: and loans.ORG_ID = nvl(P_ORG_ID, loans.ORG_ID)
2550: and loans.PRIMARY_BORROWER_ID = nvl(P_BORROWER_ID, loans.PRIMARY_BORROWER_ID)

Line 2605: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');

2601: else
2602: l_participant_rec.ACCESS_LEVEL := BORR_ACCESS_LEVEL;
2603: end if;
2604:
2605: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2606: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2607: p_init_msg_list => FND_API.G_TRUE
2608: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2609: ,p_loan_participant_rec => l_participant_rec

Line 2606: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (

2602: l_participant_rec.ACCESS_LEVEL := BORR_ACCESS_LEVEL;
2603: end if;
2604:
2605: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2606: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2607: p_init_msg_list => FND_API.G_TRUE
2608: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2609: ,p_loan_participant_rec => l_participant_rec
2610: ,X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER

Line 2681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');

2677: else
2678: l_participant_rec.ACCESS_LEVEL := COBORR_ACCESS_LEVEL;
2679: end if;
2680:
2681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2682: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2683: p_init_msg_list => FND_API.G_TRUE
2684: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2685: ,p_loan_participant_rec => l_participant_rec

Line 2682: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (

2678: l_participant_rec.ACCESS_LEVEL := COBORR_ACCESS_LEVEL;
2679: end if;
2680:
2681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2682: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2683: p_init_msg_list => FND_API.G_TRUE
2684: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2685: ,p_loan_participant_rec => l_participant_rec
2686: ,X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER

Line 2756: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');

2752: else
2753: l_participant_rec.ACCESS_LEVEL := GUAR_ACCESS_LEVEL;
2754: end if;
2755:
2756: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2757: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2758: p_init_msg_list => FND_API.G_TRUE
2759: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2760: ,p_loan_participant_rec => l_participant_rec

Line 2757: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (

2753: l_participant_rec.ACCESS_LEVEL := GUAR_ACCESS_LEVEL;
2754: end if;
2755:
2756: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2757: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2758: p_init_msg_list => FND_API.G_TRUE
2759: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2760: ,p_loan_participant_rec => l_participant_rec
2761: ,X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER