DBA Data[Home] [Help]

APPS.OKC_CONDITION_EVAL_PVT dependencies on OKC_OUTCOME_ARGUMENTS

Line 971: l_value okc_outcome_arguments.value%TYPE;

967: oce_rec oce_cur%ROWTYPE;
968:
969: l_oce_id okc_outcomes_b.id%TYPE;
970: l_pdp_id okc_process_def_parms_b.id%TYPE;
971: l_value okc_outcome_arguments.value%TYPE;
972: l_element_name okc_action_attributes_b.element_name%TYPE;
973: CURSOR oat_cur(l_oce_id IN NUMBER,
974: l_pdp_id IN NUMBER) IS
975: SELECT oat.value value,aae.element_name element_name

Line 976: FROM okc_outcome_arguments oat,

972: l_element_name okc_action_attributes_b.element_name%TYPE;
973: CURSOR oat_cur(l_oce_id IN NUMBER,
974: l_pdp_id IN NUMBER) IS
975: SELECT oat.value value,aae.element_name element_name
976: FROM okc_outcome_arguments oat,
977: okc_action_attributes_b aae
978: WHERE oat.oce_id = l_oce_id
979: AND oat.pdp_id = l_pdp_id
980: AND oat.aae_id = aae.id(+);

Line 989: l_attr_value okc_outcome_arguments.value%TYPE; --Bug 3731760

985: l_msg_tab okc_aq_pvt.msg_tab_typ;
986: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
987: p_cnh_id okc_condition_headers_b.id%TYPE;
988: l_string VARCHAR2(32000);
989: l_attr_value okc_outcome_arguments.value%TYPE; --Bug 3731760
990: v_oce_id NUMBER :=0;
991: sync_pdf_type okc_process_defs_b.pdf_type%TYPE;
992: async_pdf_type okc_process_defs_b.pdf_type%TYPE;
993: l_api_name CONSTANT VARCHAR2(30) := 'BUILD_OUTCOME';

Line 1358: l_value okc_outcome_arguments.value%TYPE;

1354: oce_rec oce_cur%ROWTYPE;
1355:
1356: l_oce_id okc_outcomes_b.id%TYPE;
1357: l_pdp_id okc_process_def_parms_b.id%TYPE;
1358: l_value okc_outcome_arguments.value%TYPE;
1359: l_element_name okc_action_attributes_b.element_name%TYPE;
1360: CURSOR oat_cur(l_oce_id IN NUMBER,
1361: l_pdp_id IN NUMBER) IS
1362: SELECT oat.value value,aae.element_name element_name

Line 1363: FROM okc_outcome_arguments oat,

1359: l_element_name okc_action_attributes_b.element_name%TYPE;
1360: CURSOR oat_cur(l_oce_id IN NUMBER,
1361: l_pdp_id IN NUMBER) IS
1362: SELECT oat.value value,aae.element_name element_name
1363: FROM okc_outcome_arguments oat,
1364: okc_action_attributes_b aae
1365: WHERE oat.oce_id = l_oce_id
1366: AND oat.pdp_id = l_pdp_id
1367: AND oat.aae_id = aae.id(+);

Line 1376: l_attr_value okc_outcome_arguments.value%TYPE; --Bug 3731760

1372: l_msg_tab okc_aq_pvt.msg_tab_typ;
1373: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
1374: p_cnh_id okc_condition_headers_b.id%TYPE;
1375: l_string VARCHAR2(32000);
1376: l_attr_value okc_outcome_arguments.value%TYPE; --Bug 3731760
1377: v_oce_id NUMBER :=0;
1378: sync_pdf_type okc_process_defs_b.pdf_type%TYPE;
1379: async_pdf_type okc_process_defs_b.pdf_type%TYPE;
1380: l_api_name CONSTANT VARCHAR2(30) := 'BUILD_DATE_OUTCOME';