DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on GMD_WIP_SPEC_VRS

Line 73: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE

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

Line 76: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE

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

Line 82: p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE

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

Line 84: , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE

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,

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