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_PDP_PVT dependencies on OKC_PROCESS_DEF_PARMS_TL

Line 47: DELETE FROM OKC_PROCESS_DEF_PARMS_TL T

43: -- PROCEDURE add_language
44: ---------------------------------------------------------------------------
45: PROCEDURE add_language IS
46: BEGIN
47: DELETE FROM OKC_PROCESS_DEF_PARMS_TL T
48: WHERE NOT EXISTS (
49: SELECT NULL
50: FROM OKC_PROCESS_DEF_PARMS_B B
51: WHERE B.ID = T.ID

Line 54: UPDATE OKC_PROCESS_DEF_PARMS_TL T SET (

50: FROM OKC_PROCESS_DEF_PARMS_B B
51: WHERE B.ID = T.ID
52: );
53:
54: UPDATE OKC_PROCESS_DEF_PARMS_TL T SET (
55: NAME,
56: DESCRIPTION) = (SELECT
57: B.NAME,
58: B.DESCRIPTION

Line 59: FROM OKC_PROCESS_DEF_PARMS_TL B

55: NAME,
56: DESCRIPTION) = (SELECT
57: B.NAME,
58: B.DESCRIPTION
59: FROM OKC_PROCESS_DEF_PARMS_TL B
60: WHERE B.ID = T.ID
61: AND B.LANGUAGE = T.SOURCE_LANG)
62: WHERE (
63: T.ID,

Line 68: FROM OKC_PROCESS_DEF_PARMS_TL SUBB, OKC_PROCESS_DEF_PARMS_TL SUBT

64: T.LANGUAGE)
65: IN (SELECT
66: SUBT.ID,
67: SUBT.LANGUAGE
68: FROM OKC_PROCESS_DEF_PARMS_TL SUBB, OKC_PROCESS_DEF_PARMS_TL SUBT
69: WHERE SUBB.ID = SUBT.ID
70: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
71: AND (SUBB.NAME <> SUBT.NAME
72: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 77: INSERT INTO OKC_PROCESS_DEF_PARMS_TL (

73: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
74: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
75: ));
76:
77: INSERT INTO OKC_PROCESS_DEF_PARMS_TL (
78: ID,
79: LANGUAGE,
80: SOURCE_LANG,
81: SFWT_FLAG,

Line 101: FROM OKC_PROCESS_DEF_PARMS_TL B, FND_LANGUAGES L

97: B.CREATION_DATE,
98: B.LAST_UPDATED_BY,
99: B.LAST_UPDATE_DATE,
100: B.LAST_UPDATE_LOGIN
101: FROM OKC_PROCESS_DEF_PARMS_TL B, FND_LANGUAGES L
102: WHERE L.INSTALLED_FLAG IN ('I', 'B')
103: AND B.LANGUAGE = USERENV('LANG')
104: AND NOT EXISTS(
105: SELECT NULL

Line 106: FROM OKC_PROCESS_DEF_PARMS_TL T

102: WHERE L.INSTALLED_FLAG IN ('I', 'B')
103: AND B.LANGUAGE = USERENV('LANG')
104: AND NOT EXISTS(
105: SELECT NULL
106: FROM OKC_PROCESS_DEF_PARMS_TL T
107: WHERE T.ID = B.ID
108: AND T.LANGUAGE = L.LANGUAGE_CODE
109: );
110:

Line 114: -- FUNCTION get_rec for: OKC_PROCESS_DEF_PARMS_TL

110:
111: END add_language;
112:
113: ---------------------------------------------------------------------------
114: -- FUNCTION get_rec for: OKC_PROCESS_DEF_PARMS_TL
115: ---------------------------------------------------------------------------
116: FUNCTION get_rec (
117: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
118: x_no_data_found OUT NOCOPY BOOLEAN

Line 117: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,

113: ---------------------------------------------------------------------------
114: -- FUNCTION get_rec for: OKC_PROCESS_DEF_PARMS_TL
115: ---------------------------------------------------------------------------
116: FUNCTION get_rec (
117: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
118: x_no_data_found OUT NOCOPY BOOLEAN
119: ) RETURN OkcProcessDefParmsTlRecType IS
120: CURSOR okc_process_def_parm1_csr (p_id IN NUMBER,
121: p_language IN VARCHAR2) IS

Line 134: FROM Okc_Process_Def_Parms_Tl

130: CREATION_DATE,
131: LAST_UPDATED_BY,
132: LAST_UPDATE_DATE,
133: LAST_UPDATE_LOGIN
134: FROM Okc_Process_Def_Parms_Tl
135: WHERE okc_process_def_parms_tl.id = p_id
136: AND okc_process_def_parms_tl.language = p_language;
137: l_okc_process_def_parms_tl_pk okc_process_def_parm1_csr%ROWTYPE;
138: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;

Line 135: WHERE okc_process_def_parms_tl.id = p_id

131: LAST_UPDATED_BY,
132: LAST_UPDATE_DATE,
133: LAST_UPDATE_LOGIN
134: FROM Okc_Process_Def_Parms_Tl
135: WHERE okc_process_def_parms_tl.id = p_id
136: AND okc_process_def_parms_tl.language = p_language;
137: l_okc_process_def_parms_tl_pk okc_process_def_parm1_csr%ROWTYPE;
138: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
139: BEGIN

Line 136: AND okc_process_def_parms_tl.language = p_language;

132: LAST_UPDATE_DATE,
133: LAST_UPDATE_LOGIN
134: FROM Okc_Process_Def_Parms_Tl
135: WHERE okc_process_def_parms_tl.id = p_id
136: AND okc_process_def_parms_tl.language = p_language;
137: l_okc_process_def_parms_tl_pk okc_process_def_parm1_csr%ROWTYPE;
138: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
139: BEGIN
140: x_no_data_found := TRUE;

Line 137: l_okc_process_def_parms_tl_pk okc_process_def_parm1_csr%ROWTYPE;

133: LAST_UPDATE_LOGIN
134: FROM Okc_Process_Def_Parms_Tl
135: WHERE okc_process_def_parms_tl.id = p_id
136: AND okc_process_def_parms_tl.language = p_language;
137: l_okc_process_def_parms_tl_pk okc_process_def_parm1_csr%ROWTYPE;
138: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
139: BEGIN
140: x_no_data_found := TRUE;
141: -- Get current database values

Line 138: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;

134: FROM Okc_Process_Def_Parms_Tl
135: WHERE okc_process_def_parms_tl.id = p_id
136: AND okc_process_def_parms_tl.language = p_language;
137: l_okc_process_def_parms_tl_pk okc_process_def_parm1_csr%ROWTYPE;
138: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
139: BEGIN
140: x_no_data_found := TRUE;
141: -- Get current database values
142: OPEN okc_process_def_parm1_csr (p_okc_process_def_parms_tl_rec.id,

Line 142: OPEN okc_process_def_parm1_csr (p_okc_process_def_parms_tl_rec.id,

138: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
139: BEGIN
140: x_no_data_found := TRUE;
141: -- Get current database values
142: OPEN okc_process_def_parm1_csr (p_okc_process_def_parms_tl_rec.id,
143: p_okc_process_def_parms_tl_rec.language);
144: FETCH okc_process_def_parm1_csr INTO
145: l_okc_process_def_parms_tl_rec.ID,
146: l_okc_process_def_parms_tl_rec.LANGUAGE,

Line 143: p_okc_process_def_parms_tl_rec.language);

139: BEGIN
140: x_no_data_found := TRUE;
141: -- Get current database values
142: OPEN okc_process_def_parm1_csr (p_okc_process_def_parms_tl_rec.id,
143: p_okc_process_def_parms_tl_rec.language);
144: FETCH okc_process_def_parm1_csr INTO
145: l_okc_process_def_parms_tl_rec.ID,
146: l_okc_process_def_parms_tl_rec.LANGUAGE,
147: l_okc_process_def_parms_tl_rec.SOURCE_LANG,

Line 145: l_okc_process_def_parms_tl_rec.ID,

141: -- Get current database values
142: OPEN okc_process_def_parm1_csr (p_okc_process_def_parms_tl_rec.id,
143: p_okc_process_def_parms_tl_rec.language);
144: FETCH okc_process_def_parm1_csr INTO
145: l_okc_process_def_parms_tl_rec.ID,
146: l_okc_process_def_parms_tl_rec.LANGUAGE,
147: l_okc_process_def_parms_tl_rec.SOURCE_LANG,
148: l_okc_process_def_parms_tl_rec.SFWT_FLAG,
149: l_okc_process_def_parms_tl_rec.NAME,

Line 146: l_okc_process_def_parms_tl_rec.LANGUAGE,

142: OPEN okc_process_def_parm1_csr (p_okc_process_def_parms_tl_rec.id,
143: p_okc_process_def_parms_tl_rec.language);
144: FETCH okc_process_def_parm1_csr INTO
145: l_okc_process_def_parms_tl_rec.ID,
146: l_okc_process_def_parms_tl_rec.LANGUAGE,
147: l_okc_process_def_parms_tl_rec.SOURCE_LANG,
148: l_okc_process_def_parms_tl_rec.SFWT_FLAG,
149: l_okc_process_def_parms_tl_rec.NAME,
150: l_okc_process_def_parms_tl_rec.DESCRIPTION,

Line 147: l_okc_process_def_parms_tl_rec.SOURCE_LANG,

143: p_okc_process_def_parms_tl_rec.language);
144: FETCH okc_process_def_parm1_csr INTO
145: l_okc_process_def_parms_tl_rec.ID,
146: l_okc_process_def_parms_tl_rec.LANGUAGE,
147: l_okc_process_def_parms_tl_rec.SOURCE_LANG,
148: l_okc_process_def_parms_tl_rec.SFWT_FLAG,
149: l_okc_process_def_parms_tl_rec.NAME,
150: l_okc_process_def_parms_tl_rec.DESCRIPTION,
151: l_okc_process_def_parms_tl_rec.CREATED_BY,

Line 148: l_okc_process_def_parms_tl_rec.SFWT_FLAG,

144: FETCH okc_process_def_parm1_csr INTO
145: l_okc_process_def_parms_tl_rec.ID,
146: l_okc_process_def_parms_tl_rec.LANGUAGE,
147: l_okc_process_def_parms_tl_rec.SOURCE_LANG,
148: l_okc_process_def_parms_tl_rec.SFWT_FLAG,
149: l_okc_process_def_parms_tl_rec.NAME,
150: l_okc_process_def_parms_tl_rec.DESCRIPTION,
151: l_okc_process_def_parms_tl_rec.CREATED_BY,
152: l_okc_process_def_parms_tl_rec.CREATION_DATE,

Line 149: l_okc_process_def_parms_tl_rec.NAME,

145: l_okc_process_def_parms_tl_rec.ID,
146: l_okc_process_def_parms_tl_rec.LANGUAGE,
147: l_okc_process_def_parms_tl_rec.SOURCE_LANG,
148: l_okc_process_def_parms_tl_rec.SFWT_FLAG,
149: l_okc_process_def_parms_tl_rec.NAME,
150: l_okc_process_def_parms_tl_rec.DESCRIPTION,
151: l_okc_process_def_parms_tl_rec.CREATED_BY,
152: l_okc_process_def_parms_tl_rec.CREATION_DATE,
153: l_okc_process_def_parms_tl_rec.LAST_UPDATED_BY,

Line 150: l_okc_process_def_parms_tl_rec.DESCRIPTION,

146: l_okc_process_def_parms_tl_rec.LANGUAGE,
147: l_okc_process_def_parms_tl_rec.SOURCE_LANG,
148: l_okc_process_def_parms_tl_rec.SFWT_FLAG,
149: l_okc_process_def_parms_tl_rec.NAME,
150: l_okc_process_def_parms_tl_rec.DESCRIPTION,
151: l_okc_process_def_parms_tl_rec.CREATED_BY,
152: l_okc_process_def_parms_tl_rec.CREATION_DATE,
153: l_okc_process_def_parms_tl_rec.LAST_UPDATED_BY,
154: l_okc_process_def_parms_tl_rec.LAST_UPDATE_DATE,

Line 151: l_okc_process_def_parms_tl_rec.CREATED_BY,

147: l_okc_process_def_parms_tl_rec.SOURCE_LANG,
148: l_okc_process_def_parms_tl_rec.SFWT_FLAG,
149: l_okc_process_def_parms_tl_rec.NAME,
150: l_okc_process_def_parms_tl_rec.DESCRIPTION,
151: l_okc_process_def_parms_tl_rec.CREATED_BY,
152: l_okc_process_def_parms_tl_rec.CREATION_DATE,
153: l_okc_process_def_parms_tl_rec.LAST_UPDATED_BY,
154: l_okc_process_def_parms_tl_rec.LAST_UPDATE_DATE,
155: l_okc_process_def_parms_tl_rec.LAST_UPDATE_LOGIN;

Line 152: l_okc_process_def_parms_tl_rec.CREATION_DATE,

148: l_okc_process_def_parms_tl_rec.SFWT_FLAG,
149: l_okc_process_def_parms_tl_rec.NAME,
150: l_okc_process_def_parms_tl_rec.DESCRIPTION,
151: l_okc_process_def_parms_tl_rec.CREATED_BY,
152: l_okc_process_def_parms_tl_rec.CREATION_DATE,
153: l_okc_process_def_parms_tl_rec.LAST_UPDATED_BY,
154: l_okc_process_def_parms_tl_rec.LAST_UPDATE_DATE,
155: l_okc_process_def_parms_tl_rec.LAST_UPDATE_LOGIN;
156: x_no_data_found := okc_process_def_parm1_csr%NOTFOUND;

Line 153: l_okc_process_def_parms_tl_rec.LAST_UPDATED_BY,

149: l_okc_process_def_parms_tl_rec.NAME,
150: l_okc_process_def_parms_tl_rec.DESCRIPTION,
151: l_okc_process_def_parms_tl_rec.CREATED_BY,
152: l_okc_process_def_parms_tl_rec.CREATION_DATE,
153: l_okc_process_def_parms_tl_rec.LAST_UPDATED_BY,
154: l_okc_process_def_parms_tl_rec.LAST_UPDATE_DATE,
155: l_okc_process_def_parms_tl_rec.LAST_UPDATE_LOGIN;
156: x_no_data_found := okc_process_def_parm1_csr%NOTFOUND;
157: CLOSE okc_process_def_parm1_csr;

Line 154: l_okc_process_def_parms_tl_rec.LAST_UPDATE_DATE,

150: l_okc_process_def_parms_tl_rec.DESCRIPTION,
151: l_okc_process_def_parms_tl_rec.CREATED_BY,
152: l_okc_process_def_parms_tl_rec.CREATION_DATE,
153: l_okc_process_def_parms_tl_rec.LAST_UPDATED_BY,
154: l_okc_process_def_parms_tl_rec.LAST_UPDATE_DATE,
155: l_okc_process_def_parms_tl_rec.LAST_UPDATE_LOGIN;
156: x_no_data_found := okc_process_def_parm1_csr%NOTFOUND;
157: CLOSE okc_process_def_parm1_csr;
158: RETURN(l_okc_process_def_parms_tl_rec);

Line 155: l_okc_process_def_parms_tl_rec.LAST_UPDATE_LOGIN;

151: l_okc_process_def_parms_tl_rec.CREATED_BY,
152: l_okc_process_def_parms_tl_rec.CREATION_DATE,
153: l_okc_process_def_parms_tl_rec.LAST_UPDATED_BY,
154: l_okc_process_def_parms_tl_rec.LAST_UPDATE_DATE,
155: l_okc_process_def_parms_tl_rec.LAST_UPDATE_LOGIN;
156: x_no_data_found := okc_process_def_parm1_csr%NOTFOUND;
157: CLOSE okc_process_def_parm1_csr;
158: RETURN(l_okc_process_def_parms_tl_rec);
159: END get_rec;

Line 158: RETURN(l_okc_process_def_parms_tl_rec);

154: l_okc_process_def_parms_tl_rec.LAST_UPDATE_DATE,
155: l_okc_process_def_parms_tl_rec.LAST_UPDATE_LOGIN;
156: x_no_data_found := okc_process_def_parm1_csr%NOTFOUND;
157: CLOSE okc_process_def_parm1_csr;
158: RETURN(l_okc_process_def_parms_tl_rec);
159: END get_rec;
160:
161: FUNCTION get_rec (
162: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType

Line 162: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType

158: RETURN(l_okc_process_def_parms_tl_rec);
159: END get_rec;
160:
161: FUNCTION get_rec (
162: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType
163: ) RETURN OkcProcessDefParmsTlRecType IS
164: l_row_notfound BOOLEAN := TRUE;
165: BEGIN
166: RETURN(get_rec(p_okc_process_def_parms_tl_rec, l_row_notfound));

Line 166: RETURN(get_rec(p_okc_process_def_parms_tl_rec, l_row_notfound));

162: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType
163: ) RETURN OkcProcessDefParmsTlRecType IS
164: l_row_notfound BOOLEAN := TRUE;
165: BEGIN
166: RETURN(get_rec(p_okc_process_def_parms_tl_rec, l_row_notfound));
167: END get_rec;
168: ---------------------------------------------------------------------------
169: -- FUNCTION get_rec for: OKC_PROCESS_DEF_PARMS_B
170: ---------------------------------------------------------------------------

Line 1283: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;

1279: l_api_version CONSTANT NUMBER := 1;
1280: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1281: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1282: l_pdpv_rec pdpv_rec_type := p_pdpv_rec;
1283: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
1284: l_pdp_rec pdp_rec_type;
1285: BEGIN
1286: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1287: G_PKG_NAME,

Line 1414: -- insert_row for:OKC_PROCESS_DEF_PARMS_TL --

1410: ---------------------------------------------------------------------------
1411: -- PROCEDURE insert_row
1412: ---------------------------------------------------------------------------
1413: ---------------------------------------------
1414: -- insert_row for:OKC_PROCESS_DEF_PARMS_TL --
1415: ---------------------------------------------
1416: PROCEDURE insert_row(
1417: p_init_msg_list IN VARCHAR2 ,
1418: x_return_status OUT NOCOPY VARCHAR2,

Line 1421: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,

1417: p_init_msg_list IN VARCHAR2 ,
1418: x_return_status OUT NOCOPY VARCHAR2,
1419: x_msg_count OUT NOCOPY NUMBER,
1420: x_msg_data OUT NOCOPY VARCHAR2,
1421: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
1422: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType) IS
1423:
1424: l_api_version CONSTANT NUMBER := 1;
1425: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1422: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType) IS

1418: x_return_status OUT NOCOPY VARCHAR2,
1419: x_msg_count OUT NOCOPY NUMBER,
1420: x_msg_data OUT NOCOPY VARCHAR2,
1421: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
1422: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType) IS
1423:
1424: l_api_version CONSTANT NUMBER := 1;
1425: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1426: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1427: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType := p_okc_process_def_parms_tl_rec;

1423:
1424: l_api_version CONSTANT NUMBER := 1;
1425: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1426: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1427: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType := p_okc_process_def_parms_tl_rec;
1428: ldefokcprocessdefparmstlrec OkcProcessDefParmsTlRecType;
1429: CURSOR get_languages IS
1430: SELECT *
1431: FROM FND_LANGUAGES

Line 1434: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --

1430: SELECT *
1431: FROM FND_LANGUAGES
1432: WHERE INSTALLED_FLAG IN ('I', 'B');
1433: -------------------------------------------------
1434: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --
1435: -------------------------------------------------
1436: FUNCTION Set_Attributes (
1437: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
1438: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType

Line 1437: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,

1433: -------------------------------------------------
1434: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --
1435: -------------------------------------------------
1436: FUNCTION Set_Attributes (
1437: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
1438: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
1439: ) RETURN VARCHAR2 IS
1440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1441: BEGIN

Line 1438: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType

1434: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --
1435: -------------------------------------------------
1436: FUNCTION Set_Attributes (
1437: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
1438: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
1439: ) RETURN VARCHAR2 IS
1440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1441: BEGIN
1442: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;

Line 1442: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;

1438: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
1439: ) RETURN VARCHAR2 IS
1440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1441: BEGIN
1442: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;
1443: x_okc_process_def_parms_tl_rec.LANGUAGE := l_lang;
1444: x_okc_process_def_parms_tl_rec.SOURCE_LANG := l_lang;
1445: RETURN(l_return_status);
1446: END Set_Attributes;

Line 1443: x_okc_process_def_parms_tl_rec.LANGUAGE := l_lang;

1439: ) RETURN VARCHAR2 IS
1440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1441: BEGIN
1442: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;
1443: x_okc_process_def_parms_tl_rec.LANGUAGE := l_lang;
1444: x_okc_process_def_parms_tl_rec.SOURCE_LANG := l_lang;
1445: RETURN(l_return_status);
1446: END Set_Attributes;
1447: BEGIN

Line 1444: x_okc_process_def_parms_tl_rec.SOURCE_LANG := l_lang;

1440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1441: BEGIN
1442: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;
1443: x_okc_process_def_parms_tl_rec.LANGUAGE := l_lang;
1444: x_okc_process_def_parms_tl_rec.SOURCE_LANG := l_lang;
1445: RETURN(l_return_status);
1446: END Set_Attributes;
1447: BEGIN
1448: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1459: p_okc_process_def_parms_tl_rec, -- IN

1455: RAISE OKC_API.G_EXCEPTION_ERROR;
1456: END IF;
1457: --- Setting item attributes
1458: l_return_status := Set_Attributes(
1459: p_okc_process_def_parms_tl_rec, -- IN
1460: l_okc_process_def_parms_tl_rec); -- OUT
1461: --- If any errors happen abort API
1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1460: l_okc_process_def_parms_tl_rec); -- OUT

1456: END IF;
1457: --- Setting item attributes
1458: l_return_status := Set_Attributes(
1459: p_okc_process_def_parms_tl_rec, -- IN
1460: l_okc_process_def_parms_tl_rec); -- OUT
1461: --- If any errors happen abort API
1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1468: l_okc_process_def_parms_tl_rec.language := l_lang_rec.language_code;

1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1465: RAISE OKC_API.G_EXCEPTION_ERROR;
1466: END IF;
1467: FOR l_lang_rec IN get_languages LOOP
1468: l_okc_process_def_parms_tl_rec.language := l_lang_rec.language_code;
1469: INSERT INTO OKC_PROCESS_DEF_PARMS_TL(
1470: id,
1471: language,
1472: source_lang,

Line 1469: INSERT INTO OKC_PROCESS_DEF_PARMS_TL(

1465: RAISE OKC_API.G_EXCEPTION_ERROR;
1466: END IF;
1467: FOR l_lang_rec IN get_languages LOOP
1468: l_okc_process_def_parms_tl_rec.language := l_lang_rec.language_code;
1469: INSERT INTO OKC_PROCESS_DEF_PARMS_TL(
1470: id,
1471: language,
1472: source_lang,
1473: sfwt_flag,

Line 1482: l_okc_process_def_parms_tl_rec.id,

1478: last_updated_by,
1479: last_update_date,
1480: last_update_login)
1481: VALUES (
1482: l_okc_process_def_parms_tl_rec.id,
1483: l_okc_process_def_parms_tl_rec.language,
1484: l_okc_process_def_parms_tl_rec.source_lang,
1485: l_okc_process_def_parms_tl_rec.sfwt_flag,
1486: l_okc_process_def_parms_tl_rec.name,

Line 1483: l_okc_process_def_parms_tl_rec.language,

1479: last_update_date,
1480: last_update_login)
1481: VALUES (
1482: l_okc_process_def_parms_tl_rec.id,
1483: l_okc_process_def_parms_tl_rec.language,
1484: l_okc_process_def_parms_tl_rec.source_lang,
1485: l_okc_process_def_parms_tl_rec.sfwt_flag,
1486: l_okc_process_def_parms_tl_rec.name,
1487: l_okc_process_def_parms_tl_rec.description,

Line 1484: l_okc_process_def_parms_tl_rec.source_lang,

1480: last_update_login)
1481: VALUES (
1482: l_okc_process_def_parms_tl_rec.id,
1483: l_okc_process_def_parms_tl_rec.language,
1484: l_okc_process_def_parms_tl_rec.source_lang,
1485: l_okc_process_def_parms_tl_rec.sfwt_flag,
1486: l_okc_process_def_parms_tl_rec.name,
1487: l_okc_process_def_parms_tl_rec.description,
1488: l_okc_process_def_parms_tl_rec.created_by,

Line 1485: l_okc_process_def_parms_tl_rec.sfwt_flag,

1481: VALUES (
1482: l_okc_process_def_parms_tl_rec.id,
1483: l_okc_process_def_parms_tl_rec.language,
1484: l_okc_process_def_parms_tl_rec.source_lang,
1485: l_okc_process_def_parms_tl_rec.sfwt_flag,
1486: l_okc_process_def_parms_tl_rec.name,
1487: l_okc_process_def_parms_tl_rec.description,
1488: l_okc_process_def_parms_tl_rec.created_by,
1489: l_okc_process_def_parms_tl_rec.creation_date,

Line 1486: l_okc_process_def_parms_tl_rec.name,

1482: l_okc_process_def_parms_tl_rec.id,
1483: l_okc_process_def_parms_tl_rec.language,
1484: l_okc_process_def_parms_tl_rec.source_lang,
1485: l_okc_process_def_parms_tl_rec.sfwt_flag,
1486: l_okc_process_def_parms_tl_rec.name,
1487: l_okc_process_def_parms_tl_rec.description,
1488: l_okc_process_def_parms_tl_rec.created_by,
1489: l_okc_process_def_parms_tl_rec.creation_date,
1490: l_okc_process_def_parms_tl_rec.last_updated_by,

Line 1487: l_okc_process_def_parms_tl_rec.description,

1483: l_okc_process_def_parms_tl_rec.language,
1484: l_okc_process_def_parms_tl_rec.source_lang,
1485: l_okc_process_def_parms_tl_rec.sfwt_flag,
1486: l_okc_process_def_parms_tl_rec.name,
1487: l_okc_process_def_parms_tl_rec.description,
1488: l_okc_process_def_parms_tl_rec.created_by,
1489: l_okc_process_def_parms_tl_rec.creation_date,
1490: l_okc_process_def_parms_tl_rec.last_updated_by,
1491: l_okc_process_def_parms_tl_rec.last_update_date,

Line 1488: l_okc_process_def_parms_tl_rec.created_by,

1484: l_okc_process_def_parms_tl_rec.source_lang,
1485: l_okc_process_def_parms_tl_rec.sfwt_flag,
1486: l_okc_process_def_parms_tl_rec.name,
1487: l_okc_process_def_parms_tl_rec.description,
1488: l_okc_process_def_parms_tl_rec.created_by,
1489: l_okc_process_def_parms_tl_rec.creation_date,
1490: l_okc_process_def_parms_tl_rec.last_updated_by,
1491: l_okc_process_def_parms_tl_rec.last_update_date,
1492: l_okc_process_def_parms_tl_rec.last_update_login);

Line 1489: l_okc_process_def_parms_tl_rec.creation_date,

1485: l_okc_process_def_parms_tl_rec.sfwt_flag,
1486: l_okc_process_def_parms_tl_rec.name,
1487: l_okc_process_def_parms_tl_rec.description,
1488: l_okc_process_def_parms_tl_rec.created_by,
1489: l_okc_process_def_parms_tl_rec.creation_date,
1490: l_okc_process_def_parms_tl_rec.last_updated_by,
1491: l_okc_process_def_parms_tl_rec.last_update_date,
1492: l_okc_process_def_parms_tl_rec.last_update_login);
1493: END LOOP;

Line 1490: l_okc_process_def_parms_tl_rec.last_updated_by,

1486: l_okc_process_def_parms_tl_rec.name,
1487: l_okc_process_def_parms_tl_rec.description,
1488: l_okc_process_def_parms_tl_rec.created_by,
1489: l_okc_process_def_parms_tl_rec.creation_date,
1490: l_okc_process_def_parms_tl_rec.last_updated_by,
1491: l_okc_process_def_parms_tl_rec.last_update_date,
1492: l_okc_process_def_parms_tl_rec.last_update_login);
1493: END LOOP;
1494: -- Set OUT values

Line 1491: l_okc_process_def_parms_tl_rec.last_update_date,

1487: l_okc_process_def_parms_tl_rec.description,
1488: l_okc_process_def_parms_tl_rec.created_by,
1489: l_okc_process_def_parms_tl_rec.creation_date,
1490: l_okc_process_def_parms_tl_rec.last_updated_by,
1491: l_okc_process_def_parms_tl_rec.last_update_date,
1492: l_okc_process_def_parms_tl_rec.last_update_login);
1493: END LOOP;
1494: -- Set OUT values
1495: x_okc_process_def_parms_tl_rec := l_okc_process_def_parms_tl_rec;

Line 1492: l_okc_process_def_parms_tl_rec.last_update_login);

1488: l_okc_process_def_parms_tl_rec.created_by,
1489: l_okc_process_def_parms_tl_rec.creation_date,
1490: l_okc_process_def_parms_tl_rec.last_updated_by,
1491: l_okc_process_def_parms_tl_rec.last_update_date,
1492: l_okc_process_def_parms_tl_rec.last_update_login);
1493: END LOOP;
1494: -- Set OUT values
1495: x_okc_process_def_parms_tl_rec := l_okc_process_def_parms_tl_rec;
1496: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1495: x_okc_process_def_parms_tl_rec := l_okc_process_def_parms_tl_rec;

1491: l_okc_process_def_parms_tl_rec.last_update_date,
1492: l_okc_process_def_parms_tl_rec.last_update_login);
1493: END LOOP;
1494: -- Set OUT values
1495: x_okc_process_def_parms_tl_rec := l_okc_process_def_parms_tl_rec;
1496: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1497: EXCEPTION
1498: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1499: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1666: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;

1662: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1663: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1664: l_pdpv_rec pdpv_rec_type;
1665: l_def_pdpv_rec pdpv_rec_type;
1666: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
1667: LxOkcProcessDefParmsTlRec OkcProcessDefParmsTlRecType;
1668: l_pdp_rec pdp_rec_type;
1669: lx_pdp_rec pdp_rec_type;
1670: -------------------------------

Line 1753: migrate(l_def_pdpv_rec, l_okc_process_def_parms_tl_rec);

1749: END IF;
1750: --------------------------------------
1751: -- Move VIEW record to "Child" records
1752: --------------------------------------
1753: migrate(l_def_pdpv_rec, l_okc_process_def_parms_tl_rec);
1754: migrate(l_def_pdpv_rec, l_pdp_rec);
1755: --------------------------------------------
1756: -- Call the INSERT_ROW for each child record
1757: --------------------------------------------

Line 1763: l_okc_process_def_parms_tl_rec,

1759: p_init_msg_list,
1760: x_return_status,
1761: x_msg_count,
1762: x_msg_data,
1763: l_okc_process_def_parms_tl_rec,
1764: LxOkcProcessDefParmsTlRec
1765: );
1766: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1767: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1892: -- lock_row for:OKC_PROCESS_DEF_PARMS_TL --

1888: ---------------------------------------------------------------------------
1889: -- PROCEDURE lock_row
1890: ---------------------------------------------------------------------------
1891: -------------------------------------------
1892: -- lock_row for:OKC_PROCESS_DEF_PARMS_TL --
1893: -------------------------------------------
1894: PROCEDURE lock_row(
1895: p_init_msg_list IN VARCHAR2 ,
1896: x_return_status OUT NOCOPY VARCHAR2,

Line 1899: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType) IS

1895: p_init_msg_list IN VARCHAR2 ,
1896: x_return_status OUT NOCOPY VARCHAR2,
1897: x_msg_count OUT NOCOPY NUMBER,
1898: x_msg_data OUT NOCOPY VARCHAR2,
1899: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType) IS
1900:
1901: E_Resource_Busy EXCEPTION;
1902: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1903: CURSOR lock_csr (p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType) IS

Line 1903: CURSOR lock_csr (p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType) IS

1899: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType) IS
1900:
1901: E_Resource_Busy EXCEPTION;
1902: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1903: CURSOR lock_csr (p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType) IS
1904: SELECT *
1905: FROM OKC_PROCESS_DEF_PARMS_TL
1906: WHERE ID = p_okc_process_def_parms_tl_rec.id
1907: FOR UPDATE NOWAIT;

Line 1905: FROM OKC_PROCESS_DEF_PARMS_TL

1901: E_Resource_Busy EXCEPTION;
1902: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1903: CURSOR lock_csr (p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType) IS
1904: SELECT *
1905: FROM OKC_PROCESS_DEF_PARMS_TL
1906: WHERE ID = p_okc_process_def_parms_tl_rec.id
1907: FOR UPDATE NOWAIT;
1908:
1909: l_api_version CONSTANT NUMBER := 1;

Line 1906: WHERE ID = p_okc_process_def_parms_tl_rec.id

1902: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1903: CURSOR lock_csr (p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType) IS
1904: SELECT *
1905: FROM OKC_PROCESS_DEF_PARMS_TL
1906: WHERE ID = p_okc_process_def_parms_tl_rec.id
1907: FOR UPDATE NOWAIT;
1908:
1909: l_api_version CONSTANT NUMBER := 1;
1910: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1926: OPEN lock_csr(p_okc_process_def_parms_tl_rec);

1922: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1923: RAISE OKC_API.G_EXCEPTION_ERROR;
1924: END IF;
1925: BEGIN
1926: OPEN lock_csr(p_okc_process_def_parms_tl_rec);
1927: FETCH lock_csr INTO l_lock_var;
1928: l_row_notfound := lock_csr%NOTFOUND;
1929: CLOSE lock_csr;
1930: EXCEPTION

Line 2096: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;

2092:
2093: l_api_version CONSTANT NUMBER := 1;
2094: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2095: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2096: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
2097: l_pdp_rec pdp_rec_type;
2098: BEGIN
2099: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2100: G_PKG_NAME,

Line 2114: migrate(p_pdpv_rec, l_okc_process_def_parms_tl_rec);

2110: END IF;
2111: --------------------------------------
2112: -- Move VIEW record to "Child" records
2113: --------------------------------------
2114: migrate(p_pdpv_rec, l_okc_process_def_parms_tl_rec);
2115: migrate(p_pdpv_rec, l_pdp_rec);
2116: --------------------------------------------
2117: -- Call the LOCK_ROW for each child record
2118: --------------------------------------------

Line 2124: l_okc_process_def_parms_tl_rec

2120: p_init_msg_list,
2121: x_return_status,
2122: x_msg_count,
2123: x_msg_data,
2124: l_okc_process_def_parms_tl_rec
2125: );
2126: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2128: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2245: -- update_row for:OKC_PROCESS_DEF_PARMS_TL --

2241: ---------------------------------------------------------------------------
2242: -- PROCEDURE update_row
2243: ---------------------------------------------------------------------------
2244: ---------------------------------------------
2245: -- update_row for:OKC_PROCESS_DEF_PARMS_TL --
2246: ---------------------------------------------
2247: PROCEDURE update_row(
2248: p_init_msg_list IN VARCHAR2 ,
2249: x_return_status OUT NOCOPY VARCHAR2,

Line 2252: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,

2248: p_init_msg_list IN VARCHAR2 ,
2249: x_return_status OUT NOCOPY VARCHAR2,
2250: x_msg_count OUT NOCOPY NUMBER,
2251: x_msg_data OUT NOCOPY VARCHAR2,
2252: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
2253: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType) IS
2254:
2255: l_api_version CONSTANT NUMBER := 1;
2256: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2253: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType) IS

2249: x_return_status OUT NOCOPY VARCHAR2,
2250: x_msg_count OUT NOCOPY NUMBER,
2251: x_msg_data OUT NOCOPY VARCHAR2,
2252: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
2253: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType) IS
2254:
2255: l_api_version CONSTANT NUMBER := 1;
2256: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2257: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2258: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType := p_okc_process_def_parms_tl_rec;

2254:
2255: l_api_version CONSTANT NUMBER := 1;
2256: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2257: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2258: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType := p_okc_process_def_parms_tl_rec;
2259: ldefokcprocessdefparmstlrec OkcProcessDefParmsTlRecType;
2260: l_row_notfound BOOLEAN := TRUE;
2261: ----------------------------------
2262: -- FUNCTION populate_new_record --

Line 2265: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,

2261: ----------------------------------
2262: -- FUNCTION populate_new_record --
2263: ----------------------------------
2264: FUNCTION populate_new_record (
2265: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
2266: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
2267: ) RETURN VARCHAR2 IS
2268: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
2269: l_row_notfound BOOLEAN := TRUE;

Line 2266: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType

2262: -- FUNCTION populate_new_record --
2263: ----------------------------------
2264: FUNCTION populate_new_record (
2265: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
2266: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
2267: ) RETURN VARCHAR2 IS
2268: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
2269: l_row_notfound BOOLEAN := TRUE;
2270: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2268: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;

2264: FUNCTION populate_new_record (
2265: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
2266: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
2267: ) RETURN VARCHAR2 IS
2268: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
2269: l_row_notfound BOOLEAN := TRUE;
2270: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2271: BEGIN
2272: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;

Line 2272: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;

2268: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
2269: l_row_notfound BOOLEAN := TRUE;
2270: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2271: BEGIN
2272: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;
2273: -- Get current database values
2274: l_okc_process_def_parms_tl_rec := get_rec(p_okc_process_def_parms_tl_rec, l_row_notfound);
2275: IF (l_row_notfound) THEN
2276: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2274: l_okc_process_def_parms_tl_rec := get_rec(p_okc_process_def_parms_tl_rec, l_row_notfound);

2270: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2271: BEGIN
2272: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;
2273: -- Get current database values
2274: l_okc_process_def_parms_tl_rec := get_rec(p_okc_process_def_parms_tl_rec, l_row_notfound);
2275: IF (l_row_notfound) THEN
2276: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2277: END IF;
2278: IF (x_okc_process_def_parms_tl_rec.id = OKC_API.G_MISS_NUM)

Line 2278: IF (x_okc_process_def_parms_tl_rec.id = OKC_API.G_MISS_NUM)

