PACKAGE: APPS.PNRX_RENT_INCREASE_DETAIL

Source

1 PACKAGE pnrx_rent_increase_detail AUTHID CURRENT_USER AS
2 /* $Header: PNRXRDRS.pls 120.1 2008/05/28 08:11:15 kkorada noship $ */
3 FUNCTION get_location_code (p_location_id IN NUMBER)
4 RETURN VARCHAR2;
5 
6 
7 PROCEDURE RENT_INCREASE_DETAIL(
8 		p_lease_number_low    IN             VARCHAR2 Default Null,
9 		p_lease_number_high   IN             VARCHAR2 Default Null,
10 		p_ri_number_low       IN             VARCHAR2 Default Null,
11 		p_ri_number_high      IN             VARCHAR2 Default Null,
12 	        p_assess_date_from    IN             DATE,
13 		p_assess_date_to      IN             DATE,
14 		p_lease_class	      IN             VARCHAR2 Default Null,
15 		p_property_id	      IN             NUMBER Default Null,
16 		p_building_id	      IN             NUMBER Default Null,
17 		p_location_id	      IN             NUMBER Default Null,
18 		p_include_draft       IN             VARCHAR2 Default NULL,
19                 p_rent_type           IN             VARCHAR2 Default NULL,
20 		l_request_id          IN             NUMBER,
21 		l_user_id             IN             NUMBER,
22 		retcode               OUT NOCOPY     VARCHAR2,
23 		errbuf                OUT NOCOPY     VARCHAR2
24                    );
25 
26 
27 
28 FUNCTION get_vendor_site (p_vendor_site_id IN NUMBER)
29 RETURN VARCHAR2;
30 
31 
32 FUNCTION get_customer_bill_site (p_site_use_id IN NUMBER)
33 RETURN VARCHAR2;
34 FUNCTION get_customer_ship_site (p_site_use_id IN NUMBER)
35 RETURN VARCHAR2;
36 FUNCTION get_index_name (p_index_id IN NUMBER)
37 RETURN VARCHAR2;
38 FUNCTION get_project_number (p_project_id IN NUMBER)
39 RETURN VARCHAR2;
40 FUNCTION get_task_number (p_task_id IN NUMBER)
41 RETURN VARCHAR2;
42 FUNCTION get_lookup_meaning (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2)
43 RETURN VARCHAR2;
44 
45 
46 TYPE vendor_rec IS RECORD (
47           vendor_name	            	PO_VENDORS.vendor_name%TYPE,
48           vendor_number             PO_VENDORS.segment1%TYPE
49           );
50 
51 TYPE customer_rec IS RECORD (
52           customer_name	            	HZ_PARTIES.party_name%TYPE,
53           customer_number             HZ_CUST_ACCOUNTS.account_number%TYPE
54           );
55 
56 FUNCTION get_vendor (p_vendor_id IN NUMBER)
57 RETURN vendor_rec;
58 
59 FUNCTION get_customer(p_customer_id IN NUMBER)
60 RETURN customer_rec;
61 
62 TYPE lease_detail IS RECORD (
63   	 		ABSTRACTED_BY_USER 	       	        NUMBER,
64   			LEASE_CLASS_CODE   			VARCHAR2(30),
65   			PAYMENT_PURPOSE_CODE            	VARCHAR2(30),
66   			PAYMENT_TERM_TYPE_CODE    		VARCHAR2(30),
67   			FREQUENCY_CODE             		VARCHAR2(30),
68   			VENDOR_ID                  	   	NUMBER,
69   			VENDOR_SITE_ID            	   	NUMBER,
70   			CUSTOMER_ID               	   	NUMBER,
71   			CUSTOMER_SITE_USE_ID           	        NUMBER,
72   			LOCATION_ID               	   	NUMBER,
73   			CUST_SHIP_SITE_ID          	   	NUMBER,
74   			AP_AR_TERM_ID           	   	NUMBER,
75   			CUST_TRX_TYPE_ID      		   	NUMBER,
76   			PROJECT_ID              	   	NUMBER,
77   			TASK_ID                          	NUMBER,
78   			ORGANIZATION_ID           	   	NUMBER,
79   			INV_RULE_ID           		   	NUMBER,
80   			ACCOUNT_RULE_ID           	   	NUMBER,
81   			SALESREP_ID           		   	NUMBER,
82   			INDEX_ID           			NUMBER,
83   			NEGATIVE_RENT_TYPE     	   	   	VARCHAR2(30),
84   			INCREASE_ON            		   	VARCHAR2(30),
85 			BASIS_TYPE                              VARCHAR2(30),
86   			RELATIONSHIP              	   	VARCHAR2(30),
87   			APPROVED_BY				NUMBER,
88   			PO_HEADER_ID				NUMBER,
89   			RECEIPT_METHOD_ID			NUMBER,
90   			TAX_CODE_ID			        NUMBER,
91   			TAX_GROUP_ID				NUMBER,
92   			SPREAD_FREQUENCY			VARCHAR2(30),
93 			INDEX_FINDER_METHOD                     VARCHAR2(30),
94   			REFERENCE_PERIOD			VARCHAR2(30),
95 			PRORATION_RULE                          VARCHAR2(80),
96   			INDEX_LEASE_ID				NUMBER,
97   			account_id			        NUMBER,
98   			account_class				VARCHAR2(30)
99 	 	);
100 
101 END;