DBA Data[Home] [Help]

APPS.PNRX_RENT_INCREASE_SUMMARY dependencies on FND_PROFILE

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

74:
75: --Initialise status parameters...
76: retcode := 0;
77: errbuf := '';
78: fnd_profile.get ('LOGIN_ID', l_login_id);
79:
80: --SELECT Fnd_Profile.value('ORG_ID') INTO l_org_id
81: --FROM dual;
82:

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

76: retcode := 0;
77: errbuf := '';
78: fnd_profile.get ('LOGIN_ID', l_login_id);
79:
80: --SELECT Fnd_Profile.value('ORG_ID') INTO l_org_id
81: --FROM dual;
82:
83: l_org_id := TO_NUMBER (fnd_profile.VALUE ('ORG_ID'));
84:

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

79:
80: --SELECT Fnd_Profile.value('ORG_ID') INTO l_org_id
81: --FROM dual;
82:
83: l_org_id := TO_NUMBER (fnd_profile.VALUE ('ORG_ID'));
84:
85: --lease number conditions.....
86: --lease_number_where_clause := 'AND l.lease_num = '||'''NE213142''';
87: