APPS.OKE_CONTRACT_PUB dependencies on OKC_ASSENTS

Line 1116: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;

1112: l_api_version CONSTANT NUMBER := 1.0;
1113: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1114: l_line_number VARCHAR2(120);
1115:
1116: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;
1117: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;
1118: l_return_value VARCHAR2(1):='?';
1119:
1120: CURSOR c_assent IS

Line 1117: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;

1113: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1114: l_line_number VARCHAR2(120);
1115:
1116: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;
1117: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;
1118: l_return_value VARCHAR2(1):='?';
1119:
1120: CURSOR c_assent IS
1121: SELECT allowed_yn

Line 1122: FROM OKC_ASSENTS

1118: l_return_value VARCHAR2(1):='?';
1119:
1120: CURSOR c_assent IS
1121: SELECT allowed_yn
1122: FROM OKC_ASSENTS
1123: WHERE sts_code = l_sts_code
1124: AND scs_code = l_scs_code
1125: AND opn_code = 'UPDATE';
1126:

Line 1173: UPDATE OKC_ASSENTS SET ALLOWED_YN = 'Y'

1169: Fetch C_assent INTO L_return_value;
1170: Close C_assent;
1171:
1172: If (l_return_value in ('N')) Then
1173: UPDATE OKC_ASSENTS SET ALLOWED_YN = 'Y'
1174: WHERE sts_code = l_sts_code
1175: AND scs_code = l_scs_code
1176: AND opn_code = 'UPDATE';
1177: End If;

Line 1194: UPDATE OKC_ASSENTS SET ALLOWED_YN = l_return_value

1190: x_clev_rec => x_clev_rec);
1191:
1192:
1193: If (l_return_value in ('N')) Then
1194: UPDATE OKC_ASSENTS SET ALLOWED_YN = l_return_value
1195: WHERE sts_code = l_sts_code
1196: AND scs_code = l_scs_code
1197: AND opn_code = 'UPDATE';
1198: End If;

Line 3225: and exists (select 'x' from okc_assents a

3221: where h.id = p_id
3222: and l.header_id = p_id
3223: and h.id = k.k_header_id
3224: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)
3225: and exists (select 'x' from okc_assents a
3226: where a.opn_code = 'CREATE_DELV'
3227: and a.sts_code = l.status_code
3228: and a.scs_code = 'PROJECT'
3229: and a.allowed_yn = 'Y');

Line 3270: and exists (select 'x' from okc_assents a

3266: and l.header_id = p_id
3267: and h.id = k.k_header_id
3268: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)
3269: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id)
3270: and exists (select 'x' from okc_assents a
3271: where a.opn_code = 'CREATE_DELV'
3272: and a.sts_code = l.status_code
3273: and a.scs_code = 'PROJECT'
3274: and a.allowed_yn = 'Y');

Line 3924: SELECT 'X' FROM OKC_ASSENTS

3920: l_check VARCHAR2(1);
3921:
3922:
3923: CURSOR check_opns IS
3924: SELECT 'X' FROM OKC_ASSENTS
3925: WHERE OPN_CODE ='DELETE'
3926: AND STS_CODE =
3927: (SELECT STS_CODE FROM OKC_K_HEADERS_B WHERE ID = P_CHR_ID)
3928: AND SCS_CODE = 'PROJECT'