eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PN_LEASE_PVT dependencies on PN_LEASE_DETAILS

Line 95: l_param_desc_flex_name VARCHAR2 (30) := 'P_PN_LEASE_DETAILS';

91: l_param_company_site_id VARCHAR2 (30) := 'P_COMPANY_SITE';
92: l_param_tenancy_location VARCHAR2 (30) := 'P_TENANCY_LOCATION';
93: l_param_tenancy_usage VARCHAR2 (30) := 'P_TENANCY_USAGE';
94: l_param_tenancy_dates VARCHAR2 (30) := 'P_TENANCY_DATES';
95: l_param_desc_flex_name VARCHAR2 (30) := 'P_PN_LEASE_DETAILS';
96: l_param_create_mode_operation VARCHAR2 (30) := 'CREATE_LEASE';
97: l_param_tenancy_recovery_type VARCHAR2 (30) := 'P_TENANCY_RECOVERY_TYPE';
98: l_param_recovery_space_std VARCHAR2 (30) := 'P_TENANCY_RECOVERY_SPACE_STD';
99: l_param_oblig_end_date VARCHAR2 (30) := 'P_TENANCY_OBLIG_END_DATE';

Line 1541: , pn_lease_details_all pld

1537: , l_lease_rec.lease_commencement_date
1538: , l_lease_rec.lease_termination_date
1539: , l_lease_rec.parent_lease_id
1540: FROM pn_leases_all pla
1541: , pn_lease_details_all pld
1542: WHERE pla.lease_id = p_lease_id
1543: AND pla.lease_id = pld.lease_id
1544: AND pld.org_id = g_org_id
1545: AND pla.org_id = g_org_id;

Line 2370: l_leasechangeid pn_lease_details.lease_change_id%TYPE;

2366: l_leaseterminationdate DATE := NULL;
2367: l_leaseexecutiondate DATE := NULL;
2368: l_lastupdatedate DATE := NULL;
2369: l_leaseextensionenddate DATE := NULL;
2370: l_leasechangeid pn_lease_details.lease_change_id%TYPE;
2371: BEGIN
2372: -- Standard start of API savepoint
2373: SAVEPOINT update_lease_pvt;
2374:

Line 4993: IF (get_attribute_status('PN_LEASE_DETAILS') > 0) THEN

