APPS.GMD_SPEC_VRS_GRP dependencies on GMD_MONITORING_SPEC_VRS

Line 27: p_mon_vr IN GMD_MONITORING_SPEC_VRS%ROWTYPE

23: -- End of comments
24:
25: PROCEDURE validate_mon_vr
26: (
27: p_mon_vr IN GMD_MONITORING_SPEC_VRS%ROWTYPE
28: , p_called_from IN VARCHAR2 DEFAULT 'API'
29: , p_operation IN VARCHAR2
30: , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE
31: , x_return_status OUT NOCOPY VARCHAR2

Line 30: , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE

26: (
27: p_mon_vr IN GMD_MONITORING_SPEC_VRS%ROWTYPE
28: , p_called_from IN VARCHAR2 DEFAULT 'API'
29: , p_operation IN VARCHAR2
30: , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE
31: , x_return_status OUT NOCOPY VARCHAR2
32: );
33:
34: PROCEDURE check_for_null_and_fks_in_mvr

Line 36: p_mon_vr IN GMD_MONITORING_SPEC_VRS%ROWTYPE

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

Line 38: , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE

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:
42: FUNCTION mon_vr_exist(p_mon_vr GMD_MONITORING_SPEC_VRS%ROWTYPE,

Line 42: FUNCTION mon_vr_exist(p_mon_vr GMD_MONITORING_SPEC_VRS%ROWTYPE,

38: , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%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