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.

[Home] [Help]

APPS.PN_VARIABLE_TERM_PKG dependencies on PN_VAR_VOL_HIST_ALL

Line 1146: start_date pn_var_vol_hist_all.start_date%TYPE,

1142: p_invoice_date IN DATE
1143: ) RETURN VARCHAR2
1144: IS
1145: TYPE vol_hist_rec IS RECORD(
1146: start_date pn_var_vol_hist_all.start_date%TYPE,
1147: end_date pn_var_vol_hist_all.end_date%TYPE,
1148: line_item_id pn_var_lines_all.line_item_id%TYPE
1149: );
1150:

Line 1147: end_date pn_var_vol_hist_all.end_date%TYPE,

1143: ) RETURN VARCHAR2
1144: IS
1145: TYPE vol_hist_rec IS RECORD(
1146: start_date pn_var_vol_hist_all.start_date%TYPE,
1147: end_date pn_var_vol_hist_all.end_date%TYPE,
1148: line_item_id pn_var_lines_all.line_item_id%TYPE
1149: );
1150:
1151: TYPE vol_hist_type IS

Line 1168: FROM pn_var_vol_hist_all vol,

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

Line 1187: FROM pn_var_vol_hist_all vol,

1183: --for firstyr
1184: 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)
1185: IS
1186: SELECT start_date, end_date, line_item_id
1187: FROM pn_var_vol_hist_all vol,
1188: (SELECT gd.period_id,
1189: gd.grp_date_id
1190: FROM pn_var_grp_dates_all gd
1191: WHERE gd.period_id= p_prd_id

Line 1207: FROM pn_var_vol_hist_all vol,

1203: --for lastyr
1204: 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)
1205: IS
1206: SELECT start_date, end_date, line_item_id
1207: FROM pn_var_vol_hist_all vol,
1208: (SELECT gd.period_id,
1209: gd.grp_date_id
1210: FROM pn_var_grp_dates_all gd
1211: WHERE gd.period_id= p_prd_id

Line 1638: start_date pn_var_vol_hist_all.start_date%TYPE,

1634: p_rent_type IN VARCHAR2
1635: ) RETURN VARCHAR2
1636: IS
1637: TYPE vol_hist_rec IS RECORD(
1638: start_date pn_var_vol_hist_all.start_date%TYPE,
1639: end_date pn_var_vol_hist_all.end_date%TYPE,
1640: line_item_id pn_var_lines_all.line_item_id%TYPE
1641: );
1642:

Line 1639: end_date pn_var_vol_hist_all.end_date%TYPE,

1635: ) RETURN VARCHAR2
1636: IS
1637: TYPE vol_hist_rec IS RECORD(
1638: start_date pn_var_vol_hist_all.start_date%TYPE,
1639: end_date pn_var_vol_hist_all.end_date%TYPE,
1640: line_item_id pn_var_lines_all.line_item_id%TYPE
1641: );
1642:
1643: TYPE vol_hist_type IS

Line 1661: FROM pn_var_vol_hist_all vol,

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

Line 1680: FROM pn_var_vol_hist_all vol,

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