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_RECOVERY_TENANCY_UPG_PKG dependencies on PN_TENANCIES_ALL

Line 49: FROM pn_tenancies_all pt,

45: pt.expiration_date,
46: pt.lease_id,
47: pt.location_id,
48: pt.org_id
49: FROM pn_tenancies_all pt,
50: pn_leases pl
51: WHERE pt.lease_id = pl.lease_id
52: AND pl.lease_num <= NVL(p_lease_num_to, pl.lease_num)
53: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)

Line 60: TABLE OF PN_TENANCIES_ALL.TENANCY_ID%TYPE

56: FROM pn_space_assign_cust_all psc
57: WHERE psc.tenancy_id = pt.tenancy_id);
58:
59: TYPE t_tenancy_id IS
60: TABLE OF PN_TENANCIES_ALL.TENANCY_ID%TYPE
61: INDEX BY BINARY_INTEGER;
62:
63: TYPE t_cust_id IS
64: TABLE OF PN_TENANCIES_ALL.CUSTOMER_ID%TYPE

Line 64: TABLE OF PN_TENANCIES_ALL.CUSTOMER_ID%TYPE

60: TABLE OF PN_TENANCIES_ALL.TENANCY_ID%TYPE
61: INDEX BY BINARY_INTEGER;
62:
63: TYPE t_cust_id IS
64: TABLE OF PN_TENANCIES_ALL.CUSTOMER_ID%TYPE
65: INDEX BY BINARY_INTEGER;
66:
67: TYPE t_cust_site_use_id IS
68: TABLE OF PN_TENANCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE

Line 68: TABLE OF PN_TENANCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE

64: TABLE OF PN_TENANCIES_ALL.CUSTOMER_ID%TYPE
65: INDEX BY BINARY_INTEGER;
66:
67: TYPE t_cust_site_use_id IS
68: TABLE OF PN_TENANCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE
69: INDEX BY BINARY_INTEGER;
70:
71: TYPE t_fin_oblig_end_date IS
72: TABLE OF PN_TENANCIES_ALL.FIN_OBLIG_END_DATE%TYPE

Line 72: TABLE OF PN_TENANCIES_ALL.FIN_OBLIG_END_DATE%TYPE

68: TABLE OF PN_TENANCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE
69: INDEX BY BINARY_INTEGER;
70:
71: TYPE t_fin_oblig_end_date IS
72: TABLE OF PN_TENANCIES_ALL.FIN_OBLIG_END_DATE%TYPE
73: INDEX BY BINARY_INTEGER;
74:
75: TYPE t_allocated_area_pct IS
76: TABLE OF PN_TENANCIES_ALL.ALLOCATED_AREA_PCT%TYPE

Line 76: TABLE OF PN_TENANCIES_ALL.ALLOCATED_AREA_PCT%TYPE

72: TABLE OF PN_TENANCIES_ALL.FIN_OBLIG_END_DATE%TYPE
73: INDEX BY BINARY_INTEGER;
74:
75: TYPE t_allocated_area_pct IS
76: TABLE OF PN_TENANCIES_ALL.ALLOCATED_AREA_PCT%TYPE
77: INDEX BY BINARY_INTEGER;
78:
79: TYPE t_recovery_type_code IS
80: TABLE OF PN_TENANCIES_ALL.RECOVERY_TYPE_CODE%TYPE

Line 80: TABLE OF PN_TENANCIES_ALL.RECOVERY_TYPE_CODE%TYPE

76: TABLE OF PN_TENANCIES_ALL.ALLOCATED_AREA_PCT%TYPE
77: INDEX BY BINARY_INTEGER;
78:
79: TYPE t_recovery_type_code IS
80: TABLE OF PN_TENANCIES_ALL.RECOVERY_TYPE_CODE%TYPE
81: INDEX BY BINARY_INTEGER;
82:
83: TYPE t_recovery_space_std_code IS
84: TABLE OF PN_TENANCIES_ALL.RECOVERY_SPACE_STD_CODE%TYPE

Line 84: TABLE OF PN_TENANCIES_ALL.RECOVERY_SPACE_STD_CODE%TYPE

80: TABLE OF PN_TENANCIES_ALL.RECOVERY_TYPE_CODE%TYPE
81: INDEX BY BINARY_INTEGER;
82:
83: TYPE t_recovery_space_std_code IS
84: TABLE OF PN_TENANCIES_ALL.RECOVERY_SPACE_STD_CODE%TYPE
85: INDEX BY BINARY_INTEGER;
86:
87: TYPE t_estimated_occupancy_date IS
88: TABLE OF PN_TENANCIES_ALL.ESTIMATED_OCCUPANCY_DATE%TYPE

Line 88: TABLE OF PN_TENANCIES_ALL.ESTIMATED_OCCUPANCY_DATE%TYPE

