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_TERMS_TMPL_APPROVAL_PVT dependencies on OKC_TMPL_DRAFT_CLAUSES

Line 331: in the OKC_TMPL_DRAFT_CLAUSES table

327: ---------------------------------------------------------------------------
328: /* added 2 new IN params and 1 out param
329: p_validation_level : 'A' or 'E' do all checks or checks with severity = E
330: p_check_for_drafts : 'Y' or 'N' if Y checks for drafts and inserts them
331: in the OKC_TMPL_DRAFT_CLAUSES table
332: x_sequence_id : contains the sequence id for table OKC_QA_ERRORS_T
333: that contains the validation results, is null if
334: no qa errors or warnings are found.
335:

Line 494: -- Insert records in OKC_TMPL_DRAFT_CLAUSES if p_check_for_drafts = Y

490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492:
493: -- 11.5.10+ changes
494: -- Insert records in OKC_TMPL_DRAFT_CLAUSES if p_check_for_drafts = Y
495: IF (p_check_for_drafts = 'Y') THEN
496:
497: OKC_TERMS_UTIL_PVT.create_tmpl_clauses_to_submit (
498: p_api_version => 1,

Line 795: -- update okc_tmpl_draft_clauses with the wf_seq_id

791: itemkey => l_itemkey,
792: owner => l_ProcessOwner );
793:
794: -- 11.5.10+ changes
795: -- update okc_tmpl_draft_clauses with the wf_seq_id
796: UPDATE OKC_TMPL_DRAFT_CLAUSES
797: SET WF_SEQ_ID = l_tmpl_rec.wf_sequence
798: WHERE template_id = p_template_id
799: AND nvl(selected_yn, 'N') = 'Y';

Line 796: UPDATE OKC_TMPL_DRAFT_CLAUSES

792: owner => l_ProcessOwner );
793:
794: -- 11.5.10+ changes
795: -- update okc_tmpl_draft_clauses with the wf_seq_id
796: UPDATE OKC_TMPL_DRAFT_CLAUSES
797: SET WF_SEQ_ID = l_tmpl_rec.wf_sequence
798: WHERE template_id = p_template_id
799: AND nvl(selected_yn, 'N') = 'Y';
800:

Line 802: DELETE OKC_TMPL_DRAFT_CLAUSES

798: WHERE template_id = p_template_id
799: AND nvl(selected_yn, 'N') = 'Y';
800:
801: -- delete all clauses with selectedYn= N, they are not required any more.
802: DELETE OKC_TMPL_DRAFT_CLAUSES
803: WHERE TEMPLATE_ID = p_template_id
804: AND nvl(selected_yn, 'N') = 'N';
805:
806: -- end of 11.5.10+ changes

Line 1443: Fecthes the article versions from table OKC_TMPL_DRAFT_CLAUSES and then

1439: -- Procedure change_clause_status
1440: ---------------------------------------------------------------------------
1441: /* 11.5.10+
1442: new procedure to change the status of articles submitted with a template
1443: Fecthes the article versions from table OKC_TMPL_DRAFT_CLAUSES and then
1444: calls article bulk api's to do the actual status changes.
1445:
1446: The following status changes are allowed
1447: DRAFT -> PENDING_APPROVAL

Line 1450: p_template_id Maps to document_id column in table OKC_TMPL_DRAFT_CLAUSES.

1446: The following status changes are allowed
1447: DRAFT -> PENDING_APPROVAL
1448: PENDING_APPROVAL -> APPROVED/REJECTED
1449:
1450: p_template_id Maps to document_id column in table OKC_TMPL_DRAFT_CLAUSES.
1451: p_wf_seq_id Maps to WF_SEQ_ID column in table OKC_TMPL_DRAFT_CLAUSES.
1452: p_status The status that the articles should be updated to,
1453: can be one of 3 values - 'PENDING_APPROVAL', 'APPROVED', 'REJECTED'.
1454: Error is thrown if the status is something else.

Line 1451: p_wf_seq_id Maps to WF_SEQ_ID column in table OKC_TMPL_DRAFT_CLAUSES.

1447: DRAFT -> PENDING_APPROVAL
1448: PENDING_APPROVAL -> APPROVED/REJECTED
1449:
1450: p_template_id Maps to document_id column in table OKC_TMPL_DRAFT_CLAUSES.
1451: p_wf_seq_id Maps to WF_SEQ_ID column in table OKC_TMPL_DRAFT_CLAUSES.
1452: p_status The status that the articles should be updated to,
1453: can be one of 3 values - 'PENDING_APPROVAL', 'APPROVED', 'REJECTED'.
1454: Error is thrown if the status is something else.
1455:

Line 1491: SELECT article_version_id from OKC_TMPL_DRAFT_CLAUSES

1487: SELECT org_id from OKC_TERMS_TEMPLATES_ALL
1488: WHERE template_id = cp_template_id;
1489:
1490: CURSOR l_tmpl_clauses_csr (cp_template_id IN NUMBER, cp_wf_seq_id IN NUMBER) IS
1491: SELECT article_version_id from OKC_TMPL_DRAFT_CLAUSES
1492: WHERE template_id = cp_template_id
1493: AND nvl(wf_seq_id, -99) = nvl(cp_wf_seq_id, -99) --[p_wf_seq_id can be null]
1494: AND selected_yn = 'Y';
1495:

Line 2005: okc_tmpl_draft_clauses otdc

2001:
2002: CURSOR global_articles_csr(cp_template_id in number,cp_wf_seq_id IN NUMBER) IS
2003: SELECT 1
2004: FROM okc_article_versions oav,
2005: okc_tmpl_draft_clauses otdc
2006: WHERE otdc.template_id = cp_template_id
2007: AND otdc.wf_seq_id = cp_wf_seq_id
2008: AND otdc.article_version_id = oav.article_version_id
2009: AND oav.global_yn = 'Y'

Line 2052: -- in table OKC_TMPL_DRAFT_CLAUSES will have the selected_yn flag set to Y

2048: --
2049: -- global_articles_exist
2050: -- IN
2051: -- p_template_id - A valid template id for which all draft clauses
2052: -- in table OKC_TMPL_DRAFT_CLAUSES will have the selected_yn flag set to Y
2053: --
2054: PROCEDURE select_draft_clauses(
2055: p_api_version IN NUMBER,
2056: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 2095: UPDATE OKC_TMPL_DRAFT_CLAUSES

2091:
2092: -- Initialize API return status to success
2093: x_return_status := FND_API.G_RET_STS_SUCCESS;
2094:
2095: UPDATE OKC_TMPL_DRAFT_CLAUSES
2096: SET selected_yn = 'Y'
2097: WHERE template_id = (
2098: select template_id from okc_terms_templates_all
2099: where template_id = p_template_id and status_code in ('DRAFT', 'REJECTED', 'REVISION'));