APPS.PN_LEASE_PVT dependencies on PN_LEASE_CHANGES_ALL

Line 6539: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
6543: )

Line 6625: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
6629: , x_return_status OUT NOCOPY VARCHAR2

Line 6670: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE

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
6674: )

Line 7003: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
7007: )

Line 7081: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE

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
7085: , x_return_status OUT NOCOPY VARCHAR2

Line 7198: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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: )
7202: IS

Line 7535: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE

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
7539: )

Line 7671: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE

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: )
7675: IS

Line 8109: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
8113: )

Line 8203: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE

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
8207: , x_return_status OUT NOCOPY VARCHAR2

Line 8510: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
8514: ,x_return_status OUT NOCOPY VARCHAR2

Line 8590: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
8594: , p_commit IN VARCHAR2

Line 8642: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE

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
8646: ,x_tbl OUT NOCOPY temp_tbl_type

Line 8980: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE

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
8984: ,x_return_status OUT NOCOPY VARCHAR2

Line 9062: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
9066: , p_commit IN VARCHAR2

Line 9431: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
9435: , p_validate IN VARCHAR2

Line 9527: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
9531: , x_return_status OUT NOCOPY VARCHAR2

Line 9574: p_lease_change_id IN pn_lease_changes_all.lease_change_id%TYPE

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;
9578: l_index BINARY_INTEGER;

Line 9961: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
9965: ,p_validate IN VARCHAR2

Line 10054: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE

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
10058: , x_return_status OUT NOCOPY VARCHAR2

Line 10544: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
10548: , p_validate IN VARCHAR2

Line 10657: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
10661: , x_return_status OUT NOCOPY VARCHAR2

Line 10711: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE

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
10715: )

Line 11200: ,p_lease_change_id IN PN_LEASE_CHANGES_ALL.lease_change_id%type

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
11204: ,p_validate IN VARCHAR2

Line 11318: , p_lease_change_id IN PN_LEASE_CHANGES_ALL.LEASE_CHANGE_ID%TYPE

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
11322: , x_return_status OUT NOCOPY VARCHAR2

Line 11956: l_lease_change_num pn_lease_changes_all.lease_change_number%TYPE;

11952: -- Derived Values
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