84: TABLE OF PN_TENANCIES_ALL.RECOVERY_SPACE_STD_CODE%TYPE
85: INDEX BY BINARY_INTEGER;
86:
87: TYPE t_estimated_occupancy_date IS
88: TABLE OF PN_TENANCIES_ALL.ESTIMATED_OCCUPANCY_DATE%TYPE
89: INDEX BY BINARY_INTEGER;
90:
91: TYPE t_expiration_date IS
92: TABLE OF PN_TENANCIES_ALL.EXPIRATION_DATE%TYPE

Line 92: TABLE OF PN_TENANCIES_ALL.EXPIRATION_DATE%TYPE

88: TABLE OF PN_TENANCIES_ALL.ESTIMATED_OCCUPANCY_DATE%TYPE
89: INDEX BY BINARY_INTEGER;
90:
91: TYPE t_expiration_date IS
92: TABLE OF PN_TENANCIES_ALL.EXPIRATION_DATE%TYPE
93: INDEX BY BINARY_INTEGER;
94:
95: TYPE t_lease_id IS
96: TABLE OF PN_TENANCIES_ALL.LEASE_ID%TYPE

Line 96: TABLE OF PN_TENANCIES_ALL.LEASE_ID%TYPE

92: TABLE OF PN_TENANCIES_ALL.EXPIRATION_DATE%TYPE
93: INDEX BY BINARY_INTEGER;
94:
95: TYPE t_lease_id IS
96: TABLE OF PN_TENANCIES_ALL.LEASE_ID%TYPE
97: INDEX BY BINARY_INTEGER;
98:
99: TYPE t_location_id IS
100: TABLE OF PN_TENANCIES_ALL.LOCATION_ID%TYPE

Line 100: TABLE OF PN_TENANCIES_ALL.LOCATION_ID%TYPE

96: TABLE OF PN_TENANCIES_ALL.LEASE_ID%TYPE
97: INDEX BY BINARY_INTEGER;
98:
99: TYPE t_location_id IS
100: TABLE OF PN_TENANCIES_ALL.LOCATION_ID%TYPE
101: INDEX BY BINARY_INTEGER;
102:
103: TYPE t_org_id IS
104: TABLE OF PN_TENANCIES_ALL.ORG_ID%TYPE

Line 104: TABLE OF PN_TENANCIES_ALL.ORG_ID%TYPE

100: TABLE OF PN_TENANCIES_ALL.LOCATION_ID%TYPE
101: INDEX BY BINARY_INTEGER;
102:
103: TYPE t_org_id IS
104: TABLE OF PN_TENANCIES_ALL.ORG_ID%TYPE
105: INDEX BY BINARY_INTEGER;
106:
107: tenancy_id_tbl t_tenancy_id;
108: cust_id_tbl t_cust_id;

Line 131: l_cust_id pn_tenancies_all.customer_id%type;

127: l_count_fin_end_dt NUMBER := 0;
128: l_action VARCHAR2(2000):= NULL;
129: l_msg VARCHAR2(2000):= NULL;
130: l_context VARCHAR2(200) := NULL;
131: l_cust_id pn_tenancies_all.customer_id%type;
132: l_cust_site_id pn_tenancies_all.customer_site_use_id%type;
133: l_date pn_tenancies_all.fin_oblig_end_date%type;
134: l_customer_id pn_tenancies_all.customer_id%type;
135: l_customer_site_id pn_tenancies_all.customer_site_use_id%type;

Line 132: l_cust_site_id pn_tenancies_all.customer_site_use_id%type;

128: l_action VARCHAR2(2000):= NULL;
129: l_msg VARCHAR2(2000):= NULL;
130: l_context VARCHAR2(200) := NULL;
131: l_cust_id pn_tenancies_all.customer_id%type;
132: l_cust_site_id pn_tenancies_all.customer_site_use_id%type;
133: l_date pn_tenancies_all.fin_oblig_end_date%type;
134: l_customer_id pn_tenancies_all.customer_id%type;
135: l_customer_site_id pn_tenancies_all.customer_site_use_id%type;
136: l_rec_type_code pn_tenancies_all.recovery_type_code%type;

Line 133: l_date pn_tenancies_all.fin_oblig_end_date%type;

129: l_msg VARCHAR2(2000):= NULL;
130: l_context VARCHAR2(200) := NULL;
131: l_cust_id pn_tenancies_all.customer_id%type;
132: l_cust_site_id pn_tenancies_all.customer_site_use_id%type;
133: l_date pn_tenancies_all.fin_oblig_end_date%type;
134: l_customer_id pn_tenancies_all.customer_id%type;
135: l_customer_site_id pn_tenancies_all.customer_site_use_id%type;
136: l_rec_type_code pn_tenancies_all.recovery_type_code%type;
137: l_rec_space_std_code pn_tenancies_all.recovery_space_std_code%type;

Line 134: l_customer_id pn_tenancies_all.customer_id%type;

130: l_context VARCHAR2(200) := NULL;
131: l_cust_id pn_tenancies_all.customer_id%type;
132: l_cust_site_id pn_tenancies_all.customer_site_use_id%type;
133: l_date pn_tenancies_all.fin_oblig_end_date%type;
134: l_customer_id pn_tenancies_all.customer_id%type;
135: l_customer_site_id pn_tenancies_all.customer_site_use_id%type;
136: l_rec_type_code pn_tenancies_all.recovery_type_code%type;
137: l_rec_space_std_code pn_tenancies_all.recovery_space_std_code%type;
138: l_fin_oblig_end_date pn_tenancies_all.fin_oblig_end_date%type;

Line 135: l_customer_site_id pn_tenancies_all.customer_site_use_id%type;

131: l_cust_id pn_tenancies_all.customer_id%type;
132: l_cust_site_id pn_tenancies_all.customer_site_use_id%type;
133: l_date pn_tenancies_all.fin_oblig_end_date%type;
134: l_customer_id pn_tenancies_all.customer_id%type;
135: l_customer_site_id pn_tenancies_all.customer_site_use_id%type;
136: l_rec_type_code pn_tenancies_all.recovery_type_code%type;
137: l_rec_space_std_code pn_tenancies_all.recovery_space_std_code%type;
138: l_fin_oblig_end_date pn_tenancies_all.fin_oblig_end_date%type;
139:

Line 136: l_rec_type_code pn_tenancies_all.recovery_type_code%type;

132: l_cust_site_id pn_tenancies_all.customer_site_use_id%type;
133: l_date pn_tenancies_all.fin_oblig_end_date%type;
134: l_customer_id pn_tenancies_all.customer_id%type;
135: l_customer_site_id pn_tenancies_all.customer_site_use_id%type;
136: l_rec_type_code pn_tenancies_all.recovery_type_code%type;
137: l_rec_space_std_code pn_tenancies_all.recovery_space_std_code%type;
138: l_fin_oblig_end_date pn_tenancies_all.fin_oblig_end_date%type;
139:
140: BEGIN

Line 137: l_rec_space_std_code pn_tenancies_all.recovery_space_std_code%type;

133: l_date pn_tenancies_all.fin_oblig_end_date%type;
134: l_customer_id pn_tenancies_all.customer_id%type;
135: l_customer_site_id pn_tenancies_all.customer_site_use_id%type;
136: l_rec_type_code pn_tenancies_all.recovery_type_code%type;
137: l_rec_space_std_code pn_tenancies_all.recovery_space_std_code%type;
138: l_fin_oblig_end_date pn_tenancies_all.fin_oblig_end_date%type;
139:
140: BEGIN
141: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (+)' );

Line 138: l_fin_oblig_end_date pn_tenancies_all.fin_oblig_end_date%type;

134: l_customer_id pn_tenancies_all.customer_id%type;
135: l_customer_site_id pn_tenancies_all.customer_site_use_id%type;
136: l_rec_type_code pn_tenancies_all.recovery_type_code%type;
137: l_rec_space_std_code pn_tenancies_all.recovery_space_std_code%type;
138: l_fin_oblig_end_date pn_tenancies_all.fin_oblig_end_date%type;
139:
140: BEGIN
141: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (+)' );
142: pnp_debug_pkg.log('Parameters ' );

Line 210: l_context := 'Updating pn_tenancies_all table';

206: IF NVL(p_upd_fin_oblg_end_dt,'N')='Y' AND fin_oblig_end_date_tbl(i) IS NULL THEN
207: l_date := exp_date_tbl(i);
208: END IF;
209:
210: l_context := 'Updating pn_tenancies_all table';
211:
212: IF (recovery_type_code_tbl(i) IS NULL AND p_rec_type_code IS NOT NULL) OR
213: (recovery_space_std_code_tbl(i) IS NULL AND
214: p_rec_space_std_code IS NOT NULL) OR

Line 218: UPDATE pn_tenancies_all

214: p_rec_space_std_code IS NOT NULL) OR
215: (l_cust_id IS NOT NULL) OR
216: (l_date IS NOT NULL) THEN
217:
218: UPDATE pn_tenancies_all
219: SET customer_id = NVL(cust_id_tbl(i), l_cust_id),
220: customer_site_use_id = NVL(cust_site_use_id_tbl(i), l_cust_site_id),
221: recovery_type_code = NVL(recovery_type_code_tbl(i), p_rec_type_code),
222: recovery_space_std_code = NVL(recovery_space_std_code_tbl(i),