4989: -- l_lease_rec.attribute15 := p_lease_rec.attribute15;
4990: END IF;
4991:
4992:
4993: IF (get_attribute_status('PN_LEASE_DETAILS') > 0) THEN
4994: /* get_attribute_mandatory_status('PN_LEASE_DETAILS'
4995: , p_lease_rec.attribute1
4996: , p_lease_rec.attribute2
4997: , p_lease_rec.attribute3

Line 4994: /* get_attribute_mandatory_status('PN_LEASE_DETAILS'

4990: END IF;
4991:
4992:
4993: IF (get_attribute_status('PN_LEASE_DETAILS') > 0) THEN
4994: /* get_attribute_mandatory_status('PN_LEASE_DETAILS'
4995: , p_lease_rec.attribute1
4996: , p_lease_rec.attribute2
4997: , p_lease_rec.attribute3
4998: , p_lease_rec.attribute4

Line 5044: , p_desc_flex_name => 'PN_LEASE_DETAILS'

5040: AND (p_lease_rec.attribute15 = pn_lease_utils.g_pn_miss_char OR p_lease_rec.attribute15 IS NULL)
5041: ) THEN
5042: pn_lease_utils.validate_desc_flex (p_api_name => l_api_name_full
5043: , p_application_short_name => 'PN'
5044: , p_desc_flex_name => 'PN_LEASE_DETAILS'
5045: , p_desc_segment1 => p_lease_rec.attribute1
5046: , p_desc_segment2 => p_lease_rec.attribute2
5047: , p_desc_segment3 => p_lease_rec.attribute3
5048: , p_desc_segment4 => p_lease_rec.attribute4

Line 11926: FROM pn_lease_details_all

11922: , send_entries
11923: , term_template_id
11924: , lease_extension_end_date
11925: , grouping_rule_id
11926: FROM pn_lease_details_all
11927: WHERE lease_id = p_lease_rec.lease_id;
11928:
11929: l_return_status VARCHAR2 (1);
11930: l_debug_mode VARCHAR2 (1);

Line 11942: l_leasechangeid pn_lease_details.lease_change_id%TYPE := NULL;

11938: l_leaseexecutiondate DATE := NULL;
11939: l_lastupdatedate DATE := NULL;
11940: l_leaseextensionenddate DATE := NULL;
11941: l_lease_status pn_leases_all.lease_status%TYPE := NULL;
11942: l_leasechangeid pn_lease_details.lease_change_id%TYPE := NULL;
11943: l_lease_context VARCHAR2 (100) := NULL;
11944: l_abstracted_by_user pn_leases_all.abstracted_by_user%TYPE := NULL;
11945: l_payment_term_proration_rule pn_leases_all.payment_term_proration_rule%TYPE := NULL;
11946: l_requestid NUMBER := NULL;

Line 13013: , p_desc_flex_name => 'PN_LEASE_DETAILS'

13009: END IF;
13010: ----------------------dbms_output.put_line('AFTER ATRR SETTING:1');--Rupak
13011: pn_lease_utils.validate_desc_flex (p_api_name => l_api_name_full
13012: , p_application_short_name => 'PN'
13013: , p_desc_flex_name => 'PN_LEASE_DETAILS'
13014: , p_desc_segment1 => l_lease_rec.attribute1
13015: , p_desc_segment2 => l_lease_rec.attribute2
13016: , p_desc_segment3 => l_lease_rec.attribute3
13017: , p_desc_segment4 => l_lease_rec.attribute4

Line 13042: fnd_message.set_token ('COLUMN', 'PN_LEASE_DETAILS_DESC_FIELDS');

13038: ----------------------dbms_output.put_line('AFTER ATRR SETTING:2');--Rupak
13039: IF (x_return_status = fnd_api.g_ret_sts_error)
13040: THEN
13041: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
13042: fnd_message.set_token ('COLUMN', 'PN_LEASE_DETAILS_DESC_FIELDS');
13043: fnd_message.set_token ('P_TEXT', 'PN_LEASE_DETAILS'|| '-'|| SQLERRM);
13044: fnd_msg_pub.ADD;
13045: RAISE fnd_api.g_exc_error;
13046: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

Line 13043: fnd_message.set_token ('P_TEXT', 'PN_LEASE_DETAILS'|| '-'|| SQLERRM);

13039: IF (x_return_status = fnd_api.g_ret_sts_error)
13040: THEN
13041: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
13042: fnd_message.set_token ('COLUMN', 'PN_LEASE_DETAILS_DESC_FIELDS');
13043: fnd_message.set_token ('P_TEXT', 'PN_LEASE_DETAILS'|| '-'|| SQLERRM);
13044: fnd_msg_pub.ADD;
13045: RAISE fnd_api.g_exc_error;
13046: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
13047: THEN

Line 13049: fnd_message.set_token ('COLUMN', 'PN_LEASE_DETAILS_DESC_FIELDS');

13045: RAISE fnd_api.g_exc_error;
13046: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
13047: THEN
13048: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
13049: fnd_message.set_token ('COLUMN', 'PN_LEASE_DETAILS_DESC_FIELDS');
13050: fnd_message.set_token ('P_TEXT', 'PN_LEASE_DETAILS'|| '-'|| SQLERRM);
13051: fnd_msg_pub.ADD;
13052: RAISE fnd_api.g_exc_unexpected_error;
13053: END IF;

Line 13050: fnd_message.set_token ('P_TEXT', 'PN_LEASE_DETAILS'|| '-'|| SQLERRM);

13046: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
13047: THEN
13048: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
13049: fnd_message.set_token ('COLUMN', 'PN_LEASE_DETAILS_DESC_FIELDS');
13050: fnd_message.set_token ('P_TEXT', 'PN_LEASE_DETAILS'|| '-'|| SQLERRM);
13051: fnd_msg_pub.ADD;
13052: RAISE fnd_api.g_exc_unexpected_error;
13053: END IF;
13054: -- pn_lease_pub.test_lease(2,'In Private:9');

Line 15450: FROM pn_leases_all pla,pn_lease_details pld

15446: pvt_debug(g_pkg_name||'-VALIDATE_PAYMENT_TERMS_TBL:Lease Account Check',3);
15447: BEGIN
15448: SELECT pld.expense_account_id,pld.receivable_account_id,pld.accrual_account_id
15449: INTO l_expense_account_id,l_receivable_account_id,l_accrual_account_id
15450: FROM pn_leases_all pla,pn_lease_details pld
15451: WHERE pla.lease_id = pld.lease_id
15452: AND pla.lease_id = p_lease_id;
15453: EXCEPTION
15454: WHEN NO_DATA_FOUND THEN

Line 16813: FROM pn_leases_all pla, pn_lease_details_all pld

16809: , l_parent_lease_id
16810: , l_termtemp_type
16811: , l_lease_change_id
16812: , l_lease_status
16813: FROM pn_leases_all pla, pn_lease_details_all pld
16814: WHERE pla.lease_id = p_lease_id
16815: AND pla.lease_id = pld.lease_id
16816: AND pld.org_id = pla.org_id
16817: AND pla.org_id = g_org_id;

Line 17836: FROM pn_leases_all pla, pn_lease_details_all pld

17832: , l_parent_lease_id
17833: , l_termtemp_type
17834: , l_lease_change_id
17835: , l_lease_status
17836: FROM pn_leases_all pla, pn_lease_details_all pld
17837: WHERE pla.lease_id = p_lease_id
17838: AND pla.lease_id = pld.lease_id
17839: AND pld.org_id = pla.org_id
17840: AND pla.org_id = g_org_id;

Line 18650: ,pn_lease_details_all PLD

18646: ,PLA.status status
18647: ,PLA.lease_status lease_status
18648: ,PLD.lease_commencement_date lease_commencement_date
18649: FROM pn_leases_all PLA
18650: ,pn_lease_details_all PLD
18651: WHERE PLD.lease_id = PLA.lease_id
18652: AND PLD.org_id = PLA.org_id
18653: AND PLA.lease_id = p_lease_id
18654: AND PLA.org_id = g_org_id;