APPS.GMD_SPEC_VRS_GRP dependencies on GMD_INVENTORY_SPEC_VRS

Line 50: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE

46: RETURN BOOLEAN;
47:
48: PROCEDURE validate_inv_vr
49: (
50: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
51: , p_called_from IN VARCHAR2 DEFAULT 'API'
52: , p_operation IN VARCHAR2
53: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
54: , x_return_status OUT NOCOPY VARCHAR2

Line 53: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE

49: (
50: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
51: , p_called_from IN VARCHAR2 DEFAULT 'API'
52: , p_operation IN VARCHAR2
53: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
54: , x_return_status OUT NOCOPY VARCHAR2
55: );
56:
57: PROCEDURE check_for_null_and_fks_in_ivr

Line 59: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE

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

Line 61: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE

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:
65: FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,

Line 65: FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,

61: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
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: