APPS.GMD_SPEC_VRS_GRP dependencies on GMD_SPECIFICATIONS

Line 37: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE

33:
34: PROCEDURE check_for_null_and_fks_in_mvr
35: (
36: p_mon_vr IN GMD_MONITORING_SPEC_VRS%ROWTYPE
37: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
38: , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE
39: , x_return_status OUT NOCOPY VARCHAR2
40: );
41:

Line 43: p_spec GMD_SPECIFICATIONS%ROWTYPE)

39: , x_return_status OUT NOCOPY VARCHAR2
40: );
41:
42: FUNCTION mon_vr_exist(p_mon_vr GMD_MONITORING_SPEC_VRS%ROWTYPE,
43: p_spec GMD_SPECIFICATIONS%ROWTYPE)
44: RETURN BOOLEAN;
45:
46: PROCEDURE validate_inv_vr
47: (

Line 58: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE

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: );
62:

Line 64: p_spec GMD_SPECIFICATIONS%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:
68:

Line 81: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE

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: );
85:

Line 87: p_spec GMD_SPECIFICATIONS%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:
91:

Line 103: , p_spec IN gmd_specifications%ROWTYPE

99:
100: PROCEDURE check_for_null_and_fks_in_cvr
101: (
102: p_cust_vr IN gmd_customer_spec_vrs%ROWTYPE
103: , p_spec IN gmd_specifications%ROWTYPE
104: , x_return_status OUT NOCOPY VARCHAR2
105: );
106:
107: FUNCTION cust_vr_exist(p_cust_vr GMD_CUSTOMER_SPEC_VRS%ROWTYPE,

Line 108: p_spec GMD_SPECIFICATIONS%ROWTYPE)

104: , x_return_status OUT NOCOPY VARCHAR2
105: );
106:
107: FUNCTION cust_vr_exist(p_cust_vr GMD_CUSTOMER_SPEC_VRS%ROWTYPE,
108: p_spec GMD_SPECIFICATIONS%ROWTYPE)
109: RETURN BOOLEAN;
110:
111:
112:

Line 124: , p_spec IN gmd_specifications%ROWTYPE

120:
121: PROCEDURE check_for_null_and_fks_in_svr
122: (
123: p_supp_vr IN gmd_supplier_spec_vrs%ROWTYPE
124: , p_spec IN gmd_specifications%ROWTYPE
125: , x_return_status OUT NOCOPY VARCHAR2
126: );
127:
128: FUNCTION supp_vr_exist(p_supp_vr GMD_SUPPLIER_SPEC_VRS%ROWTYPE,

Line 129: p_spec GMD_SPECIFICATIONS%ROWTYPE)

125: , x_return_status OUT NOCOPY VARCHAR2
126: );
127:
128: FUNCTION supp_vr_exist(p_supp_vr GMD_SUPPLIER_SPEC_VRS%ROWTYPE,
129: p_spec GMD_SPECIFICATIONS%ROWTYPE)
130: RETURN BOOLEAN;
131:
132: PROCEDURE VALIDATE_BEFORE_DELETE_INV_VRS(
133: p_spec_id IN NUMBER,