APPS.OKS_CONTRACT_LINE_PUB dependencies on OKS_K_LINES_TL

Line 5: -- Translate OKS_K_LINES_TLH table (not included in Private TAPI)

1: PACKAGE BODY oks_contract_line_pub AS
2: /* $Header: OKSPKLNB.pls 120.1 2005/07/15 09:23:17 parkumar noship $ */
3: PROCEDURE add_language IS
4: BEGIN
5: -- Translate OKS_K_LINES_TLH table (not included in Private TAPI)
6: -- (To translate OKS_K_LINES_TL table call the procedure included
7: -- in the TAPI: OKS_KLN_PVT.add_language )
8: DELETE FROM OKS_K_LINES_TLH T
9: WHERE NOT EXISTS (

Line 6: -- (To translate OKS_K_LINES_TL table call the procedure included

2: /* $Header: OKSPKLNB.pls 120.1 2005/07/15 09:23:17 parkumar noship $ */
3: PROCEDURE add_language IS
4: BEGIN
5: -- Translate OKS_K_LINES_TLH table (not included in Private TAPI)
6: -- (To translate OKS_K_LINES_TL table call the procedure included
7: -- in the TAPI: OKS_KLN_PVT.add_language )
8: DELETE FROM OKS_K_LINES_TLH T
9: WHERE NOT EXISTS (
10: SELECT NULL

Line 8: DELETE FROM OKS_K_LINES_TLH T

4: BEGIN
5: -- Translate OKS_K_LINES_TLH table (not included in Private TAPI)
6: -- (To translate OKS_K_LINES_TL table call the procedure included
7: -- in the TAPI: OKS_KLN_PVT.add_language )
8: DELETE FROM OKS_K_LINES_TLH T
9: WHERE NOT EXISTS (
10: SELECT NULL
11: FROM OKS_K_LINES_BH B
12: WHERE B.ID =T.ID

Line 16: UPDATE OKS_K_LINES_TLH T SET(

12: WHERE B.ID =T.ID
13: AND B.MAJOR_VERSION =T.MAJOR_VERSION
14: );
15:
16: UPDATE OKS_K_LINES_TLH T SET(
17: INVOICE_TEXT,
18: IB_TRX_DETAILS,
19: STATUS_TEXT,
20: REACT_TIME_NAME) = (SELECT

Line 25: FROM OKS_K_LINES_TLH B

21: B.INVOICE_TEXT,
22: B.IB_TRX_DETAILS,
23: B.STATUS_TEXT,
24: B.REACT_TIME_NAME
25: FROM OKS_K_LINES_TLH B
26: WHERE B.ID = T.ID
27: AND B.MAJOR_VERSION = T.MAJOR_VERSION
28: AND B.LANGUAGE = T.SOURCE_LANG)
29: WHERE ( T.ID,

Line 36: FROM OKS_K_LINES_TLH SUBB, OKS_K_LINES_TLH SUBT

32: IN (SELECT
33: SUBT.ID,
34: SUBT.MAJOR_VERSION,
35: SUBT.LANGUAGE
36: FROM OKS_K_LINES_TLH SUBB, OKS_K_LINES_TLH SUBT
37: WHERE SUBB.ID = SUBT.ID
38: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
39: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
40: AND (SUBB.INVOICE_TEXT <> SUBT.INVOICE_TEXT

Line 50: INSERT INTO OKS_K_LINES_TLH (

46: OR (SUBB.STATUS_TEXT IS NULL AND SUBT.STATUS_TEXT IS NOT NULL)
47: OR (SUBB.REACT_TIME_NAME IS NULL AND SUBT.REACT_TIME_NAME IS NOT NULL)
48: ));
49:
50: INSERT INTO OKS_K_LINES_TLH (
51: ID,
52: MAJOR_VERSION,
53: LANGUAGE,
54: SOURCE_LANG,

Line 80: FROM OKS_K_LINES_TLH B, FND_LANGUAGES L

76: B.CREATION_DATE,
77: B.LAST_UPDATED_BY,
78: B.LAST_UPDATE_DATE,
79: B.LAST_UPDATE_LOGIN
80: FROM OKS_K_LINES_TLH B, FND_LANGUAGES L
81: WHERE L.INSTALLED_FLAG IN ('I', 'B')
82: AND B.LANGUAGE = USERENV('LANG')
83: AND NOT EXISTS (
84: SELECT NULL

Line 85: FROM OKS_K_LINES_TLH T

81: WHERE L.INSTALLED_FLAG IN ('I', 'B')
82: AND B.LANGUAGE = USERENV('LANG')
83: AND NOT EXISTS (
84: SELECT NULL
85: FROM OKS_K_LINES_TLH T
86: WHERE T.ID = B.ID
87: AND T.MAJOR_VERSION = B.MAJOR_VERSION
88: AND T.LANGUAGE = L.LANGUAGE_CODE
89: );

Line 865: INSERT INTO OKS_K_LINES_TL(

861: );
862:
863: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
864: FORALL i in 1..l_tabsize
865: INSERT INTO OKS_K_LINES_TL(
866: id,
867: language,
868: source_lang,
869: sfwt_flag,

Line 916: -- Procedure for mass insert in OKS_K_LINES_BH and OKS_K_LINES_TLH

912: --RAISE;
913: END INSERT_ROW_UPG;
914:
915: -------------------------------------------------------------------
916: -- Procedure for mass insert in OKS_K_LINES_BH and OKS_K_LINES_TLH
917: -------------------------------------------------------------------
918: PROCEDURE CREATE_LINE_VERSION_UPG(x_return_status OUT NOCOPY VARCHAR2,
919: p_klnhv_tbl IN klnhv_tbl_type) IS
920:

Line 1315: Insert Into oks_k_lines_tlh

1311: );
1312:
1313: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
1314: FORALL i in 1..l_tabsize
1315: Insert Into oks_k_lines_tlh
1316: (
1317: id ,
1318: major_version,
1319: language ,