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

Line 833: 2. Update the table OKC_TMPL_DRAFT_CLAUSES with the merged/parent template id.

829: -- and working copy
830: -- 11.5.10+ changes
831: 1. Store the parent template id in a package global variable. This will retrieved
832: and returned by the overaloaded procedure.
833: 2. Update the table OKC_TMPL_DRAFT_CLAUSES with the merged/parent template id.
834: */
835: PROCEDURE Merge_Template_Working_Copy (
836: p_api_version IN NUMBER,
837: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 1167: -- Update OKC_TMPL_DRAFT_CLAUSES

1163: END IF;
1164: --------------------------------------------
1165:
1166: --------------------------------------------
1167: -- Update OKC_TMPL_DRAFT_CLAUSES
1168: --------------------------------------------
1169: UPDATE OKC_TMPL_DRAFT_CLAUSES
1170: SET template_id = l_base_template_id
1171: WHERE template_id = p_template_id;

Line 1169: UPDATE OKC_TMPL_DRAFT_CLAUSES

1165:
1166: --------------------------------------------
1167: -- Update OKC_TMPL_DRAFT_CLAUSES
1168: --------------------------------------------
1169: UPDATE OKC_TMPL_DRAFT_CLAUSES
1170: SET template_id = l_base_template_id
1171: WHERE template_id = p_template_id;
1172:
1173: -- Store the l_base_template_id in the package global variable for

Line 3588: -- looks in first in new table OKC_TMPL_DRAFT_CLAUSES if status

3584: /*
3585: -- 11.5.10+
3586: -- 2004/8/20 ANJKUMAR: overloaded function with additional params
3587: -- p_doc_type and p_doc_id, changes logic only for p_doc_type = 'TEMPLATE'
3588: -- looks in first in new table OKC_TMPL_DRAFT_CLAUSES if status
3589: -- DRAFT/REJECTED/PENDING_APPROVAL for article versions
3590: --
3591: */
3592: FUNCTION get_latest_tmpl_art_version_id(

Line 3609: -- new cursor to get draft/rejected versions from table OKC_TMPL_DRAFT_CLAUSES

3605: l_api_name CONSTANT VARCHAR2(30) := 'get_latest_tmpl_art_version_id';
3606: -- new variable
3607: l_stop BOOLEAN := TRUE;
3608:
3609: -- new cursor to get draft/rejected versions from table OKC_TMPL_DRAFT_CLAUSES
3610: CURSOR l_draft_selected_ver_csr IS
3611: SELECT ARTV.article_version_id
3612: FROM OKC_TMPL_DRAFT_CLAUSES TMPLC,
3613: OKC_ARTICLE_VERSIONS ARTV

Line 3612: FROM OKC_TMPL_DRAFT_CLAUSES TMPLC,

3608:
3609: -- new cursor to get draft/rejected versions from table OKC_TMPL_DRAFT_CLAUSES
3610: CURSOR l_draft_selected_ver_csr IS
3611: SELECT ARTV.article_version_id
3612: FROM OKC_TMPL_DRAFT_CLAUSES TMPLC,
3613: OKC_ARTICLE_VERSIONS ARTV
3614: WHERE TMPLC.template_id = p_doc_id
3615: AND TMPLC.article_id = p_article_id
3616: AND TMPLC.selected_yn = 'Y'

Line 3636: AND NOT EXISTS (SELECT 1 from OKC_TMPL_DRAFT_CLAUSES TMPLC

3632: AND cp_effective_date BETWEEN ver.start_date AND NVL(ver.end_date,cp_effective_date+1)
3633: -- begin change
3634: -- Bug 4021182, we cannot include pending approval, on hold or expired clauses here
3635: AND VER.article_status IN ('APPROVED', 'DRAFT', 'REJECTED')
3636: AND NOT EXISTS (SELECT 1 from OKC_TMPL_DRAFT_CLAUSES TMPLC
3637: WHERE TMPLC.template_id = p_doc_id
3638: AND TMPLC.article_id = p_article_id
3639: AND TMPLC.article_version_id = VER.article_version_id)
3640: -- end change

Line 3662: -- new cursor to get draft/rejected versions from table OKC_TMPL_DRAFT_CLAUSES

3658: --AND ver1.start_date <= cp_effective_date
3659: --AND ver1.article_status = 'APPROVED'
3660: );
3661:
3662: -- new cursor to get draft/rejected versions from table OKC_TMPL_DRAFT_CLAUSES
3663: CURSOR l_pen_app_selected_ver_csr IS
3664: SELECT ARTV.article_version_id
3665: FROM OKC_TMPL_DRAFT_CLAUSES TMPLC,
3666: OKC_ARTICLE_VERSIONS ARTV

Line 3665: FROM OKC_TMPL_DRAFT_CLAUSES TMPLC,

3661:
3662: -- new cursor to get draft/rejected versions from table OKC_TMPL_DRAFT_CLAUSES
3663: CURSOR l_pen_app_selected_ver_csr IS
3664: SELECT ARTV.article_version_id
3665: FROM OKC_TMPL_DRAFT_CLAUSES TMPLC,
3666: OKC_ARTICLE_VERSIONS ARTV
3667: WHERE TMPLC.template_id = p_doc_id
3668: AND TMPLC.article_id = p_article_id
3669: AND TMPLC.selected_yn = 'Y'

Line 3831: --finds draft clauses to be submitted with template and creates rows in OKC_TMPL_DRAFT_CLAUSES

3827: -- PROCEDURE create_tmpl_clauses_to_submit
3828: -------------------------------------------------------
3829: /*
3830: --11.5.10+
3831: --finds draft clauses to be submitted with template and creates rows in OKC_TMPL_DRAFT_CLAUSES
3832: --returns whether there is a draft clause through x_drafts_present
3833: */
3834: PROCEDURE create_tmpl_clauses_to_submit (
3835: p_api_version IN NUMBER,

Line 3928: -- it takes selected_yn flag value from table OKC_TMPL_DRAFT_CLAUSES

3924: WHERE lookup_code = 'UNASSIGNED' and lookup_type = 'OKC_ARTICLE_SECTION';
3925:
3926: -- muteshev bug#4327485 begin
3927: -- created new cursor selected_yn_csr
3928: -- it takes selected_yn flag value from table OKC_TMPL_DRAFT_CLAUSES
3929: cursor selected_yn_csr( cp_template_id number,
3930: cp_article_id number,
3931: cp_article_version_id number) is
3932: select selected_yn

Line 3933: from OKC_TMPL_DRAFT_CLAUSES

3929: cursor selected_yn_csr( cp_template_id number,
3930: cp_article_id number,
3931: cp_article_version_id number) is
3932: select selected_yn
3933: from OKC_TMPL_DRAFT_CLAUSES
3934: where template_id = cp_template_id
3935: and article_id = cp_article_id
3936: and article_version_id = cp_article_version_id;
3937: -- muteshev bug#4327485 end

Line 3942: TYPE article_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

3938:
3939: TYPE draft_articles_tbl_type is TABLE of draft_articles_csr%ROWTYPE INDEX BY BINARY_INTEGER;
3940: TYPE sec_details_tbl_type is TABLE of sec_name_csr%ROWTYPE INDEX BY BINARY_INTEGER ;
3941: TYPE section_label_tbl_type IS TABLE of OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER ;
3942: TYPE article_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3943: TYPE article_version_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
3944: TYPE section_name_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER ;
3945: TYPE article_label_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_LABEL%TYPE INDEX BY BINARY_INTEGER ;
3946: TYPE multiple_scns_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.MULTIPLE_SCNS_YN%TYPE INDEX BY BINARY_INTEGER ;

Line 3943: TYPE article_version_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;

3939: TYPE draft_articles_tbl_type is TABLE of draft_articles_csr%ROWTYPE INDEX BY BINARY_INTEGER;
3940: TYPE sec_details_tbl_type is TABLE of sec_name_csr%ROWTYPE INDEX BY BINARY_INTEGER ;
3941: TYPE section_label_tbl_type IS TABLE of OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER ;
3942: TYPE article_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3943: TYPE article_version_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
3944: TYPE section_name_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER ;
3945: TYPE article_label_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_LABEL%TYPE INDEX BY BINARY_INTEGER ;
3946: TYPE multiple_scns_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.MULTIPLE_SCNS_YN%TYPE INDEX BY BINARY_INTEGER ;
3947: TYPE prev_val_version_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.PREV_VAL_VERSION_YN%TYPE INDEX BY BINARY_INTEGER ;

Line 3944: TYPE section_name_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER ;

3940: TYPE sec_details_tbl_type is TABLE of sec_name_csr%ROWTYPE INDEX BY BINARY_INTEGER ;
3941: TYPE section_label_tbl_type IS TABLE of OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER ;
3942: TYPE article_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3943: TYPE article_version_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
3944: TYPE section_name_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER ;
3945: TYPE article_label_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_LABEL%TYPE INDEX BY BINARY_INTEGER ;
3946: TYPE multiple_scns_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.MULTIPLE_SCNS_YN%TYPE INDEX BY BINARY_INTEGER ;
3947: TYPE prev_val_version_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.PREV_VAL_VERSION_YN%TYPE INDEX BY BINARY_INTEGER ;
3948: TYPE selected_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SELECTED_YN%TYPE INDEX BY BINARY_INTEGER ;

Line 3945: TYPE article_label_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_LABEL%TYPE INDEX BY BINARY_INTEGER ;

3941: TYPE section_label_tbl_type IS TABLE of OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER ;
3942: TYPE article_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3943: TYPE article_version_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
3944: TYPE section_name_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER ;
3945: TYPE article_label_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_LABEL%TYPE INDEX BY BINARY_INTEGER ;
3946: TYPE multiple_scns_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.MULTIPLE_SCNS_YN%TYPE INDEX BY BINARY_INTEGER ;
3947: TYPE prev_val_version_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.PREV_VAL_VERSION_YN%TYPE INDEX BY BINARY_INTEGER ;
3948: TYPE selected_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SELECTED_YN%TYPE INDEX BY BINARY_INTEGER ;
3949:

Line 3946: TYPE multiple_scns_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.MULTIPLE_SCNS_YN%TYPE INDEX BY BINARY_INTEGER ;

3942: TYPE article_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3943: TYPE article_version_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
3944: TYPE section_name_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER ;
3945: TYPE article_label_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_LABEL%TYPE INDEX BY BINARY_INTEGER ;
3946: TYPE multiple_scns_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.MULTIPLE_SCNS_YN%TYPE INDEX BY BINARY_INTEGER ;
3947: TYPE prev_val_version_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.PREV_VAL_VERSION_YN%TYPE INDEX BY BINARY_INTEGER ;
3948: TYPE selected_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SELECTED_YN%TYPE INDEX BY BINARY_INTEGER ;
3949:
3950: draft_articles_tbl draft_articles_tbl_type;

Line 3947: TYPE prev_val_version_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.PREV_VAL_VERSION_YN%TYPE INDEX BY BINARY_INTEGER ;

3943: TYPE article_version_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
3944: TYPE section_name_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER ;
3945: TYPE article_label_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_LABEL%TYPE INDEX BY BINARY_INTEGER ;
3946: TYPE multiple_scns_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.MULTIPLE_SCNS_YN%TYPE INDEX BY BINARY_INTEGER ;
3947: TYPE prev_val_version_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.PREV_VAL_VERSION_YN%TYPE INDEX BY BINARY_INTEGER ;
3948: TYPE selected_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SELECTED_YN%TYPE INDEX BY BINARY_INTEGER ;
3949:
3950: draft_articles_tbl draft_articles_tbl_type;
3951: sec_details_tbl sec_details_tbl_type;

Line 3948: TYPE selected_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SELECTED_YN%TYPE INDEX BY BINARY_INTEGER ;

3944: TYPE section_name_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER ;
3945: TYPE article_label_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_LABEL%TYPE INDEX BY BINARY_INTEGER ;
3946: TYPE multiple_scns_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.MULTIPLE_SCNS_YN%TYPE INDEX BY BINARY_INTEGER ;
3947: TYPE prev_val_version_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.PREV_VAL_VERSION_YN%TYPE INDEX BY BINARY_INTEGER ;
3948: TYPE selected_yn_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SELECTED_YN%TYPE INDEX BY BINARY_INTEGER ;
3949:
3950: draft_articles_tbl draft_articles_tbl_type;
3951: sec_details_tbl sec_details_tbl_type;
3952:

Line 4086: DELETE FROM OKC_TMPL_DRAFT_CLAUSES

4082: draft_articles_tbl.DELETE;
4083:
4084:
4085: --delete old records associated with the template id
4086: DELETE FROM OKC_TMPL_DRAFT_CLAUSES
4087: WHERE template_id = p_template_id;
4088:
4089: IF article_id_tbl.COUNT > 0 THEN
4090: l_user_id := Fnd_Global.user_id;

Line 4095: INSERT INTO OKC_TMPL_DRAFT_CLAUSES

4091: l_login_id := Fnd_Global.login_id;
4092:
4093: FORALL i IN article_id_tbl.FIRST .. article_id_tbl.LAST
4094:
4095: INSERT INTO OKC_TMPL_DRAFT_CLAUSES
4096: (
4097: TEMPLATE_ID,
4098: ARTICLE_ID,
4099: ARTICLE_VERSION_ID,