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 244: OKC_K_ART_VARIABLES_PVT.insert_row(

240: okc_debug.log('120: Variables of article '||p_sav_sae_id||' is being created',2);
241: END IF;
242:
243: FOR l_article_var_rec IN l_article_var_csr(p_article_version_id) LOOP
244: OKC_K_ART_VARIABLES_PVT.insert_row(
245: p_validation_level => p_validation_level,
246: x_return_status => x_return_status,
247: p_cat_id => x_id,
248: p_variable_code => l_article_var_rec.variable_code,

Line 641: x_cat_id okc_k_art_variables.cat_id%type;

637: l_summary_amend_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
638: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
639: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
640: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
641: x_cat_id okc_k_art_variables.cat_id%type;
642: x_variable_code okc_k_art_variables.variable_code%type;
643:
644: CURSOR l_document_id_csr IS
645: SELECT DOCUMENT_ID,DOCUMENT_TYPE

Line 642: x_variable_code okc_k_art_variables.variable_code%type;

638: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
639: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
640: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
641: x_cat_id okc_k_art_variables.cat_id%type;
642: x_variable_code okc_k_art_variables.variable_code%type;
643:
644: CURSOR l_document_id_csr IS
645: SELECT DOCUMENT_ID,DOCUMENT_TYPE
646: FROM OKC_K_ARTIClES_B

Line 669: ( SELECT 'X' FROM OKC_K_ART_VARIABLES

665: OKC_BUS_VARIABLES_B BUSVAR
666: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
667: AND KART.ID = P_ID
668: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE AND NOT EXISTS
669: ( SELECT 'X' FROM OKC_K_ART_VARIABLES
670: WHERE CAT_ID=KART.ID
671: AND VARIABLE_CODE = BUSVAR.VARIABLE_CODE);
672:
673: CURSOR l_update_variable_csr is

Line 685: OKC_K_ART_VARIABLES ARTVAR

681: ARTVAR.OBJECT_VERSION_NUMBER
682: FROM OKC_ARTICLE_VARIABLES VAR,
683: OKC_K_ARTICLES_B KART,
684: OKC_BUS_VARIABLES_B BUSVAR,
685: OKC_K_ART_VARIABLES ARTVAR
686: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
687: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE
688: AND ARTVAR.CAT_ID = KART.ID
689: AND ARTVAR.VARIABLE_CODE = VAR.VARIABLE_CODE

Line 697: FROM OKC_K_ART_VARIABLES ARTVAR,

693: CURSOR l_delete_variable_csr is
694: SELECT ARTVAR.CAT_ID,
695: ARTVAR.VARIABLE_CODE,
696: ARTVAR.OBJECT_VERSION_NUMBER
697: FROM OKC_K_ART_VARIABLES ARTVAR,
698: OKC_K_ARTICLES_B KART
699: WHERE KART.ID = ARTVAR.CAT_ID
700: AND KART.ID = P_ID
701: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VARIABLES VAR

Line 841: -- 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.

837: --------------------------------------------
838: IF FND_API.To_Boolean(l_sync_variable) THEN
839:
840: -- If Article is changed then
841: -- 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.
842: -- 2.Delete record in okc_k_art_variables for those variables which are present in old article version but absent in new article version.
843: -- 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.
844:
845:

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

838: IF FND_API.To_Boolean(l_sync_variable) THEN
839:
840: -- If Article is changed then
841: -- 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.
842: -- 2.Delete record in okc_k_art_variables for those variables which are present in old article version but absent in new article version.
843: -- 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.
844:
845:
846: -- creating new article variables

Line 843: -- 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.

839:
840: -- If Article is changed then
841: -- 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.
842: -- 2.Delete record in okc_k_art_variables for those variables which are present in old article version but absent in new article version.
843: -- 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.
844:
845:
846: -- creating new article variables
847: IF (l_debug = 'Y') THEN

Line 852: OKC_K_ART_VARIABLES_PVT.insert_row(

848: okc_debug.log('1710: Creating New article variables for article version '|| l_article_version_id, 2);
849: END IF;
850:
851: FOR l_create_variable_rec IN l_create_variable_csr LOOP
852: OKC_K_ART_VARIABLES_PVT.insert_row(
853: x_return_status => x_return_status,
854: p_cat_id => p_id,
855: p_variable_code => l_create_variable_rec.variable_code,
856: p_variable_type => l_create_variable_rec.variable_type,

Line 878: OKC_K_ART_VARIABLES_PVT.delete_row(

874: okc_debug.log('1710: Deleing old article variables for article version '|| p_article_version_id||' which are not present in new article version', 2);
875: END IF;
876:
877: FOR l_delete_variable_rec IN l_delete_variable_csr LOOP
878: OKC_K_ART_VARIABLES_PVT.delete_row(
879: x_return_status => x_return_status,
880: p_cat_id => l_delete_variable_rec.cat_id,
881: p_variable_code => l_delete_variable_rec.variable_code,
882: p_object_version_number => l_delete_variable_rec.object_version_number

Line 900: OKC_K_ART_VARIABLES_PVT.update_row(

896: END IF;
897:
898: FOR l_update_variable_rec IN l_update_variable_csr LOOP
899:
900: OKC_K_ART_VARIABLES_PVT.update_row(
901: x_return_status => x_return_status,
902: p_cat_id => p_id,
903: p_variable_code => l_update_variable_rec.variable_code,
904: p_variable_type => l_update_variable_rec.variable_type,

Line 1176: -- Delete Child records from OKC_K_ART_VARIABLES_TABLE

1172: END IF;
1173: END IF;
1174:
1175: IF p_mode<>'AMEND' or l_delete_rec THEN
1176: -- Delete Child records from OKC_K_ART_VARIABLES_TABLE
1177: IF (l_debug = 'Y') THEN
1178: okc_debug.log('2260: Deleting Child record from okc_k_art_varibles', 2) ;
1179: END IF;
1180:

Line 1181: OKC_K_ART_VARIABLES_PVT.delete_set(

1177: IF (l_debug = 'Y') THEN
1178: okc_debug.log('2260: Deleting Child record from okc_k_art_varibles', 2) ;
1179: END IF;
1180:
1181: OKC_K_ART_VARIABLES_PVT.delete_set(
1182: x_return_status => x_return_status,
1183: p_cat_id => p_id
1184: );
1185: