67:
68:
69: PROCEDURE validate_wip_vr
70: (
71: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
72: , p_called_from IN VARCHAR2 DEFAULT 'API'
73: , p_operation IN VARCHAR2
74: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
75: , x_return_status OUT NOCOPY VARCHAR2
70: (
71: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
72: , p_called_from IN VARCHAR2 DEFAULT 'API'
73: , p_operation IN VARCHAR2
74: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
75: , x_return_status OUT NOCOPY VARCHAR2
76: );
77:
78: PROCEDURE check_for_null_and_fks_in_wvr
76: );
77:
78: PROCEDURE check_for_null_and_fks_in_wvr
79: (
80: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
81: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
82: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
83: , x_return_status OUT NOCOPY VARCHAR2
84: );
78: PROCEDURE check_for_null_and_fks_in_wvr
79: (
80: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
81: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
82: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
83: , x_return_status OUT NOCOPY VARCHAR2
84: );
85:
86: FUNCTION wip_vr_exist(p_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE,
82: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
83: , x_return_status OUT NOCOPY VARCHAR2
84: );
85:
86: FUNCTION wip_vr_exist(p_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE,
87: p_spec GMD_SPECIFICATIONS%ROWTYPE)
88: RETURN BOOLEAN;
89:
90: