679: CREATION_DATE,
680: LAST_UPDATED_BY,
681: LAST_UPDATE_DATE,
682: LAST_UPDATE_LOGIN
683: FROM Okc_Process_Defs_V
684: WHERE okc_process_defs_v.id = p_id;
685: l_okc_pdfv_pk okc_pdfv_pk_csr%ROWTYPE;
686: CURSOR okc_cnhv_pk_csr (p_id IN NUMBER) IS
687: SELECT
680: LAST_UPDATED_BY,
681: LAST_UPDATE_DATE,
682: LAST_UPDATE_LOGIN
683: FROM Okc_Process_Defs_V
684: WHERE okc_process_defs_v.id = p_id;
685: l_okc_pdfv_pk okc_pdfv_pk_csr%ROWTYPE;
686: CURSOR okc_cnhv_pk_csr (p_id IN NUMBER) IS
687: SELECT
688: ID,
1178: p_ocev_rec IN ocev_rec_type) IS
1179:
1180: CURSOR okc_pdfv_pk_csr IS
1181: SELECT '1'
1182: FROM Okc_Process_Defs_V
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
1179:
1180: CURSOR okc_pdfv_pk_csr IS
1181: SELECT '1'
1182: FROM Okc_Process_Defs_V
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
1189: and cnh.acn_id = acn.id;
1190:
1191: CURSOR pdf_type_csr(p_pdf_id IN NUMBER) IS
1192: Select pdf.usage, pdf.pdf_type
1193: From okc_process_defs_v pdf, okc_outcomes_v oce
1194: where pdf.id = p_pdf_id
1195: and pdf.id = oce.pdf_id;
1196:
1197: l_dummy VARCHAR2(1) := '?';
1194: where pdf.id = p_pdf_id
1195: and pdf.id = oce.pdf_id;
1196:
1197: l_dummy VARCHAR2(1) := '?';
1198: l_sync_flag okc_process_defs_v.pdf_type%TYPE;
1199: l_usage okc_process_defs_v.usage%TYPE;
1200: l_pdf_type okc_process_defs_v.pdf_type%TYPE;
1201: BEGIN
1202: -- initialize return status
1195: and pdf.id = oce.pdf_id;
1196:
1197: l_dummy VARCHAR2(1) := '?';
1198: l_sync_flag okc_process_defs_v.pdf_type%TYPE;
1199: l_usage okc_process_defs_v.usage%TYPE;
1200: l_pdf_type okc_process_defs_v.pdf_type%TYPE;
1201: BEGIN
1202: -- initialize return status
1203: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1196:
1197: l_dummy VARCHAR2(1) := '?';
1198: l_sync_flag okc_process_defs_v.pdf_type%TYPE;
1199: l_usage okc_process_defs_v.usage%TYPE;
1200: l_pdf_type okc_process_defs_v.pdf_type%TYPE;
1201: BEGIN
1202: -- initialize return status
1203: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1204:
1225: p_token1_value => 'pdf_id',
1226: p_token2 => g_child_table_token,
1227: p_token2_value => 'OKC_OUTCOMES_V',
1228: p_token3 => g_parent_table_token,
1229: p_token3_value => 'OKC_PROCESS_DEFS_V');
1230: x_return_status := OKC_API.G_RET_STS_ERROR;
1231: RAISE G_EXCEPTION_HALT_VALIDATION;
1232: END IF;
1233: