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 3394: INSERT INTO OKL_TXL_QUOTE_LINES_TL(

3390: in_due_date(i)); --dkagrawa bug 4187250
3391:
3392: -- Bulk insert into tl table
3393: FORALL i in 1..l_tabsize
3394: INSERT INTO OKL_TXL_QUOTE_LINES_TL(
3395: id,
3396: language,
3397: source_lang,
3398: sfwt_flag,

Line 3565: -- lock_row for:OKL_TXL_QUOTE_LINES_TL --

3561: '_PVT'
3562: );
3563: END lock_row;
3564: -----------------------------------------
3565: -- lock_row for:OKL_TXL_QUOTE_LINES_TL --
3566: -----------------------------------------
3567: PROCEDURE lock_row(
3568: p_init_msg_list IN VARCHAR2,
3569: x_return_status OUT NOCOPY VARCHAR2,

Line 3572: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS

3568: p_init_msg_list IN VARCHAR2,
3569: x_return_status OUT NOCOPY VARCHAR2,
3570: x_msg_count OUT NOCOPY NUMBER,
3571: x_msg_data OUT NOCOPY VARCHAR2,
3572: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
3573:
3574: E_Resource_Busy EXCEPTION;
3575: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3576: CURSOR lock_csr (p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS

Line 3576: CURSOR lock_csr (p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS

3572: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
3573:
3574: E_Resource_Busy EXCEPTION;
3575: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3576: CURSOR lock_csr (p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
3577: SELECT *
3578: FROM OKL_TXL_QUOTE_LINES_TL
3579: WHERE ID = p_okl_txl_quote_lines_tl_rec.id
3580: FOR UPDATE NOWAIT;

Line 3578: FROM OKL_TXL_QUOTE_LINES_TL

3574: E_Resource_Busy EXCEPTION;
3575: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3576: CURSOR lock_csr (p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
3577: SELECT *
3578: FROM OKL_TXL_QUOTE_LINES_TL
3579: WHERE ID = p_okl_txl_quote_lines_tl_rec.id
3580: FOR UPDATE NOWAIT;
3581:
3582: l_api_version CONSTANT NUMBER := 1;

Line 3579: WHERE ID = p_okl_txl_quote_lines_tl_rec.id

3575: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3576: CURSOR lock_csr (p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
3577: SELECT *
3578: FROM OKL_TXL_QUOTE_LINES_TL
3579: WHERE ID = p_okl_txl_quote_lines_tl_rec.id
3580: FOR UPDATE NOWAIT;
3581:
3582: l_api_version CONSTANT NUMBER := 1;
3583: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 3599: OPEN lock_csr(p_okl_txl_quote_lines_tl_rec);

3595: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3596: RAISE OKC_API.G_EXCEPTION_ERROR;
3597: END IF;
3598: BEGIN
3599: OPEN lock_csr(p_okl_txl_quote_lines_tl_rec);
3600: FETCH lock_csr INTO l_lock_var;
3601: l_row_notfound := lock_csr%NOTFOUND;
3602: CLOSE lock_csr;
3603: EXCEPTION

Line 3664: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

3660: l_api_version CONSTANT NUMBER := 1;
3661: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
3662: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3663: l_tql_rec tql_rec_type;
3664: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
3665: BEGIN
3666: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3667: G_PKG_NAME,
3668: p_init_msg_list,

Line 3682: migrate(p_tqlv_rec, l_okl_txl_quote_lines_tl_rec);

3678: --------------------------------------
3679: -- Move VIEW record to "Child" records
3680: --------------------------------------
3681: migrate(p_tqlv_rec, l_tql_rec);
3682: migrate(p_tqlv_rec, l_okl_txl_quote_lines_tl_rec);
3683: --------------------------------------------
3684: -- Call the LOCK_ROW for each child record
3685: --------------------------------------------
3686: lock_row(

Line 3703: l_okl_txl_quote_lines_tl_rec

3699: p_init_msg_list,
3700: x_return_status,
3701: x_msg_count,
3702: x_msg_data,
3703: l_okl_txl_quote_lines_tl_rec
3704: );
3705: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3706: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3707: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4274: -- update_row for:OKL_TXL_QUOTE_LINES_TL --

4270: '_PVT'
4271: );
4272: END update_row;
4273: -------------------------------------------
4274: -- update_row for:OKL_TXL_QUOTE_LINES_TL --
4275: -------------------------------------------
4276: PROCEDURE update_row(
4277: p_init_msg_list IN VARCHAR2,
4278: x_return_status OUT NOCOPY VARCHAR2,

Line 4281: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,

4277: p_init_msg_list IN VARCHAR2,
4278: x_return_status OUT NOCOPY VARCHAR2,
4279: x_msg_count OUT NOCOPY NUMBER,
4280: x_msg_data OUT NOCOPY VARCHAR2,
4281: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4282: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType) IS
4283:
4284: l_api_version CONSTANT NUMBER := 1;
4285: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 4282: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType) IS

4278: x_return_status OUT NOCOPY VARCHAR2,
4279: x_msg_count OUT NOCOPY NUMBER,
4280: x_msg_data OUT NOCOPY VARCHAR2,
4281: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4282: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType) IS
4283:
4284: l_api_version CONSTANT NUMBER := 1;
4285: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4286: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4287: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType := p_okl_txl_quote_lines_tl_rec;

4283:
4284: l_api_version CONSTANT NUMBER := 1;
4285: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4286: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4287: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType := p_okl_txl_quote_lines_tl_rec;
4288: ldefokltxlquotelinestlrec OklTxlQuoteLinesTlRecType;
4289: l_row_notfound BOOLEAN := TRUE;
4290: ----------------------------------
4291: -- FUNCTION populate_new_record --

Line 4294: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,

4290: ----------------------------------
4291: -- FUNCTION populate_new_record --
4292: ----------------------------------
4293: FUNCTION populate_new_record (
4294: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4295: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4296: ) RETURN VARCHAR2 IS
4297: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4298: l_row_notfound BOOLEAN := TRUE;

Line 4295: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

4291: -- FUNCTION populate_new_record --
4292: ----------------------------------
4293: FUNCTION populate_new_record (
4294: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4295: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4296: ) RETURN VARCHAR2 IS
4297: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4298: l_row_notfound BOOLEAN := TRUE;
4299: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4297: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

4293: FUNCTION populate_new_record (
4294: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4295: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4296: ) RETURN VARCHAR2 IS
4297: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4298: l_row_notfound BOOLEAN := TRUE;
4299: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4300: BEGIN
4301: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

Line 4301: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

4297: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4298: l_row_notfound BOOLEAN := TRUE;
4299: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4300: BEGIN
4301: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
4302: -- Get current database values
4303: l_okl_txl_quote_lines_tl_rec := get_rec(p_okl_txl_quote_lines_tl_rec, l_row_notfound);
4304: IF (l_row_notfound) THEN
4305: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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

4299: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4300: BEGIN
4301: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
4302: -- Get current database values
4303: l_okl_txl_quote_lines_tl_rec := get_rec(p_okl_txl_quote_lines_tl_rec, l_row_notfound);
4304: IF (l_row_notfound) THEN
4305: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4306: END IF;
4307: IF (x_okl_txl_quote_lines_tl_rec.id = OKC_API.G_MISS_NUM)

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

4303: l_okl_txl_quote_lines_tl_rec := get_rec(p_okl_txl_quote_lines_tl_rec, l_row_notfound);
4304: IF (l_row_notfound) THEN
4305: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4306: END IF;
4307: IF (x_okl_txl_quote_lines_tl_rec.id = OKC_API.G_MISS_NUM)
4308: THEN
4309: x_okl_txl_quote_lines_tl_rec.id := l_okl_txl_quote_lines_tl_rec.id;
4310: END IF;
4311: IF (x_okl_txl_quote_lines_tl_rec.language = OKC_API.G_MISS_CHAR)

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

4305: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4306: END IF;
4307: IF (x_okl_txl_quote_lines_tl_rec.id = OKC_API.G_MISS_NUM)
4308: THEN
4309: x_okl_txl_quote_lines_tl_rec.id := l_okl_txl_quote_lines_tl_rec.id;
4310: END IF;
4311: IF (x_okl_txl_quote_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
4312: THEN
4313: x_okl_txl_quote_lines_tl_rec.language := l_okl_txl_quote_lines_tl_rec.language;

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

4307: IF (x_okl_txl_quote_lines_tl_rec.id = OKC_API.G_MISS_NUM)
4308: THEN
4309: x_okl_txl_quote_lines_tl_rec.id := l_okl_txl_quote_lines_tl_rec.id;
4310: END IF;
4311: IF (x_okl_txl_quote_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
4312: THEN
4313: x_okl_txl_quote_lines_tl_rec.language := l_okl_txl_quote_lines_tl_rec.language;
4314: END IF;
4315: IF (x_okl_txl_quote_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

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

4309: x_okl_txl_quote_lines_tl_rec.id := l_okl_txl_quote_lines_tl_rec.id;
4310: END IF;
4311: IF (x_okl_txl_quote_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
4312: THEN
4313: x_okl_txl_quote_lines_tl_rec.language := l_okl_txl_quote_lines_tl_rec.language;
4314: END IF;
4315: IF (x_okl_txl_quote_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4316: THEN
4317: x_okl_txl_quote_lines_tl_rec.source_lang := l_okl_txl_quote_lines_tl_rec.source_lang;

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

4311: IF (x_okl_txl_quote_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
4312: THEN
4313: x_okl_txl_quote_lines_tl_rec.language := l_okl_txl_quote_lines_tl_rec.language;
4314: END IF;
4315: IF (x_okl_txl_quote_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4316: THEN
4317: x_okl_txl_quote_lines_tl_rec.source_lang := l_okl_txl_quote_lines_tl_rec.source_lang;
4318: END IF;
4319: IF (x_okl_txl_quote_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

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

4313: x_okl_txl_quote_lines_tl_rec.language := l_okl_txl_quote_lines_tl_rec.language;
4314: END IF;
4315: IF (x_okl_txl_quote_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4316: THEN
4317: x_okl_txl_quote_lines_tl_rec.source_lang := l_okl_txl_quote_lines_tl_rec.source_lang;
4318: END IF;
4319: IF (x_okl_txl_quote_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4320: THEN
4321: x_okl_txl_quote_lines_tl_rec.sfwt_flag := l_okl_txl_quote_lines_tl_rec.sfwt_flag;

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

4315: IF (x_okl_txl_quote_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4316: THEN
4317: x_okl_txl_quote_lines_tl_rec.source_lang := l_okl_txl_quote_lines_tl_rec.source_lang;
4318: END IF;
4319: IF (x_okl_txl_quote_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4320: THEN
4321: x_okl_txl_quote_lines_tl_rec.sfwt_flag := l_okl_txl_quote_lines_tl_rec.sfwt_flag;
4322: END IF;
4323: IF (x_okl_txl_quote_lines_tl_rec.description = OKC_API.G_MISS_CHAR)

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

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

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

4319: IF (x_okl_txl_quote_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4320: THEN
4321: x_okl_txl_quote_lines_tl_rec.sfwt_flag := l_okl_txl_quote_lines_tl_rec.sfwt_flag;
4322: END IF;
4323: IF (x_okl_txl_quote_lines_tl_rec.description = OKC_API.G_MISS_CHAR)
4324: THEN
4325: x_okl_txl_quote_lines_tl_rec.description := l_okl_txl_quote_lines_tl_rec.description;
4326: END IF;
4327: IF (x_okl_txl_quote_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)

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

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

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

4323: IF (x_okl_txl_quote_lines_tl_rec.description = OKC_API.G_MISS_CHAR)
4324: THEN
4325: x_okl_txl_quote_lines_tl_rec.description := l_okl_txl_quote_lines_tl_rec.description;
4326: END IF;
4327: IF (x_okl_txl_quote_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)
4328: THEN
4329: x_okl_txl_quote_lines_tl_rec.created_by := l_okl_txl_quote_lines_tl_rec.created_by;
4330: END IF;
4331: IF (x_okl_txl_quote_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)

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

4325: x_okl_txl_quote_lines_tl_rec.description := l_okl_txl_quote_lines_tl_rec.description;
4326: END IF;
4327: IF (x_okl_txl_quote_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)
4328: THEN
4329: x_okl_txl_quote_lines_tl_rec.created_by := l_okl_txl_quote_lines_tl_rec.created_by;
4330: END IF;
4331: IF (x_okl_txl_quote_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4332: THEN
4333: x_okl_txl_quote_lines_tl_rec.creation_date := l_okl_txl_quote_lines_tl_rec.creation_date;

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

4327: IF (x_okl_txl_quote_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)
4328: THEN
4329: x_okl_txl_quote_lines_tl_rec.created_by := l_okl_txl_quote_lines_tl_rec.created_by;
4330: END IF;
4331: IF (x_okl_txl_quote_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4332: THEN
4333: x_okl_txl_quote_lines_tl_rec.creation_date := l_okl_txl_quote_lines_tl_rec.creation_date;
4334: END IF;
4335: IF (x_okl_txl_quote_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

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

4329: x_okl_txl_quote_lines_tl_rec.created_by := l_okl_txl_quote_lines_tl_rec.created_by;
4330: END IF;
4331: IF (x_okl_txl_quote_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4332: THEN
4333: x_okl_txl_quote_lines_tl_rec.creation_date := l_okl_txl_quote_lines_tl_rec.creation_date;
4334: END IF;
4335: IF (x_okl_txl_quote_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4336: THEN
4337: x_okl_txl_quote_lines_tl_rec.last_updated_by := l_okl_txl_quote_lines_tl_rec.last_updated_by;

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

4331: IF (x_okl_txl_quote_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4332: THEN
4333: x_okl_txl_quote_lines_tl_rec.creation_date := l_okl_txl_quote_lines_tl_rec.creation_date;
4334: END IF;
4335: IF (x_okl_txl_quote_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4336: THEN
4337: x_okl_txl_quote_lines_tl_rec.last_updated_by := l_okl_txl_quote_lines_tl_rec.last_updated_by;
4338: END IF;
4339: IF (x_okl_txl_quote_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

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

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

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

4335: IF (x_okl_txl_quote_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4336: THEN
4337: x_okl_txl_quote_lines_tl_rec.last_updated_by := l_okl_txl_quote_lines_tl_rec.last_updated_by;
4338: END IF;
4339: IF (x_okl_txl_quote_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4340: THEN
4341: x_okl_txl_quote_lines_tl_rec.last_update_date := l_okl_txl_quote_lines_tl_rec.last_update_date;
4342: END IF;
4343: IF (x_okl_txl_quote_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

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

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

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

4339: IF (x_okl_txl_quote_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4340: THEN
4341: x_okl_txl_quote_lines_tl_rec.last_update_date := l_okl_txl_quote_lines_tl_rec.last_update_date;
4342: END IF;
4343: IF (x_okl_txl_quote_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4344: THEN
4345: x_okl_txl_quote_lines_tl_rec.last_update_login := l_okl_txl_quote_lines_tl_rec.last_update_login;
4346: END IF;
4347: RETURN(l_return_status);

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

4341: x_okl_txl_quote_lines_tl_rec.last_update_date := l_okl_txl_quote_lines_tl_rec.last_update_date;
4342: END IF;
4343: IF (x_okl_txl_quote_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4344: THEN
4345: x_okl_txl_quote_lines_tl_rec.last_update_login := l_okl_txl_quote_lines_tl_rec.last_update_login;
4346: END IF;
4347: RETURN(l_return_status);
4348: END populate_new_record;
4349: -----------------------------------------------

Line 4350: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --

4346: END IF;
4347: RETURN(l_return_status);
4348: END populate_new_record;
4349: -----------------------------------------------
4350: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
4351: -----------------------------------------------
4352: FUNCTION Set_Attributes (
4353: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4354: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

Line 4353: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,

4349: -----------------------------------------------
4350: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
4351: -----------------------------------------------
4352: FUNCTION Set_Attributes (
4353: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4354: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4355: ) RETURN VARCHAR2 IS
4356: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4357: BEGIN

Line 4354: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

4350: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
4351: -----------------------------------------------
4352: FUNCTION Set_Attributes (
4353: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
4354: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4355: ) RETURN VARCHAR2 IS
4356: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4357: BEGIN
4358: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

Line 4358: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

4354: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
4355: ) RETURN VARCHAR2 IS
4356: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4357: BEGIN
4358: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
4359: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
4360: x_okl_txl_quote_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
4361: RETURN(l_return_status);
4362: END Set_Attributes;

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

4355: ) RETURN VARCHAR2 IS
4356: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4357: BEGIN
4358: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
4359: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
4360: x_okl_txl_quote_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
4361: RETURN(l_return_status);
4362: END Set_Attributes;
4363: BEGIN

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

4356: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4357: BEGIN
4358: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
4359: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
4360: x_okl_txl_quote_lines_tl_rec.SOURCE_LANG := USERENV('LANG');
4361: RETURN(l_return_status);
4362: END Set_Attributes;
4363: BEGIN
4364: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4375: p_okl_txl_quote_lines_tl_rec, -- IN

4371: RAISE OKC_API.G_EXCEPTION_ERROR;
4372: END IF;
4373: --- Setting item attributes
4374: l_return_status := Set_Attributes(
4375: p_okl_txl_quote_lines_tl_rec, -- IN
4376: l_okl_txl_quote_lines_tl_rec); -- OUT
4377: --- If any errors happen abort API
4378: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4376: l_okl_txl_quote_lines_tl_rec); -- OUT

4372: END IF;
4373: --- Setting item attributes
4374: l_return_status := Set_Attributes(
4375: p_okl_txl_quote_lines_tl_rec, -- IN
4376: l_okl_txl_quote_lines_tl_rec); -- OUT
4377: --- If any errors happen abort API
4378: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4380: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

4379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4380: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4381: RAISE OKC_API.G_EXCEPTION_ERROR;
4382: END IF;
4383: l_return_status := populate_new_record(l_okl_txl_quote_lines_tl_rec, ldefokltxlquotelinestlrec);
4384: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4387: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4389: UPDATE OKL_TXL_QUOTE_LINES_TL

4385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4387: RAISE OKC_API.G_EXCEPTION_ERROR;
4388: END IF;
4389: UPDATE OKL_TXL_QUOTE_LINES_TL
4390: SET DESCRIPTION = ldefokltxlquotelinestlrec.description,
4391: CREATED_BY = ldefokltxlquotelinestlrec.created_by,
4392: SOURCE_LANG = ldefokltxlquotelinestlrec.source_lang, --Fix for bug 3637102
4393: CREATION_DATE = ldefokltxlquotelinestlrec.creation_date,

Line 4401: UPDATE OKL_TXL_QUOTE_LINES_TL

4397: WHERE ID = ldefokltxlquotelinestlrec.id
4398: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
4399: --AND SOURCE_LANG = USERENV('LANG');
4400:
4401: UPDATE OKL_TXL_QUOTE_LINES_TL
4402: SET SFWT_FLAG = 'Y'
4403: WHERE ID = ldefokltxlquotelinestlrec.id
4404: AND SOURCE_LANG <> USERENV('LANG');
4405:

Line 4406: x_okl_txl_quote_lines_tl_rec := ldefokltxlquotelinestlrec;

4402: SET SFWT_FLAG = 'Y'
4403: WHERE ID = ldefokltxlquotelinestlrec.id
4404: AND SOURCE_LANG <> USERENV('LANG');
4405:
4406: x_okl_txl_quote_lines_tl_rec := ldefokltxlquotelinestlrec;
4407: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4408: EXCEPTION
4409: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4410: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 4470: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

4466: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
4467: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4468: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
4469: l_def_tqlv_rec tqlv_rec_type;
4470: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4471: lx_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4472: l_tql_rec tql_rec_type;
4473: lx_tql_rec tql_rec_type;
4474:

Line 4471: lx_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

4467: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4468: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
4469: l_def_tqlv_rec tqlv_rec_type;
4470: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4471: lx_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
4472: l_tql_rec tql_rec_type;
4473: lx_tql_rec tql_rec_type;
4474:
4475:

Line 4868: migrate(l_def_tqlv_rec, l_okl_txl_quote_lines_tl_rec);

4864:
4865: --------------------------------------
4866: -- Move VIEW record to "Child" records
4867: --------------------------------------
4868: migrate(l_def_tqlv_rec, l_okl_txl_quote_lines_tl_rec);
4869: migrate(l_def_tqlv_rec, l_tql_rec);
4870: --------------------------------------------
4871: -- Call the UPDATE_ROW for each child record
4872: --------------------------------------------

Line 4878: l_okl_txl_quote_lines_tl_rec,

4874: p_init_msg_list,
4875: x_return_status,
4876: x_msg_count,
4877: x_msg_data,
4878: l_okl_txl_quote_lines_tl_rec,
4879: lx_okl_txl_quote_lines_tl_rec
4880: );
4881: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4882: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4879: lx_okl_txl_quote_lines_tl_rec

4875: x_return_status,
4876: x_msg_count,
4877: x_msg_data,
4878: l_okl_txl_quote_lines_tl_rec,
4879: lx_okl_txl_quote_lines_tl_rec
4880: );
4881: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4882: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4883: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4886: migrate(lx_okl_txl_quote_lines_tl_rec, l_def_tqlv_rec);

4882: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4883: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4884: RAISE OKC_API.G_EXCEPTION_ERROR;
4885: END IF;
4886: migrate(lx_okl_txl_quote_lines_tl_rec, l_def_tqlv_rec);
4887: update_row(
4888: p_init_msg_list,
4889: x_return_status,
4890: x_msg_count,

Line 5083: -- delete_row for:OKL_TXL_QUOTE_LINES_TL --

5079: '_PVT'
5080: );
5081: END delete_row;
5082: -------------------------------------------
5083: -- delete_row for:OKL_TXL_QUOTE_LINES_TL --
5084: -------------------------------------------
5085: PROCEDURE delete_row(
5086: p_init_msg_list IN VARCHAR2,
5087: x_return_status OUT NOCOPY VARCHAR2,

Line 5090: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS

5086: p_init_msg_list IN VARCHAR2,
5087: x_return_status OUT NOCOPY VARCHAR2,
5088: x_msg_count OUT NOCOPY NUMBER,
5089: x_msg_data OUT NOCOPY VARCHAR2,
5090: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType) IS
5091:
5092: l_api_version CONSTANT NUMBER := 1;
5093: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
5094: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 5095: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType:= p_okl_txl_quote_lines_tl_rec;

5091:
5092: l_api_version CONSTANT NUMBER := 1;
5093: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
5094: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5095: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType:= p_okl_txl_quote_lines_tl_rec;
5096: l_row_notfound BOOLEAN := TRUE;
5097: -----------------------------------------------
5098: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
5099: -----------------------------------------------

Line 5098: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --

5094: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5095: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType:= p_okl_txl_quote_lines_tl_rec;
5096: l_row_notfound BOOLEAN := TRUE;
5097: -----------------------------------------------
5098: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
5099: -----------------------------------------------
5100: FUNCTION Set_Attributes (
5101: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
5102: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

Line 5101: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,

5097: -----------------------------------------------
5098: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
5099: -----------------------------------------------
5100: FUNCTION Set_Attributes (
5101: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
5102: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
5103: ) RETURN VARCHAR2 IS
5104: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5105: BEGIN

Line 5102: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType

5098: -- Set_Attributes for:OKL_TXL_QUOTE_LINES_TL --
5099: -----------------------------------------------
5100: FUNCTION Set_Attributes (
5101: p_okl_txl_quote_lines_tl_rec IN OklTxlQuoteLinesTlRecType,
5102: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
5103: ) RETURN VARCHAR2 IS
5104: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5105: BEGIN
5106: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

Line 5106: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;

5102: x_okl_txl_quote_lines_tl_rec OUT NOCOPY OklTxlQuoteLinesTlRecType
5103: ) RETURN VARCHAR2 IS
5104: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5105: BEGIN
5106: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
5107: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
5108: RETURN(l_return_status);
5109: END Set_Attributes;
5110: BEGIN

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

5103: ) RETURN VARCHAR2 IS
5104: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5105: BEGIN
5106: x_okl_txl_quote_lines_tl_rec := p_okl_txl_quote_lines_tl_rec;
5107: x_okl_txl_quote_lines_tl_rec.LANGUAGE := USERENV('LANG');
5108: RETURN(l_return_status);
5109: END Set_Attributes;
5110: BEGIN
5111: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 5122: p_okl_txl_quote_lines_tl_rec, -- IN

5118: RAISE OKC_API.G_EXCEPTION_ERROR;
5119: END IF;
5120: --- Setting item attributes
5121: l_return_status := Set_Attributes(
5122: p_okl_txl_quote_lines_tl_rec, -- IN
5123: l_okl_txl_quote_lines_tl_rec); -- OUT
5124: --- If any errors happen abort API
5125: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5126: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5123: l_okl_txl_quote_lines_tl_rec); -- OUT

5119: END IF;
5120: --- Setting item attributes
5121: l_return_status := Set_Attributes(
5122: p_okl_txl_quote_lines_tl_rec, -- IN
5123: l_okl_txl_quote_lines_tl_rec); -- OUT
5124: --- If any errors happen abort API
5125: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5126: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5127: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5130: DELETE FROM OKL_TXL_QUOTE_LINES_TL

5126: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5127: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5128: RAISE OKC_API.G_EXCEPTION_ERROR;
5129: END IF;
5130: DELETE FROM OKL_TXL_QUOTE_LINES_TL
5131: WHERE ID = l_okl_txl_quote_lines_tl_rec.id;
5132:
5133: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5134: EXCEPTION

Line 5131: WHERE ID = l_okl_txl_quote_lines_tl_rec.id;

5127: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5128: RAISE OKC_API.G_EXCEPTION_ERROR;
5129: END IF;
5130: DELETE FROM OKL_TXL_QUOTE_LINES_TL
5131: WHERE ID = l_okl_txl_quote_lines_tl_rec.id;
5132:
5133: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5134: EXCEPTION
5135: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 5181: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;

5177: l_api_version CONSTANT NUMBER := 1;
5178: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
5179: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5180: l_tqlv_rec tqlv_rec_type := p_tqlv_rec;
5181: l_okl_txl_quote_lines_tl_rec OklTxlQuoteLinesTlRecType;
5182: l_tql_rec tql_rec_type;
5183: BEGIN
5184: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
5185: G_PKG_NAME,

Line 5199: migrate(l_tqlv_rec, l_okl_txl_quote_lines_tl_rec);

5195: END IF;
5196: --------------------------------------
5197: -- Move VIEW record to "Child" records
5198: --------------------------------------
5199: migrate(l_tqlv_rec, l_okl_txl_quote_lines_tl_rec);
5200: migrate(l_tqlv_rec, l_tql_rec);
5201: --------------------------------------------
5202: -- Call the DELETE_ROW for each child record
5203: --------------------------------------------

Line 5209: l_okl_txl_quote_lines_tl_rec

5205: p_init_msg_list,
5206: x_return_status,
5207: x_msg_count,
5208: x_msg_data,
5209: l_okl_txl_quote_lines_tl_rec
5210: );
5211: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5213: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN