35:
36: PROCEDURE check_for_null_and_fks_in_mvr
37: (
38: p_mon_vr IN GMD_MONITORING_SPEC_VRS%ROWTYPE
39: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
40: , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE
41: , x_return_status OUT NOCOPY VARCHAR2
42: );
43:
41: , x_return_status OUT NOCOPY VARCHAR2
42: );
43:
44: FUNCTION mon_vr_exist(p_mon_vr GMD_MONITORING_SPEC_VRS%ROWTYPE,
45: p_spec GMD_SPECIFICATIONS%ROWTYPE)
46: RETURN BOOLEAN;
47:
48: PROCEDURE validate_inv_vr
49: (
56:
57: PROCEDURE check_for_null_and_fks_in_ivr
58: (
59: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
60: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
61: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
62: , x_return_status OUT NOCOPY VARCHAR2
63: );
64:
62: , x_return_status OUT NOCOPY VARCHAR2
63: );
64:
65: FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,
66: p_spec GMD_SPECIFICATIONS%ROWTYPE)
67: RETURN BOOLEAN;
68:
69:
70:
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: );
87:
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:
93:
101:
102: PROCEDURE check_for_null_and_fks_in_cvr
103: (
104: p_cust_vr IN gmd_customer_spec_vrs%ROWTYPE
105: , p_spec IN gmd_specifications%ROWTYPE
106: , x_return_status OUT NOCOPY VARCHAR2
107: );
108:
109: FUNCTION cust_vr_exist(p_cust_vr GMD_CUSTOMER_SPEC_VRS%ROWTYPE,
106: , x_return_status OUT NOCOPY VARCHAR2
107: );
108:
109: FUNCTION cust_vr_exist(p_cust_vr GMD_CUSTOMER_SPEC_VRS%ROWTYPE,
110: p_spec GMD_SPECIFICATIONS%ROWTYPE)
111: RETURN BOOLEAN;
112:
113:
114:
122:
123: PROCEDURE check_for_null_and_fks_in_svr
124: (
125: p_supp_vr IN gmd_supplier_spec_vrs%ROWTYPE
126: , p_spec IN gmd_specifications%ROWTYPE
127: , x_return_status OUT NOCOPY VARCHAR2
128: );
129:
130: FUNCTION supp_vr_exist(p_supp_vr GMD_SUPPLIER_SPEC_VRS%ROWTYPE,
127: , x_return_status OUT NOCOPY VARCHAR2
128: );
129:
130: FUNCTION supp_vr_exist(p_supp_vr GMD_SUPPLIER_SPEC_VRS%ROWTYPE,
131: p_spec GMD_SPECIFICATIONS%ROWTYPE)
132: RETURN BOOLEAN;
133:
134: PROCEDURE VALIDATE_BEFORE_DELETE_INV_VRS(
135: p_spec_id IN NUMBER,