1: PACKAGE VEA_LAYER_LICENSES_SV AUTHID CURRENT_USER as
2: /* $Header: VEAVALLS.pls 115.7 2003/04/28 17:49:51 heali ship $ */
3: --{
4: /*====================== vea_layer_licenses_sv =========================*/
5: /*========================================================================
1: PACKAGE VEA_LAYER_LICENSES_SV AUTHID CURRENT_USER as
2: /* $Header: VEAVALLS.pls 115.7 2003/04/28 17:49:51 heali ship $ */
3: --{
4: /*====================== vea_layer_licenses_sv =========================*/
5: /*========================================================================
6: PURPOSE:
7:
8: NOTES: To run the script:
19: --
20: FUNCTION
21: isLicensed
22: (
23: p_layer_provider_code IN vea_layer_licenses.layer_provider_code%TYPE,
24: p_tp_layer_id IN vea_layer_licenses.tp_layer_id%TYPE
25: )
26: RETURN BOOLEAN;
27: --
20: FUNCTION
21: isLicensed
22: (
23: p_layer_provider_code IN vea_layer_licenses.layer_provider_code%TYPE,
24: p_tp_layer_id IN vea_layer_licenses.tp_layer_id%TYPE
25: )
26: RETURN BOOLEAN;
27: --
28: --
28: --
29: PROCEDURE
30: delete_rows
31: (
32: p_layer_provider_code IN vea_layer_licenses.layer_provider_code%TYPE,
33: p_tp_layer_id IN vea_layer_licenses.tp_layer_id%TYPE
34: );
35: --
36: --
29: PROCEDURE
30: delete_rows
31: (
32: p_layer_provider_code IN vea_layer_licenses.layer_provider_code%TYPE,
33: p_tp_layer_id IN vea_layer_licenses.tp_layer_id%TYPE
34: );
35: --
36: --
37: PROCEDURE
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_layer_provider_code IN vea_layer_licenses.layer_provider_code%TYPE,
48: p_customer_name IN vea_layer_licenses.customer_name%TYPE,
49: p_description IN vea_layer_licenses.description%TYPE,
50: p_tp_layer_id IN vea_layer_licenses.tp_layer_id%TYPE
51: );
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_layer_provider_code IN vea_layer_licenses.layer_provider_code%TYPE,
48: p_customer_name IN vea_layer_licenses.customer_name%TYPE,
49: p_description IN vea_layer_licenses.description%TYPE,
50: p_tp_layer_id IN vea_layer_licenses.tp_layer_id%TYPE
51: );
52: --
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_layer_provider_code IN vea_layer_licenses.layer_provider_code%TYPE,
48: p_customer_name IN vea_layer_licenses.customer_name%TYPE,
49: p_description IN vea_layer_licenses.description%TYPE,
50: p_tp_layer_id IN vea_layer_licenses.tp_layer_id%TYPE
51: );
52: --
53: --
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_layer_provider_code IN vea_layer_licenses.layer_provider_code%TYPE,
48: p_customer_name IN vea_layer_licenses.customer_name%TYPE,
49: p_description IN vea_layer_licenses.description%TYPE,
50: p_tp_layer_id IN vea_layer_licenses.tp_layer_id%TYPE
51: );
52: --
53: --
54: --
53: --
54: --
55: --
56: --}
57: END VEA_LAYER_LICENSES_SV;