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_TP_LAYERS_SV dependencies on VEA_TP_LAYERS

Line 1: PACKAGE VEA_TP_LAYERS_SV AUTHID CURRENT_USER as

1: PACKAGE VEA_TP_LAYERS_SV AUTHID CURRENT_USER as
2: /* $Header: VEAVATLS.pls 115.4 2004/07/27 00:06:51 rvishnuv ship $ */
3: --{
4: /*====================== vea_tp_layers_sv =========================*/
5: /*========================================================================

Line 4: /====================== vea_tp_layers_sv =========================/

1: PACKAGE VEA_TP_LAYERS_SV AUTHID CURRENT_USER as
2: /* $Header: VEAVATLS.pls 115.4 2004/07/27 00:06:51 rvishnuv ship $ */
3: --{
4: /*====================== vea_tp_layers_sv =========================*/
5: /*========================================================================
6: PURPOSE:
7:
8: NOTES: To run the script:

Line 20: g_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;

16: --
17: --
18: --
19: --
20: g_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
21: --
22: --
23: PROCEDURE
24: delete_rows

Line 26: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

22: --
23: PROCEDURE
24: delete_rows
25: (
26: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
27: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
28: p_tp_layer_name IN vea_tp_layers.name%TYPE,
29: p_application_short_name IN vea_packages.application_short_name%TYPE
30: );

Line 27: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,

23: PROCEDURE
24: delete_rows
25: (
26: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
27: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
28: p_tp_layer_name IN vea_tp_layers.name%TYPE,
29: p_application_short_name IN vea_packages.application_short_name%TYPE
30: );
31: --

Line 28: p_tp_layer_name IN vea_tp_layers.name%TYPE,

24: delete_rows
25: (
26: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
27: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
28: p_tp_layer_name IN vea_tp_layers.name%TYPE,
29: p_application_short_name IN vea_packages.application_short_name%TYPE
30: );
31: --
32: --

Line 36: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE

32: --
33: PROCEDURE
34: deleteUnlicensedLayers
35: (
36: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE
37: );
38: --
39: --
40: FUNCTION

Line 43: p_tp_layer_name IN vea_tp_layers.name%TYPE

39: --
40: FUNCTION
41: get_tp_layer_id
42: (
43: p_tp_layer_name IN vea_tp_layers.name%TYPE
44: )
45: RETURN vea_tp_layers.tp_layer_id%TYPE;
46: --
47: --

Line 45: RETURN vea_tp_layers.tp_layer_id%TYPE;

41: get_tp_layer_id
42: (
43: p_tp_layer_name IN vea_tp_layers.name%TYPE
44: )
45: RETURN vea_tp_layers.tp_layer_id%TYPE;
46: --
47: --
48: /*========================================================================
49:

Line 58: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

54: ========================================================================*/
55: FUNCTION
56: getId
57: (
58: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
59: p_tp_layer_name IN vea_tp_layers.name%TYPE
60: )
61: RETURN vea_tp_layers.tp_layer_id%TYPE;
62: --

Line 59: p_tp_layer_name IN vea_tp_layers.name%TYPE

55: FUNCTION
56: getId
57: (
58: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
59: p_tp_layer_name IN vea_tp_layers.name%TYPE
60: )
61: RETURN vea_tp_layers.tp_layer_id%TYPE;
62: --
63: --

Line 61: RETURN vea_tp_layers.tp_layer_id%TYPE;

57: (
58: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
59: p_tp_layer_name IN vea_tp_layers.name%TYPE
60: )
61: RETURN vea_tp_layers.tp_layer_id%TYPE;
62: --
63: --
64: PROCEDURE
65: process

Line 74: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,

70: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,
75: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
76: p_name IN vea_tp_layers.name%TYPE,
77: p_description IN vea_tp_layers.description%TYPE,
78: p_active_flag IN vea_tp_layers.active_flag%TYPE,

Line 75: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,

71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,
75: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
76: p_name IN vea_tp_layers.name%TYPE,
77: p_description IN vea_tp_layers.description%TYPE,
78: p_active_flag IN vea_tp_layers.active_flag%TYPE,
79: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL

Line 76: p_name IN vea_tp_layers.name%TYPE,

72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,
75: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
76: p_name IN vea_tp_layers.name%TYPE,
77: p_description IN vea_tp_layers.description%TYPE,
78: p_active_flag IN vea_tp_layers.active_flag%TYPE,
79: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
80: );

Line 77: p_description IN vea_tp_layers.description%TYPE,

73: x_msg_data OUT NOCOPY VARCHAR2,
74: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,
75: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
76: p_name IN vea_tp_layers.name%TYPE,
77: p_description IN vea_tp_layers.description%TYPE,
78: p_active_flag IN vea_tp_layers.active_flag%TYPE,
79: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
80: );
81: --

Line 78: p_active_flag IN vea_tp_layers.active_flag%TYPE,

74: x_id OUT NOCOPY vea_tp_layers.tp_layer_id%TYPE,
75: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
76: p_name IN vea_tp_layers.name%TYPE,
77: p_description IN vea_tp_layers.description%TYPE,
78: p_active_flag IN vea_tp_layers.active_flag%TYPE,
79: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
80: );
81: --
82: --

Line 79: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL

75: p_layer_provider_code IN vea_tp_layers.layer_provider_code%TYPE,
76: p_name IN vea_tp_layers.name%TYPE,
77: p_description IN vea_tp_layers.description%TYPE,
78: p_active_flag IN vea_tp_layers.active_flag%TYPE,
79: p_id IN vea_tp_layers.tp_layer_id%TYPE := NULL
80: );
81: --
82: --
83: --

Line 86: END VEA_TP_LAYERS_SV;

82: --
83: --
84: --
85: --}
86: END VEA_TP_LAYERS_SV;