44: RETURN BOOLEAN;
45:
46: PROCEDURE validate_inv_vr
47: (
48: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
49: , p_called_from IN VARCHAR2 DEFAULT 'API'
50: , p_operation IN VARCHAR2
51: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
52: , x_return_status OUT NOCOPY VARCHAR2
47: (
48: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
49: , p_called_from IN VARCHAR2 DEFAULT 'API'
50: , p_operation IN VARCHAR2
51: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
52: , x_return_status OUT NOCOPY VARCHAR2
53: );
54:
55: PROCEDURE check_for_null_and_fks_in_ivr
53: );
54:
55: PROCEDURE check_for_null_and_fks_in_ivr
56: (
57: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
58: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
59: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
60: , x_return_status OUT NOCOPY VARCHAR2
61: );
55: PROCEDURE check_for_null_and_fks_in_ivr
56: (
57: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
58: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
59: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
60: , x_return_status OUT NOCOPY VARCHAR2
61: );
62:
63: FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,
59: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
60: , x_return_status OUT NOCOPY VARCHAR2
61: );
62:
63: FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,
64: p_spec GMD_SPECIFICATIONS%ROWTYPE)
65: RETURN BOOLEAN;
66:
67: