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.VEA_TPA_UTIL_PVT dependencies on ECE_XREF_CATEGORIES

Line 2219: ECE_XREF_CATEGORIES.

2215:
2216: PROCEDURE NAME: insert_ece_xref_category
2217:
2218: PURPOSE: Inserts a code conversion category into EDI table
2219: ECE_XREF_CATEGORIES.
2220:
2221: ========================================================================*/
2222: PROCEDURE insert_ece_xref_category
2223: (

Line 2224: p_category_id IN ece_xref_categories.xref_category_id%TYPE,

2220:
2221: ========================================================================*/
2222: PROCEDURE insert_ece_xref_category
2223: (
2224: p_category_id IN ece_xref_categories.xref_category_id%TYPE,
2225: p_category_code IN ece_xref_categories.xref_category_code%TYPE,
2226: p_description IN ece_xref_categories.description%TYPE
2227: )
2228: IS

Line 2225: p_category_code IN ece_xref_categories.xref_category_code%TYPE,

2221: ========================================================================*/
2222: PROCEDURE insert_ece_xref_category
2223: (
2224: p_category_id IN ece_xref_categories.xref_category_id%TYPE,
2225: p_category_code IN ece_xref_categories.xref_category_code%TYPE,
2226: p_description IN ece_xref_categories.description%TYPE
2227: )
2228: IS
2229: --{

Line 2226: p_description IN ece_xref_categories.description%TYPE

2222: PROCEDURE insert_ece_xref_category
2223: (
2224: p_category_id IN ece_xref_categories.xref_category_id%TYPE,
2225: p_category_code IN ece_xref_categories.xref_category_code%TYPE,
2226: p_description IN ece_xref_categories.description%TYPE
2227: )
2228: IS
2229: --{
2230: l_api_name CONSTANT VARCHAR2(30) := 'insert_ece_xref_category';

Line 2239: INSERT INTO ece_xref_categories

2235: BEGIN
2236: --{
2237: l_location := '0010';
2238: --
2239: INSERT INTO ece_xref_categories
2240: (
2241: xref_category_id,
2242: xref_category_code,
2243: description,

Line 2293: ECE_XREF_CATEGORIES, if not existing already.

2289:
2290: PROCEDURE NAME: process_ece_xref_category
2291:
2292: PURPOSE: Inserts a code conversion category into EDI table
2293: ECE_XREF_CATEGORIES, if not existing already.
2294:
2295: ========================================================================*/
2296: FUNCTION process_ece_xref_category
2297: (

Line 2298: p_category_code IN ece_xref_categories.xref_category_code%TYPE,

2294:
2295: ========================================================================*/
2296: FUNCTION process_ece_xref_category
2297: (
2298: p_category_code IN ece_xref_categories.xref_category_code%TYPE,
2299: p_description IN ece_xref_categories.description%TYPE DEFAULT NULL
2300: )
2301: RETURN ece_xref_categories.xref_category_id%TYPE
2302: IS

Line 2299: p_description IN ece_xref_categories.description%TYPE DEFAULT NULL

2295: ========================================================================*/
2296: FUNCTION process_ece_xref_category
2297: (
2298: p_category_code IN ece_xref_categories.xref_category_code%TYPE,
2299: p_description IN ece_xref_categories.description%TYPE DEFAULT NULL
2300: )
2301: RETURN ece_xref_categories.xref_category_id%TYPE
2302: IS
2303: --{

Line 2301: RETURN ece_xref_categories.xref_category_id%TYPE

2297: (
2298: p_category_code IN ece_xref_categories.xref_category_code%TYPE,
2299: p_description IN ece_xref_categories.description%TYPE DEFAULT NULL
2300: )
2301: RETURN ece_xref_categories.xref_category_id%TYPE
2302: IS
2303: --{
2304: l_api_name CONSTANT VARCHAR2(30) := 'process_ece_xref_category';
2305: l_location VARCHAR2(32767);

Line 2308: l_xref_category_id ece_xref_categories.xref_category_id%TYPE;

2304: l_api_name CONSTANT VARCHAR2(30) := 'process_ece_xref_category';
2305: l_location VARCHAR2(32767);
2306: --
2307: --
2308: l_xref_category_id ece_xref_categories.xref_category_id%TYPE;
2309: --
2310: --
2311: CURSOR xref_category_cur
2312: (

Line 2313: p_category_code IN ece_xref_categories.xref_category_code%TYPE

2309: --
2310: --
2311: CURSOR xref_category_cur
2312: (
2313: p_category_code IN ece_xref_categories.xref_category_code%TYPE
2314: )
2315: IS
2316: SELECT xref_category_id
2317: FROM ece_xref_categories

Line 2317: FROM ece_xref_categories

2313: p_category_code IN ece_xref_categories.xref_category_code%TYPE
2314: )
2315: IS
2316: SELECT xref_category_id
2317: FROM ece_xref_categories
2318: WHERE xref_category_code = p_category_code;
2319: --}
2320: BEGIN
2321: --{

Line 2349: SELECT ECE_XREF_CATEGORIES_S1.nextval

2345: THEN
2346: --{
2347: l_location := '0050';
2348: --
2349: SELECT ECE_XREF_CATEGORIES_S1.nextval
2350: INTO l_xref_category_id
2351: FROM DUAL;
2352: --
2353: --

Line 2765: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;

2761: l_api_name CONSTANT VARCHAR2(30) := 'process_code_conversion';
2762: l_location VARCHAR2(32767);
2763: --
2764: --
2765: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
2766: l_xref_category_id ece_xref_categories.xref_category_id%TYPE;
2767: --}
2768: BEGIN
2769: --{

Line 2766: l_xref_category_id ece_xref_categories.xref_category_id%TYPE;

2762: l_location VARCHAR2(32767);
2763: --
2764: --
2765: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
2766: l_xref_category_id ece_xref_categories.xref_category_id%TYPE;
2767: --}
2768: BEGIN
2769: --{
2770: l_location := '0010';

Line 2857: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;

2853: l_index NUMBER;
2854: --
2855: --
2856: l_parameter_name vea_parameters.name%TYPE;
2857: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
2858: l_code_conversion_rec vea_tpa_util_pvt.g_code_conversion_rec_type;
2859: l_internal_value ece_xref_data.xref_int_value%TYPE;
2860: --
2861: --

Line 3014: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;

3010: RETURN ece_xref_data.xref_int_value%TYPE
3011: IS
3012: --{
3013: l_parameter_name vea_parameters.name%TYPE;
3014: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
3015: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3016: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3017: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3018: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;

Line 3141: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;

3137: RETURN ece_xref_data.xref_ext_value1%TYPE
3138: IS
3139: --{
3140: l_parameter_name vea_parameters.name%TYPE;
3141: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
3142: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3143: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3144: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3145: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;