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.

APPS.PN_LEASE_PVT dependencies on PN_LEASES_ALL

Line 5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';

1: PACKAGE BODY PN_LEASE_PVT AS
2: /* $Header: PNLSPVTB.pls 120.6.12020000.4 2013/04/05 14:09:14 ppenumar ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_LEASE_PVT';
5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';
6: g_tl_table_name CONSTANT VARCHAR2 (40) := 'NONE';
7: g_resp_appl_id CONSTANT NUMBER := fnd_global.resp_appl_id;
8: g_resp_id CONSTANT NUMBER := fnd_global.resp_id;
9: g_user_id CONSTANT NUMBER := fnd_global.user_id;

Line 1540: FROM pn_leases_all pla

1536: INTO l_lease_rec.lease_class_code
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

Line 5686: , p_lease_id IN PN_LEASES_ALL.lease_id%type

5682:
5683:
5684:
5685: PROCEDURE NOTE_INSERT_ROW(p_note_tbl IN OUT NOCOPY lease_note_tbl_type
5686: , p_lease_id IN PN_LEASES_ALL.lease_id%type
5687: , x_return_status OUT NOCOPY VARCHAR2
5688: , p_tbl IN temp_tbl_type
5689: , p_commit IN VARCHAR2
5690: )

Line 5834: ,p_lease_id PN_LEASES_ALL.LEASE_ID%TYPE

5830: END CREATE_NOTE;
5831:
5832: PROCEDURE VALIDATE_NOTE_FOR_UPDATE(
5833: p_note_tbl IN OUT NOCOPY lease_note_tbl_type
5834: ,p_lease_id PN_LEASES_ALL.LEASE_ID%TYPE
5835: ,x_tbl OUT NOCOPY temp_tbl_type
5836: ,x_return_status IN OUT NOCOPY VARCHAR2
5837:
5838: )

Line 6084: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

6080: END VALIDATE_NOTE_FOR_UPDATE;
6081:
6082:
6083: PROCEDURE NOTE_UPDATE_ROW ( p_note_tbl IN OUT NOCOPY lease_note_tbl_type
6084: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
6085: ,x_return_status OUT NOCOPY VARCHAR2
6086: ,p_tbl IN temp_tbl_type
6087: ,p_commit IN VARCHAR2
6088: )

Line 6214: p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

6210: ------------------dbms_output.put_line('NOTE UPDATION FAILED'||SQLERRM);
6211: END NOTE_UPDATE_ROW;
6212:
6213: PROCEDURE UPDATE_NOTE (
6214: p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
6215: , p_commit IN VARCHAR2
6216: , p_validate IN VARCHAR2
6217: , p_note_tbl IN OUT NOCOPY lease_note_tbl_type
6218: , x_return_status OUT NOCOPY VARCHAR2

Line 6538: , p_lease_id IN PN_LEASES_ALL.lease_id%type

6534: pvt_debug(g_pkg_name||'-VALIDATE_RIGHT_FOR_CREATE:Exception'||SQLERRM,3);
6535: END VALIDATE_RIGHT_FOR_CREATE;
6536:
6537: PROCEDURE RIGHT_INSERT_ROW(p_right_tbl IN OUT NOCOPY lease_right_tbl_type
6538: , p_lease_id IN PN_LEASES_ALL.lease_id%type
6539: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
6540: , x_return_status OUT NOCOPY VARCHAR2
6541: , p_tbl IN temp_tbl_type
6542: , p_commit IN VARCHAR2

Line 6624: p_lease_id IN PN_LEASES_ALL.lease_id%type

6620: pvt_debug(g_pkg_name||'-RIGHT_INSERT_ROW::Exception'||SQLERRM,3);
6621: END RIGHT_INSERT_ROW;
6622:
6623: PROCEDURE CREATE_RIGHT (
6624: p_lease_id IN PN_LEASES_ALL.lease_id%type
6625: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
6626: , p_commit IN VARCHAR2
6627: , p_validate IN VARCHAR2
6628: , p_right_tbl IN OUT NOCOPY lease_right_tbl_type

Line 6669: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

6665:
6666:
6667: PROCEDURE VALIDATE_RIGHT_FOR_UPDATE(
6668: p_right_tbl IN OUT NOCOPY lease_right_tbl_type
6669: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
6670: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE
6671: ,x_tbl OUT NOCOPY temp_tbl_type
6672: ,x_return_status IN OUT NOCOPY VARCHAR2
6673: ,p_commit IN VARCHAR2

Line 7002: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%type

6998: --------------------dbms_output.put_line('sqlcode: '||sqlcode||'and sqlerrm: '||sqlerrm);
6999: END VALIDATE_RIGHT_FOR_UPDATE;
7000:
7001: PROCEDURE RIGHT_UPDATE_ROW( p_right_tbl IN OUT NOCOPY lease_right_tbl_type
7002: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%type
7003: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
7004: ,x_return_status OUT NOCOPY VARCHAR2
7005: ,p_tbl IN temp_tbl_type
7006: ,p_commit IN VARCHAR2

Line 7080: p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

7076: pvt_debug(g_pkg_name||'-RIGHT_UPDATE_ROW:Exception'||SQLERRM,3);
7077: END RIGHT_UPDATE_ROW;
7078:
7079: PROCEDURE UPDATE_RIGHT (
7080: p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
7081: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE
7082: , p_commit IN VARCHAR2
7083: , p_validate IN VARCHAR2
7084: , p_right_tbl IN OUT NOCOPY lease_right_tbl_type

Line 7197: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%type

7193:
7194:
7195: PROCEDURE VALIDATE_OBLIGATION_FOR_CREATE(
7196: p_obligation_tbl IN OUT NOCOPY lease_obligation_tbl_type
7197: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%type
7198: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
7199: ,x_tbl OUT NOCOPY temp_tbl_type
7200: ,x_return_status IN OUT NOCOPY VARCHAR2
7201: )

Line 7534: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

7530: pvt_debug(g_pkg_name||'-VALIDATE_OBLIGATION_FOR_CREATE:OTHERS:EXCEPTION:'||SQLERRM,3);
7531: END VALIDATE_OBLIGATION_FOR_CREATE;
7532:
7533: PROCEDURE OBLIGATION_INSERT_ROW(p_obligation_tbl IN OUT NOCOPY LEASE_OBLIGATION_TBL_TYPE
7534: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
7535: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE
7536: ,x_return_status IN OUT NOCOPY VARCHAR2
7537: ,p_tbl IN OUT NOCOPY TEMP_TBL_TYPE
7538: ,p_commit IN VARCHAR2

Line 7670: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

7666:
7667:
7668: PROCEDURE VALIDATE_OBLIGATION_FOR_UPDATE(
7669: p_obligation_tbl IN OUT NOCOPY lease_obligation_tbl_type
7670: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
7671: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE
7672: ,x_tbl OUT NOCOPY temp_tbl_type
7673: ,x_return_status IN OUT NOCOPY VARCHAR2
7674: )

Line 8108: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%type

8104: pvt_debug(g_pkg_name||'-VALIDATE_OBLIGATION_FOR_UPDATE:OTHERS:EXCEPTION:'||SQLERRM,3);
8105: END VALIDATE_OBLIGATION_FOR_UPDATE;
8106:
8107: PROCEDURE OBLIGATION_UPDATE_ROW (p_obligation_tbl IN OUT NOCOPY lease_obligation_tbl_type
8108: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%type
8109: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
8110: ,x_return_status OUT NOCOPY VARCHAR2
8111: ,p_tbl IN temp_tbl_type
8112: ,p_commit IN VARCHAR2

Line 8202: p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

8198: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:Exception:'||SQLERRM,3);
8199: END OBLIGATION_UPDATE_ROW;
8200:
8201: PROCEDURE UPDATE_OBLIGATION (
8202: p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
8203: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE
8204: , p_commit IN VARCHAR2
8205: , p_validate IN VARCHAR2
8206: , p_obligation_tbl IN OUT NOCOPY lease_obligation_tbl_type

Line 8509: ,p_lease_id IN PN_LEASES_ALL.lease_id%type

8505:
8506:
8507: PROCEDURE MILESTONE_INSERT_ROW(
8508: p_milestone_tbl IN OUT NOCOPY lease_milestone_tbl_type
8509: ,p_lease_id IN PN_LEASES_ALL.lease_id%type
8510: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
8511: ,p_option_id IN PN_LEASE_MILESTONES_ALL.option_id%type
8512: ,p_insurance_req_id IN PN_LEASE_MILESTONES_ALL.insurance_requirement_id%type
8513: ,p_payment_term_id IN PN_LEASE_MILESTONES_ALL.payment_term_id%type

Line 8589: , p_lease_id IN PN_LEASES_ALL.lease_id%type

8585: END MILESTONE_INSERT_ROW;
8586:
8587: PROCEDURE CREATE_MILESTONE (
8588: p_milestone_tbl IN OUT NOCOPY lease_milestone_tbl_type
8589: , p_lease_id IN PN_LEASES_ALL.lease_id%type
8590: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
8591: , p_option_id IN PN_LEASE_MILESTONES_ALL.option_id%type
8592: , p_insurance_req_id IN PN_LEASE_MILESTONES_ALL.insurance_requirement_id%type
8593: , p_payment_term_id IN PN_LEASE_MILESTONES_ALL.payment_term_id%type

Line 8641: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

8637:
8638:
8639: PROCEDURE VALIDATE_MILESTONE_FOR_UPDATE(
8640: p_milestone_tbl IN OUT NOCOPY lease_milestone_tbl_type
8641: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
8642: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE
8643: ,p_option_id IN PN_LEASE_MILESTONES_ALL.OPTION_ID%TYPE
8644: ,p_insurance_req_id IN PN_LEASE_MILESTONES_ALL.INSURANCE_REQUIREMENT_ID%TYPE
8645: ,p_payment_term_id IN PN_LEASE_MILESTONES_ALL.PAYMENT_TERM_ID%TYPE

Line 8979: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

8975:
8976:
8977: PROCEDURE MILESTONE_UPDATE_ROW(
8978: p_milestone_tbl IN OUT NOCOPY lease_milestone_tbl_type
8979: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
8980: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE
8981: ,p_option_id IN PN_LEASE_MILESTONES_ALL.OPTION_ID%TYPE
8982: ,p_insurance_req_id IN PN_LEASE_MILESTONES_ALL.INSURANCE_REQUIREMENT_ID%TYPE
8983: ,p_payment_term_id IN PN_LEASE_MILESTONES_ALL.PAYMENT_TERM_ID%TYPE

Line 9061: , p_lease_id IN PN_LEASES_ALL.lease_id%type

9057: END MILESTONE_UPDATE_ROW;
9058:
9059: PROCEDURE UPDATE_MILESTONE (
9060: p_milestone_tbl IN OUT NOCOPY lease_milestone_tbl_type
9061: , p_lease_id IN PN_LEASES_ALL.lease_id%type
9062: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
9063: , p_option_id IN PN_LEASE_MILESTONES_ALL.option_id%type
9064: , p_insurance_req_id IN PN_LEASE_MILESTONES_ALL.insurance_requirement_id%type
9065: , p_payment_term_id IN PN_LEASE_MILESTONES_ALL.payment_term_id%type

Line 9430: , p_lease_id IN PN_LEASES_ALL.lease_id%type

9426: END VALIDATE_INSURANCE_FOR_CREATE;
9427:
9428:
9429: PROCEDURE INSURANCE_INSERT_ROW (p_insurance_tbl IN OUT NOCOPY lease_insurance_tbl_type
9430: , p_lease_id IN PN_LEASES_ALL.lease_id%type
9431: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
9432: , x_return_status OUT NOCOPY VARCHAR2
9433: , p_tbl IN temp_tbl_type
9434: , p_commit IN VARCHAR2

Line 9526: p_lease_id IN PN_LEASES_ALL.lease_id%type

9522: pvt_debug(g_pkg_name||'-INSURANCE_INSERT_ROW:Exception'||SQLERRM,3);
9523: END INSURANCE_INSERT_ROW;
9524:
9525: PROCEDURE CREATE_INSURANCE (
9526: p_lease_id IN PN_LEASES_ALL.lease_id%type
9527: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
9528: , p_commit IN VARCHAR2
9529: , p_validate IN VARCHAR2
9530: , p_insurance_tbl IN OUT NOCOPY lease_insurance_tbl_type

Line 9573: p_lease_id IN pn_leases_all.lease_id%TYPE,

9569: PROCEDURE validate_insurance_for_update (
9570: p_insurance_tbl IN OUT NOCOPY lease_insurance_tbl_type,
9571: x_tbl OUT NOCOPY temp_tbl_type,
9572: x_return_status IN OUT NOCOPY VARCHAR2,
9573: p_lease_id IN pn_leases_all.lease_id%TYPE,
9574: p_lease_change_id IN pn_lease_changes_all.lease_change_id%TYPE
9575: )
9576: IS
9577: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 9960: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%type

9956: ------------------dbms_output.put_line('Exception:VALIDATE_INSURANCE_FOR_UPDATE'||SQLERRM);
9957: END VALIDATE_INSURANCE_FOR_UPDATE;
9958:
9959: PROCEDURE INSURANCE_UPDATE_ROW (p_insurance_tbl IN OUT NOCOPY lease_insurance_tbl_type
9960: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%type
9961: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
9962: ,x_return_status OUT NOCOPY VARCHAR2
9963: ,p_tbl IN temp_tbl_type
9964: ,p_commit IN VARCHAR2

Line 10053: p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

10049: pvt_debug(g_pkg_name||'-INSURANCE_UPDATE_ROW:Exception:'||SQLERRM,3);
10050: END INSURANCE_UPDATE_ROW;
10051:
10052: PROCEDURE UPDATE_INSURANCE (
10053: p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
10054: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE
10055: , p_commit IN VARCHAR2
10056: , p_validate IN VARCHAR2
10057: , p_insurance_tbl IN OUT NOCOPY lease_insurance_tbl_type

Line 10543: , p_lease_id IN PN_LEASES_ALL.lease_id%type

10539:
10540:
10541: PROCEDURE OPTION_INSERT_ROW(
10542: p_option_tbl IN OUT NOCOPY lease_option_tbl_type
10543: , p_lease_id IN PN_LEASES_ALL.lease_id%type
10544: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
10545: , x_return_status OUT NOCOPY VARCHAR2
10546: , p_tbl IN temp_tbl_type
10547: , p_commit IN VARCHAR2

Line 10656: p_lease_id IN PN_LEASES_ALL.lease_id%type

10652: END OPTION_INSERT_ROW;
10653:
10654:
10655: PROCEDURE CREATE_OPTION (
10656: p_lease_id IN PN_LEASES_ALL.lease_id%type
10657: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
10658: , p_commit IN VARCHAR2
10659: , p_validate IN VARCHAR2
10660: , p_option_tbl IN OUT NOCOPY lease_option_tbl_type

Line 10710: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

10706:
10707:
10708: PROCEDURE VALIDATE_OPTION_FOR_UPDATE(
10709: p_option_tbl IN OUT NOCOPY lease_option_tbl_type
10710: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
10711: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE
10712: ,x_tbl OUT NOCOPY temp_tbl_type
10713: ,x_return_status IN OUT NOCOPY VARCHAR2
10714: ,p_commit IN VARCHAR2

Line 11199: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%type

11195: END VALIDATE_OPTION_FOR_UPDATE;
11196:
11197: PROCEDURE OPTION_UPDATE_ROW(
11198: p_option_tbl IN OUT NOCOPY lease_option_tbl_type
11199: ,p_lease_id IN PN_LEASES_ALL.LEASE_ID%type
11200: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type
11201: ,x_return_status OUT NOCOPY VARCHAR2
11202: ,p_tbl IN temp_tbl_type
11203: ,p_commit IN VARCHAR2

Line 11317: p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE

11313: pvt_debug(g_pkg_name||'OPTION_UPDATE_ROW:Exception:'||SQLERRM,3);
11314: END OPTION_UPDATE_ROW;
11315:
11316: PROCEDURE UPDATE_OPTION (
11317: p_lease_id IN PN_LEASES_ALL.LEASE_ID%TYPE
11318: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE
11319: , p_commit IN VARCHAR2
11320: , p_validate IN VARCHAR2
11321: , p_option_tbl IN OUT NOCOPY lease_option_tbl_type

Line 11885: FROM pn_leases_all

11881: , lease_status
11882: , location_id
11883: , customer_id
11884: , cal_start
11885: FROM pn_leases_all
11886: WHERE lease_id = p_lease_rec.lease_id;
11887:
11888: CURSOR cur_lease_details
11889: IS

Line 11941: l_lease_status pn_leases_all.lease_status%TYPE := NULL;

11937: l_leaseterminationdate DATE := 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;

Line 11944: l_abstracted_by_user pn_leases_all.abstracted_by_user%TYPE := 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;
11947: l_cross_val_flag VARCHAR2 (1) := 'N';
11948: l_proration_rule_flag VARCHAR2 (1) := 'N';

Line 11945: l_payment_term_proration_rule pn_leases_all.payment_term_proration_rule%TYPE := 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;
11947: l_cross_val_flag VARCHAR2 (1) := 'N';
11948: l_proration_rule_flag VARCHAR2 (1) := 'N';
11949: --- Cursor Variable Declaration

Line 11957: l_old_status_code pn_leases_all.status%TYPE := NULL;

11953: l_lease_rec lease_rec;
11954: --l_lease_detail_attribs pn_lease_pub.lease_detail_attribs_rec_type;
11955: l_rowid VARCHAR2 (18) := NULL;
11956: l_lease_change_num pn_lease_changes_all.lease_change_number%TYPE;
11957: l_old_status_code pn_leases_all.status%TYPE := NULL;
11958: l_api_version CONSTANT NUMBER := 1.0;
11959: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_LEASE';
11960: l_api_name_full CONSTANT VARCHAR2 (61) := g_pkg_name
11961: || '.'

Line 11970: l_lease_status_db pn_leases_all.lease_status%TYPE := NULL;

11966: x_request_id NUMBER:=NULL;
11967: l_tenancy_id NUMBER:=NULL;
11968: l_status VARCHAR2(50);
11969: l_status_new VARCHAR2(50);
11970: l_lease_status_db pn_leases_all.lease_status%TYPE := NULL;
11971: l_lease_status_new pn_leases_all.lease_status%TYPE := NULL;
11972: BEGIN
11973: l_lease_context := NVL(p_lease_context,'UPD');
11974: g_lease_context := l_lease_context;

Line 11971: l_lease_status_new pn_leases_all.lease_status%TYPE := NULL;

11967: l_tenancy_id NUMBER:=NULL;
11968: l_status VARCHAR2(50);
11969: l_status_new VARCHAR2(50);
11970: l_lease_status_db pn_leases_all.lease_status%TYPE := NULL;
11971: l_lease_status_new pn_leases_all.lease_status%TYPE := NULL;
11972: BEGIN
11973: l_lease_context := NVL(p_lease_context,'UPD');
11974: g_lease_context := l_lease_context;
11975: -- Standard start of API savepoint

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 16743: l_lease_status pn_leases_all.status%TYPE;

16739: WHERE payment_term_id = p_payment_term_id;
16740:
16741:
16742: -- l_payterm_details cur_payment_terms%ROWTYPE;
16743: l_lease_status pn_leases_all.status%TYPE;
16744: l_lease_context VARCHAR2(20);
16745: e_invalid_mode EXCEPTION;
16746:
16747: k NUMBER;

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 17770: l_lease_status pn_leases_all.STATUS%TYPE;

17766: l_return_status VARCHAR2 (1);
17767:
17768:
17769: --l_term_defaults cur_term_template%ROWTYPE;
17770: l_lease_status pn_leases_all.STATUS%TYPE;
17771: l_lease_context VARCHAR2(20) := null;
17772:
17773: l_lease_class_code VARCHAR2 (30);
17774: l_lease_commencement_date DATE;

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 18649: FROM pn_leases_all PLA

18645: IS SELECT PLA.lease_id lease_id
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

Line 18799: UPDATE pn_leases_all

18795: IF NVL(p_new_lease_status,l_lease_status_old) <> l_lease_status_old
18796: AND l_approval_status_old='D'
18797: THEN
18798: BEGIN
18799: UPDATE pn_leases_all
18800: SET lease_status = p_new_lease_status
18801: WHERE lease_id = p_lease_id
18802: AND org_id= g_org_id;
18803: --dbms_output.put_line('p_new_lease_status updated');

Line 18882: UPDATE pn_leases_all

18878: THEN
18879:
18880: --dbms_output.put_line('Updating status to Submitted');
18881: BEGIN
18882: UPDATE pn_leases_all
18883: SET status = l_submitted_status -- Holds the value of S'
18884: WHERE lease_id = p_lease_id
18885: AND org_id= g_org_id;
18886: COMMIT;

Line 18913: UPDATE pn_leases_all

18909: --dbms_output.put_line('Updating approval status to F');
18910: l_schedule_context := 'ABS';
18911:
18912: BEGIN
18913: UPDATE pn_leases_all
18914: SET status = p_new_approval_status_code -- Will hold the value of 'F'
18915: WHERE lease_id = p_lease_id
18916: AND org_id= g_org_id;
18917: