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: --
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
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: );
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: --
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: --
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
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: );
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: --
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: --
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
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: --
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
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: --
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
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
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
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: --
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: --
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: --