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_MIGRATE_GRP dependencies on OKC_SECTIONS_B

Line 1699: l_scn_id OKC_SECTIONS_B.ID%TYPE;

1695: )
1696: IS
1697: l_api_version CONSTANT NUMBER := 1;
1698: l_api_name CONSTANT VARCHAR2(30) := 'Add_Standard_Clause';
1699: l_scn_id OKC_SECTIONS_B.ID%TYPE;
1700: l_id NUMBER;
1701: l_ref_sequence NUMBER := 0;
1702: la_ref_sequence NUMBER := 0;
1703: ls_ref_sequence NUMBER := 0;

Line 1722: OKC_SECTIONS_B SEC

1718:
1719: CURSOR l_sec_id_validate_csr IS
1720: SELECT id
1721: FROM
1722: OKC_SECTIONS_B SEC
1723: WHERE SEC.ID = p_section_id
1724: AND DOCUMENT_TYPE = p_document_type
1725: AND DOCUMENT_ID = p_document_id;
1726:

Line 1730: OKC_SECTIONS_B SEC

1726:
1727: CURSOR l_sec_name_validate_csr IS
1728: SELECT id
1729: FROM
1730: OKC_SECTIONS_B SEC
1731: WHERE SEC.heading = p_section_name
1732: AND DOCUMENT_TYPE = p_document_type
1733: AND DOCUMENT_ID = p_document_id;
1734:

Line 1784: FROM OKC_SECTIONS_B

1780: AND ART.org_id = l_org_id;
1781:
1782: CURSOR ls_ref_seq_csr(lc_scn_id IN NUMBER) is
1783: SELECT nvl(max(section_sequence),0)
1784: FROM OKC_SECTIONS_B
1785: WHERE document_type = p_document_type
1786: AND document_id = p_document_id
1787: AND scn_id=lc_scn_id;
1788:

Line 2170: l_scn_id OKC_SECTIONS_B.ID%TYPE;

2166: l_api_version CONSTANT NUMBER := 1;
2167: l_api_name CONSTANT VARCHAR2(30) := 'Add_Non_Standard_Clause';
2168: l_cat_id NUMBER;
2169: l_article_version_id NUMBER;
2170: l_scn_id OKC_SECTIONS_B.ID%TYPE;
2171:
2172:
2173: CURSOR l_sec_id_validate_csr IS
2174: SELECT id

Line 2176: OKC_SECTIONS_B SEC

2172:
2173: CURSOR l_sec_id_validate_csr IS
2174: SELECT id
2175: FROM
2176: OKC_SECTIONS_B SEC
2177: WHERE SEC.ID = p_section_id
2178: AND DOCUMENT_TYPE = p_document_type
2179: AND DOCUMENT_ID = p_document_id;
2180:

Line 2184: OKC_SECTIONS_B SEC

2180:
2181: CURSOR l_sec_name_validate_csr IS
2182: SELECT id
2183: FROM
2184: OKC_SECTIONS_B SEC
2185: WHERE SEC.heading = p_section_name
2186: AND DOCUMENT_TYPE = p_document_type
2187: AND DOCUMENT_ID = p_document_id;
2188:

Line 2316: p_ref_id => l_scn_id ,-- Id of okc_sections_b or okc_articles_b depending upon ref type

2312: p_std_article_version_id => NULL,
2313: p_display_name => p_clause_disp_name,
2314: p_article_description => p_clause_description,
2315: p_ref_type => 'SECTION', -- 'ARTICLE' or 'SECTION'
2316: p_ref_id => l_scn_id ,-- Id of okc_sections_b or okc_articles_b depending upon ref type
2317: p_doc_type => p_document_type,
2318: p_doc_id => p_document_id,
2319: p_cat_id => NULL, -- Should be passed when exsisitng std is modified to make non-std.If it is passed then ref_type and ref_id doesnt need to be passed.
2320: p_amendment_description => NULL,

Line 2437: l_section_sequence OKC_SECTIONS_B.section_sequence%TYPE;

2433: l_api_version CONSTANT NUMBER := 1;
2434: l_api_name CONSTANT VARCHAR2(30) := 'add_section';
2435: l_scn_id NUMBER;
2436: l_dummy VARCHAR2(1) := NULL;
2437: l_section_sequence OKC_SECTIONS_B.section_sequence%TYPE;
2438: l_scn_code OKC_SECTIONS_B.scn_code%TYPE;
2439: l_scn_heading OKC_SECTIONS_B.heading%TYPE;
2440: l_scn_desc OKC_SECTIONS_B.description%TYPE;
2441: l_section_name OKC_SECTIONS_B.heading%TYPE;

Line 2438: l_scn_code OKC_SECTIONS_B.scn_code%TYPE;

2434: l_api_name CONSTANT VARCHAR2(30) := 'add_section';
2435: l_scn_id NUMBER;
2436: l_dummy VARCHAR2(1) := NULL;
2437: l_section_sequence OKC_SECTIONS_B.section_sequence%TYPE;
2438: l_scn_code OKC_SECTIONS_B.scn_code%TYPE;
2439: l_scn_heading OKC_SECTIONS_B.heading%TYPE;
2440: l_scn_desc OKC_SECTIONS_B.description%TYPE;
2441: l_section_name OKC_SECTIONS_B.heading%TYPE;
2442: l_section_description OKC_SECTIONS_B.description%TYPE;

Line 2439: l_scn_heading OKC_SECTIONS_B.heading%TYPE;

2435: l_scn_id NUMBER;
2436: l_dummy VARCHAR2(1) := NULL;
2437: l_section_sequence OKC_SECTIONS_B.section_sequence%TYPE;
2438: l_scn_code OKC_SECTIONS_B.scn_code%TYPE;
2439: l_scn_heading OKC_SECTIONS_B.heading%TYPE;
2440: l_scn_desc OKC_SECTIONS_B.description%TYPE;
2441: l_section_name OKC_SECTIONS_B.heading%TYPE;
2442: l_section_description OKC_SECTIONS_B.description%TYPE;
2443:

Line 2440: l_scn_desc OKC_SECTIONS_B.description%TYPE;

2436: l_dummy VARCHAR2(1) := NULL;
2437: l_section_sequence OKC_SECTIONS_B.section_sequence%TYPE;
2438: l_scn_code OKC_SECTIONS_B.scn_code%TYPE;
2439: l_scn_heading OKC_SECTIONS_B.heading%TYPE;
2440: l_scn_desc OKC_SECTIONS_B.description%TYPE;
2441: l_section_name OKC_SECTIONS_B.heading%TYPE;
2442: l_section_description OKC_SECTIONS_B.description%TYPE;
2443:
2444:

Line 2441: l_section_name OKC_SECTIONS_B.heading%TYPE;

2437: l_section_sequence OKC_SECTIONS_B.section_sequence%TYPE;
2438: l_scn_code OKC_SECTIONS_B.scn_code%TYPE;
2439: l_scn_heading OKC_SECTIONS_B.heading%TYPE;
2440: l_scn_desc OKC_SECTIONS_B.description%TYPE;
2441: l_section_name OKC_SECTIONS_B.heading%TYPE;
2442: l_section_description OKC_SECTIONS_B.description%TYPE;
2443:
2444:
2445: CURSOR l_sec_validate_csr IS

Line 2442: l_section_description OKC_SECTIONS_B.description%TYPE;

2438: l_scn_code OKC_SECTIONS_B.scn_code%TYPE;
2439: l_scn_heading OKC_SECTIONS_B.heading%TYPE;
2440: l_scn_desc OKC_SECTIONS_B.description%TYPE;
2441: l_section_name OKC_SECTIONS_B.heading%TYPE;
2442: l_section_description OKC_SECTIONS_B.description%TYPE;
2443:
2444:
2445: CURSOR l_sec_validate_csr IS
2446: SELECT lookup_code,meaning,description

Line 2455: OKC_SECTIONS_B

2451:
2452: CURSOR l_sec_seq_csr IS
2453: SELECT max(section_sequence)
2454: FROM
2455: OKC_SECTIONS_B
2456: WHERE document_id = p_document_id
2457: AND document_type = p_document_type
2458: AND scn_id IS NULL;
2459: