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_LAYERS_SV dependencies on VEA_LAYERS_S

Line 1: PACKAGE BODY VEA_LAYERS_SV as

1: PACKAGE BODY VEA_LAYERS_SV as
2: /* $Header: VEAVALAB.pls 115.15 2004/07/27 00:09:55 rvishnuv ship $ */
3: --{
4: /*====================== vea_layers_sv =========================*/
5: /*========================================================================

Line 4: /====================== vea_layers_sv =========================/

1: PACKAGE BODY VEA_LAYERS_SV as
2: /* $Header: VEAVALAB.pls 115.15 2004/07/27 00:09:55 rvishnuv ship $ */
3: --{
4: /*====================== vea_layers_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_LAYERS
7:
8: NOTES: To run the script:

Line 33: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_LAYERS_SV';

29: processConflictingLayers
30:
31: =========================================================================*/
32:
33: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_LAYERS_SV';
34: --
35: --
36: /*========================================================================
37:

Line 145: p_sequence_number IN vea_layers.sequence_number%TYPE,

141: saveBranchToGlobal(
142: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
143: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
144: p_layer_id IN vea_layers.layer_id%TYPE,
145: p_sequence_number IN vea_layers.sequence_number%TYPE,
146: p_tps_parameter1_name IN vea_parameters.name%TYPE,
147: p_tps_parameter1_int_value IN ece_xref_data.xref_int_value%TYPE,
148: p_tps_parameter2_name IN vea_parameters.name%TYPE,
149: p_tps_parameter2_int_value IN ece_xref_data.xref_int_value%TYPE,

Line 307: p_sequence_number IN vea_layers.sequence_number%TYPE,

303: saveBranchCriteria (
304: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
305: p_layer_id IN vea_layers.layer_id%TYPE,
306: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
307: p_sequence_number IN vea_layers.sequence_number%TYPE,
308: p_active_flag IN vea_layers.active_flag%TYPE,
309: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
310: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
311: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE,

Line 1598: p_sequence_number IN vea_layers.sequence_number%TYPE

1594: (
1595: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1596: p_layer_id IN vea_layers.layer_id%TYPE,
1597: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1598: p_sequence_number IN vea_layers.sequence_number%TYPE
1599: )
1600: IS
1601: --{
1602: l_api_name CONSTANT VARCHAR2(30) := 'validateUniqueBranchSequence';

Line 1700: p_sequence_number IN vea_layers.sequence_number%TYPE,

1696: p_layer_id IN vea_layers.layer_id%TYPE,
1697: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1698: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1699: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1700: p_sequence_number IN vea_layers.sequence_number%TYPE,
1701: p_description IN vea_layers.description%TYPE,
1702: p_active_flag IN vea_layers.active_flag%TYPE,
1703: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1704: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

Line 1790: p_sequence_number IN vea_layers.sequence_number%TYPE,

1786: p_layer_id IN vea_layers.layer_id%TYPE,
1787: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1788: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1789: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1790: p_sequence_number IN vea_layers.sequence_number%TYPE,
1791: p_description IN vea_layers.description%TYPE,
1792: p_active_flag IN vea_layers.active_flag%TYPE,
1793: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1794: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

Line 1903: p_sequence_number IN vea_layers.sequence_number%TYPE,

1899: p_layer_id IN vea_layers.layer_id%TYPE,
1900: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
1901: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
1902: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
1903: p_sequence_number IN vea_layers.sequence_number%TYPE,
1904: p_description IN vea_layers.description%TYPE,
1905: p_active_flag IN vea_layers.active_flag%TYPE,
1906: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
1907: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,

Line 2266: l_index := vea_layers_sv.g_layer_active_tbl.FIRST;

2262: LOOP
2263: --{
2264: l_location := '0020';
2265: --
2266: l_index := vea_layers_sv.g_layer_active_tbl.FIRST;
2267: --
2268: --
2269: l_location := '0030';
2270: --

Line 2276: l_layer_active_rec := vea_layers_sv.g_layer_active_tbl(l_index);

2272: LOOP
2273: --{
2274: l_location := '0040';
2275: --
2276: l_layer_active_rec := vea_layers_sv.g_layer_active_tbl(l_index);
2277: --
2278: --
2279: l_location := '0050';
2280: --

Line 2299: l_index := vea_layers_sv.g_layer_active_tbl.NEXT(l_index);

2295: --
2296: --
2297: l_location := '0060';
2298: --
2299: l_index := vea_layers_sv.g_layer_active_tbl.NEXT(l_index);
2300: --}
2301: END LOOP;
2302: --}
2303: END LOOP;

Line 2525: p_sequence_number IN vea_layers.sequence_number%TYPE,

2521: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2522: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2523: p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
2524: p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
2525: p_sequence_number IN vea_layers.sequence_number%TYPE,
2526: p_description IN vea_layers.description%TYPE,
2527: p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
2528: p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
2529: p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE ,

Line 3098: SELECT NVL( p_id, vea_layers_s.NEXTVAL )

3094: --
3095: --
3096: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
3097: THEN
3098: SELECT NVL( p_id, vea_layers_s.NEXTVAL )
3099: INTO l_layer_id
3100: FROM DUAL;
3101: ELSE
3102: SELECT vea_layers_s.NEXTVAL

Line 3102: SELECT vea_layers_s.NEXTVAL

3098: SELECT NVL( p_id, vea_layers_s.NEXTVAL )
3099: INTO l_layer_id
3100: FROM DUAL;
3101: ELSE
3102: SELECT vea_layers_s.NEXTVAL
3103: INTO l_layer_id
3104: FROM DUAL;
3105: END IF;
3106: --

Line 3327: END VEA_LAYERS_SV;

3323: --}
3324: --}
3325: END process;
3326: --}
3327: END VEA_LAYERS_SV;