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_LEASE_MILESTONES_ALL

Line 8511: ,p_option_id IN PN_LEASE_MILESTONES_ALL.option_id%type

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
8515: ,p_tbl IN temp_tbl_type

Line 8512: ,p_insurance_req_id IN PN_LEASE_MILESTONES_ALL.insurance_requirement_id%type

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
8515: ,p_tbl IN temp_tbl_type
8516: ,p_commit IN VARCHAR2

Line 8513: ,p_payment_term_id IN PN_LEASE_MILESTONES_ALL.payment_term_id%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
8515: ,p_tbl IN temp_tbl_type
8516: ,p_commit IN VARCHAR2
8517: )

Line 8522: l_milestone_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;

8518: IS
8519: l_index BINARY_INTEGER;
8520: t_index BINARY_INTEGER;
8521: l_row_id VARCHAR2(100) ;
8522: l_milestone_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;
8523: BEGIN
8524: ----------------------dbms_output.put_line('Inside MILESTONE_INSERT_ROW');--Rupak
8525: pvt_debug(g_pkg_name||'-Inside MILESTONE_INSERT_ROW:',3);
8526: for l_index in p_milestone_tbl.FIRST..p_milestone_tbl.LAST LOOP

Line 8591: , p_option_id IN PN_LEASE_MILESTONES_ALL.option_id%type

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

Line 8592: , p_insurance_req_id IN PN_LEASE_MILESTONES_ALL.insurance_requirement_id%type

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
8595: , p_validate IN VARCHAR2
8596: , x_return_status OUT NOCOPY VARCHAR2

Line 8593: , p_payment_term_id IN PN_LEASE_MILESTONES_ALL.payment_term_id%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
8595: , p_validate IN VARCHAR2
8596: , x_return_status OUT NOCOPY VARCHAR2
8597: -- , x_msg_count OUT NUMBER

Line 8643: ,p_option_id IN PN_LEASE_MILESTONES_ALL.OPTION_ID%TYPE

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

Line 8644: ,p_insurance_req_id IN PN_LEASE_MILESTONES_ALL.INSURANCE_REQUIREMENT_ID%TYPE

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
8647: ,x_return_status IN OUT NOCOPY VARCHAR2
8648: ,p_commit IN VARCHAR2

Line 8645: ,p_payment_term_id IN PN_LEASE_MILESTONES_ALL.PAYMENT_TERM_ID%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
8647: ,x_return_status IN OUT NOCOPY VARCHAR2
8648: ,p_commit IN VARCHAR2
8649: )

Line 8655: l_user_id PN_LEASE_MILESTONES_ALL.USER_ID%TYPE;

8651: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8652: l_index BINARY_INTEGER;
8653: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
8654: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
8655: l_user_id PN_LEASE_MILESTONES_ALL.USER_ID%TYPE;
8656: l_milestone_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;
8657: l_cur_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;
8658: l_tbl_index BINARY_INTEGER;
8659: l_tbl_flag NUMBER ;

Line 8656: l_milestone_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;

8652: l_index BINARY_INTEGER;
8653: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
8654: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
8655: l_user_id PN_LEASE_MILESTONES_ALL.USER_ID%TYPE;
8656: l_milestone_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;
8657: l_cur_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;
8658: l_tbl_index BINARY_INTEGER;
8659: l_tbl_flag NUMBER ;
8660: l_tbl temp_tbl_type;

Line 8657: l_cur_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;

8653: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
8654: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
8655: l_user_id PN_LEASE_MILESTONES_ALL.USER_ID%TYPE;
8656: l_milestone_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;
8657: l_cur_id PN_LEASE_MILESTONES_ALL.LEASE_MILESTONE_ID%TYPE;
8658: l_tbl_index BINARY_INTEGER;
8659: l_tbl_flag NUMBER ;
8660: l_tbl temp_tbl_type;
8661: l_api_name VARCHAR2(30) := 'UPDATE_MILESTONE';

Line 8695: from pn_lease_milestones_all

8691: ATTRIBUTE15,
8692: MILESTONE_DATE,
8693: USER_ID,
8694: LEASE_ID
8695: from pn_lease_milestones_all
8696: where lease_milestone_id = p_milestone_id;
8697:
8698: lcu_milestone_rec c_milestone%ROWTYPE;
8699:

Line 8981: ,p_option_id IN PN_LEASE_MILESTONES_ALL.OPTION_ID%TYPE

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
8985: ,p_tbl IN temp_tbl_type

Line 8982: ,p_insurance_req_id IN PN_LEASE_MILESTONES_ALL.INSURANCE_REQUIREMENT_ID%TYPE

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
8985: ,p_tbl IN temp_tbl_type
8986: ,p_commit IN VARCHAR2

Line 8983: ,p_payment_term_id IN PN_LEASE_MILESTONES_ALL.PAYMENT_TERM_ID%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
8985: ,p_tbl IN temp_tbl_type
8986: ,p_commit IN VARCHAR2
8987: )

Line 9063: , p_option_id IN PN_LEASE_MILESTONES_ALL.option_id%type

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

Line 9064: , p_insurance_req_id IN PN_LEASE_MILESTONES_ALL.insurance_requirement_id%type

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
9067: , p_validate IN VARCHAR2
9068: , x_return_status OUT NOCOPY VARCHAR2

Line 9065: , p_payment_term_id IN PN_LEASE_MILESTONES_ALL.payment_term_id%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
9067: , p_validate IN VARCHAR2
9068: , x_return_status OUT NOCOPY VARCHAR2
9069: -- , x_msg_count OUT NUMBER