APPS.OKE_CONTRACT_PUB dependencies on OKC_ASSENTS

Line 1117: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;

1113: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1114: --bug 9354391 changed length of line_number to 150 as per table
1115: l_line_number VARCHAR2(150);
1116:
1117: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;
1118: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;
1119: l_return_value VARCHAR2(1):='?';
1120:
1121: CURSOR c_assent IS

Line 1118: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;

1114: --bug 9354391 changed length of line_number to 150 as per table
1115: l_line_number VARCHAR2(150);
1116:
1117: l_sts_code OKC_ASSENTS.STS_CODE%TYPE;
1118: l_scs_code OKC_ASSENTS.SCS_CODE%TYPE;
1119: l_return_value VARCHAR2(1):='?';
1120:
1121: CURSOR c_assent IS
1122: SELECT allowed_yn

Line 1123: FROM OKC_ASSENTS

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

Line 1174: UPDATE OKC_ASSENTS SET ALLOWED_YN = 'Y'

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

Line 1195: UPDATE OKC_ASSENTS SET ALLOWED_YN = l_return_value

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

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

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

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

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

Line 3926: SELECT 'X' FROM OKC_ASSENTS

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