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.OKL_TQL_PVT dependencies on OKL_TXL_QUOTE_LINES_TL

Line 1065: DELETE FROM OKL_TXL_QUOTE_LINES_TL T

1061: -- PROCEDURE add_language
1062: ---------------------------------------------------------------------------
1063: PROCEDURE add_language IS
1064: BEGIN
1065: DELETE FROM OKL_TXL_QUOTE_LINES_TL T
1066: WHERE NOT EXISTS (
1067: SELECT NULL
1068: FROM OKL_TXL_QTE_LINES_ALL_B B
1069: WHERE B.ID = T.ID

Line 1073: UPDATE OKL_TXL_QUOTE_LINES_TL T SET (

1069: WHERE B.ID = T.ID
1070: AND T.LANGUAGE = USERENV('LANG')
1071: );
1072:
1073: UPDATE OKL_TXL_QUOTE_LINES_TL T SET (
1074: DESCRIPTION) = (SELECT
1075: B.DESCRIPTION
1076: FROM OKL_TXL_QUOTE_LINES_TL B
1077: WHERE B.ID = T.ID

Line 1076: FROM OKL_TXL_QUOTE_LINES_TL B

1072:
1073: UPDATE OKL_TXL_QUOTE_LINES_TL T SET (
1074: DESCRIPTION) = (SELECT
1075: B.DESCRIPTION
1076: FROM OKL_TXL_QUOTE_LINES_TL B
1077: WHERE B.ID = T.ID
1078: AND B.LANGUAGE = T.SOURCE_LANG)
1079: WHERE (
1080: T.ID,

Line 1085: FROM OKL_TXL_QUOTE_LINES_TL SUBB, OKL_TXL_QUOTE_LINES_TL SUBT

1081: T.LANGUAGE)
1082: IN (SELECT
1083: SUBT.ID,
1084: SUBT.LANGUAGE
1085: FROM OKL_TXL_QUOTE_LINES_TL SUBB, OKL_TXL_QUOTE_LINES_TL SUBT
1086: WHERE SUBB.ID = SUBT.ID
1087: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1088: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1089: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 1093: INSERT INTO OKL_TXL_QUOTE_LINES_TL (

1089: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
1090: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
1091: ));
1092:
1093: INSERT INTO OKL_TXL_QUOTE_LINES_TL (
1094: ID,
1095: LANGUAGE,
1096: SOURCE_LANG,
1097: SFWT_FLAG,

Line 1115: FROM OKL_TXL_QUOTE_LINES_TL B, FND_LANGUAGES L

1111: B.CREATION_DATE,
1112: B.LAST_UPDATED_BY,
1113: B.LAST_UPDATE_DATE,
1114: B.LAST_UPDATE_LOGIN
1115: FROM OKL_TXL_QUOTE_LINES_TL B, FND_LANGUAGES L
1116: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1117: AND B.LANGUAGE = USERENV('LANG')
1118: AND NOT EXISTS(
1119: SELECT NULL

Line 1120: FROM OKL_TXL_QUOTE_LINES_TL T

1116: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1117: AND B.LANGUAGE = USERENV('LANG')
1118: AND NOT EXISTS(
1119: SELECT NULL
1120: FROM OKL_TXL_QUOTE_LINES_TL T
1121: WHERE T.ID = B.ID
1122: AND T.LANGUAGE = L.LANGUAGE_CODE
1123: );
1124:

Line 1293: -- FUNCTION get_rec for: OKL_TXL_QUOTE_LINES_TL

1289: BEGIN
1290: RETURN(get_rec(p_tql_rec, l_row_notfound));
1291: END get_rec;
1292: ---------------------------------------------------------------------------
1293: -- FUNCTION get_rec for: OKL_TXL_QUOTE_LINES_TL
1294: ---------------------------------------------------------------------------
1295: FUNCTION get_rec (
1296: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
1297: x_no_data_found OUT NOCOPY BOOLEAN

Line 1296: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,

1292: ---------------------------------------------------------------------------
1293: -- FUNCTION get_rec for: OKL_TXL_QUOTE_LINES_TL
1294: ---------------------------------------------------------------------------
1295: FUNCTION get_rec (
1296: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
1297: x_no_data_found OUT NOCOPY BOOLEAN
1298: ) RETURN OklTxlQuoteLinesTlRecType IS
1299: CURSOR okl_txl_quote_lines_tl_pk_csr (p_id IN NUMBER,
1300: p_language IN VARCHAR2) IS

Line 1299: CURSOR okl_txl_quote_lines_tl_pk_csr (p_id IN NUMBER,

1295: FUNCTION get_rec (
1296: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
1297: x_no_data_found OUT NOCOPY BOOLEAN
1298: ) RETURN OklTxlQuoteLinesTlRecType IS
1299: CURSOR okl_txl_quote_lines_tl_pk_csr (p_id IN NUMBER,
1300: p_language IN VARCHAR2) IS
1301: SELECT
1302: ID,
1303: LANGUAGE,

Line 1312: FROM Okl_Txl_Quote_Lines_Tl

1308: CREATION_DATE,
1309: LAST_UPDATED_BY,
1310: LAST_UPDATE_DATE,
1311: LAST_UPDATE_LOGIN
1312: FROM Okl_Txl_Quote_Lines_Tl
1313: WHERE okl_txl_quote_lines_tl.id = p_id
1314: AND okl_txl_quote_lines_tl.language = p_language;
1315: l_okl_txl_quote_lines_tl_pk okl_txl_quote_lines_tl_pk_csr%ROWTYPE;
1316: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

Line 1313: WHERE okl_txl_quote_lines_tl.id = p_id

1309: LAST_UPDATED_BY,
1310: LAST_UPDATE_DATE,
1311: LAST_UPDATE_LOGIN
1312: FROM Okl_Txl_Quote_Lines_Tl
1313: WHERE okl_txl_quote_lines_tl.id = p_id
1314: AND okl_txl_quote_lines_tl.language = p_language;
1315: l_okl_txl_quote_lines_tl_pk okl_txl_quote_lines_tl_pk_csr%ROWTYPE;
1316: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
1317: BEGIN

Line 1314: AND okl_txl_quote_lines_tl.language = p_language;

1310: LAST_UPDATE_DATE,
1311: LAST_UPDATE_LOGIN
1312: FROM Okl_Txl_Quote_Lines_Tl
1313: WHERE okl_txl_quote_lines_tl.id = p_id
1314: AND okl_txl_quote_lines_tl.language = p_language;
1315: l_okl_txl_quote_lines_tl_pk okl_txl_quote_lines_tl_pk_csr%ROWTYPE;
1316: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
1317: BEGIN
1318: x_no_data_found := TRUE;

Line 1315: l_okl_txl_quote_lines_tl_pk okl_txl_quote_lines_tl_pk_csr%ROWTYPE;

1311: LAST_UPDATE_LOGIN
1312: FROM Okl_Txl_Quote_Lines_Tl
1313: WHERE okl_txl_quote_lines_tl.id = p_id
1314: AND okl_txl_quote_lines_tl.language = p_language;
1315: l_okl_txl_quote_lines_tl_pk okl_txl_quote_lines_tl_pk_csr%ROWTYPE;
1316: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
1317: BEGIN
1318: x_no_data_found := TRUE;
1319: -- Get current database values

Line 1316: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

1312: FROM Okl_Txl_Quote_Lines_Tl
1313: WHERE okl_txl_quote_lines_tl.id = p_id
1314: AND okl_txl_quote_lines_tl.language = p_language;
1315: l_okl_txl_quote_lines_tl_pk okl_txl_quote_lines_tl_pk_csr%ROWTYPE;
1316: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
1317: BEGIN
1318: x_no_data_found := TRUE;
1319: -- Get current database values
1320: OPEN okl_txl_quote_lines_tl_pk_csr (p_okl_txl_quote_lines_tl_rec.id,

Line 1320: OPEN okl_txl_quote_lines_tl_pk_csr (p_okl_txl_quote_lines_tl_rec.id,

1316: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
1317: BEGIN
1318: x_no_data_found := TRUE;
1319: -- Get current database values
1320: OPEN okl_txl_quote_lines_tl_pk_csr (p_okl_txl_quote_lines_tl_rec.id,
1321: p_okl_txl_quote_lines_tl_rec.language);
1322: FETCH okl_txl_quote_lines_tl_pk_csr INTO
1323: l_okl_txl_quote_lines_tl_rec.ID,
1324: l_okl_txl_quote_lines_tl_rec.LANGUAGE,

Line 1321: p_okl_txl_quote_lines_tl_rec.language);

1317: BEGIN
1318: x_no_data_found := TRUE;
1319: -- Get current database values
1320: OPEN okl_txl_quote_lines_tl_pk_csr (p_okl_txl_quote_lines_tl_rec.id,
1321: p_okl_txl_quote_lines_tl_rec.language);
1322: FETCH okl_txl_quote_lines_tl_pk_csr INTO
1323: l_okl_txl_quote_lines_tl_rec.ID,
1324: l_okl_txl_quote_lines_tl_rec.LANGUAGE,
1325: l_okl_txl_quote_lines_tl_rec.SOURCE_LANG,

Line 1322: FETCH okl_txl_quote_lines_tl_pk_csr INTO

1318: x_no_data_found := TRUE;
1319: -- Get current database values
1320: OPEN okl_txl_quote_lines_tl_pk_csr (p_okl_txl_quote_lines_tl_rec.id,
1321: p_okl_txl_quote_lines_tl_rec.language);
1322: FETCH okl_txl_quote_lines_tl_pk_csr INTO
1323: l_okl_txl_quote_lines_tl_rec.ID,
1324: l_okl_txl_quote_lines_tl_rec.LANGUAGE,
1325: l_okl_txl_quote_lines_tl_rec.SOURCE_LANG,
1326: l_okl_txl_quote_lines_tl_rec.SFWT_FLAG,

Line 1323: l_okl_txl_quote_lines_tl_rec.ID,

1319: -- Get current database values
1320: OPEN okl_txl_quote_lines_tl_pk_csr (p_okl_txl_quote_lines_tl_rec.id,
1321: p_okl_txl_quote_lines_tl_rec.language);
1322: FETCH okl_txl_quote_lines_tl_pk_csr INTO
1323: l_okl_txl_quote_lines_tl_rec.ID,
1324: l_okl_txl_quote_lines_tl_rec.LANGUAGE,
1325: l_okl_txl_quote_lines_tl_rec.SOURCE_LANG,
1326: l_okl_txl_quote_lines_tl_rec.SFWT_FLAG,
1327: l_okl_txl_quote_lines_tl_rec.DESCRIPTION,

Line 1324: l_okl_txl_quote_lines_tl_rec.LANGUAGE,

1320: OPEN okl_txl_quote_lines_tl_pk_csr (p_okl_txl_quote_lines_tl_rec.id,
1321: p_okl_txl_quote_lines_tl_rec.language);
1322: FETCH okl_txl_quote_lines_tl_pk_csr INTO
1323: l_okl_txl_quote_lines_tl_rec.ID,
1324: l_okl_txl_quote_lines_tl_rec.LANGUAGE,
1325: l_okl_txl_quote_lines_tl_rec.SOURCE_LANG,
1326: l_okl_txl_quote_lines_tl_rec.SFWT_FLAG,
1327: l_okl_txl_quote_lines_tl_rec.DESCRIPTION,
1328: l_okl_txl_quote_lines_tl_rec.CREATED_BY,

Line 1325: l_okl_txl_quote_lines_tl_rec.SOURCE_LANG,

1321: p_okl_txl_quote_lines_tl_rec.language);
1322: FETCH okl_txl_quote_lines_tl_pk_csr INTO
1323: l_okl_txl_quote_lines_tl_rec.ID,
1324: l_okl_txl_quote_lines_tl_rec.LANGUAGE,
1325: l_okl_txl_quote_lines_tl_rec.SOURCE_LANG,
1326: l_okl_txl_quote_lines_tl_rec.SFWT_FLAG,
1327: l_okl_txl_quote_lines_tl_rec.DESCRIPTION,
1328: l_okl_txl_quote_lines_tl_rec.CREATED_BY,
1329: l_okl_txl_quote_lines_tl_rec.CREATION_DATE,

Line 1326: l_okl_txl_quote_lines_tl_rec.SFWT_FLAG,

1322: FETCH okl_txl_quote_lines_tl_pk_csr INTO
1323: l_okl_txl_quote_lines_tl_rec.ID,
1324: l_okl_txl_quote_lines_tl_rec.LANGUAGE,
1325: l_okl_txl_quote_lines_tl_rec.SOURCE_LANG,
1326: l_okl_txl_quote_lines_tl_rec.SFWT_FLAG,
1327: l_okl_txl_quote_lines_tl_rec.DESCRIPTION,
1328: l_okl_txl_quote_lines_tl_rec.CREATED_BY,
1329: l_okl_txl_quote_lines_tl_rec.CREATION_DATE,
1330: l_okl_txl_quote_lines_tl_rec.LAST_UPDATED_BY,

Line 1327: l_okl_txl_quote_lines_tl_rec.DESCRIPTION,

1323: l_okl_txl_quote_lines_tl_rec.ID,
1324: l_okl_txl_quote_lines_tl_rec.LANGUAGE,
1325: l_okl_txl_quote_lines_tl_rec.SOURCE_LANG,
1326: l_okl_txl_quote_lines_tl_rec.SFWT_FLAG,
1327: l_okl_txl_quote_lines_tl_rec.DESCRIPTION,
1328: l_okl_txl_quote_lines_tl_rec.CREATED_BY,
1329: l_okl_txl_quote_lines_tl_rec.CREATION_DATE,
1330: l_okl_txl_quote_lines_tl_rec.LAST_UPDATED_BY,
1331: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_DATE,

Line 1328: l_okl_txl_quote_lines_tl_rec.CREATED_BY,

1324: l_okl_txl_quote_lines_tl_rec.LANGUAGE,
1325: l_okl_txl_quote_lines_tl_rec.SOURCE_LANG,
1326: l_okl_txl_quote_lines_tl_rec.SFWT_FLAG,
1327: l_okl_txl_quote_lines_tl_rec.DESCRIPTION,
1328: l_okl_txl_quote_lines_tl_rec.CREATED_BY,
1329: l_okl_txl_quote_lines_tl_rec.CREATION_DATE,
1330: l_okl_txl_quote_lines_tl_rec.LAST_UPDATED_BY,
1331: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_DATE,
1332: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_LOGIN;

Line 1329: l_okl_txl_quote_lines_tl_rec.CREATION_DATE,

1325: l_okl_txl_quote_lines_tl_rec.SOURCE_LANG,
1326: l_okl_txl_quote_lines_tl_rec.SFWT_FLAG,
1327: l_okl_txl_quote_lines_tl_rec.DESCRIPTION,
1328: l_okl_txl_quote_lines_tl_rec.CREATED_BY,
1329: l_okl_txl_quote_lines_tl_rec.CREATION_DATE,
1330: l_okl_txl_quote_lines_tl_rec.LAST_UPDATED_BY,
1331: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_DATE,
1332: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_LOGIN;
1333: x_no_data_found := okl_txl_quote_lines_tl_pk_csr%NOTFOUND;

Line 1330: l_okl_txl_quote_lines_tl_rec.LAST_UPDATED_BY,

1326: l_okl_txl_quote_lines_tl_rec.SFWT_FLAG,
1327: l_okl_txl_quote_lines_tl_rec.DESCRIPTION,
1328: l_okl_txl_quote_lines_tl_rec.CREATED_BY,
1329: l_okl_txl_quote_lines_tl_rec.CREATION_DATE,
1330: l_okl_txl_quote_lines_tl_rec.LAST_UPDATED_BY,
1331: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_DATE,
1332: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_LOGIN;
1333: x_no_data_found := okl_txl_quote_lines_tl_pk_csr%NOTFOUND;
1334: CLOSE okl_txl_quote_lines_tl_pk_csr;

Line 1331: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_DATE,

1327: l_okl_txl_quote_lines_tl_rec.DESCRIPTION,
1328: l_okl_txl_quote_lines_tl_rec.CREATED_BY,
1329: l_okl_txl_quote_lines_tl_rec.CREATION_DATE,
1330: l_okl_txl_quote_lines_tl_rec.LAST_UPDATED_BY,
1331: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_DATE,
1332: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_LOGIN;
1333: x_no_data_found := okl_txl_quote_lines_tl_pk_csr%NOTFOUND;
1334: CLOSE okl_txl_quote_lines_tl_pk_csr;
1335: RETURN(l_okl_txl_quote_lines_tl_rec);

Line 1332: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_LOGIN;

1328: l_okl_txl_quote_lines_tl_rec.CREATED_BY,
1329: l_okl_txl_quote_lines_tl_rec.CREATION_DATE,
1330: l_okl_txl_quote_lines_tl_rec.LAST_UPDATED_BY,
1331: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_DATE,
1332: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_LOGIN;
1333: x_no_data_found := okl_txl_quote_lines_tl_pk_csr%NOTFOUND;
1334: CLOSE okl_txl_quote_lines_tl_pk_csr;
1335: RETURN(l_okl_txl_quote_lines_tl_rec);
1336: END get_rec;

Line 1333: x_no_data_found := okl_txl_quote_lines_tl_pk_csr%NOTFOUND;

1329: l_okl_txl_quote_lines_tl_rec.CREATION_DATE,
1330: l_okl_txl_quote_lines_tl_rec.LAST_UPDATED_BY,
1331: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_DATE,
1332: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_LOGIN;
1333: x_no_data_found := okl_txl_quote_lines_tl_pk_csr%NOTFOUND;
1334: CLOSE okl_txl_quote_lines_tl_pk_csr;
1335: RETURN(l_okl_txl_quote_lines_tl_rec);
1336: END get_rec;
1337:

Line 1334: CLOSE okl_txl_quote_lines_tl_pk_csr;

1330: l_okl_txl_quote_lines_tl_rec.LAST_UPDATED_BY,
1331: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_DATE,
1332: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_LOGIN;
1333: x_no_data_found := okl_txl_quote_lines_tl_pk_csr%NOTFOUND;
1334: CLOSE okl_txl_quote_lines_tl_pk_csr;
1335: RETURN(l_okl_txl_quote_lines_tl_rec);
1336: END get_rec;
1337:
1338: FUNCTION get_rec (

Line 1335: RETURN(l_okl_txl_quote_lines_tl_rec);

1331: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_DATE,
1332: l_okl_txl_quote_lines_tl_rec.LAST_UPDATE_LOGIN;
1333: x_no_data_found := okl_txl_quote_lines_tl_pk_csr%NOTFOUND;
1334: CLOSE okl_txl_quote_lines_tl_pk_csr;
1335: RETURN(l_okl_txl_quote_lines_tl_rec);
1336: END get_rec;
1337:
1338: FUNCTION get_rec (
1339: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType

Line 1339: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType

1335: RETURN(l_okl_txl_quote_lines_tl_rec);
1336: END get_rec;
1337:
1338: FUNCTION get_rec (
1339: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType
1340: ) RETURN OklTxlQuoteLinesTlRecType IS
1341: l_row_notfound BOOLEAN := TRUE;
1342: BEGIN
1343: RETURN(get_rec(p_okl_txl_quote_lines_tl_rec, l_row_notfound));

Line 1343: RETURN(get_rec(p_okl_txl_quote_lines_tl_rec, l_row_notfound));

1339: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType
1340: ) RETURN OklTxlQuoteLinesTlRecType IS
1341: l_row_notfound BOOLEAN := TRUE;
1342: BEGIN
1343: RETURN(get_rec(p_okl_txl_quote_lines_tl_rec, l_row_notfound));
1344: END get_rec;
1345: ---------------------------------------------------------------------------
1346: -- FUNCTION get_rec for: OKL_TXL_QUOTE_LINES_V
1347: ---------------------------------------------------------------------------

Line 2178: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

2174: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
2175: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2176: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
2177: l_tql_rec tql_rec_type;
2178: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
2179: BEGIN
2180: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2181: G_PKG_NAME,
2182: p_init_msg_list,

Line 2548: -- insert_row for:OKL_TXL_QUOTE_LINES_TL --

2544: '_PVT'
2545: );
2546: END insert_row;
2547: -------------------------------------------
2548: -- insert_row for:OKL_TXL_QUOTE_LINES_TL --
2549: -------------------------------------------
2550: PROCEDURE insert_row(
2551: p_init_msg_list IN VARCHAR2,
2552: x_return_status OUT NOCOPY VARCHAR2,

Line 2555: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,

2551: p_init_msg_list IN VARCHAR2,
2552: x_return_status OUT NOCOPY VARCHAR2,
2553: x_msg_count OUT NOCOPY NUMBER,
2554: x_msg_data OUT NOCOPY VARCHAR2,
2555: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
2556: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType) IS
2557:
2558: l_api_version CONSTANT NUMBER := 1;
2559: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 2556: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType) IS

2552: x_return_status OUT NOCOPY VARCHAR2,
2553: x_msg_count OUT NOCOPY NUMBER,
2554: x_msg_data OUT NOCOPY VARCHAR2,
2555: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
2556: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType) IS
2557:
2558: l_api_version CONSTANT NUMBER := 1;
2559: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2560: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2561: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType := p_okl_txl_quote_lines_tl_rec;

2557:
2558: l_api_version CONSTANT NUMBER := 1;
2559: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2560: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2561: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType := p_okl_txl_quote_lines_tl_rec;
2562: ldefokltxlquotelinestlrec OklTxlQuoteLinesTlRecType;
2563: CURSOR get_languages IS
2564: SELECT *
2565: FROM FND_LANGUAGES

Line 2568: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --

2564: SELECT *
2565: FROM FND_LANGUAGES
2566: WHERE INSTALLED_FLAG IN ('I', 'B');
2567: -----------------------------------------------
2568: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
2569: -----------------------------------------------
2570: FUNCTION Set_Attributes (
2571: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
2572: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

Line 2571: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,

2567: -----------------------------------------------
2568: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
2569: -----------------------------------------------
2570: FUNCTION Set_Attributes (
2571: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
2572: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
2573: ) RETURN VARCHAR2 IS
2574: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2575: BEGIN

Line 2572: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

2568: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
2569: -----------------------------------------------
2570: FUNCTION Set_Attributes (
2571: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
2572: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
2573: ) RETURN VARCHAR2 IS
2574: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2575: BEGIN
2576: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

Line 2576: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

2572: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
2573: ) RETURN VARCHAR2 IS
2574: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2575: BEGIN
2576: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
2577: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
2578: x_okl_txl_quote_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
2579: RETURN(l_return_status);
2580: END Set_Attributes;

Line 2577: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');

2573: ) RETURN VARCHAR2 IS
2574: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2575: BEGIN
2576: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
2577: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
2578: x_okl_txl_quote_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
2579: RETURN(l_return_status);
2580: END Set_Attributes;
2581: BEGIN

Line 2578: x_okl_txl_quote_lines_tl_rec.SOURCE_LANG := USERENV('LANG');

2574: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2575: BEGIN
2576: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
2577: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
2578: x_okl_txl_quote_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
2579: RETURN(l_return_status);
2580: END Set_Attributes;
2581: BEGIN
2582: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2593: p_okl_txl_quote_lines_tl_rec, -- IN

2589: RAISE OKC_API.G_EXCEPTION_ERROR;
2590: END IF;
2591: --- Setting item attributes
2592: l_return_status := Set_Attributes(
2593: p_okl_txl_quote_lines_tl_rec, -- IN
2594: l_okl_txl_quote_lines_tl_rec); -- OUT
2595: --- If any errors happen abort API
2596: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2597: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2594: l_okl_txl_quote_lines_tl_rec); -- OUT

2590: END IF;
2591: --- Setting item attributes
2592: l_return_status := Set_Attributes(
2593: p_okl_txl_quote_lines_tl_rec, -- IN
2594: l_okl_txl_quote_lines_tl_rec); -- OUT
2595: --- If any errors happen abort API
2596: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2597: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2598: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2602: l_okl_txl_quote_lines_tl_rec.language := l_lang_rec.language_code;

2598: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2599: RAISE OKC_API.G_EXCEPTION_ERROR;
2600: END IF;
2601: FOR l_lang_rec IN get_languages LOOP
2602: l_okl_txl_quote_lines_tl_rec.language := l_lang_rec.language_code;
2603: INSERT INTO OKL_TXL_QUOTE_LINES_TL(
2604: id,
2605: language,
2606: source_lang,

Line 2603: INSERT INTO OKL_TXL_QUOTE_LINES_TL(

2599: RAISE OKC_API.G_EXCEPTION_ERROR;
2600: END IF;
2601: FOR l_lang_rec IN get_languages LOOP
2602: l_okl_txl_quote_lines_tl_rec.language := l_lang_rec.language_code;
2603: INSERT INTO OKL_TXL_QUOTE_LINES_TL(
2604: id,
2605: language,
2606: source_lang,
2607: sfwt_flag,

Line 2615: l_okl_txl_quote_lines_tl_rec.id,

2611: last_updated_by,
2612: last_update_date,
2613: last_update_login)
2614: VALUES (
2615: l_okl_txl_quote_lines_tl_rec.id,
2616: l_okl_txl_quote_lines_tl_rec.language,
2617: l_okl_txl_quote_lines_tl_rec.source_lang,
2618: l_okl_txl_quote_lines_tl_rec.sfwt_flag,
2619: l_okl_txl_quote_lines_tl_rec.description,

Line 2616: l_okl_txl_quote_lines_tl_rec.language,

2612: last_update_date,
2613: last_update_login)
2614: VALUES (
2615: l_okl_txl_quote_lines_tl_rec.id,
2616: l_okl_txl_quote_lines_tl_rec.language,
2617: l_okl_txl_quote_lines_tl_rec.source_lang,
2618: l_okl_txl_quote_lines_tl_rec.sfwt_flag,
2619: l_okl_txl_quote_lines_tl_rec.description,
2620: l_okl_txl_quote_lines_tl_rec.created_by,

Line 2617: l_okl_txl_quote_lines_tl_rec.source_lang,

2613: last_update_login)
2614: VALUES (
2615: l_okl_txl_quote_lines_tl_rec.id,
2616: l_okl_txl_quote_lines_tl_rec.language,
2617: l_okl_txl_quote_lines_tl_rec.source_lang,
2618: l_okl_txl_quote_lines_tl_rec.sfwt_flag,
2619: l_okl_txl_quote_lines_tl_rec.description,
2620: l_okl_txl_quote_lines_tl_rec.created_by,
2621: l_okl_txl_quote_lines_tl_rec.creation_date,

Line 2618: l_okl_txl_quote_lines_tl_rec.sfwt_flag,

2614: VALUES (
2615: l_okl_txl_quote_lines_tl_rec.id,
2616: l_okl_txl_quote_lines_tl_rec.language,
2617: l_okl_txl_quote_lines_tl_rec.source_lang,
2618: l_okl_txl_quote_lines_tl_rec.sfwt_flag,
2619: l_okl_txl_quote_lines_tl_rec.description,
2620: l_okl_txl_quote_lines_tl_rec.created_by,
2621: l_okl_txl_quote_lines_tl_rec.creation_date,
2622: l_okl_txl_quote_lines_tl_rec.last_updated_by,

Line 2619: l_okl_txl_quote_lines_tl_rec.description,

2615: l_okl_txl_quote_lines_tl_rec.id,
2616: l_okl_txl_quote_lines_tl_rec.language,
2617: l_okl_txl_quote_lines_tl_rec.source_lang,
2618: l_okl_txl_quote_lines_tl_rec.sfwt_flag,
2619: l_okl_txl_quote_lines_tl_rec.description,
2620: l_okl_txl_quote_lines_tl_rec.created_by,
2621: l_okl_txl_quote_lines_tl_rec.creation_date,
2622: l_okl_txl_quote_lines_tl_rec.last_updated_by,
2623: l_okl_txl_quote_lines_tl_rec.last_update_date,

Line 2620: l_okl_txl_quote_lines_tl_rec.created_by,

2616: l_okl_txl_quote_lines_tl_rec.language,
2617: l_okl_txl_quote_lines_tl_rec.source_lang,
2618: l_okl_txl_quote_lines_tl_rec.sfwt_flag,
2619: l_okl_txl_quote_lines_tl_rec.description,
2620: l_okl_txl_quote_lines_tl_rec.created_by,
2621: l_okl_txl_quote_lines_tl_rec.creation_date,
2622: l_okl_txl_quote_lines_tl_rec.last_updated_by,
2623: l_okl_txl_quote_lines_tl_rec.last_update_date,
2624: l_okl_txl_quote_lines_tl_rec.last_update_login);

Line 2621: l_okl_txl_quote_lines_tl_rec.creation_date,

2617: l_okl_txl_quote_lines_tl_rec.source_lang,
2618: l_okl_txl_quote_lines_tl_rec.sfwt_flag,
2619: l_okl_txl_quote_lines_tl_rec.description,
2620: l_okl_txl_quote_lines_tl_rec.created_by,
2621: l_okl_txl_quote_lines_tl_rec.creation_date,
2622: l_okl_txl_quote_lines_tl_rec.last_updated_by,
2623: l_okl_txl_quote_lines_tl_rec.last_update_date,
2624: l_okl_txl_quote_lines_tl_rec.last_update_login);
2625: END LOOP;

Line 2622: l_okl_txl_quote_lines_tl_rec.last_updated_by,

2618: l_okl_txl_quote_lines_tl_rec.sfwt_flag,
2619: l_okl_txl_quote_lines_tl_rec.description,
2620: l_okl_txl_quote_lines_tl_rec.created_by,
2621: l_okl_txl_quote_lines_tl_rec.creation_date,
2622: l_okl_txl_quote_lines_tl_rec.last_updated_by,
2623: l_okl_txl_quote_lines_tl_rec.last_update_date,
2624: l_okl_txl_quote_lines_tl_rec.last_update_login);
2625: END LOOP;
2626: -- Set OUT values

Line 2623: l_okl_txl_quote_lines_tl_rec.last_update_date,

2619: l_okl_txl_quote_lines_tl_rec.description,
2620: l_okl_txl_quote_lines_tl_rec.created_by,
2621: l_okl_txl_quote_lines_tl_rec.creation_date,
2622: l_okl_txl_quote_lines_tl_rec.last_updated_by,
2623: l_okl_txl_quote_lines_tl_rec.last_update_date,
2624: l_okl_txl_quote_lines_tl_rec.last_update_login);
2625: END LOOP;
2626: -- Set OUT values
2627: x_okl_txl_quote_lines_tl_rec := l_okl_txl_quote_lines_tl_rec;

Line 2624: l_okl_txl_quote_lines_tl_rec.last_update_login);

2620: l_okl_txl_quote_lines_tl_rec.created_by,
2621: l_okl_txl_quote_lines_tl_rec.creation_date,
2622: l_okl_txl_quote_lines_tl_rec.last_updated_by,
2623: l_okl_txl_quote_lines_tl_rec.last_update_date,
2624: l_okl_txl_quote_lines_tl_rec.last_update_login);
2625: END LOOP;
2626: -- Set OUT values
2627: x_okl_txl_quote_lines_tl_rec := l_okl_txl_quote_lines_tl_rec;
2628: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2627: x_okl_txl_quote_lines_tl_rec := l_okl_txl_quote_lines_tl_rec;

