APPS.PO_MOD_UTIL_PVT dependencies on PO_OKC_VARS_GT

Line 493: -- get system defined variables for mod and base - this values are dumped in PO_OKC_VARS_GT

489: and KAV.cat_id = KAB.id
490: and BVB.value_set_id = FVS.flex_value_set_id (+);
491: begin
492:
493: -- get system defined variables for mod and base - this values are dumped in PO_OKC_VARS_GT
494:
495: OKC_TERMS_UTIL_PVT.get_system_variables(p_api_version => 1.0,
496: p_init_msg_list => FND_API.G_FALSE,
497: x_return_status => p_ret_status,

Line 506: insert into PO_OKC_VARS_GT(DOC_TYPE,

502: p_only_doc_variables => FND_API.G_TRUE,
503: x_sys_var_value_tbl => p_sys_var_val_tbl);
504:
505: if p_sys_var_val_tbl.count > 0 then
506: insert into PO_OKC_VARS_GT(DOC_TYPE,
507: DOC_ID,
508: ARTICLE_VERSION_ID,
509: cat_id,
510: VARIABLE_CODE

Line 519: update PO_OKC_VARS_GT set VARIABLE_VALUE = p_sys_var_val_tbl(i).variable_value_id

515: and kart.document_type = p_mod_doc_type
516: and kart.document_id = p_mod_doc_id);
517:
518: forall i in 1..p_sys_var_val_tbl.count
519: update PO_OKC_VARS_GT set VARIABLE_VALUE = p_sys_var_val_tbl(i).variable_value_id
520: where doc_type = p_mod_doc_type
521: and doc_id = p_mod_doc_id
522: and variable_code = p_sys_var_val_tbl(i).variable_code;
523:

Line 536: insert into PO_OKC_VARS_GT(DOC_TYPE,

532: p_doc_id => p_base_doc_id,
533: p_only_doc_variables => FND_API.G_TRUE,
534: x_sys_var_value_tbl => p_bsys_var_val_tbl);
535: if p_bsys_var_val_tbl.count > 0 then
536: insert into PO_OKC_VARS_GT(DOC_TYPE,
537: DOC_ID,
538: ARTICLE_VERSION_ID,
539: cat_id,
540: VARIABLE_CODE

Line 549: update PO_OKC_VARS_GT set VARIABLE_VALUE = p_bsys_var_val_tbl(i).variable_value_id

545: and kart.document_type = p_base_doc_type
546: and kart.document_id = p_base_doc_id);
547:
548: forall i in 1..p_bsys_var_val_tbl.count
549: update PO_OKC_VARS_GT set VARIABLE_VALUE = p_bsys_var_val_tbl(i).variable_value_id
550: where doc_type = p_base_doc_type
551: and doc_id = p_base_doc_id
552: and variable_code = p_bsys_var_val_tbl(i).variable_code;
553: end if;

Line 557: -- get user defined variables for mod and base - this values are dumped in PO_OKC_VARS_GT

553: end if;
554:
555: end if;
556:
557: -- get user defined variables for mod and base - this values are dumped in PO_OKC_VARS_GT
558: open c_usr_var(p_mod_doc_type, p_mod_doc_id);
559: loop
560: fetch c_usr_var bulk collect into t_catId, t_artVerId, t_varCode, t_varval limit 1000;
561: exit when t_catId.count = 0;

Line 564: insert into PO_OKC_VARS_GT(DOC_TYPE,

560: fetch c_usr_var bulk collect into t_catId, t_artVerId, t_varCode, t_varval limit 1000;
561: exit when t_catId.count = 0;
562:
563: forall i in 1..t_catId.count
564: insert into PO_OKC_VARS_GT(DOC_TYPE,
565: DOC_ID,
566: ARTICLE_VERSION_ID,
567: cat_id,
568: VARIABLE_CODE,

Line 585: insert into PO_OKC_VARS_GT(DOC_TYPE,

581: fetch c_usr_var bulk collect into t_catId, t_artVerId, t_varCode, t_varval limit 1000;
582: exit when t_catId.count = 0;
583:
584: forall i in 1..t_catId.count
585: insert into PO_OKC_VARS_GT(DOC_TYPE,
586: DOC_ID,
587: ARTICLE_VERSION_ID,
588: cat_id,
589: VARIABLE_CODE,

Line 645: -- select * from OKC_TERMS_UDV_WITH_PROCEDURE_T/OKC_TERMS_CLM_UDV_T/PO_OKC_VARS_GT where document_type = mod and document_id = id;

641: X_MSG_COUNT => p_msg_count,
642: X_MSG_DATA => p_msg_data
643: );
644: -- the values for mod records will go into SGD XML for variable substitution
645: -- select * from OKC_TERMS_UDV_WITH_PROCEDURE_T/OKC_TERMS_CLM_UDV_T/PO_OKC_VARS_GT where document_type = mod and document_id = id;
646:
647: -- based on okc_k_art_variables for mod check values for all variables which have changed between mod and base n all of the GT above
648: -- if there are changed variables then find the clauses using them and report as changed in changed_clauses query of datatemplate
649: