DBA Data[Home] [Help]

APPS.OKC_OAT_PVT dependencies on OKC_ACTION_ATTRIBUTES_V

Line 354: FROM Okc_Action_Attributes_V

350: CREATION_DATE,
351: LAST_UPDATED_BY,
352: LAST_UPDATE_DATE,
353: LAST_UPDATE_LOGIN
354: FROM Okc_Action_Attributes_V
355: WHERE okc_action_attributes_v.id = p_id;
356: l_okc_aaev_pk okc_aaev_pk_csr%ROWTYPE;
357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
358: l_row_notfound BOOLEAN := TRUE;

Line 355: WHERE okc_action_attributes_v.id = p_id;

351: LAST_UPDATED_BY,
352: LAST_UPDATE_DATE,
353: LAST_UPDATE_LOGIN
354: FROM Okc_Action_Attributes_V
355: WHERE okc_action_attributes_v.id = p_id;
356: l_okc_aaev_pk okc_aaev_pk_csr%ROWTYPE;
357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
358: l_row_notfound BOOLEAN := TRUE;
359: BEGIN

Line 720: FROM Okc_action_attributes_v

716: p_oatv_rec IN oatv_rec_type) IS
717:
718: CURSOR okc_aaev_pk_csr IS
719: SELECT '1'
720: FROM Okc_action_attributes_v
721: WHERE okc_action_attributes_v.id = p_oatv_rec.aae_id;
722:
723: l_dummy VARCHAR2(1) := '?';
724: Begin

Line 721: WHERE okc_action_attributes_v.id = p_oatv_rec.aae_id;

717:
718: CURSOR okc_aaev_pk_csr IS
719: SELECT '1'
720: FROM Okc_action_attributes_v
721: WHERE okc_action_attributes_v.id = p_oatv_rec.aae_id;
722:
723: l_dummy VARCHAR2(1) := '?';
724: Begin
725: IF p_oatv_rec.value IS NULL THEN

Line 740: p_token3_value => 'OKC_ACTION_ATTRIBUTES_V');

736: p_token1_value => 'aae_id',
737: p_token2 => g_child_table_token,
738: p_token2_value => 'OKC_OUTCOME_ARGUMENTS_V',
739: p_token3 => g_parent_table_token,
740: p_token3_value => 'OKC_ACTION_ATTRIBUTES_V');
741: x_return_status := OKC_API.G_RET_STS_ERROR;
742: RAISE G_EXCEPTION_HALT_VALIDATION;
743: END IF;
744: END IF;

Line 938: from okc_action_attributes_v

934: where id = p_pdp_id;
935:
936: cursor aae_cur(p_aae_id IN NUMBER) is
937: select data_type
938: from okc_action_attributes_v
939: where id = p_aae_id;
940:
941: v_aae_data_type VARCHAr2(90);
942: v_pdp_data_type VARCHAR2(90);