2274: l_okc_process_def_parms_tl_rec := get_rec(p_okc_process_def_parms_tl_rec, l_row_notfound);
2275: IF (l_row_notfound) THEN
2276: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2277: END IF;
2278: IF (x_okc_process_def_parms_tl_rec.id = OKC_API.G_MISS_NUM)
2279: THEN
2280: x_okc_process_def_parms_tl_rec.id := l_okc_process_def_parms_tl_rec.id;
2281: END IF;
2282: IF (x_okc_process_def_parms_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2280: x_okc_process_def_parms_tl_rec.id := l_okc_process_def_parms_tl_rec.id;

2276: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2277: END IF;
2278: IF (x_okc_process_def_parms_tl_rec.id = OKC_API.G_MISS_NUM)
2279: THEN
2280: x_okc_process_def_parms_tl_rec.id := l_okc_process_def_parms_tl_rec.id;
2281: END IF;
2282: IF (x_okc_process_def_parms_tl_rec.language = OKC_API.G_MISS_CHAR)
2283: THEN
2284: x_okc_process_def_parms_tl_rec.language := l_okc_process_def_parms_tl_rec.language;

Line 2282: IF (x_okc_process_def_parms_tl_rec.language = OKC_API.G_MISS_CHAR)

2278: IF (x_okc_process_def_parms_tl_rec.id = OKC_API.G_MISS_NUM)
2279: THEN
2280: x_okc_process_def_parms_tl_rec.id := l_okc_process_def_parms_tl_rec.id;
2281: END IF;
2282: IF (x_okc_process_def_parms_tl_rec.language = OKC_API.G_MISS_CHAR)
2283: THEN
2284: x_okc_process_def_parms_tl_rec.language := l_okc_process_def_parms_tl_rec.language;
2285: END IF;
2286: IF (x_okc_process_def_parms_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2284: x_okc_process_def_parms_tl_rec.language := l_okc_process_def_parms_tl_rec.language;

2280: x_okc_process_def_parms_tl_rec.id := l_okc_process_def_parms_tl_rec.id;
2281: END IF;
2282: IF (x_okc_process_def_parms_tl_rec.language = OKC_API.G_MISS_CHAR)
2283: THEN
2284: x_okc_process_def_parms_tl_rec.language := l_okc_process_def_parms_tl_rec.language;
2285: END IF;
2286: IF (x_okc_process_def_parms_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2287: THEN
2288: x_okc_process_def_parms_tl_rec.source_lang := l_okc_process_def_parms_tl_rec.source_lang;

Line 2286: IF (x_okc_process_def_parms_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2282: IF (x_okc_process_def_parms_tl_rec.language = OKC_API.G_MISS_CHAR)
2283: THEN
2284: x_okc_process_def_parms_tl_rec.language := l_okc_process_def_parms_tl_rec.language;
2285: END IF;
2286: IF (x_okc_process_def_parms_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2287: THEN
2288: x_okc_process_def_parms_tl_rec.source_lang := l_okc_process_def_parms_tl_rec.source_lang;
2289: END IF;
2290: IF (x_okc_process_def_parms_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2288: x_okc_process_def_parms_tl_rec.source_lang := l_okc_process_def_parms_tl_rec.source_lang;

2284: x_okc_process_def_parms_tl_rec.language := l_okc_process_def_parms_tl_rec.language;
2285: END IF;
2286: IF (x_okc_process_def_parms_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2287: THEN
2288: x_okc_process_def_parms_tl_rec.source_lang := l_okc_process_def_parms_tl_rec.source_lang;
2289: END IF;
2290: IF (x_okc_process_def_parms_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2291: THEN
2292: x_okc_process_def_parms_tl_rec.sfwt_flag := l_okc_process_def_parms_tl_rec.sfwt_flag;

Line 2290: IF (x_okc_process_def_parms_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2286: IF (x_okc_process_def_parms_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2287: THEN
2288: x_okc_process_def_parms_tl_rec.source_lang := l_okc_process_def_parms_tl_rec.source_lang;
2289: END IF;
2290: IF (x_okc_process_def_parms_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2291: THEN
2292: x_okc_process_def_parms_tl_rec.sfwt_flag := l_okc_process_def_parms_tl_rec.sfwt_flag;
2293: END IF;
2294: IF (x_okc_process_def_parms_tl_rec.name = OKC_API.G_MISS_CHAR)

Line 2292: x_okc_process_def_parms_tl_rec.sfwt_flag := l_okc_process_def_parms_tl_rec.sfwt_flag;

2288: x_okc_process_def_parms_tl_rec.source_lang := l_okc_process_def_parms_tl_rec.source_lang;
2289: END IF;
2290: IF (x_okc_process_def_parms_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2291: THEN
2292: x_okc_process_def_parms_tl_rec.sfwt_flag := l_okc_process_def_parms_tl_rec.sfwt_flag;
2293: END IF;
2294: IF (x_okc_process_def_parms_tl_rec.name = OKC_API.G_MISS_CHAR)
2295: THEN
2296: x_okc_process_def_parms_tl_rec.name := l_okc_process_def_parms_tl_rec.name;

Line 2294: IF (x_okc_process_def_parms_tl_rec.name = OKC_API.G_MISS_CHAR)

2290: IF (x_okc_process_def_parms_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2291: THEN
2292: x_okc_process_def_parms_tl_rec.sfwt_flag := l_okc_process_def_parms_tl_rec.sfwt_flag;
2293: END IF;
2294: IF (x_okc_process_def_parms_tl_rec.name = OKC_API.G_MISS_CHAR)
2295: THEN
2296: x_okc_process_def_parms_tl_rec.name := l_okc_process_def_parms_tl_rec.name;
2297: END IF;
2298: IF (x_okc_process_def_parms_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 2296: x_okc_process_def_parms_tl_rec.name := l_okc_process_def_parms_tl_rec.name;

2292: x_okc_process_def_parms_tl_rec.sfwt_flag := l_okc_process_def_parms_tl_rec.sfwt_flag;
2293: END IF;
2294: IF (x_okc_process_def_parms_tl_rec.name = OKC_API.G_MISS_CHAR)
2295: THEN
2296: x_okc_process_def_parms_tl_rec.name := l_okc_process_def_parms_tl_rec.name;
2297: END IF;
2298: IF (x_okc_process_def_parms_tl_rec.description = OKC_API.G_MISS_CHAR)
2299: THEN
2300: x_okc_process_def_parms_tl_rec.description := l_okc_process_def_parms_tl_rec.description;

Line 2298: IF (x_okc_process_def_parms_tl_rec.description = OKC_API.G_MISS_CHAR)

2294: IF (x_okc_process_def_parms_tl_rec.name = OKC_API.G_MISS_CHAR)
2295: THEN
2296: x_okc_process_def_parms_tl_rec.name := l_okc_process_def_parms_tl_rec.name;
2297: END IF;
2298: IF (x_okc_process_def_parms_tl_rec.description = OKC_API.G_MISS_CHAR)
2299: THEN
2300: x_okc_process_def_parms_tl_rec.description := l_okc_process_def_parms_tl_rec.description;
2301: END IF;
2302: IF (x_okc_process_def_parms_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2300: x_okc_process_def_parms_tl_rec.description := l_okc_process_def_parms_tl_rec.description;

2296: x_okc_process_def_parms_tl_rec.name := l_okc_process_def_parms_tl_rec.name;
2297: END IF;
2298: IF (x_okc_process_def_parms_tl_rec.description = OKC_API.G_MISS_CHAR)
2299: THEN
2300: x_okc_process_def_parms_tl_rec.description := l_okc_process_def_parms_tl_rec.description;
2301: END IF;
2302: IF (x_okc_process_def_parms_tl_rec.created_by = OKC_API.G_MISS_NUM)
2303: THEN
2304: x_okc_process_def_parms_tl_rec.created_by := l_okc_process_def_parms_tl_rec.created_by;

Line 2302: IF (x_okc_process_def_parms_tl_rec.created_by = OKC_API.G_MISS_NUM)

2298: IF (x_okc_process_def_parms_tl_rec.description = OKC_API.G_MISS_CHAR)
2299: THEN
2300: x_okc_process_def_parms_tl_rec.description := l_okc_process_def_parms_tl_rec.description;
2301: END IF;
2302: IF (x_okc_process_def_parms_tl_rec.created_by = OKC_API.G_MISS_NUM)
2303: THEN
2304: x_okc_process_def_parms_tl_rec.created_by := l_okc_process_def_parms_tl_rec.created_by;
2305: END IF;
2306: IF (x_okc_process_def_parms_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2304: x_okc_process_def_parms_tl_rec.created_by := l_okc_process_def_parms_tl_rec.created_by;

2300: x_okc_process_def_parms_tl_rec.description := l_okc_process_def_parms_tl_rec.description;
2301: END IF;
2302: IF (x_okc_process_def_parms_tl_rec.created_by = OKC_API.G_MISS_NUM)
2303: THEN
2304: x_okc_process_def_parms_tl_rec.created_by := l_okc_process_def_parms_tl_rec.created_by;
2305: END IF;
2306: IF (x_okc_process_def_parms_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2307: THEN
2308: x_okc_process_def_parms_tl_rec.creation_date := l_okc_process_def_parms_tl_rec.creation_date;

Line 2306: IF (x_okc_process_def_parms_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2302: IF (x_okc_process_def_parms_tl_rec.created_by = OKC_API.G_MISS_NUM)
2303: THEN
2304: x_okc_process_def_parms_tl_rec.created_by := l_okc_process_def_parms_tl_rec.created_by;
2305: END IF;
2306: IF (x_okc_process_def_parms_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2307: THEN
2308: x_okc_process_def_parms_tl_rec.creation_date := l_okc_process_def_parms_tl_rec.creation_date;
2309: END IF;
2310: IF (x_okc_process_def_parms_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2308: x_okc_process_def_parms_tl_rec.creation_date := l_okc_process_def_parms_tl_rec.creation_date;

2304: x_okc_process_def_parms_tl_rec.created_by := l_okc_process_def_parms_tl_rec.created_by;
2305: END IF;
2306: IF (x_okc_process_def_parms_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2307: THEN
2308: x_okc_process_def_parms_tl_rec.creation_date := l_okc_process_def_parms_tl_rec.creation_date;
2309: END IF;
2310: IF (x_okc_process_def_parms_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2311: THEN
2312: x_okc_process_def_parms_tl_rec.last_updated_by := l_okc_process_def_parms_tl_rec.last_updated_by;

Line 2310: IF (x_okc_process_def_parms_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2306: IF (x_okc_process_def_parms_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2307: THEN
2308: x_okc_process_def_parms_tl_rec.creation_date := l_okc_process_def_parms_tl_rec.creation_date;
2309: END IF;
2310: IF (x_okc_process_def_parms_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2311: THEN
2312: x_okc_process_def_parms_tl_rec.last_updated_by := l_okc_process_def_parms_tl_rec.last_updated_by;
2313: END IF;
2314: IF (x_okc_process_def_parms_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2312: x_okc_process_def_parms_tl_rec.last_updated_by := l_okc_process_def_parms_tl_rec.last_updated_by;

2308: x_okc_process_def_parms_tl_rec.creation_date := l_okc_process_def_parms_tl_rec.creation_date;
2309: END IF;
2310: IF (x_okc_process_def_parms_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2311: THEN
2312: x_okc_process_def_parms_tl_rec.last_updated_by := l_okc_process_def_parms_tl_rec.last_updated_by;
2313: END IF;
2314: IF (x_okc_process_def_parms_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2315: THEN
2316: x_okc_process_def_parms_tl_rec.last_update_date := l_okc_process_def_parms_tl_rec.last_update_date;

Line 2314: IF (x_okc_process_def_parms_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2310: IF (x_okc_process_def_parms_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2311: THEN
2312: x_okc_process_def_parms_tl_rec.last_updated_by := l_okc_process_def_parms_tl_rec.last_updated_by;
2313: END IF;
2314: IF (x_okc_process_def_parms_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2315: THEN
2316: x_okc_process_def_parms_tl_rec.last_update_date := l_okc_process_def_parms_tl_rec.last_update_date;
2317: END IF;
2318: IF (x_okc_process_def_parms_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2316: x_okc_process_def_parms_tl_rec.last_update_date := l_okc_process_def_parms_tl_rec.last_update_date;

2312: x_okc_process_def_parms_tl_rec.last_updated_by := l_okc_process_def_parms_tl_rec.last_updated_by;
2313: END IF;
2314: IF (x_okc_process_def_parms_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2315: THEN
2316: x_okc_process_def_parms_tl_rec.last_update_date := l_okc_process_def_parms_tl_rec.last_update_date;
2317: END IF;
2318: IF (x_okc_process_def_parms_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2319: THEN
2320: x_okc_process_def_parms_tl_rec.last_update_login := l_okc_process_def_parms_tl_rec.last_update_login;

Line 2318: IF (x_okc_process_def_parms_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2314: IF (x_okc_process_def_parms_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2315: THEN
2316: x_okc_process_def_parms_tl_rec.last_update_date := l_okc_process_def_parms_tl_rec.last_update_date;
2317: END IF;
2318: IF (x_okc_process_def_parms_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2319: THEN
2320: x_okc_process_def_parms_tl_rec.last_update_login := l_okc_process_def_parms_tl_rec.last_update_login;
2321: END IF;
2322: RETURN(l_return_status);

Line 2320: x_okc_process_def_parms_tl_rec.last_update_login := l_okc_process_def_parms_tl_rec.last_update_login;

2316: x_okc_process_def_parms_tl_rec.last_update_date := l_okc_process_def_parms_tl_rec.last_update_date;
2317: END IF;
2318: IF (x_okc_process_def_parms_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2319: THEN
2320: x_okc_process_def_parms_tl_rec.last_update_login := l_okc_process_def_parms_tl_rec.last_update_login;
2321: END IF;
2322: RETURN(l_return_status);
2323: END populate_new_record;
2324: -------------------------------------------------

Line 2325: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --

2321: END IF;
2322: RETURN(l_return_status);
2323: END populate_new_record;
2324: -------------------------------------------------
2325: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --
2326: -------------------------------------------------
2327: FUNCTION Set_Attributes (
2328: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
2329: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType

Line 2328: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,

2324: -------------------------------------------------
2325: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --
2326: -------------------------------------------------
2327: FUNCTION Set_Attributes (
2328: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
2329: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
2330: ) RETURN VARCHAR2 IS
2331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2332: BEGIN

Line 2329: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType

2325: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --
2326: -------------------------------------------------
2327: FUNCTION Set_Attributes (
2328: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
2329: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
2330: ) RETURN VARCHAR2 IS
2331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2332: BEGIN
2333: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;

Line 2333: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;

2329: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
2330: ) RETURN VARCHAR2 IS
2331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2332: BEGIN
2333: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;
2334: x_okc_process_def_parms_tl_rec.LANGUAGE := l_lang;
2335: x_okc_process_def_parms_tl_rec.SOURCE_LANG := l_lang;
2336: RETURN(l_return_status);
2337: END Set_Attributes;

Line 2334: x_okc_process_def_parms_tl_rec.LANGUAGE := l_lang;

2330: ) RETURN VARCHAR2 IS
2331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2332: BEGIN
2333: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;
2334: x_okc_process_def_parms_tl_rec.LANGUAGE := l_lang;
2335: x_okc_process_def_parms_tl_rec.SOURCE_LANG := l_lang;
2336: RETURN(l_return_status);
2337: END Set_Attributes;
2338: BEGIN

Line 2335: x_okc_process_def_parms_tl_rec.SOURCE_LANG := l_lang;

2331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2332: BEGIN
2333: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;
2334: x_okc_process_def_parms_tl_rec.LANGUAGE := l_lang;
2335: x_okc_process_def_parms_tl_rec.SOURCE_LANG := l_lang;
2336: RETURN(l_return_status);
2337: END Set_Attributes;
2338: BEGIN
2339: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2350: p_okc_process_def_parms_tl_rec, -- IN

2346: RAISE OKC_API.G_EXCEPTION_ERROR;
2347: END IF;
2348: --- Setting item attributes
2349: l_return_status := Set_Attributes(
2350: p_okc_process_def_parms_tl_rec, -- IN
2351: l_okc_process_def_parms_tl_rec); -- OUT
2352: --- If any errors happen abort API
2353: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2351: l_okc_process_def_parms_tl_rec); -- OUT

2347: END IF;
2348: --- Setting item attributes
2349: l_return_status := Set_Attributes(
2350: p_okc_process_def_parms_tl_rec, -- IN
2351: l_okc_process_def_parms_tl_rec); -- OUT
2352: --- If any errors happen abort API
2353: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2358: l_return_status := populate_new_record(l_okc_process_def_parms_tl_rec, ldefokcprocessdefparmstlrec);

2354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2356: RAISE OKC_API.G_EXCEPTION_ERROR;
2357: END IF;
2358: l_return_status := populate_new_record(l_okc_process_def_parms_tl_rec, ldefokcprocessdefparmstlrec);
2359: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2361: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2362: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2364: UPDATE OKC_PROCESS_DEF_PARMS_TL

2360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2361: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2362: RAISE OKC_API.G_EXCEPTION_ERROR;
2363: END IF;
2364: UPDATE OKC_PROCESS_DEF_PARMS_TL
2365: SET NAME = ldefokcprocessdefparmstlrec.name,
2366: DESCRIPTION = ldefokcprocessdefparmstlrec.description,
2367: CREATED_BY = ldefokcprocessdefparmstlrec.created_by,
2368: CREATION_DATE = ldefokcprocessdefparmstlrec.creation_date,

Line 2376: UPDATE OKC_PROCESS_DEF_PARMS_TL

2372: WHERE ID = ldefokcprocessdefparmstlrec.id
2373: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2374: --AND SOURCE_LANG = USERENV('LANG');
2375:
2376: UPDATE OKC_PROCESS_DEF_PARMS_TL
2377: SET SFWT_FLAG = 'Y'
2378: WHERE ID = ldefokcprocessdefparmstlrec.id
2379: AND SOURCE_LANG <> USERENV('LANG');
2380:

Line 2381: x_okc_process_def_parms_tl_rec := ldefokcprocessdefparmstlrec;

2377: SET SFWT_FLAG = 'Y'
2378: WHERE ID = ldefokcprocessdefparmstlrec.id
2379: AND SOURCE_LANG <> USERENV('LANG');
2380:
2381: x_okc_process_def_parms_tl_rec := ldefokcprocessdefparmstlrec;
2382: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2383: EXCEPTION
2384: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2385: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2629: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;

2625: l_pdpv_rec pdpv_rec_type := p_pdpv_rec;
2626: l_def_pdpv_rec pdpv_rec_type;
2627: l_pdp_rec pdp_rec_type;
2628: lx_pdp_rec pdp_rec_type;
2629: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
2630: LxOkcProcessDefParmsTlRec OkcProcessDefParmsTlRecType;
2631: -------------------------------
2632: -- FUNCTION fill_who_columns --
2633: -------------------------------

Line 2816: migrate(l_def_pdpv_rec, l_okc_process_def_parms_tl_rec);

2812: --------------------------------------
2813: -- Move VIEW record to "Child" records
2814: --------------------------------------
2815: migrate(l_def_pdpv_rec, l_pdp_rec);
2816: migrate(l_def_pdpv_rec, l_okc_process_def_parms_tl_rec);
2817: --------------------------------------------
2818: -- Call the UPDATE_ROW for each child record
2819: --------------------------------------------
2820: update_row(

Line 2839: l_okc_process_def_parms_tl_rec,

2835: p_init_msg_list,
2836: x_return_status,
2837: x_msg_count,
2838: x_msg_data,
2839: l_okc_process_def_parms_tl_rec,
2840: LxOkcProcessDefParmsTlRec
2841: );
2842: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2953: -- delete_row for:OKC_PROCESS_DEF_PARMS_TL --

2949: ---------------------------------------------------------------------------
2950: -- PROCEDURE delete_row
2951: ---------------------------------------------------------------------------
2952: ---------------------------------------------
2953: -- delete_row for:OKC_PROCESS_DEF_PARMS_TL --
2954: ---------------------------------------------
2955: PROCEDURE delete_row(
2956: p_init_msg_list IN VARCHAR2 ,
2957: x_return_status OUT NOCOPY VARCHAR2,

Line 2960: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType) IS

2956: p_init_msg_list IN VARCHAR2 ,
2957: x_return_status OUT NOCOPY VARCHAR2,
2958: x_msg_count OUT NOCOPY NUMBER,
2959: x_msg_data OUT NOCOPY VARCHAR2,
2960: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType) IS
2961:
2962: l_api_version CONSTANT NUMBER := 1;
2963: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2964: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2965: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType:= p_okc_process_def_parms_tl_rec;

2961:
2962: l_api_version CONSTANT NUMBER := 1;
2963: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2964: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2965: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType:= p_okc_process_def_parms_tl_rec;
2966: l_row_notfound BOOLEAN := TRUE;
2967: -------------------------------------------------
2968: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --
2969: -------------------------------------------------

Line 2968: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --

2964: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2965: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType:= p_okc_process_def_parms_tl_rec;
2966: l_row_notfound BOOLEAN := TRUE;
2967: -------------------------------------------------
2968: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --
2969: -------------------------------------------------
2970: FUNCTION Set_Attributes (
2971: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
2972: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType

Line 2971: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,

2967: -------------------------------------------------
2968: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --
2969: -------------------------------------------------
2970: FUNCTION Set_Attributes (
2971: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
2972: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
2973: ) RETURN VARCHAR2 IS
2974: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2975: BEGIN

Line 2972: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType

2968: -- Set_Attributes for:OKC_PROCESS_DEF_PARMS_TL --
2969: -------------------------------------------------
2970: FUNCTION Set_Attributes (
2971: p_okc_process_def_parms_tl_rec IN OkcProcessDefParmsTlRecType,
2972: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
2973: ) RETURN VARCHAR2 IS
2974: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2975: BEGIN
2976: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;

Line 2976: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;

2972: x_okc_process_def_parms_tl_rec OUT NOCOPY OkcProcessDefParmsTlRecType
2973: ) RETURN VARCHAR2 IS
2974: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2975: BEGIN
2976: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;
2977: x_okc_process_def_parms_tl_rec.LANGUAGE := USERENV('LANG');
2978: RETURN(l_return_status);
2979: END Set_Attributes;
2980: BEGIN

Line 2977: x_okc_process_def_parms_tl_rec.LANGUAGE := USERENV('LANG');

2973: ) RETURN VARCHAR2 IS
2974: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2975: BEGIN
2976: x_okc_process_def_parms_tl_rec := p_okc_process_def_parms_tl_rec;
2977: x_okc_process_def_parms_tl_rec.LANGUAGE := USERENV('LANG');
2978: RETURN(l_return_status);
2979: END Set_Attributes;
2980: BEGIN
2981: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2992: p_okc_process_def_parms_tl_rec, -- IN

2988: RAISE OKC_API.G_EXCEPTION_ERROR;
2989: END IF;
2990: --- Setting item attributes
2991: l_return_status := Set_Attributes(
2992: p_okc_process_def_parms_tl_rec, -- IN
2993: l_okc_process_def_parms_tl_rec); -- OUT
2994: --- If any errors happen abort API
2995: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2993: l_okc_process_def_parms_tl_rec); -- OUT

2989: END IF;
2990: --- Setting item attributes
2991: l_return_status := Set_Attributes(
2992: p_okc_process_def_parms_tl_rec, -- IN
2993: l_okc_process_def_parms_tl_rec); -- OUT
2994: --- If any errors happen abort API
2995: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2997: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3000: DELETE FROM OKC_PROCESS_DEF_PARMS_TL

2996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2997: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2998: RAISE OKC_API.G_EXCEPTION_ERROR;
2999: END IF;
3000: DELETE FROM OKC_PROCESS_DEF_PARMS_TL
3001: WHERE ID = l_okc_process_def_parms_tl_rec.id;
3002:
3003: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3004: EXCEPTION

Line 3001: WHERE ID = l_okc_process_def_parms_tl_rec.id;

2997: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2998: RAISE OKC_API.G_EXCEPTION_ERROR;
2999: END IF;
3000: DELETE FROM OKC_PROCESS_DEF_PARMS_TL
3001: WHERE ID = l_okc_process_def_parms_tl_rec.id;
3002:
3003: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3004: EXCEPTION
3005: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3113: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;

3109: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3110: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3111: l_pdpv_rec pdpv_rec_type := p_pdpv_rec;
3112: l_pdp_rec pdp_rec_type;
3113: l_okc_process_def_parms_tl_rec OkcProcessDefParmsTlRecType;
3114: BEGIN
3115: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3116: G_PKG_NAME,
3117: p_init_msg_list,

Line 3141: migrate(l_pdpv_rec, l_okc_process_def_parms_tl_rec);

3137: --------------------------------------
3138: -- Move VIEW record to "Child" records
3139: --------------------------------------
3140: migrate(l_pdpv_rec, l_pdp_rec);
3141: migrate(l_pdpv_rec, l_okc_process_def_parms_tl_rec);
3142: --------------------------------------------
3143: -- Call the DELETE_ROW for each child record
3144: --------------------------------------------
3145: delete_row(

Line 3162: l_okc_process_def_parms_tl_rec

3158: p_init_msg_list,
3159: x_return_status,
3160: x_msg_count,
3161: x_msg_data,
3162: l_okc_process_def_parms_tl_rec
3163: );
3164: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3165: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3166: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN