APPS.LNS_UTILITY_PUB dependencies on FND_USER

Line 1103: FUNCTION IS_CUSTOMER_CONTACT(p_fnd_user_id IN NUMBER) return VARCHAR2 IS

1099:
1100:
1101: --This function checks if the given user is a valid Customer Contact or not.
1102:
1103: FUNCTION IS_CUSTOMER_CONTACT(p_fnd_user_id IN NUMBER) return VARCHAR2 IS
1104:
1105: l_customer_contact_flag VARCHAR2(1) ;
1106: l_api_name CONSTANT VARCHAR2(30) := 'IS_CUSTOMER_CONTACT';
1107:

Line 1113: FROM hz_parties party, fnd_user fnduser

1109: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1110: l_customer_contact_flag := 'N' ;
1111:
1112: SELECT 'Y' INTO l_customer_contact_flag
1113: FROM hz_parties party, fnd_user fnduser
1114: WHERE party.party_type = 'PARTY_RELATIONSHIP'
1115: AND party.status ='A'
1116: AND fnduser.customer_id = party.party_id
1117: AND fnduser.user_id = p_fnd_user_id;

Line 1117: AND fnduser.user_id = p_fnd_user_id;

1113: FROM hz_parties party, fnd_user fnduser
1114: WHERE party.party_type = 'PARTY_RELATIONSHIP'
1115: AND party.status ='A'
1116: AND fnduser.customer_id = party.party_id
1117: AND fnduser.user_id = p_fnd_user_id;
1118:
1119: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :END');
1120: return l_customer_contact_flag ;
1121: EXCEPTION

Line 1135: (p_fnd_user_id IN NUMBER

1131:
1132: --This function returns the number of loans to which a given user has access to
1133:
1134: FUNCTION CUSTOMER_CONTACT_LOANS_COUNT
1135: (p_fnd_user_id IN NUMBER
1136: ,p_org_id IN NUMBER
1137: ,p_borrower_id IN NUMBER) return NUMBER IS
1138:
1139: l_fnd_user_id NUMBER;

Line 1139: l_fnd_user_id NUMBER;

1135: (p_fnd_user_id IN NUMBER
1136: ,p_org_id IN NUMBER
1137: ,p_borrower_id IN NUMBER) return NUMBER IS
1138:
1139: l_fnd_user_id NUMBER;
1140: l_number_of_loans NUMBER;
1141: l_subject_id NUMBER;
1142: l_api_name CONSTANT VARCHAR2(30) := 'CUSTOMER_CONTACT_LOANS_COUNT';
1143: l_org_id NUMBER;

Line 1147: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' FND_USER_ID - ' || p_fnd_user_id);

1143: l_org_id NUMBER;
1144: BEGIN
1145: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1146: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' ORGID - ' || p_org_id);
1147: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' FND_USER_ID - ' || p_fnd_user_id);
1148: l_number_of_loans := 0 ;
1149: l_fnd_user_id := p_fnd_user_id;
1150: l_subject_id := -1;
1151: l_org_id := p_org_id;

Line 1149: l_fnd_user_id := p_fnd_user_id;

1145: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1146: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' ORGID - ' || p_org_id);
1147: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' FND_USER_ID - ' || p_fnd_user_id);
1148: l_number_of_loans := 0 ;
1149: l_fnd_user_id := p_fnd_user_id;
1150: l_subject_id := -1;
1151: l_org_id := p_org_id;
1152:
1153:

Line 1155: FROM hz_parties party, fnd_user fnduser

1151: l_org_id := p_org_id;
1152:
1153:
1154: SELECT person_party_id INTO l_subject_id
1155: FROM hz_parties party, fnd_user fnduser
1156: WHERE party.party_type = 'PARTY_RELATIONSHIP'
1157: AND party.status ='A'
1158: AND fnduser.customer_id = party.party_id
1159: AND fnduser.user_id = l_fnd_user_id;

Line 1159: AND fnduser.user_id = l_fnd_user_id;

1155: FROM hz_parties party, fnd_user fnduser
1156: WHERE party.party_type = 'PARTY_RELATIONSHIP'
1157: AND party.status ='A'
1158: AND fnduser.customer_id = party.party_id
1159: AND fnduser.user_id = l_fnd_user_id;
1160:
1161: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' Subject_ID - ' || l_subject_id);
1162:
1163: SELECT count(participant.loan_id) INTO l_number_of_loans