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

Line 1988: v_index_line_id pn_index_history_lines.index_line_id%TYPE;

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

Line 1989: v_index_figure pn_index_history_lines.index_figure%TYPE;

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

Line 2007: FROM pn_index_history_lines phl

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

Line 2021: FROM pn_index_history_lines phl

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

Line 2120: Current CPI = Lookup PN_INDEX_HISTORY_LINES using finder date

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

Line 2123: Current CPI = Lookup PN_INDEX_HISTORY_LINES using finder date

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

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

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

Line 2202: FROM pn_index_history_lines phl

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

Line 6923: FROM pn_index_history_lines pihl

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

Line 6946: v_new_index_figure pn_index_history_lines.index_figure%TYPE;

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

Line 6947: v_updated_index_date pn_index_history_lines.index_date%TYPE;

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

Line 7063: UPDATE pn_index_history_lines

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