2623: l_okl_txl_quote_lines_tl_rec.last_update_date,
2624: l_okl_txl_quote_lines_tl_rec.last_update_login);
2625: END LOOP;
2626: -- Set OUT values
2627: x_okl_txl_quote_lines_tl_rec := l_okl_txl_quote_lines_tl_rec;
2628: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2629: EXCEPTION
2630: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2631: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2694: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

2690: l_tqlv_rec tqlv_rec_type;
2691: l_def_tqlv_rec tqlv_rec_type;
2692: l_tql_rec tql_rec_type;
2693: lx_tql_rec tql_rec_type;
2694: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
2695: lx_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
2696:
2697:
2698: -- RMUNJULU 09-MAY-03 2949544 Added variable

Line 2695: lx_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

2691: l_def_tqlv_rec tqlv_rec_type;
2692: l_tql_rec tql_rec_type;
2693: lx_tql_rec tql_rec_type;
2694: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
2695: lx_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
2696:
2697:
2698: -- RMUNJULU 09-MAY-03 2949544 Added variable
2699: l_rounded_amount NUMBER;

Line 2821: migrate(l_def_tqlv_rec, l_okl_txl_quote_lines_tl_rec);

2817: --------------------------------------
2818: -- Move VIEW record to "Child" records
2819: --------------------------------------
2820: migrate(l_def_tqlv_rec, l_tql_rec);
2821: migrate(l_def_tqlv_rec, l_okl_txl_quote_lines_tl_rec);
2822: --------------------------------------------
2823: -- Call the INSERT_ROW for each child record
2824: --------------------------------------------
2825: insert_row(

Line 2844: l_okl_txl_quote_lines_tl_rec,

2840: p_init_msg_list,
2841: x_return_status,
2842: x_msg_count,
2843: x_msg_data,
2844: l_okl_txl_quote_lines_tl_rec,
2845: lx_okl_txl_quote_lines_tl_rec
2846: );
2847: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2848: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2845: lx_okl_txl_quote_lines_tl_rec

2841: x_return_status,
2842: x_msg_count,
2843: x_msg_data,
2844: l_okl_txl_quote_lines_tl_rec,
2845: lx_okl_txl_quote_lines_tl_rec
2846: );
2847: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2848: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2849: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2852: migrate(lx_okl_txl_quote_lines_tl_rec, l_def_tqlv_rec);

2848: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2849: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2850: RAISE OKC_API.G_EXCEPTION_ERROR;
2851: END IF;
2852: migrate(lx_okl_txl_quote_lines_tl_rec, l_def_tqlv_rec);
2853: -- Set OUT values
2854: x_tqlv_rec := l_def_tqlv_rec;
2855: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2856: EXCEPTION

Line 3403: INSERT INTO OKL_TXL_QUOTE_LINES_TL(

3399: FOR l_lang_rec IN get_languages LOOP
3400:
3401: -- Bulk insert into tl table
3402: FORALL i in 1..l_tabsize
3403: INSERT INTO OKL_TXL_QUOTE_LINES_TL(
3404: id,
3405: language,
3406: source_lang,
3407: sfwt_flag,

Line 3575: -- lock_row for:OKL_TXL_QUOTE_LINES_TL --

3571: '_PVT'
3572: );
3573: END lock_row;
3574: -----------------------------------------
3575: -- lock_row for:OKL_TXL_QUOTE_LINES_TL --
3576: -----------------------------------------
3577: PROCEDURE lock_row(
3578: p_init_msg_list IN VARCHAR2,
3579: x_return_status OUT NOCOPY VARCHAR2,

Line 3582: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS

3578: p_init_msg_list IN VARCHAR2,
3579: x_return_status OUT NOCOPY VARCHAR2,
3580: x_msg_count OUT NOCOPY NUMBER,
3581: x_msg_data OUT NOCOPY VARCHAR2,
3582: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
3583:
3584: E_Resource_Busy EXCEPTION;
3585: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3586: CURSOR lock_csr (p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS

Line 3586: CURSOR lock_csr (p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS

3582: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
3583:
3584: E_Resource_Busy EXCEPTION;
3585: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3586: CURSOR lock_csr (p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
3587: SELECT *
3588: FROM OKL_TXL_QUOTE_LINES_TL
3589: WHERE ID = p_okl_txl_quote_lines_tl_rec.id
3590: FOR UPDATE NOWAIT;

Line 3588: FROM OKL_TXL_QUOTE_LINES_TL

3584: E_Resource_Busy EXCEPTION;
3585: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3586: CURSOR lock_csr (p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
3587: SELECT *
3588: FROM OKL_TXL_QUOTE_LINES_TL
3589: WHERE ID = p_okl_txl_quote_lines_tl_rec.id
3590: FOR UPDATE NOWAIT;
3591:
3592: l_api_version CONSTANT NUMBER := 1;

Line 3589: WHERE ID = p_okl_txl_quote_lines_tl_rec.id

3585: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3586: CURSOR lock_csr (p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
3587: SELECT *
3588: FROM OKL_TXL_QUOTE_LINES_TL
3589: WHERE ID = p_okl_txl_quote_lines_tl_rec.id
3590: FOR UPDATE NOWAIT;
3591:
3592: l_api_version CONSTANT NUMBER := 1;
3593: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 3609: OPEN lock_csr(p_okl_txl_quote_lines_tl_rec);

3605: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3606: RAISE OKC_API.G_EXCEPTION_ERROR;
3607: END IF;
3608: BEGIN
3609: OPEN lock_csr(p_okl_txl_quote_lines_tl_rec);
3610: FETCH lock_csr INTO l_lock_var;
3611: l_row_notfound := lock_csr%NOTFOUND;
3612: CLOSE lock_csr;
3613: EXCEPTION

Line 3674: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

3670: l_api_version CONSTANT NUMBER := 1;
3671: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
3672: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3673: l_tql_rec tql_rec_type;
3674: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
3675: BEGIN
3676: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3677: G_PKG_NAME,
3678: p_init_msg_list,

Line 3692: migrate(p_tqlv_rec, l_okl_txl_quote_lines_tl_rec);

3688: --------------------------------------
3689: -- Move VIEW record to "Child" records
3690: --------------------------------------
3691: migrate(p_tqlv_rec, l_tql_rec);
3692: migrate(p_tqlv_rec, l_okl_txl_quote_lines_tl_rec);
3693: --------------------------------------------
3694: -- Call the LOCK_ROW for each child record
3695: --------------------------------------------
3696: lock_row(

Line 3713: l_okl_txl_quote_lines_tl_rec

3709: p_init_msg_list,
3710: x_return_status,
3711: x_msg_count,
3712: x_msg_data,
3713: l_okl_txl_quote_lines_tl_rec
3714: );
3715: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3716: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3717: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4284: -- update_row for:OKL_TXL_QUOTE_LINES_TL --

4280: '_PVT'
4281: );
4282: END update_row;
4283: -------------------------------------------
4284: -- update_row for:OKL_TXL_QUOTE_LINES_TL --
4285: -------------------------------------------
4286: PROCEDURE update_row(
4287: p_init_msg_list IN VARCHAR2,
4288: x_return_status OUT NOCOPY VARCHAR2,

Line 4291: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,

4287: p_init_msg_list IN VARCHAR2,
4288: x_return_status OUT NOCOPY VARCHAR2,
4289: x_msg_count OUT NOCOPY NUMBER,
4290: x_msg_data OUT NOCOPY VARCHAR2,
4291: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4292: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType) IS
4293:
4294: l_api_version CONSTANT NUMBER := 1;
4295: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 4292: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType) IS

4288: x_return_status OUT NOCOPY VARCHAR2,
4289: x_msg_count OUT NOCOPY NUMBER,
4290: x_msg_data OUT NOCOPY VARCHAR2,
4291: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4292: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType) IS
4293:
4294: l_api_version CONSTANT NUMBER := 1;
4295: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4296: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4297: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType := p_okl_txl_quote_lines_tl_rec;

4293:
4294: l_api_version CONSTANT NUMBER := 1;
4295: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4296: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4297: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType := p_okl_txl_quote_lines_tl_rec;
4298: ldefokltxlquotelinestlrec OklTxlQuoteLinesTlRecType;
4299: l_row_notfound BOOLEAN := TRUE;
4300: ----------------------------------
4301: -- FUNCTION populate_new_record --

Line 4304: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,

4300: ----------------------------------
4301: -- FUNCTION populate_new_record --
4302: ----------------------------------
4303: FUNCTION populate_new_record (
4304: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4305: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4306: ) RETURN VARCHAR2 IS
4307: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4308: l_row_notfound BOOLEAN := TRUE;

Line 4305: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

4301: -- FUNCTION populate_new_record --
4302: ----------------------------------
4303: FUNCTION populate_new_record (
4304: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4305: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4306: ) RETURN VARCHAR2 IS
4307: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4308: l_row_notfound BOOLEAN := TRUE;
4309: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4307: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

4303: FUNCTION populate_new_record (
4304: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4305: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4306: ) RETURN VARCHAR2 IS
4307: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4308: l_row_notfound BOOLEAN := TRUE;
4309: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4310: BEGIN
4311: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

Line 4311: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

4307: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4308: l_row_notfound BOOLEAN := TRUE;
4309: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4310: BEGIN
4311: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
4312: -- Get current database values
4313: l_okl_txl_quote_lines_tl_rec := get_rec(p_okl_txl_quote_lines_tl_rec, l_row_notfound);
4314: IF (l_row_notfound) THEN
4315: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 4313: l_okl_txl_quote_lines_tl_rec := get_rec(p_okl_txl_quote_lines_tl_rec, l_row_notfound);

4309: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4310: BEGIN
4311: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
4312: -- Get current database values
4313: l_okl_txl_quote_lines_tl_rec := get_rec(p_okl_txl_quote_lines_tl_rec, l_row_notfound);
4314: IF (l_row_notfound) THEN
4315: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4316: END IF;
4317: IF (x_okl_txl_quote_lines_tl_rec.id = OKC_API.G_MISS_NUM)

Line 4317: IF (x_okl_txl_quote_lines_tl_rec.id = OKC_API.G_MISS_NUM)

4313: l_okl_txl_quote_lines_tl_rec := get_rec(p_okl_txl_quote_lines_tl_rec, l_row_notfound);
4314: IF (l_row_notfound) THEN
4315: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4316: END IF;
4317: IF (x_okl_txl_quote_lines_tl_rec.id = OKC_API.G_MISS_NUM)
4318: THEN
4319: x_okl_txl_quote_lines_tl_rec.id := l_okl_txl_quote_lines_tl_rec.id;
4320: END IF;
4321: IF (x_okl_txl_quote_lines_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 4319: x_okl_txl_quote_lines_tl_rec.id := l_okl_txl_quote_lines_tl_rec.id;

4315: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4316: END IF;
4317: IF (x_okl_txl_quote_lines_tl_rec.id = OKC_API.G_MISS_NUM)
4318: THEN
4319: x_okl_txl_quote_lines_tl_rec.id := l_okl_txl_quote_lines_tl_rec.id;
4320: END IF;
4321: IF (x_okl_txl_quote_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
4322: THEN
4323: x_okl_txl_quote_lines_tl_rec.language := l_okl_txl_quote_lines_tl_rec.language;

Line 4321: IF (x_okl_txl_quote_lines_tl_rec.language = OKC_API.G_MISS_CHAR)

4317: IF (x_okl_txl_quote_lines_tl_rec.id = OKC_API.G_MISS_NUM)
4318: THEN
4319: x_okl_txl_quote_lines_tl_rec.id := l_okl_txl_quote_lines_tl_rec.id;
4320: END IF;
4321: IF (x_okl_txl_quote_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
4322: THEN
4323: x_okl_txl_quote_lines_tl_rec.language := l_okl_txl_quote_lines_tl_rec.language;
4324: END IF;
4325: IF (x_okl_txl_quote_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 4323: x_okl_txl_quote_lines_tl_rec.language := l_okl_txl_quote_lines_tl_rec.language;

4319: x_okl_txl_quote_lines_tl_rec.id := l_okl_txl_quote_lines_tl_rec.id;
4320: END IF;
4321: IF (x_okl_txl_quote_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
4322: THEN
4323: x_okl_txl_quote_lines_tl_rec.language := l_okl_txl_quote_lines_tl_rec.language;
4324: END IF;
4325: IF (x_okl_txl_quote_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4326: THEN
4327: x_okl_txl_quote_lines_tl_rec.source_lang := l_okl_txl_quote_lines_tl_rec.source_lang;

Line 4325: IF (x_okl_txl_quote_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

4321: IF (x_okl_txl_quote_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
4322: THEN
4323: x_okl_txl_quote_lines_tl_rec.language := l_okl_txl_quote_lines_tl_rec.language;
4324: END IF;
4325: IF (x_okl_txl_quote_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4326: THEN
4327: x_okl_txl_quote_lines_tl_rec.source_lang := l_okl_txl_quote_lines_tl_rec.source_lang;
4328: END IF;
4329: IF (x_okl_txl_quote_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 4327: x_okl_txl_quote_lines_tl_rec.source_lang := l_okl_txl_quote_lines_tl_rec.source_lang;

4323: x_okl_txl_quote_lines_tl_rec.language := l_okl_txl_quote_lines_tl_rec.language;
4324: END IF;
4325: IF (x_okl_txl_quote_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4326: THEN
4327: x_okl_txl_quote_lines_tl_rec.source_lang := l_okl_txl_quote_lines_tl_rec.source_lang;
4328: END IF;
4329: IF (x_okl_txl_quote_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4330: THEN
4331: x_okl_txl_quote_lines_tl_rec.sfwt_flag := l_okl_txl_quote_lines_tl_rec.sfwt_flag;

Line 4329: IF (x_okl_txl_quote_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

4325: IF (x_okl_txl_quote_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4326: THEN
4327: x_okl_txl_quote_lines_tl_rec.source_lang := l_okl_txl_quote_lines_tl_rec.source_lang;
4328: END IF;
4329: IF (x_okl_txl_quote_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4330: THEN
4331: x_okl_txl_quote_lines_tl_rec.sfwt_flag := l_okl_txl_quote_lines_tl_rec.sfwt_flag;
4332: END IF;
4333: IF (x_okl_txl_quote_lines_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 4331: x_okl_txl_quote_lines_tl_rec.sfwt_flag := l_okl_txl_quote_lines_tl_rec.sfwt_flag;

4327: x_okl_txl_quote_lines_tl_rec.source_lang := l_okl_txl_quote_lines_tl_rec.source_lang;
4328: END IF;
4329: IF (x_okl_txl_quote_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4330: THEN
4331: x_okl_txl_quote_lines_tl_rec.sfwt_flag := l_okl_txl_quote_lines_tl_rec.sfwt_flag;
4332: END IF;
4333: IF (x_okl_txl_quote_lines_tl_rec.description = OKC_API.G_MISS_CHAR)
4334: THEN
4335: x_okl_txl_quote_lines_tl_rec.description := l_okl_txl_quote_lines_tl_rec.description;

Line 4333: IF (x_okl_txl_quote_lines_tl_rec.description = OKC_API.G_MISS_CHAR)

4329: IF (x_okl_txl_quote_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4330: THEN
4331: x_okl_txl_quote_lines_tl_rec.sfwt_flag := l_okl_txl_quote_lines_tl_rec.sfwt_flag;
4332: END IF;
4333: IF (x_okl_txl_quote_lines_tl_rec.description = OKC_API.G_MISS_CHAR)
4334: THEN
4335: x_okl_txl_quote_lines_tl_rec.description := l_okl_txl_quote_lines_tl_rec.description;
4336: END IF;
4337: IF (x_okl_txl_quote_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 4335: x_okl_txl_quote_lines_tl_rec.description := l_okl_txl_quote_lines_tl_rec.description;

4331: x_okl_txl_quote_lines_tl_rec.sfwt_flag := l_okl_txl_quote_lines_tl_rec.sfwt_flag;
4332: END IF;
4333: IF (x_okl_txl_quote_lines_tl_rec.description = OKC_API.G_MISS_CHAR)
4334: THEN
4335: x_okl_txl_quote_lines_tl_rec.description := l_okl_txl_quote_lines_tl_rec.description;
4336: END IF;
4337: IF (x_okl_txl_quote_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)
4338: THEN
4339: x_okl_txl_quote_lines_tl_rec.created_by := l_okl_txl_quote_lines_tl_rec.created_by;

Line 4337: IF (x_okl_txl_quote_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)

4333: IF (x_okl_txl_quote_lines_tl_rec.description = OKC_API.G_MISS_CHAR)
4334: THEN
4335: x_okl_txl_quote_lines_tl_rec.description := l_okl_txl_quote_lines_tl_rec.description;
4336: END IF;
4337: IF (x_okl_txl_quote_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)
4338: THEN
4339: x_okl_txl_quote_lines_tl_rec.created_by := l_okl_txl_quote_lines_tl_rec.created_by;
4340: END IF;
4341: IF (x_okl_txl_quote_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 4339: x_okl_txl_quote_lines_tl_rec.created_by := l_okl_txl_quote_lines_tl_rec.created_by;

4335: x_okl_txl_quote_lines_tl_rec.description := l_okl_txl_quote_lines_tl_rec.description;
4336: END IF;
4337: IF (x_okl_txl_quote_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)
4338: THEN
4339: x_okl_txl_quote_lines_tl_rec.created_by := l_okl_txl_quote_lines_tl_rec.created_by;
4340: END IF;
4341: IF (x_okl_txl_quote_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4342: THEN
4343: x_okl_txl_quote_lines_tl_rec.creation_date := l_okl_txl_quote_lines_tl_rec.creation_date;

Line 4341: IF (x_okl_txl_quote_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)

4337: IF (x_okl_txl_quote_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)
4338: THEN
4339: x_okl_txl_quote_lines_tl_rec.created_by := l_okl_txl_quote_lines_tl_rec.created_by;
4340: END IF;
4341: IF (x_okl_txl_quote_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4342: THEN
4343: x_okl_txl_quote_lines_tl_rec.creation_date := l_okl_txl_quote_lines_tl_rec.creation_date;
4344: END IF;
4345: IF (x_okl_txl_quote_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 4343: x_okl_txl_quote_lines_tl_rec.creation_date := l_okl_txl_quote_lines_tl_rec.creation_date;

4339: x_okl_txl_quote_lines_tl_rec.created_by := l_okl_txl_quote_lines_tl_rec.created_by;
4340: END IF;
4341: IF (x_okl_txl_quote_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4342: THEN
4343: x_okl_txl_quote_lines_tl_rec.creation_date := l_okl_txl_quote_lines_tl_rec.creation_date;
4344: END IF;
4345: IF (x_okl_txl_quote_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4346: THEN
4347: x_okl_txl_quote_lines_tl_rec.last_updated_by := l_okl_txl_quote_lines_tl_rec.last_updated_by;

Line 4345: IF (x_okl_txl_quote_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

4341: IF (x_okl_txl_quote_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4342: THEN
4343: x_okl_txl_quote_lines_tl_rec.creation_date := l_okl_txl_quote_lines_tl_rec.creation_date;
4344: END IF;
4345: IF (x_okl_txl_quote_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4346: THEN
4347: x_okl_txl_quote_lines_tl_rec.last_updated_by := l_okl_txl_quote_lines_tl_rec.last_updated_by;
4348: END IF;
4349: IF (x_okl_txl_quote_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 4347: x_okl_txl_quote_lines_tl_rec.last_updated_by := l_okl_txl_quote_lines_tl_rec.last_updated_by;

4343: x_okl_txl_quote_lines_tl_rec.creation_date := l_okl_txl_quote_lines_tl_rec.creation_date;
4344: END IF;
4345: IF (x_okl_txl_quote_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4346: THEN
4347: x_okl_txl_quote_lines_tl_rec.last_updated_by := l_okl_txl_quote_lines_tl_rec.last_updated_by;
4348: END IF;
4349: IF (x_okl_txl_quote_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4350: THEN
4351: x_okl_txl_quote_lines_tl_rec.last_update_date := l_okl_txl_quote_lines_tl_rec.last_update_date;

Line 4349: IF (x_okl_txl_quote_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

4345: IF (x_okl_txl_quote_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4346: THEN
4347: x_okl_txl_quote_lines_tl_rec.last_updated_by := l_okl_txl_quote_lines_tl_rec.last_updated_by;
4348: END IF;
4349: IF (x_okl_txl_quote_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4350: THEN
4351: x_okl_txl_quote_lines_tl_rec.last_update_date := l_okl_txl_quote_lines_tl_rec.last_update_date;
4352: END IF;
4353: IF (x_okl_txl_quote_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 4351: x_okl_txl_quote_lines_tl_rec.last_update_date := l_okl_txl_quote_lines_tl_rec.last_update_date;

4347: x_okl_txl_quote_lines_tl_rec.last_updated_by := l_okl_txl_quote_lines_tl_rec.last_updated_by;
4348: END IF;
4349: IF (x_okl_txl_quote_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4350: THEN
4351: x_okl_txl_quote_lines_tl_rec.last_update_date := l_okl_txl_quote_lines_tl_rec.last_update_date;
4352: END IF;
4353: IF (x_okl_txl_quote_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4354: THEN
4355: x_okl_txl_quote_lines_tl_rec.last_update_login := l_okl_txl_quote_lines_tl_rec.last_update_login;

Line 4353: IF (x_okl_txl_quote_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

4349: IF (x_okl_txl_quote_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4350: THEN
4351: x_okl_txl_quote_lines_tl_rec.last_update_date := l_okl_txl_quote_lines_tl_rec.last_update_date;
4352: END IF;
4353: IF (x_okl_txl_quote_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4354: THEN
4355: x_okl_txl_quote_lines_tl_rec.last_update_login := l_okl_txl_quote_lines_tl_rec.last_update_login;
4356: END IF;
4357: RETURN(l_return_status);

Line 4355: x_okl_txl_quote_lines_tl_rec.last_update_login := l_okl_txl_quote_lines_tl_rec.last_update_login;

4351: x_okl_txl_quote_lines_tl_rec.last_update_date := l_okl_txl_quote_lines_tl_rec.last_update_date;
4352: END IF;
4353: IF (x_okl_txl_quote_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4354: THEN
4355: x_okl_txl_quote_lines_tl_rec.last_update_login := l_okl_txl_quote_lines_tl_rec.last_update_login;
4356: END IF;
4357: RETURN(l_return_status);
4358: END populate_new_record;
4359: -----------------------------------------------

Line 4360: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --

4356: END IF;
4357: RETURN(l_return_status);
4358: END populate_new_record;
4359: -----------------------------------------------
4360: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
4361: -----------------------------------------------
4362: FUNCTION Set_Attributes (
4363: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4364: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

Line 4363: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,

4359: -----------------------------------------------
4360: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
4361: -----------------------------------------------
4362: FUNCTION Set_Attributes (
4363: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4364: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4365: ) RETURN VARCHAR2 IS
4366: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4367: BEGIN

Line 4364: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

4360: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
4361: -----------------------------------------------
4362: FUNCTION Set_Attributes (
4363: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4364: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4365: ) RETURN VARCHAR2 IS
4366: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4367: BEGIN
4368: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

Line 4368: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

4364: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4365: ) RETURN VARCHAR2 IS
4366: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4367: BEGIN
4368: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
4369: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
4370: x_okl_txl_quote_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
4371: RETURN(l_return_status);
4372: END Set_Attributes;

Line 4369: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');

4365: ) RETURN VARCHAR2 IS
4366: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4367: BEGIN
4368: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
4369: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
4370: x_okl_txl_quote_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
4371: RETURN(l_return_status);
4372: END Set_Attributes;
4373: BEGIN

Line 4370: x_okl_txl_quote_lines_tl_rec.SOURCE_LANG := USERENV('LANG');

4366: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4367: BEGIN
4368: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
4369: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
4370: x_okl_txl_quote_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
4371: RETURN(l_return_status);
4372: END Set_Attributes;
4373: BEGIN
4374: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4385: p_okl_txl_quote_lines_tl_rec, -- IN

4381: RAISE OKC_API.G_EXCEPTION_ERROR;
4382: END IF;
4383: --- Setting item attributes
4384: l_return_status := Set_Attributes(
4385: p_okl_txl_quote_lines_tl_rec, -- IN
4386: l_okl_txl_quote_lines_tl_rec); -- OUT
4387: --- If any errors happen abort API
4388: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4389: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4386: l_okl_txl_quote_lines_tl_rec); -- OUT

4382: END IF;
4383: --- Setting item attributes
4384: l_return_status := Set_Attributes(
4385: p_okl_txl_quote_lines_tl_rec, -- IN
4386: l_okl_txl_quote_lines_tl_rec); -- OUT
4387: --- If any errors happen abort API
4388: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4389: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4390: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4393: l_return_status := populate_new_record(l_okl_txl_quote_lines_tl_rec, ldefokltxlquotelinestlrec);

4389: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4390: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4391: RAISE OKC_API.G_EXCEPTION_ERROR;
4392: END IF;
4393: l_return_status := populate_new_record(l_okl_txl_quote_lines_tl_rec, ldefokltxlquotelinestlrec);
4394: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4395: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4396: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4397: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4399: UPDATE OKL_TXL_QUOTE_LINES_TL

4395: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4396: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4397: RAISE OKC_API.G_EXCEPTION_ERROR;
4398: END IF;
4399: UPDATE OKL_TXL_QUOTE_LINES_TL
4400: SET DESCRIPTION = ldefokltxlquotelinestlrec.description,
4401: CREATED_BY = ldefokltxlquotelinestlrec.created_by,
4402: SOURCE_LANG = ldefokltxlquotelinestlrec.source_lang, --Fix for bug 3637102
4403: CREATION_DATE = ldefokltxlquotelinestlrec.creation_date,

Line 4411: UPDATE OKL_TXL_QUOTE_LINES_TL

4407: WHERE ID = ldefokltxlquotelinestlrec.id
4408: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
4409: --AND SOURCE_LANG = USERENV('LANG');
4410:
4411: UPDATE OKL_TXL_QUOTE_LINES_TL
4412: SET SFWT_FLAG = 'Y'
4413: WHERE ID = ldefokltxlquotelinestlrec.id
4414: AND SOURCE_LANG <> USERENV('LANG');
4415:

Line 4416: x_okl_txl_quote_lines_tl_rec := ldefokltxlquotelinestlrec;

4412: SET SFWT_FLAG = 'Y'
4413: WHERE ID = ldefokltxlquotelinestlrec.id
4414: AND SOURCE_LANG <> USERENV('LANG');
4415:
4416: x_okl_txl_quote_lines_tl_rec := ldefokltxlquotelinestlrec;
4417: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4418: EXCEPTION
4419: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4420: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 4480: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

4476: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
4477: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4478: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
4479: l_def_tqlv_rec tqlv_rec_type;
4480: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4481: lx_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4482: l_tql_rec tql_rec_type;
4483: lx_tql_rec tql_rec_type;
4484:

Line 4481: lx_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

4477: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4478: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
4479: l_def_tqlv_rec tqlv_rec_type;
4480: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4481: lx_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4482: l_tql_rec tql_rec_type;
4483: lx_tql_rec tql_rec_type;
4484:
4485:

Line 4878: migrate(l_def_tqlv_rec, l_okl_txl_quote_lines_tl_rec);

4874:
4875: --------------------------------------
4876: -- Move VIEW record to "Child" records
4877: --------------------------------------
4878: migrate(l_def_tqlv_rec, l_okl_txl_quote_lines_tl_rec);
4879: migrate(l_def_tqlv_rec, l_tql_rec);
4880: --------------------------------------------
4881: -- Call the UPDATE_ROW for each child record
4882: --------------------------------------------

Line 4888: l_okl_txl_quote_lines_tl_rec,

4884: p_init_msg_list,
4885: x_return_status,
4886: x_msg_count,
4887: x_msg_data,
4888: l_okl_txl_quote_lines_tl_rec,
4889: lx_okl_txl_quote_lines_tl_rec
4890: );
4891: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4889: lx_okl_txl_quote_lines_tl_rec

4885: x_return_status,
4886: x_msg_count,
4887: x_msg_data,
4888: l_okl_txl_quote_lines_tl_rec,
4889: lx_okl_txl_quote_lines_tl_rec
4890: );
4891: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4893: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4896: migrate(lx_okl_txl_quote_lines_tl_rec, l_def_tqlv_rec);

4892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4893: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4894: RAISE OKC_API.G_EXCEPTION_ERROR;
4895: END IF;
4896: migrate(lx_okl_txl_quote_lines_tl_rec, l_def_tqlv_rec);
4897: update_row(
4898: p_init_msg_list,
4899: x_return_status,
4900: x_msg_count,

Line 5093: -- delete_row for:OKL_TXL_QUOTE_LINES_TL --

5089: '_PVT'
5090: );
5091: END delete_row;
5092: -------------------------------------------
5093: -- delete_row for:OKL_TXL_QUOTE_LINES_TL --
5094: -------------------------------------------
5095: PROCEDURE delete_row(
5096: p_init_msg_list IN VARCHAR2,
5097: x_return_status OUT NOCOPY VARCHAR2,

Line 5100: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS

5096: p_init_msg_list IN VARCHAR2,
5097: x_return_status OUT NOCOPY VARCHAR2,
5098: x_msg_count OUT NOCOPY NUMBER,
5099: x_msg_data OUT NOCOPY VARCHAR2,
5100: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
5101:
5102: l_api_version CONSTANT NUMBER := 1;
5103: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
5104: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 5105: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType:= p_okl_txl_quote_lines_tl_rec;

5101:
5102: l_api_version CONSTANT NUMBER := 1;
5103: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
5104: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5105: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType:= p_okl_txl_quote_lines_tl_rec;
5106: l_row_notfound BOOLEAN := TRUE;
5107: -----------------------------------------------
5108: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
5109: -----------------------------------------------

Line 5108: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --

5104: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5105: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType:= p_okl_txl_quote_lines_tl_rec;
5106: l_row_notfound BOOLEAN := TRUE;
5107: -----------------------------------------------
5108: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
5109: -----------------------------------------------
5110: FUNCTION Set_Attributes (
5111: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
5112: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

Line 5111: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,

5107: -----------------------------------------------
5108: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
5109: -----------------------------------------------
5110: FUNCTION Set_Attributes (
5111: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
5112: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
5113: ) RETURN VARCHAR2 IS
5114: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5115: BEGIN

Line 5112: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

5108: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
5109: -----------------------------------------------
5110: FUNCTION Set_Attributes (
5111: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
5112: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
5113: ) RETURN VARCHAR2 IS
5114: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5115: BEGIN
5116: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

Line 5116: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

5112: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
5113: ) RETURN VARCHAR2 IS
5114: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5115: BEGIN
5116: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
5117: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
5118: RETURN(l_return_status);
5119: END Set_Attributes;
5120: BEGIN

Line 5117: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');

5113: ) RETURN VARCHAR2 IS
5114: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5115: BEGIN
5116: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
5117: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
5118: RETURN(l_return_status);
5119: END Set_Attributes;
5120: BEGIN
5121: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 5132: p_okl_txl_quote_lines_tl_rec, -- IN

5128: RAISE OKC_API.G_EXCEPTION_ERROR;
5129: END IF;
5130: --- Setting item attributes
5131: l_return_status := Set_Attributes(
5132: p_okl_txl_quote_lines_tl_rec, -- IN
5133: l_okl_txl_quote_lines_tl_rec); -- OUT
5134: --- If any errors happen abort API
5135: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5136: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5133: l_okl_txl_quote_lines_tl_rec); -- OUT

5129: END IF;
5130: --- Setting item attributes
5131: l_return_status := Set_Attributes(
5132: p_okl_txl_quote_lines_tl_rec, -- IN
5133: l_okl_txl_quote_lines_tl_rec); -- OUT
5134: --- If any errors happen abort API
5135: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5136: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5137: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5140: DELETE FROM OKL_TXL_QUOTE_LINES_TL

5136: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5137: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5138: RAISE OKC_API.G_EXCEPTION_ERROR;
5139: END IF;
5140: DELETE FROM OKL_TXL_QUOTE_LINES_TL
5141: WHERE ID = l_okl_txl_quote_lines_tl_rec.id;
5142:
5143: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5144: EXCEPTION

Line 5141: WHERE ID = l_okl_txl_quote_lines_tl_rec.id;

5137: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5138: RAISE OKC_API.G_EXCEPTION_ERROR;
5139: END IF;
5140: DELETE FROM OKL_TXL_QUOTE_LINES_TL
5141: WHERE ID = l_okl_txl_quote_lines_tl_rec.id;
5142:
5143: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5144: EXCEPTION
5145: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 5191: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

5187: l_api_version CONSTANT NUMBER := 1;
5188: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
5189: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5190: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
5191: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
5192: l_tql_rec tql_rec_type;
5193: BEGIN
5194: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
5195: G_PKG_NAME,

Line 5209: migrate(l_tqlv_rec, l_okl_txl_quote_lines_tl_rec);

5205: END IF;
5206: --------------------------------------
5207: -- Move VIEW record to "Child" records
5208: --------------------------------------
5209: migrate(l_tqlv_rec, l_okl_txl_quote_lines_tl_rec);
5210: migrate(l_tqlv_rec, l_tql_rec);
5211: --------------------------------------------
5212: -- Call the DELETE_ROW for each child record
5213: --------------------------------------------

Line 5219: l_okl_txl_quote_lines_tl_rec

5215: p_init_msg_list,
5216: x_return_status,
5217: x_msg_count,
5218: x_msg_data,
5219: l_okl_txl_quote_lines_tl_rec
5220: );
5221: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5222: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5223: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN