eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_K_ARTICLES_GRP dependencies on OKC_K_ART_VARIABLES

Line 92: l_variable_code OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE;

88: l_api_version CONSTANT NUMBER := 1;
89: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article';
90: l_cat_id NUMBER;
91: l_del_cat_id NUMBER;
92: l_variable_code OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE;
93: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
94: l_summary_amend_operation_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
95: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
96:

Line 275: OKC_K_ART_VARIABLES_PVT.insert_row(

271: okc_debug.log('120: Variables of article '||p_sav_sae_id||' is being created',2);
272: END IF;
273:
274: FOR l_article_var_rec IN l_article_var_csr(p_article_version_id) LOOP
275: OKC_K_ART_VARIABLES_PVT.insert_row(
276: p_validation_level => p_validation_level,
277: x_return_status => x_return_status,
278: p_cat_id => x_id,
279: p_variable_code => l_article_var_rec.variable_code,

Line 676: x_cat_id okc_k_art_variables.cat_id%type;

672: l_summary_amend_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
673: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
674: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
675: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
676: x_cat_id okc_k_art_variables.cat_id%type;
677: x_variable_code okc_k_art_variables.variable_code%type;
678: l_orig_system_reference_id1 NUMBER;
679:
680: CURSOR l_document_id_csr IS

Line 677: x_variable_code okc_k_art_variables.variable_code%type;

673: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
674: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
675: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
676: x_cat_id okc_k_art_variables.cat_id%type;
677: x_variable_code okc_k_art_variables.variable_code%type;
678: l_orig_system_reference_id1 NUMBER;
679:
680: CURSOR l_document_id_csr IS
681: SELECT DOCUMENT_ID,DOCUMENT_TYPE,orig_system_reference_id1

Line 705: ( SELECT 'X' FROM OKC_K_ART_VARIABLES

701: OKC_BUS_VARIABLES_B BUSVAR
702: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
703: AND KART.ID = P_ID
704: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE AND NOT EXISTS
705: ( SELECT 'X' FROM OKC_K_ART_VARIABLES
706: WHERE CAT_ID=KART.ID
707: AND VARIABLE_CODE = BUSVAR.VARIABLE_CODE);
708:
709: CURSOR l_update_variable_csr is

Line 721: OKC_K_ART_VARIABLES ARTVAR

717: ARTVAR.OBJECT_VERSION_NUMBER
718: FROM OKC_ARTICLE_VARIABLES VAR,
719: OKC_K_ARTICLES_B KART,
720: OKC_BUS_VARIABLES_B BUSVAR,
721: OKC_K_ART_VARIABLES ARTVAR
722: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
723: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE
724: AND ARTVAR.CAT_ID = KART.ID
725: AND ARTVAR.VARIABLE_CODE = VAR.VARIABLE_CODE

Line 733: FROM OKC_K_ART_VARIABLES ARTVAR,

729: CURSOR l_delete_variable_csr is
730: SELECT ARTVAR.CAT_ID,
731: ARTVAR.VARIABLE_CODE,
732: ARTVAR.OBJECT_VERSION_NUMBER
733: FROM OKC_K_ART_VARIABLES ARTVAR,
734: OKC_K_ARTICLES_B KART
735: WHERE KART.ID = ARTVAR.CAT_ID
736: AND KART.ID = P_ID
737: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VARIABLES VAR

Line 947: -- 1.Create record in okc_k_art_variables for those variables which are present in new article version but were absent in old article version.

943: --------------------------------------------
944: IF FND_API.To_Boolean(l_sync_variable) THEN
945:
946: -- If Article is changed then
947: -- 1.Create record in okc_k_art_variables for those variables which are present in new article version but were absent in old article version.
948: -- 2.Delete record in okc_k_art_variables for those variables which are present in old article version but absent in new article version.
949: -- 3.Update record in okc_k_art_variables for those variables which are present in both version and for which value has been entered previously.
950:
951:

Line 948: -- 2.Delete record in okc_k_art_variables for those variables which are present in old article version but absent in new article version.

944: IF FND_API.To_Boolean(l_sync_variable) THEN
945:
946: -- If Article is changed then
947: -- 1.Create record in okc_k_art_variables for those variables which are present in new article version but were absent in old article version.
948: -- 2.Delete record in okc_k_art_variables for those variables which are present in old article version but absent in new article version.
949: -- 3.Update record in okc_k_art_variables for those variables which are present in both version and for which value has been entered previously.
950:
951:
952: -- creating new article variables

Line 949: -- 3.Update record in okc_k_art_variables for those variables which are present in both version and for which value has been entered previously.

945:
946: -- If Article is changed then
947: -- 1.Create record in okc_k_art_variables for those variables which are present in new article version but were absent in old article version.
948: -- 2.Delete record in okc_k_art_variables for those variables which are present in old article version but absent in new article version.
949: -- 3.Update record in okc_k_art_variables for those variables which are present in both version and for which value has been entered previously.
950:
951:
952: -- creating new article variables
953: IF (l_debug = 'Y') THEN

Line 958: OKC_K_ART_VARIABLES_PVT.insert_row(

954: okc_debug.log('1710: Creating New article variables for article version '|| l_article_version_id, 2);
955: END IF;
956:
957: FOR l_create_variable_rec IN l_create_variable_csr LOOP
958: OKC_K_ART_VARIABLES_PVT.insert_row(
959: x_return_status => x_return_status,
960: p_cat_id => p_id,
961: p_variable_code => l_create_variable_rec.variable_code,
962: p_variable_type => l_create_variable_rec.variable_type,

Line 984: OKC_K_ART_VARIABLES_PVT.delete_row(

980: okc_debug.log('1710: Deleing old article variables for article version '|| p_article_version_id||' which are not present in new article version', 2);
981: END IF;
982:
983: FOR l_delete_variable_rec IN l_delete_variable_csr LOOP
984: OKC_K_ART_VARIABLES_PVT.delete_row(
985: x_return_status => x_return_status,
986: p_cat_id => l_delete_variable_rec.cat_id,
987: p_variable_code => l_delete_variable_rec.variable_code,
988: p_object_version_number => l_delete_variable_rec.object_version_number

Line 1006: OKC_K_ART_VARIABLES_PVT.update_row(

1002: END IF;
1003:
1004: FOR l_update_variable_rec IN l_update_variable_csr LOOP
1005:
1006: OKC_K_ART_VARIABLES_PVT.update_row(
1007: x_return_status => x_return_status,
1008: p_cat_id => p_id,
1009: p_variable_code => l_update_variable_rec.variable_code,
1010: p_variable_type => l_update_variable_rec.variable_type,

Line 1338: -- Delete Child records from OKC_K_ART_VARIABLES_TABLE

1334: END IF;
1335: END IF;
1336:
1337: IF p_mode<>'AMEND' or l_delete_rec THEN
1338: -- Delete Child records from OKC_K_ART_VARIABLES_TABLE
1339: IF (l_debug = 'Y') THEN
1340: okc_debug.log('2260: Deleting Child record from okc_k_art_varibles', 2) ;
1341: END IF;
1342:

Line 1343: OKC_K_ART_VARIABLES_PVT.delete_set(

1339: IF (l_debug = 'Y') THEN
1340: okc_debug.log('2260: Deleting Child record from okc_k_art_varibles', 2) ;
1341: END IF;
1342:
1343: OKC_K_ART_VARIABLES_PVT.delete_set(
1344: x_return_status => x_return_status,
1345: p_cat_id => p_id
1346: );
1347: