DBA Data[Home] [Help]

APPS.VEA_LAYERPROVIDERS_SV dependencies on VEA_LAYER_PROVIDERS

Line 21: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

17: --
18: PROCEDURE
19: delete_rows
20: (
21: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
22: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE DEFAULT NULL
23: );
24: --
25: --

Line 22: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE DEFAULT NULL

18: PROCEDURE
19: delete_rows
20: (
21: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
22: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE DEFAULT NULL
23: );
24: --
25: --
26: PROCEDURE

Line 29: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,

25: --
26: PROCEDURE
27: insert_row
28: (
29: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
30: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
31: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
32: p_description IN vea_layer_providers.description%TYPE
33: );

Line 30: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

26: PROCEDURE
27: insert_row
28: (
29: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
30: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
31: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
32: p_description IN vea_layer_providers.description%TYPE
33: );
34: --

Line 31: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,

27: insert_row
28: (
29: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
30: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
31: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
32: p_description IN vea_layer_providers.description%TYPE
33: );
34: --
35: --

Line 32: p_description IN vea_layer_providers.description%TYPE

28: (
29: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
30: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
31: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
32: p_description IN vea_layer_providers.description%TYPE
33: );
34: --
35: --
36: PROCEDURE

Line 39: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,

35: --
36: PROCEDURE
37: update_row
38: (
39: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
40: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
41: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
42: p_description IN vea_layer_providers.description%TYPE
43: );

Line 40: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

36: PROCEDURE
37: update_row
38: (
39: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
40: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
41: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
42: p_description IN vea_layer_providers.description%TYPE
43: );
44: --

Line 41: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,

37: update_row
38: (
39: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
40: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
41: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
42: p_description IN vea_layer_providers.description%TYPE
43: );
44: --
45: --

Line 42: p_description IN vea_layer_providers.description%TYPE

38: (
39: p_layer_provider_id IN vea_layer_providers.layer_provider_id%TYPE,
40: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
41: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
42: p_description IN vea_layer_providers.description%TYPE
43: );
44: --
45: --
46: PROCEDURE

Line 49: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

45: --
46: PROCEDURE
47: validate
48: (
49: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
50: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
51: );
52: --
53: --

Line 50: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE

46: PROCEDURE
47: validate
48: (
49: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
50: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
51: );
52: --
53: --
54: PROCEDURE

Line 57: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

53: --
54: PROCEDURE
55: validateUniqueCodes
56: (
57: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
58: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
59: );
60: --
61: --

Line 58: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE

54: PROCEDURE
55: validateUniqueCodes
56: (
57: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
58: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
59: );
60: --
61: --
62: FUNCTION

Line 65: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE

61: --
62: FUNCTION
63: getLayerProviderCode
64: (
65: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE
66: ) RETURN VARCHAR2;
67: --
68: --
69: FUNCTION

Line 72: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE

68: --
69: FUNCTION
70: getLayerProviderName
71: (
72: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE
73: ) RETURN VARCHAR2;
74: --
75: --
76: PROCEDURE

Line 86: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,

82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
87: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
88: p_description IN vea_layer_providers.description%TYPE
89: );
90: --

Line 87: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,

83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
87: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
88: p_description IN vea_layer_providers.description%TYPE
89: );
90: --
91: --

Line 88: p_description IN vea_layer_providers.description%TYPE

84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_layer_provider_code IN vea_layer_providers.layer_provider_code%TYPE,
87: p_layer_provider_name IN vea_layer_providers.layer_provider_name%TYPE,
88: p_description IN vea_layer_providers.description%TYPE
89: );
90: --
91: --
92: --