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.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_LINES_DET_FACTORS

Line 1148: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,

1144: END ;
1145: END LOOP;
1146: END;
1147:
1148: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1152: p_location_type IN VARCHAR2,

Line 1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,

1145: END LOOP;
1146: END;
1147:
1148: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1152: p_location_type IN VARCHAR2,
1153: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,

Line 1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,

1146: END;
1147:
1148: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1152: p_location_type IN VARCHAR2,
1153: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
1154: p_geography_type IN VARCHAR2,

Line 1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,

1147:
1148: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1152: p_location_type IN VARCHAR2,
1153: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
1154: p_geography_type IN VARCHAR2,
1155: x_geography_value OUT NOCOPY VARCHAR2,

Line 1153: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,

1149: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1150: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1151: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1152: p_location_type IN VARCHAR2,
1153: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
1154: p_geography_type IN VARCHAR2,
1155: x_geography_value OUT NOCOPY VARCHAR2,
1156: x_geo_val_found OUT NOCOPY BOOLEAN) IS
1157:

Line 1733: FROM ZX_LINES_DET_FACTORS zx_det

1729: l_adj_gl_date_tbl(i),
1730: l_adj_trx_date_tbl(i),
1731: l_adj_trx_class_tbl(i),
1732: l_hq_estb_ptp_id_tbl(i)
1733: FROM ZX_LINES_DET_FACTORS zx_det
1734: WHERE zx_det.application_id = 222
1735: AND zx_det.trx_id = l_adj_trx_id_tbl(i)
1736: and zx_det.trx_line_id = Nvl(l_adj_trx_line_id_tbl(i),zx_det.trx_line_id)
1737: AND ROWNUM = 1;

Line 1742: 'Error in fetching data from ZX_LINES_DET_FACTORS for adjusted doc tax invoice date and gl date. Error Message : '

1738: EXCEPTION
1739: WHEN OTHERS THEN
1740: IF (g_level_statement>= g_current_runtime_level ) THEN
1741: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1742: 'Error in fetching data from ZX_LINES_DET_FACTORS for adjusted doc tax invoice date and gl date. Error Message : '
1743: ||substrb(SQLERRM,1,120) );
1744: END IF;
1745: END;
1746: