DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on GMD_INVENTORY_SPEC_VRS

Line 48: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE

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

Line 51: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE

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

Line 57: p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE

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

Line 59: , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE

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

Line 63: FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,

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