DBA Data[Home] [Help]

APPS.PNRX_RENT_INCREASE_DETAIL dependencies on FND_PROFILE

Line 104: fnd_profile.get ('LOGIN_ID', l_login_id);

100:
101: --Initialise status parameters...
102: retcode := 0;
103: errbuf := '';
104: fnd_profile.get ('LOGIN_ID', l_login_id);
105:
106: --SELECT Fnd_Profile.value('ORG_ID') INTO l_org_id
107: --FROM dual;
108:

Line 106: --SELECT Fnd_Profile.value('ORG_ID') INTO l_org_id

102: retcode := 0;
103: errbuf := '';
104: fnd_profile.get ('LOGIN_ID', l_login_id);
105:
106: --SELECT Fnd_Profile.value('ORG_ID') INTO l_org_id
107: --FROM dual;
108:
109: l_org_id := TO_NUMBER (fnd_profile.VALUE ('ORG_ID'));
110:

Line 109: l_org_id := TO_NUMBER (fnd_profile.VALUE ('ORG_ID'));

105:
106: --SELECT Fnd_Profile.value('ORG_ID') INTO l_org_id
107: --FROM dual;
108:
109: l_org_id := TO_NUMBER (fnd_profile.VALUE ('ORG_ID'));
110:
111: --lease number conditions.....
112: --lease_number_where_clause := 'AND l.lease_num = '||'''NE213142''';
113: