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 346: in the OKC_TMPL_DRAFT_CLAUSES table

342: ---------------------------------------------------------------------------
343: /* added 2 new IN params and 1 out param
344: p_validation_level : 'A' or 'E' do all checks or checks with severity = E
345: p_check_for_drafts : 'Y' or 'N' if Y checks for drafts and inserts them
346: in the OKC_TMPL_DRAFT_CLAUSES table
347: x_sequence_id : contains the sequence id for table OKC_QA_ERRORS_T
348: that contains the validation results, is null if
349: no qa errors or warnings are found.
350:

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

505: RAISE FND_API.G_EXC_ERROR;
506: END IF;
507:
508: -- 11.5.10+ changes
509: -- Insert records in OKC_TMPL_DRAFT_CLAUSES if p_check_for_drafts = Y
510: IF (p_check_for_drafts = 'Y') THEN
511:
512: OKC_TERMS_UTIL_PVT.create_tmpl_clauses_to_submit (
513: p_api_version => 1,

Line 810: -- update okc_tmpl_draft_clauses with the wf_seq_id

806: itemkey => l_itemkey,
807: owner => l_ProcessOwner );
808:
809: -- 11.5.10+ changes
810: -- update okc_tmpl_draft_clauses with the wf_seq_id
811: UPDATE OKC_TMPL_DRAFT_CLAUSES
812: SET WF_SEQ_ID = l_tmpl_rec.wf_sequence
813: WHERE template_id = p_template_id
814: AND nvl(selected_yn, 'N') = 'Y';

Line 811: UPDATE OKC_TMPL_DRAFT_CLAUSES

807: owner => l_ProcessOwner );
808:
809: -- 11.5.10+ changes
810: -- update okc_tmpl_draft_clauses with the wf_seq_id
811: UPDATE OKC_TMPL_DRAFT_CLAUSES
812: SET WF_SEQ_ID = l_tmpl_rec.wf_sequence
813: WHERE template_id = p_template_id
814: AND nvl(selected_yn, 'N') = 'Y';
815:

Line 817: DELETE OKC_TMPL_DRAFT_CLAUSES

813: WHERE template_id = p_template_id
814: AND nvl(selected_yn, 'N') = 'Y';
815:
816: -- delete all clauses with selectedYn= N, they are not required any more.
817: DELETE OKC_TMPL_DRAFT_CLAUSES
818: WHERE TEMPLATE_ID = p_template_id
819: AND nvl(selected_yn, 'N') = 'N';
820:
821: -- end of 11.5.10+ changes

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

1488: -- Procedure change_clause_status
1489: ---------------------------------------------------------------------------
1490: /* 11.5.10+
1491: new procedure to change the status of articles submitted with a template
1492: Fecthes the article versions from table OKC_TMPL_DRAFT_CLAUSES and then
1493: calls article bulk api's to do the actual status changes.
1494:
1495: The following status changes are allowed
1496: DRAFT -> PENDING_APPROVAL

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

1495: The following status changes are allowed
1496: DRAFT -> PENDING_APPROVAL
1497: PENDING_APPROVAL -> APPROVED/REJECTED
1498:
1499: p_template_id Maps to document_id column in table OKC_TMPL_DRAFT_CLAUSES.
1500: p_wf_seq_id Maps to WF_SEQ_ID column in table OKC_TMPL_DRAFT_CLAUSES.
1501: p_status The status that the articles should be updated to,
1502: can be one of 3 values - 'PENDING_APPROVAL', 'APPROVED', 'REJECTED'.
1503: Error is thrown if the status is something else.

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

1496: DRAFT -> PENDING_APPROVAL
1497: PENDING_APPROVAL -> APPROVED/REJECTED
1498:
1499: p_template_id Maps to document_id column in table OKC_TMPL_DRAFT_CLAUSES.
1500: p_wf_seq_id Maps to WF_SEQ_ID column in table OKC_TMPL_DRAFT_CLAUSES.
1501: p_status The status that the articles should be updated to,
1502: can be one of 3 values - 'PENDING_APPROVAL', 'APPROVED', 'REJECTED'.
1503: Error is thrown if the status is something else.
1504:

Line 1540: SELECT article_version_id from OKC_TMPL_DRAFT_CLAUSES

1536: SELECT org_id from OKC_TERMS_TEMPLATES_ALL
1537: WHERE template_id = cp_template_id;
1538:
1539: CURSOR l_tmpl_clauses_csr (cp_template_id IN NUMBER, cp_wf_seq_id IN NUMBER) IS
1540: SELECT article_version_id from OKC_TMPL_DRAFT_CLAUSES
1541: WHERE template_id = cp_template_id
1542: AND nvl(wf_seq_id, -99) = nvl(cp_wf_seq_id, -99) --[p_wf_seq_id can be null]
1543: AND selected_yn = 'Y';
1544:

Line 2055: okc_tmpl_draft_clauses otdc

2051:
2052: CURSOR global_articles_csr(cp_template_id in number,cp_wf_seq_id IN NUMBER) IS
2053: SELECT 1
2054: FROM okc_article_versions oav,
2055: okc_tmpl_draft_clauses otdc
2056: WHERE otdc.template_id = cp_template_id
2057: AND otdc.wf_seq_id = cp_wf_seq_id
2058: AND otdc.article_version_id = oav.article_version_id
2059: AND oav.global_yn = 'Y'

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

2118: --
2119: -- global_articles_exist
2120: -- IN
2121: -- p_template_id - A valid template id for which all draft clauses
2122: -- in table OKC_TMPL_DRAFT_CLAUSES will have the selected_yn flag set to Y
2123: --
2124: PROCEDURE select_draft_clauses(
2125: p_api_version IN NUMBER,
2126: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 2165: UPDATE OKC_TMPL_DRAFT_CLAUSES

2161:
2162: -- Initialize API return status to success
2163: x_return_status := FND_API.G_RET_STS_SUCCESS;
2164:
2165: UPDATE OKC_TMPL_DRAFT_CLAUSES
2166: SET selected_yn = 'Y'
2167: WHERE template_id = (
2168: select template_id from okc_terms_templates_all
2169: where template_id = p_template_id and status_code in ('DRAFT', 'REJECTED', 'REVISION'));