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