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_INDEX_AMOUNT_PKG dependencies on PN_INDEX_HISTORY_LINES

Line 1987: v_index_line_id pn_index_history_lines.index_line_id%TYPE;

1983: ,op_cpi_value OUT NOCOPY NUMBER
1984: ,op_cpi_id OUT NOCOPY NUMBER
1985: ,op_msg OUT NOCOPY VARCHAR2
1986: ) IS
1987: v_index_line_id pn_index_history_lines.index_line_id%TYPE;
1988: v_index_figure pn_index_history_lines.index_figure%TYPE;
1989: v_msg VARCHAR2 (1000);
1990: v_found_index BOOLEAN;
1991: BEGIN

Line 1988: v_index_figure pn_index_history_lines.index_figure%TYPE;

1984: ,op_cpi_id OUT NOCOPY NUMBER
1985: ,op_msg OUT NOCOPY VARCHAR2
1986: ) IS
1987: v_index_line_id pn_index_history_lines.index_line_id%TYPE;
1988: v_index_figure pn_index_history_lines.index_figure%TYPE;
1989: v_msg VARCHAR2 (1000);
1990: v_found_index BOOLEAN;
1991: BEGIN
1992: --put_log ('..In lookup_index_history');

Line 2006: FROM pn_index_history_lines phl

2002: SELECT phl.index_line_id
2003: ,phl.index_figure
2004: INTO v_index_line_id
2005: ,v_index_figure
2006: FROM pn_index_history_lines phl
2007: WHERE phl.index_id = p_index_history_id
2008: AND phl.index_date = p_index_finder_date;
2009: v_found_index := TRUE;
2010: EXCEPTION

Line 2020: FROM pn_index_history_lines phl

2016: SELECT phl.index_line_id
2017: ,phl.index_figure
2018: INTO v_index_line_id
2019: ,v_index_figure
2020: FROM pn_index_history_lines phl
2021: WHERE phl.index_id = p_index_history_id
2022: AND TO_NUMBER (TO_CHAR (phl.index_date, 'MMYYYY')) =
2023: TO_NUMBER (TO_CHAR (p_index_finder_date, 'MMYYYY'));
2024: END IF; --NOT V_FOUND_INDEX

Line 2119: Current CPI = Lookup PN_INDEX_HISTORY_LINES using finder date

2115:
2116: Note: Finder date lookup only match the year and month and not the day.
2117:
2118: IF INDEX_FINDER = Always Finder Date (Code: ??) or THEN
2119: Current CPI = Lookup PN_INDEX_HISTORY_LINES using finder date
2120:
2121: ELSE INDEX_FINDER = Backbill (Code: ??)
2122: Current CPI = Lookup PN_INDEX_HISTORY_LINES using finder date
2123:

Line 2122: Current CPI = Lookup PN_INDEX_HISTORY_LINES using finder date

2118: IF INDEX_FINDER = Always Finder Date (Code: ??) or THEN
2119: Current CPI = Lookup PN_INDEX_HISTORY_LINES using finder date
2120:
2121: ELSE INDEX_FINDER = Backbill (Code: ??)
2122: Current CPI = Lookup PN_INDEX_HISTORY_LINES using finder date
2123:
2124: ELSE INDEX_FINDER = Most Recent(Code: ??)
2125:
2126: Current CPI = Lookup PN_INDEX_HISTORY_LINES using the most recent reported

Line 2126: Current CPI = Lookup PN_INDEX_HISTORY_LINES using the most recent reported

2122: Current CPI = Lookup PN_INDEX_HISTORY_LINES using finder date
2123:
2124: ELSE INDEX_FINDER = Most Recent(Code: ??)
2125:
2126: Current CPI = Lookup PN_INDEX_HISTORY_LINES using the most recent reported
2127:
2128: index from up to a year from the finder date.
2129:
2130: Derive Previous CPI:

Line 2201: FROM pn_index_history_lines phl

2197: -- second, derive the finder date to be used.
2198: --
2199: SELECT MAX (phl.index_date)
2200: INTO v_current_finder_date
2201: FROM pn_index_history_lines phl
2202: WHERE phl.index_id = p_index_history_id
2203: AND TO_NUMBER (TO_CHAR (phl.index_date, 'YYYYMM'))
2204: BETWEEN v_lower_index_date_code
2205: AND v_upper_index_date_code

Line 6921: FROM pn_index_history_lines pihl

6917: ) IS
6918: SELECT pihl.index_line_id
6919: ,pihl.index_figure
6920: ,pihl.index_date
6921: FROM pn_index_history_lines pihl
6922: WHERE pihl.updated_flag = 'Y'
6923: AND pihl.index_id = p_index_history_id;
6924:
6925: CURSOR index_periods (

Line 6944: v_new_index_figure pn_index_history_lines.index_figure%TYPE;

6940: v_msg VARCHAR2 (1000);
6941: v_current_cpi_value NUMBER;
6942: v_previous_cpi_value NUMBER;
6943: v_index_percent_change NUMBER := null; -- #Bug2102073
6944: v_new_index_figure pn_index_history_lines.index_figure%TYPE;
6945: v_updated_index_date pn_index_history_lines.index_date%TYPE;
6946:
6947: BEGIN
6948: put_log ( 'ip_index_history_line_id '

Line 6945: v_updated_index_date pn_index_history_lines.index_date%TYPE;

6941: v_current_cpi_value NUMBER;
6942: v_previous_cpi_value NUMBER;
6943: v_index_percent_change NUMBER := null; -- #Bug2102073
6944: v_new_index_figure pn_index_history_lines.index_figure%TYPE;
6945: v_updated_index_date pn_index_history_lines.index_date%TYPE;
6946:
6947: BEGIN
6948: put_log ( 'ip_index_history_line_id '
6949: || ip_index_history_id);

Line 7061: UPDATE pn_index_history_lines

7057: -- null out NOCOPY the update flag of history line
7058: -- this column is always updated by the index history
7059: -- form every time a record is updated.
7060: --
7061: UPDATE pn_index_history_lines
7062: SET updated_flag = NULL
7063: WHERE index_line_id = ihl_rec.index_line_id;
7064:
7065: END LOOP index_history_lines;