APPS.PN_LEASE_UTILS dependencies on FND_PROFILE

Line 7: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');--nvl(PN_MO_CACHE_UTILS.get_current_org_id,fnd_profile.VALUE ('org_id'));

3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_LEASE_UTILS';
5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';
6: g_tl_table_name CONSTANT VARCHAR2 (40) := 'NONE';
7: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');--nvl(PN_MO_CACHE_UTILS.get_current_org_id,fnd_profile.VALUE ('org_id'));
8: --:= fnd_profile.VALUE ('org_id');
9: --PN_MO_CACHE_UTILS.get_current_org_id;--Messages
10:
11: PROCEDURE add_null_parameter_msg (

Line 8: --:= fnd_profile.VALUE ('org_id');

4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_LEASE_UTILS';
5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';
6: g_tl_table_name CONSTANT VARCHAR2 (40) := 'NONE';
7: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');--nvl(PN_MO_CACHE_UTILS.get_current_org_id,fnd_profile.VALUE ('org_id'));
8: --:= fnd_profile.VALUE ('org_id');
9: --PN_MO_CACHE_UTILS.get_current_org_id;--Messages
10:
11: PROCEDURE add_null_parameter_msg (
12: p_token_apiname VARCHAR2

Line 1041: WHERE set_of_books_id = fnd_profile.VALUE ('GL_SET_OF_BKS_ID');

1037: CURSOR c_structure_num
1038: IS
1039: SELECT chart_of_accounts_id
1040: FROM gl_sets_of_books
1041: WHERE set_of_books_id = fnd_profile.VALUE ('GL_SET_OF_BKS_ID');
1042:
1043: CURSOR c_get_account (
1044: p_chart_of_acct_id IN NUMBER
1045: )

Line 1077: fnd_message.set_token ('SET_OF_BOOKS_ID', fnd_profile.VALUE ('GL_SET_OF_BKS_ID'));

1073: IF (c_structure_num%NOTFOUND)
1074: THEN
1075: /*fnd_message.set_name ('PN', 'PN_CHART_OF_ACCOUNTS_ID');
1076: fnd_message.set_token ('STRUCTURE_NUM', l_structure_num);
1077: fnd_message.set_token ('SET_OF_BOOKS_ID', fnd_profile.VALUE ('GL_SET_OF_BKS_ID'));
1078:
1079: fnd_msg_pub.ADD;*/
1080: x_return_status := fnd_api.g_ret_sts_error;
1081: ELSE

Line 1269: AND comp.org_id = fnd_profile.VALUE('org_id');

1265: WHERE csite.lease_role_type = p_lease_role_type
1266: AND comp.company_id = csite.company_id)
1267: AND comp.company_id = x_company_id
1268: --AND comp.org_id = g_org_id;
1269: AND comp.org_id = fnd_profile.VALUE('org_id');
1270: CURSOR c_company_name (
1271: p_lease_role_type VARCHAR2
1272: )
1273: IS

Line 1283: AND comp.org_id =fnd_profile.VALUE('org_id');

1279: WHERE csite.lease_role_type = p_lease_role_type
1280: AND comp.company_id = csite.company_id)
1281: AND comp.NAME = p_company_name
1282: -- AND comp.org_id = g_org_id;
1283: AND comp.org_id =fnd_profile.VALUE('org_id');
1284: BEGIN
1285: IF ( x_company_id IS NULL
1286: OR x_company_id = pn_lease_utils.g_pn_miss_num
1287: )

Line 1295: -------dbms_output.put_line('fnd_profile.VALUE.org_id'||fnd_profile.VALUE('org_id'));

1291: FETCH c_company_name
1292: INTO x_company_id;
1293: ----dbms_output.put_line('Company ID:'||x_company_id);
1294: ----dbms_output.put_line('PN_MO_CACHE_UTILS.get_current_org_id'||PN_MO_CACHE_UTILS.get_current_org_id);
1295: -------dbms_output.put_line('fnd_profile.VALUE.org_id'||fnd_profile.VALUE('org_id'));
1296: ----dbms_output.put_line('fnd_global.org_id'||fnd_global.org_id);
1297: IF (c_company_name%NOTFOUND)
1298: THEN
1299: /* fnd_message.set_name ('PN', 'PN_INVALID_COMPANY');

Line 1383: AND org_id = fnd_profile.VALUE('ORG_ID');

1379: FROM pn_company_sites_all
1380: WHERE company_id = p_company_id
1381: AND company_site_id = x_company_site_id
1382: --AND org_id = g_org_id;
1383: AND org_id = fnd_profile.VALUE('ORG_ID');
1384:
1385: CURSOR c_company_site_name (
1386: p_company_id NUMBER
1387: , p_company_site_name VARCHAR2

Line 1395: AND org_id = fnd_profile.VALUE('ORG_ID');

1391: FROM pn_company_sites_all
1392: WHERE company_id = p_company_id
1393: AND NAME = p_company_site_name
1394: --AND org_id = g_org_id;
1395: AND org_id = fnd_profile.VALUE('ORG_ID');
1396: BEGIN
1397: IF ( x_company_site_id IS NULL
1398: OR x_company_site_id = pn_lease_utils.g_pn_miss_num
1399: )