45: x_coordination_type OUT NOCOPY VARCHAR2,
46: x_return_status OUT NOCOPY VARCHAR2)
47: IS
48:
49: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
50: l_msg_data VARCHAR2(2000);
51: l_msg_count NUMBER;
52: l_contract_type VARCHAR2(150) := 'REP_SBCR';
53: l_contract_version_num NUMBER;
52: l_contract_type VARCHAR2(150) := 'REP_SBCR';
53: l_contract_version_num NUMBER;
54: l_contract_id NUMBER;
55:
56: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
57:
58: l_api_name VARCHAR2(30) := 'GET_SBCR_DETAILS';
59:
60: BEGIN
117: p_contract_id IN NUMBER,
118: x_return_status OUT NOCOPY VARCHAR2)
119: IS
120:
121: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
122: l_msg_data VARCHAR2(2000);
123: l_msg_count NUMBER;
124: l_contract_type VARCHAR2(150) := 'REP_SBCR';
125: