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_VARIABLE_TERM_PKG dependencies on PN_VAR_VOL_HIST_ALL

Line 1150: start_date pn_var_vol_hist_all.start_date%TYPE,

1146: p_invoice_date IN DATE
1147: ) RETURN VARCHAR2
1148: IS
1149: TYPE vol_hist_rec IS RECORD(
1150: start_date pn_var_vol_hist_all.start_date%TYPE,
1151: end_date pn_var_vol_hist_all.end_date%TYPE,
1152: line_item_id pn_var_lines_all.line_item_id%TYPE
1153: );
1154:

Line 1151: end_date pn_var_vol_hist_all.end_date%TYPE,

1147: ) RETURN VARCHAR2
1148: IS
1149: TYPE vol_hist_rec IS RECORD(
1150: start_date pn_var_vol_hist_all.start_date%TYPE,
1151: end_date pn_var_vol_hist_all.end_date%TYPE,
1152: line_item_id pn_var_lines_all.line_item_id%TYPE
1153: );
1154:
1155: TYPE vol_hist_type IS

Line 1172: FROM pn_var_vol_hist_all vol,

1168: --Get all volume history records for a inv_dt,period_id,line_item_id combination
1169: CURSOR vol_hist_dates(p_prd_id IN NUMBER, p_inv_dt IN DATE, p_line_id IN NUMBER)
1170: IS
1171: SELECT start_date, end_date, line_item_id
1172: FROM pn_var_vol_hist_all vol,
1173: (SELECT gd.period_id,
1174: gd.grp_date_id
1175: FROM pn_var_grp_dates_all gd
1176: WHERE gd.period_id= p_prd_id

Line 1191: FROM pn_var_vol_hist_all vol,

1187: --for firstyr
1188: CURSOR vol_hist_dates_fy(p_prd_id IN NUMBER, p_inv_dt IN DATE, p_line_id IN NUMBER,p_end_dt IN DATE)
1189: IS
1190: SELECT start_date, end_date, line_item_id
1191: FROM pn_var_vol_hist_all vol,
1192: (SELECT gd.period_id,
1193: gd.grp_date_id
1194: FROM pn_var_grp_dates_all gd
1195: WHERE gd.period_id= p_prd_id

Line 1211: FROM pn_var_vol_hist_all vol,

1207: --for lastyr
1208: CURSOR vol_hist_dates_ly(p_prd_id IN NUMBER, p_inv_dt IN DATE, p_line_id IN NUMBER,p_st_dt IN DATE)
1209: IS
1210: SELECT start_date, end_date, line_item_id
1211: FROM pn_var_vol_hist_all vol,
1212: (SELECT gd.period_id,
1213: gd.grp_date_id
1214: FROM pn_var_grp_dates_all gd
1215: WHERE gd.period_id= p_prd_id

Line 1642: start_date pn_var_vol_hist_all.start_date%TYPE,

1638: p_rent_type IN VARCHAR2
1639: ) RETURN VARCHAR2
1640: IS
1641: TYPE vol_hist_rec IS RECORD(
1642: start_date pn_var_vol_hist_all.start_date%TYPE,
1643: end_date pn_var_vol_hist_all.end_date%TYPE,
1644: line_item_id pn_var_lines_all.line_item_id%TYPE
1645: );
1646:

Line 1643: end_date pn_var_vol_hist_all.end_date%TYPE,

1639: ) RETURN VARCHAR2
1640: IS
1641: TYPE vol_hist_rec IS RECORD(
1642: start_date pn_var_vol_hist_all.start_date%TYPE,
1643: end_date pn_var_vol_hist_all.end_date%TYPE,
1644: line_item_id pn_var_lines_all.line_item_id%TYPE
1645: );
1646:
1647: TYPE vol_hist_type IS

Line 1665: FROM pn_var_vol_hist_all vol,

1661: --for forecasted terms
1662: CURSOR vol_hist_dates_for(p_prd_id IN NUMBER, p_inv_dt IN DATE, p_line_id IN NUMBER)
1663: IS
1664: SELECT start_date, end_date, line_item_id
1665: FROM pn_var_vol_hist_all vol,
1666: (SELECT gd.period_id,
1667: gd.grp_date_id
1668: FROM pn_var_grp_dates_all gd
1669: WHERE gd.period_id= p_prd_id

Line 1684: FROM pn_var_vol_hist_all vol,

1680: --for variance terms
1681: CURSOR vol_hist_dates_var(p_prd_id IN NUMBER, p_inv_dt IN DATE, p_line_id IN NUMBER)
1682: IS
1683: SELECT start_date, end_date, line_item_id
1684: FROM pn_var_vol_hist_all vol,
1685: (SELECT gd.period_id,
1686: gd.grp_date_id
1687: FROM pn_var_grp_dates_all gd
1688: WHERE gd.period_id= p_prd_id