APPS.OKC_OCE_PVT dependencies on OKC_CONDITION_HEADERS_V

Line 733: FROM Okc_Condition_Headers_V

729: CREATION_DATE,
730: LAST_UPDATED_BY,
731: LAST_UPDATE_DATE,
732: LAST_UPDATE_LOGIN
733: FROM Okc_Condition_Headers_V
734: WHERE okc_condition_headers_v.id = p_id;
735: l_okc_cnhv_pk okc_cnhv_pk_csr%ROWTYPE;
736: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
737: l_row_notfound BOOLEAN := TRUE;

Line 734: WHERE okc_condition_headers_v.id = p_id;

730: LAST_UPDATED_BY,
731: LAST_UPDATE_DATE,
732: LAST_UPDATE_LOGIN
733: FROM Okc_Condition_Headers_V
734: WHERE okc_condition_headers_v.id = p_id;
735: l_okc_cnhv_pk okc_cnhv_pk_csr%ROWTYPE;
736: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
737: l_row_notfound BOOLEAN := TRUE;
738: BEGIN

Line 1107: FROM Okc_condition_headers_v

1103: p_ocev_rec IN ocev_rec_type) IS
1104:
1105: CURSOR okc_cnhv_pk_csr IS
1106: SELECT '1'
1107: FROM Okc_condition_headers_v
1108: WHERE okc_condition_headers_v.id = p_ocev_rec.cnh_id;
1109:
1110: l_dummy VARCHAR2(1) := '?';
1111:

Line 1108: WHERE okc_condition_headers_v.id = p_ocev_rec.cnh_id;

1104:
1105: CURSOR okc_cnhv_pk_csr IS
1106: SELECT '1'
1107: FROM Okc_condition_headers_v
1108: WHERE okc_condition_headers_v.id = p_ocev_rec.cnh_id;
1109:
1110: l_dummy VARCHAR2(1) := '?';
1111:
1112: Begin

Line 1140: p_token3_value => 'OKC_CONDITION_HEADERS_V');

1136: p_token1_value => 'cnh_id',
1137: p_token2 => g_child_table_token,
1138: p_token2_value => 'OKC_OUTCOMES_V',
1139: p_token3 => g_parent_table_token,
1140: p_token3_value => 'OKC_CONDITION_HEADERS_V');
1141: x_return_status := OKC_API.G_RET_STS_ERROR;
1142: RAISE G_EXCEPTION_HALT_VALIDATION;
1143: END IF;
1144: EXCEPTION

Line 1187: from okc_condition_headers_v cnh, okc_actions_v acn

1183: WHERE okc_process_defs_v.id = p_ocev_rec.pdf_id;
1184:
1185: CURSOR sync_flag_yn_csr(p_cnh_id IN NUMBER) IS
1186: Select acn.sync_allowed_yn
1187: from okc_condition_headers_v cnh, okc_actions_v acn
1188: where cnh.id = p_cnh_id
1189: and cnh.acn_id = acn.id;
1190:
1191: CURSOR pdf_type_csr(p_pdf_id IN NUMBER) IS