DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on GMD_WIP_SPEC_VRS

Line 71: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE

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

Line 74: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE

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

Line 80: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE

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

Line 82: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE

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,

Line 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: