521: mrvariablehtml_tbl(i),
522: mrvariablexml_tbl(i),
523: 1,
524: sysdate,
525: Fnd_Global.User_Id,
526: sysdate,
527: Fnd_Global.User_Id,
528: Fnd_Global.Login_Id);
529:
523: 1,
524: sysdate,
525: Fnd_Global.User_Id,
526: sysdate,
527: Fnd_Global.User_Id,
528: Fnd_Global.Login_Id);
529:
530: END IF;
531:
524: sysdate,
525: Fnd_Global.User_Id,
526: sysdate,
527: Fnd_Global.User_Id,
528: Fnd_Global.Login_Id);
529:
530: END IF;
531:
532: -- MRV changes Start
1552: Null,
1553: ref_article_id_tbl(i),
1554: ref_article_version_id_tbl(i),
1555: 1,
1556: Fnd_Global.User_Id,
1557: sysdate,
1558: Fnd_Global.User_Id,
1559: Fnd_Global.Login_Id,
1560: sysdate,
1554: ref_article_version_id_tbl(i),
1555: 1,
1556: Fnd_Global.User_Id,
1557: sysdate,
1558: Fnd_Global.User_Id,
1559: Fnd_Global.Login_Id,
1560: sysdate,
1561: orig_article_id_tbl1(i));
1562:
1555: 1,
1556: Fnd_Global.User_Id,
1557: sysdate,
1558: Fnd_Global.User_Id,
1559: Fnd_Global.Login_Id,
1560: sysdate,
1561: orig_article_id_tbl1(i));
1562:
1563: END IF;
2128: heading_tbl(i),
2129: scn_code_tbl(i),
2130: description_tbl(i),
2131: 1,
2132: Fnd_Global.User_Id,
2133: sysdate,
2134: Fnd_Global.User_Id,
2135: Fnd_Global.Login_Id,
2136: sysdate);
2130: description_tbl(i),
2131: 1,
2132: Fnd_Global.User_Id,
2133: sysdate,
2134: Fnd_Global.User_Id,
2135: Fnd_Global.Login_Id,
2136: sysdate);
2137:
2138: END IF;
2131: 1,
2132: Fnd_Global.User_Id,
2133: sysdate,
2134: Fnd_Global.User_Id,
2135: Fnd_Global.Login_Id,
2136: sysdate);
2137:
2138: END IF;
2139:
2342: END IF;
2343:
2344: UPDATE OKC_K_ARTICLES_B
2345: SET SCN_ID = l_unassigned_scn_id,
2346: LAST_UPDATED_BY = FND_GLOBAl.USER_ID,
2347: LAST_UPDATE_LOGIN = FND_GLOBAl.LOGIN_ID,
2348: LAST_UPDATE_DATE = sysdate
2349: WHERE DOCUMENT_TYPE = p_doc_type
2350: AND DOCUMENT_ID = p_doc_id
2343:
2344: UPDATE OKC_K_ARTICLES_B
2345: SET SCN_ID = l_unassigned_scn_id,
2346: LAST_UPDATED_BY = FND_GLOBAl.USER_ID,
2347: LAST_UPDATE_LOGIN = FND_GLOBAl.LOGIN_ID,
2348: LAST_UPDATE_DATE = sysdate
2349: WHERE DOCUMENT_TYPE = p_doc_type
2350: AND DOCUMENT_ID = p_doc_id
2351: AND SOURCE_FLAG IS NULL;
3405: SET TEMPLATE_ID = p_source_doc_id,
3406: DOC_NUMBERING_SCHEME = l_tmpl_rec.tmpl_numbering_scheme,
3407: ARTICLE_EFFECTIVE_DATE = p_article_effective_date, -- To Check and confirm with PMs
3408: CONTRACT_EXPERT_FINISH_FLAG = 'N',
3409: LAST_UPDATED_BY = FND_GLOBAl.USER_ID,
3410: LAST_UPDATE_LOGIN = FND_GLOBAl.LOGIN_ID,
3411: LAST_UPDATE_DATE = sysdate,
3412: CONTRACT_SOURCE_CODE = G_STRUCT_CONTRACT_SOURCE,
3413: AUTHORING_PARTY_CODE = G_INTERNAL_PARTY_CODE,
3406: DOC_NUMBERING_SCHEME = l_tmpl_rec.tmpl_numbering_scheme,
3407: ARTICLE_EFFECTIVE_DATE = p_article_effective_date, -- To Check and confirm with PMs
3408: CONTRACT_EXPERT_FINISH_FLAG = 'N',
3409: LAST_UPDATED_BY = FND_GLOBAl.USER_ID,
3410: LAST_UPDATE_LOGIN = FND_GLOBAl.LOGIN_ID,
3411: LAST_UPDATE_DATE = sysdate,
3412: CONTRACT_SOURCE_CODE = G_STRUCT_CONTRACT_SOURCE,
3413: AUTHORING_PARTY_CODE = G_INTERNAL_PARTY_CODE,
3414: CONTRACT_ADMIN_ID = p_contract_admin_id,
3434: ARTICLE_EFFECTIVE_DATE = p_article_effective_date, -- To Check and confirm with PMs
3435: CONFIG_HEADER_ID = NULL,
3436: CONFIG_REVISION_NUMBER = NULL,
3437: VALID_CONFIG_YN = NULL,
3438: LAST_UPDATED_BY = FND_GLOBAl.USER_ID,
3439: LAST_UPDATE_LOGIN = FND_GLOBAl.LOGIN_ID,
3440: LAST_UPDATE_DATE = sysdate,
3441: CONTRACT_SOURCE_CODE = G_STRUCT_CONTRACT_SOURCE,
3442: AUTHORING_PARTY_CODE = G_INTERNAL_PARTY_CODE,
3435: CONFIG_HEADER_ID = NULL,
3436: CONFIG_REVISION_NUMBER = NULL,
3437: VALID_CONFIG_YN = NULL,
3438: LAST_UPDATED_BY = FND_GLOBAl.USER_ID,
3439: LAST_UPDATE_LOGIN = FND_GLOBAl.LOGIN_ID,
3440: LAST_UPDATE_DATE = sysdate,
3441: CONTRACT_SOURCE_CODE = G_STRUCT_CONTRACT_SOURCE,
3442: AUTHORING_PARTY_CODE = G_INTERNAL_PARTY_CODE,
3443: CONTRACT_ADMIN_ID = p_contract_admin_id,
4059: var_value_id_tbl(i),
4060: override_global_yn_tbl(i),
4061: 1,
4062: sysdate,
4063: Fnd_Global.User_Id,
4064: sysdate,
4065: Fnd_Global.User_Id,
4066: Fnd_Global.Login_Id,
4067: mr_variable_html_tbl(i),
4061: 1,
4062: sysdate,
4063: Fnd_Global.User_Id,
4064: sysdate,
4065: Fnd_Global.User_Id,
4066: Fnd_Global.Login_Id,
4067: mr_variable_html_tbl(i),
4068: mr_variable_xml_tbl(i));
4069:
4062: sysdate,
4063: Fnd_Global.User_Id,
4064: sysdate,
4065: Fnd_Global.User_Id,
4066: Fnd_Global.Login_Id,
4067: mr_variable_html_tbl(i),
4068: mr_variable_xml_tbl(i));
4069:
4070: FOR i IN cat_tbl.FIRST..cat_tbl.LAST