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_TPL_PVT dependencies on OKL_TXL_AP_INV_LNS_TL

Line 1270: DELETE FROM OKL_TXL_AP_INV_LNS_TL T

1266: -- PROCEDURE add_language
1267: ---------------------------------------------------------------------------
1268: PROCEDURE add_language IS
1269: BEGIN
1270: DELETE FROM OKL_TXL_AP_INV_LNS_TL T
1271: WHERE NOT EXISTS (
1272: SELECT NULL
1273: FROM OKL_TXL_AP_INV_LNS_ALL_B B
1274: WHERE B.ID = T.ID

Line 1278: UPDATE OKL_TXL_AP_INV_LNS_TL T SET (

1274: WHERE B.ID = T.ID
1275: AND T.LANGUAGE = USERENV('LANG')
1276: );
1277:
1278: UPDATE OKL_TXL_AP_INV_LNS_TL T SET (
1279: DESCRIPTION) = (SELECT
1280: B.DESCRIPTION
1281: FROM OKL_TXL_AP_INV_LNS_TL B
1282: WHERE B.ID = T.ID

Line 1281: FROM OKL_TXL_AP_INV_LNS_TL B

1277:
1278: UPDATE OKL_TXL_AP_INV_LNS_TL T SET (
1279: DESCRIPTION) = (SELECT
1280: B.DESCRIPTION
1281: FROM OKL_TXL_AP_INV_LNS_TL B
1282: WHERE B.ID = T.ID
1283: AND B.LANGUAGE = T.SOURCE_LANG)
1284: WHERE (
1285: T.ID,

Line 1290: FROM OKL_TXL_AP_INV_LNS_TL SUBB, OKL_TXL_AP_INV_LNS_TL SUBT

1286: T.LANGUAGE)
1287: IN (SELECT
1288: SUBT.ID,
1289: SUBT.LANGUAGE
1290: FROM OKL_TXL_AP_INV_LNS_TL SUBB, OKL_TXL_AP_INV_LNS_TL SUBT
1291: WHERE SUBB.ID = SUBT.ID
1292: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1293: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1294: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 1298: INSERT INTO OKL_TXL_AP_INV_LNS_TL (

1294: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
1295: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
1296: ));
1297:
1298: INSERT INTO OKL_TXL_AP_INV_LNS_TL (
1299: ID,
1300: LANGUAGE,
1301: SOURCE_LANG,
1302: SFWT_FLAG,

Line 1320: FROM OKL_TXL_AP_INV_LNS_TL B, FND_LANGUAGES L

1316: B.CREATION_DATE,
1317: B.LAST_UPDATED_BY,
1318: B.LAST_UPDATE_DATE,
1319: B.LAST_UPDATE_LOGIN
1320: FROM OKL_TXL_AP_INV_LNS_TL B, FND_LANGUAGES L
1321: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1322: AND B.LANGUAGE = USERENV('LANG')
1323: AND NOT EXISTS(
1324: SELECT NULL

Line 1325: FROM OKL_TXL_AP_INV_LNS_TL T

1321: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1322: AND B.LANGUAGE = USERENV('LANG')
1323: AND NOT EXISTS(
1324: SELECT NULL
1325: FROM OKL_TXL_AP_INV_LNS_TL T
1326: WHERE T.ID = B.ID
1327: AND T.LANGUAGE = L.LANGUAGE_CODE
1328: );
1329:

Line 1459: -- FUNCTION get_rec for: OKL_TXL_AP_INV_LNS_TL

1455: BEGIN
1456: RETURN(get_rec(p_tpl_rec, l_row_notfound));
1457: END get_rec;
1458: ---------------------------------------------------------------------------
1459: -- FUNCTION get_rec for: OKL_TXL_AP_INV_LNS_TL
1460: ---------------------------------------------------------------------------
1461: FUNCTION get_rec (
1462: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
1463: x_no_data_found OUT NOCOPY BOOLEAN

Line 1462: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,

1458: ---------------------------------------------------------------------------
1459: -- FUNCTION get_rec for: OKL_TXL_AP_INV_LNS_TL
1460: ---------------------------------------------------------------------------
1461: FUNCTION get_rec (
1462: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
1463: x_no_data_found OUT NOCOPY BOOLEAN
1464: ) RETURN okl_txl_ap_inv_lns_tl_rec_type IS
1465: CURSOR okl_txl_ap_inv_lns_tl_pk_csr (p_id IN NUMBER,
1466: p_language IN VARCHAR2) IS

Line 1464: ) RETURN okl_txl_ap_inv_lns_tl_rec_type IS

1460: ---------------------------------------------------------------------------
1461: FUNCTION get_rec (
1462: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
1463: x_no_data_found OUT NOCOPY BOOLEAN
1464: ) RETURN okl_txl_ap_inv_lns_tl_rec_type IS
1465: CURSOR okl_txl_ap_inv_lns_tl_pk_csr (p_id IN NUMBER,
1466: p_language IN VARCHAR2) IS
1467: SELECT
1468: ID,

Line 1465: CURSOR okl_txl_ap_inv_lns_tl_pk_csr (p_id IN NUMBER,

1461: FUNCTION get_rec (
1462: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
1463: x_no_data_found OUT NOCOPY BOOLEAN
1464: ) RETURN okl_txl_ap_inv_lns_tl_rec_type IS
1465: CURSOR okl_txl_ap_inv_lns_tl_pk_csr (p_id IN NUMBER,
1466: p_language IN VARCHAR2) IS
1467: SELECT
1468: ID,
1469: LANGUAGE,

Line 1478: FROM Okl_Txl_Ap_Inv_Lns_Tl

1474: CREATION_DATE,
1475: LAST_UPDATED_BY,
1476: LAST_UPDATE_DATE,
1477: LAST_UPDATE_LOGIN
1478: FROM Okl_Txl_Ap_Inv_Lns_Tl
1479: WHERE okl_txl_ap_inv_lns_tl.id = p_id
1480: AND okl_txl_ap_inv_lns_tl.language = p_language;
1481: l_okl_txl_ap_inv_lns_tl_pk okl_txl_ap_inv_lns_tl_pk_csr%ROWTYPE;
1482: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;

Line 1479: WHERE okl_txl_ap_inv_lns_tl.id = p_id

1475: LAST_UPDATED_BY,
1476: LAST_UPDATE_DATE,
1477: LAST_UPDATE_LOGIN
1478: FROM Okl_Txl_Ap_Inv_Lns_Tl
1479: WHERE okl_txl_ap_inv_lns_tl.id = p_id
1480: AND okl_txl_ap_inv_lns_tl.language = p_language;
1481: l_okl_txl_ap_inv_lns_tl_pk okl_txl_ap_inv_lns_tl_pk_csr%ROWTYPE;
1482: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
1483: BEGIN

Line 1480: AND okl_txl_ap_inv_lns_tl.language = p_language;

1476: LAST_UPDATE_DATE,
1477: LAST_UPDATE_LOGIN
1478: FROM Okl_Txl_Ap_Inv_Lns_Tl
1479: WHERE okl_txl_ap_inv_lns_tl.id = p_id
1480: AND okl_txl_ap_inv_lns_tl.language = p_language;
1481: l_okl_txl_ap_inv_lns_tl_pk okl_txl_ap_inv_lns_tl_pk_csr%ROWTYPE;
1482: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
1483: BEGIN
1484: x_no_data_found := TRUE;

Line 1481: l_okl_txl_ap_inv_lns_tl_pk okl_txl_ap_inv_lns_tl_pk_csr%ROWTYPE;

1477: LAST_UPDATE_LOGIN
1478: FROM Okl_Txl_Ap_Inv_Lns_Tl
1479: WHERE okl_txl_ap_inv_lns_tl.id = p_id
1480: AND okl_txl_ap_inv_lns_tl.language = p_language;
1481: l_okl_txl_ap_inv_lns_tl_pk okl_txl_ap_inv_lns_tl_pk_csr%ROWTYPE;
1482: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
1483: BEGIN
1484: x_no_data_found := TRUE;
1485: -- Get current database values

Line 1482: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;

1478: FROM Okl_Txl_Ap_Inv_Lns_Tl
1479: WHERE okl_txl_ap_inv_lns_tl.id = p_id
1480: AND okl_txl_ap_inv_lns_tl.language = p_language;
1481: l_okl_txl_ap_inv_lns_tl_pk okl_txl_ap_inv_lns_tl_pk_csr%ROWTYPE;
1482: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
1483: BEGIN
1484: x_no_data_found := TRUE;
1485: -- Get current database values
1486: OPEN okl_txl_ap_inv_lns_tl_pk_csr (p_okl_txl_ap_inv_lns_tl_rec.id,

Line 1486: OPEN okl_txl_ap_inv_lns_tl_pk_csr (p_okl_txl_ap_inv_lns_tl_rec.id,

1482: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
1483: BEGIN
1484: x_no_data_found := TRUE;
1485: -- Get current database values
1486: OPEN okl_txl_ap_inv_lns_tl_pk_csr (p_okl_txl_ap_inv_lns_tl_rec.id,
1487: p_okl_txl_ap_inv_lns_tl_rec.language);
1488: FETCH okl_txl_ap_inv_lns_tl_pk_csr INTO
1489: l_okl_txl_ap_inv_lns_tl_rec.ID,
1490: l_okl_txl_ap_inv_lns_tl_rec.LANGUAGE,

Line 1487: p_okl_txl_ap_inv_lns_tl_rec.language);

1483: BEGIN
1484: x_no_data_found := TRUE;
1485: -- Get current database values
1486: OPEN okl_txl_ap_inv_lns_tl_pk_csr (p_okl_txl_ap_inv_lns_tl_rec.id,
1487: p_okl_txl_ap_inv_lns_tl_rec.language);
1488: FETCH okl_txl_ap_inv_lns_tl_pk_csr INTO
1489: l_okl_txl_ap_inv_lns_tl_rec.ID,
1490: l_okl_txl_ap_inv_lns_tl_rec.LANGUAGE,
1491: l_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG,

Line 1488: FETCH okl_txl_ap_inv_lns_tl_pk_csr INTO

1484: x_no_data_found := TRUE;
1485: -- Get current database values
1486: OPEN okl_txl_ap_inv_lns_tl_pk_csr (p_okl_txl_ap_inv_lns_tl_rec.id,
1487: p_okl_txl_ap_inv_lns_tl_rec.language);
1488: FETCH okl_txl_ap_inv_lns_tl_pk_csr INTO
1489: l_okl_txl_ap_inv_lns_tl_rec.ID,
1490: l_okl_txl_ap_inv_lns_tl_rec.LANGUAGE,
1491: l_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG,
1492: l_okl_txl_ap_inv_lns_tl_rec.SFWT_FLAG,

Line 1489: l_okl_txl_ap_inv_lns_tl_rec.ID,

1485: -- Get current database values
1486: OPEN okl_txl_ap_inv_lns_tl_pk_csr (p_okl_txl_ap_inv_lns_tl_rec.id,
1487: p_okl_txl_ap_inv_lns_tl_rec.language);
1488: FETCH okl_txl_ap_inv_lns_tl_pk_csr INTO
1489: l_okl_txl_ap_inv_lns_tl_rec.ID,
1490: l_okl_txl_ap_inv_lns_tl_rec.LANGUAGE,
1491: l_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG,
1492: l_okl_txl_ap_inv_lns_tl_rec.SFWT_FLAG,
1493: l_okl_txl_ap_inv_lns_tl_rec.DESCRIPTION,

Line 1490: l_okl_txl_ap_inv_lns_tl_rec.LANGUAGE,

1486: OPEN okl_txl_ap_inv_lns_tl_pk_csr (p_okl_txl_ap_inv_lns_tl_rec.id,
1487: p_okl_txl_ap_inv_lns_tl_rec.language);
1488: FETCH okl_txl_ap_inv_lns_tl_pk_csr INTO
1489: l_okl_txl_ap_inv_lns_tl_rec.ID,
1490: l_okl_txl_ap_inv_lns_tl_rec.LANGUAGE,
1491: l_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG,
1492: l_okl_txl_ap_inv_lns_tl_rec.SFWT_FLAG,
1493: l_okl_txl_ap_inv_lns_tl_rec.DESCRIPTION,
1494: l_okl_txl_ap_inv_lns_tl_rec.CREATED_BY,

Line 1491: l_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG,

1487: p_okl_txl_ap_inv_lns_tl_rec.language);
1488: FETCH okl_txl_ap_inv_lns_tl_pk_csr INTO
1489: l_okl_txl_ap_inv_lns_tl_rec.ID,
1490: l_okl_txl_ap_inv_lns_tl_rec.LANGUAGE,
1491: l_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG,
1492: l_okl_txl_ap_inv_lns_tl_rec.SFWT_FLAG,
1493: l_okl_txl_ap_inv_lns_tl_rec.DESCRIPTION,
1494: l_okl_txl_ap_inv_lns_tl_rec.CREATED_BY,
1495: l_okl_txl_ap_inv_lns_tl_rec.CREATION_DATE,

Line 1492: l_okl_txl_ap_inv_lns_tl_rec.SFWT_FLAG,

1488: FETCH okl_txl_ap_inv_lns_tl_pk_csr INTO
1489: l_okl_txl_ap_inv_lns_tl_rec.ID,
1490: l_okl_txl_ap_inv_lns_tl_rec.LANGUAGE,
1491: l_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG,
1492: l_okl_txl_ap_inv_lns_tl_rec.SFWT_FLAG,
1493: l_okl_txl_ap_inv_lns_tl_rec.DESCRIPTION,
1494: l_okl_txl_ap_inv_lns_tl_rec.CREATED_BY,
1495: l_okl_txl_ap_inv_lns_tl_rec.CREATION_DATE,
1496: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATED_BY,

Line 1493: l_okl_txl_ap_inv_lns_tl_rec.DESCRIPTION,

1489: l_okl_txl_ap_inv_lns_tl_rec.ID,
1490: l_okl_txl_ap_inv_lns_tl_rec.LANGUAGE,
1491: l_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG,
1492: l_okl_txl_ap_inv_lns_tl_rec.SFWT_FLAG,
1493: l_okl_txl_ap_inv_lns_tl_rec.DESCRIPTION,
1494: l_okl_txl_ap_inv_lns_tl_rec.CREATED_BY,
1495: l_okl_txl_ap_inv_lns_tl_rec.CREATION_DATE,
1496: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATED_BY,
1497: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_DATE,

Line 1494: l_okl_txl_ap_inv_lns_tl_rec.CREATED_BY,

1490: l_okl_txl_ap_inv_lns_tl_rec.LANGUAGE,
1491: l_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG,
1492: l_okl_txl_ap_inv_lns_tl_rec.SFWT_FLAG,
1493: l_okl_txl_ap_inv_lns_tl_rec.DESCRIPTION,
1494: l_okl_txl_ap_inv_lns_tl_rec.CREATED_BY,
1495: l_okl_txl_ap_inv_lns_tl_rec.CREATION_DATE,
1496: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATED_BY,
1497: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_DATE,
1498: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_LOGIN;

Line 1495: l_okl_txl_ap_inv_lns_tl_rec.CREATION_DATE,

1491: l_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG,
1492: l_okl_txl_ap_inv_lns_tl_rec.SFWT_FLAG,
1493: l_okl_txl_ap_inv_lns_tl_rec.DESCRIPTION,
1494: l_okl_txl_ap_inv_lns_tl_rec.CREATED_BY,
1495: l_okl_txl_ap_inv_lns_tl_rec.CREATION_DATE,
1496: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATED_BY,
1497: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_DATE,
1498: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_LOGIN;
1499: x_no_data_found := okl_txl_ap_inv_lns_tl_pk_csr%NOTFOUND;

Line 1496: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATED_BY,

1492: l_okl_txl_ap_inv_lns_tl_rec.SFWT_FLAG,
1493: l_okl_txl_ap_inv_lns_tl_rec.DESCRIPTION,
1494: l_okl_txl_ap_inv_lns_tl_rec.CREATED_BY,
1495: l_okl_txl_ap_inv_lns_tl_rec.CREATION_DATE,
1496: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATED_BY,
1497: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_DATE,
1498: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_LOGIN;
1499: x_no_data_found := okl_txl_ap_inv_lns_tl_pk_csr%NOTFOUND;
1500: CLOSE okl_txl_ap_inv_lns_tl_pk_csr;

Line 1497: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_DATE,

1493: l_okl_txl_ap_inv_lns_tl_rec.DESCRIPTION,
1494: l_okl_txl_ap_inv_lns_tl_rec.CREATED_BY,
1495: l_okl_txl_ap_inv_lns_tl_rec.CREATION_DATE,
1496: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATED_BY,
1497: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_DATE,
1498: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_LOGIN;
1499: x_no_data_found := okl_txl_ap_inv_lns_tl_pk_csr%NOTFOUND;
1500: CLOSE okl_txl_ap_inv_lns_tl_pk_csr;
1501: RETURN(l_okl_txl_ap_inv_lns_tl_rec);

Line 1498: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_LOGIN;

1494: l_okl_txl_ap_inv_lns_tl_rec.CREATED_BY,
1495: l_okl_txl_ap_inv_lns_tl_rec.CREATION_DATE,
1496: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATED_BY,
1497: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_DATE,
1498: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_LOGIN;
1499: x_no_data_found := okl_txl_ap_inv_lns_tl_pk_csr%NOTFOUND;
1500: CLOSE okl_txl_ap_inv_lns_tl_pk_csr;
1501: RETURN(l_okl_txl_ap_inv_lns_tl_rec);
1502: END get_rec;

Line 1499: x_no_data_found := okl_txl_ap_inv_lns_tl_pk_csr%NOTFOUND;

1495: l_okl_txl_ap_inv_lns_tl_rec.CREATION_DATE,
1496: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATED_BY,
1497: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_DATE,
1498: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_LOGIN;
1499: x_no_data_found := okl_txl_ap_inv_lns_tl_pk_csr%NOTFOUND;
1500: CLOSE okl_txl_ap_inv_lns_tl_pk_csr;
1501: RETURN(l_okl_txl_ap_inv_lns_tl_rec);
1502: END get_rec;
1503:

Line 1500: CLOSE okl_txl_ap_inv_lns_tl_pk_csr;

1496: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATED_BY,
1497: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_DATE,
1498: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_LOGIN;
1499: x_no_data_found := okl_txl_ap_inv_lns_tl_pk_csr%NOTFOUND;
1500: CLOSE okl_txl_ap_inv_lns_tl_pk_csr;
1501: RETURN(l_okl_txl_ap_inv_lns_tl_rec);
1502: END get_rec;
1503:
1504: FUNCTION get_rec (

Line 1501: RETURN(l_okl_txl_ap_inv_lns_tl_rec);

1497: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_DATE,
1498: l_okl_txl_ap_inv_lns_tl_rec.LAST_UPDATE_LOGIN;
1499: x_no_data_found := okl_txl_ap_inv_lns_tl_pk_csr%NOTFOUND;
1500: CLOSE okl_txl_ap_inv_lns_tl_pk_csr;
1501: RETURN(l_okl_txl_ap_inv_lns_tl_rec);
1502: END get_rec;
1503:
1504: FUNCTION get_rec (
1505: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type

Line 1505: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type

1501: RETURN(l_okl_txl_ap_inv_lns_tl_rec);
1502: END get_rec;
1503:
1504: FUNCTION get_rec (
1505: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type
1506: ) RETURN okl_txl_ap_inv_lns_tl_rec_type IS
1507: l_row_notfound BOOLEAN := TRUE;
1508: BEGIN
1509: RETURN(get_rec(p_okl_txl_ap_inv_lns_tl_rec, l_row_notfound));

Line 1506: ) RETURN okl_txl_ap_inv_lns_tl_rec_type IS

1502: END get_rec;
1503:
1504: FUNCTION get_rec (
1505: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type
1506: ) RETURN okl_txl_ap_inv_lns_tl_rec_type IS
1507: l_row_notfound BOOLEAN := TRUE;
1508: BEGIN
1509: RETURN(get_rec(p_okl_txl_ap_inv_lns_tl_rec, l_row_notfound));
1510: END get_rec;

Line 1509: RETURN(get_rec(p_okl_txl_ap_inv_lns_tl_rec, l_row_notfound));

1505: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type
1506: ) RETURN okl_txl_ap_inv_lns_tl_rec_type IS
1507: l_row_notfound BOOLEAN := TRUE;
1508: BEGIN
1509: RETURN(get_rec(p_okl_txl_ap_inv_lns_tl_rec, l_row_notfound));
1510: END get_rec;
1511: ---------------------------------------------------------------------------
1512: -- FUNCTION get_rec for: OKL_TXL_AP_INV_LNS_V
1513: ---------------------------------------------------------------------------

Line 2218: p_to IN OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type -- PostGen-11

2214: p_to.sel_id := p_from.sel_id;
2215: END migrate;
2216: PROCEDURE migrate (
2217: p_from IN tplv_rec_type,
2218: p_to IN OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type -- PostGen-11
2219: ) IS
2220: BEGIN
2221: p_to.id := p_from.id;
2222: p_to.sfwt_flag := p_from.sfwt_flag;

Line 2231: p_from IN okl_txl_ap_inv_lns_tl_rec_type,

2227: p_to.last_update_date := p_from.last_update_date;
2228: p_to.last_update_login := p_from.last_update_login;
2229: END migrate;
2230: PROCEDURE migrate (
2231: p_from IN okl_txl_ap_inv_lns_tl_rec_type,
2232: p_to IN OUT NOCOPY tplv_rec_type -- PostGen-11
2233: ) IS
2234: BEGIN
2235: p_to.id := p_from.id;

Line 2264: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;

2260: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
2261: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2262: l_tplv_rec tplv_rec_type := p_tplv_rec;
2263: l_tpl_rec tpl_rec_type;
2264: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
2265: BEGIN
2266: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2267: G_PKG_NAME,
2268: p_init_msg_list,

Line 2597: -- insert_row for:OKL_TXL_AP_INV_LNS_TL --

2593: '_PVT'
2594: );
2595: END insert_row;
2596: ------------------------------------------
2597: -- insert_row for:OKL_TXL_AP_INV_LNS_TL --
2598: ------------------------------------------
2599: PROCEDURE insert_row(
2600: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2601: x_return_status OUT NOCOPY VARCHAR2,

Line 2604: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,

2600: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2601: x_return_status OUT NOCOPY VARCHAR2,
2602: x_msg_count OUT NOCOPY NUMBER,
2603: x_msg_data OUT NOCOPY VARCHAR2,
2604: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
2605: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type) IS
2606:
2607: l_api_version CONSTANT NUMBER := 1;
2608: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 2605: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type) IS

2601: x_return_status OUT NOCOPY VARCHAR2,
2602: x_msg_count OUT NOCOPY NUMBER,
2603: x_msg_data OUT NOCOPY VARCHAR2,
2604: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
2605: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type) IS
2606:
2607: l_api_version CONSTANT NUMBER := 1;
2608: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2609: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2610: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type := p_okl_txl_ap_inv_lns_tl_rec;

2606:
2607: l_api_version CONSTANT NUMBER := 1;
2608: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2609: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2610: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type := p_okl_txl_ap_inv_lns_tl_rec;
2611: ldefokltxlapinvlnstlrec okl_txl_ap_inv_lns_tl_rec_type;
2612: CURSOR get_languages IS
2613: SELECT *
2614: FROM FND_LANGUAGES

Line 2611: ldefokltxlapinvlnstlrec okl_txl_ap_inv_lns_tl_rec_type;

2607: l_api_version CONSTANT NUMBER := 1;
2608: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2609: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2610: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type := p_okl_txl_ap_inv_lns_tl_rec;
2611: ldefokltxlapinvlnstlrec okl_txl_ap_inv_lns_tl_rec_type;
2612: CURSOR get_languages IS
2613: SELECT *
2614: FROM FND_LANGUAGES
2615: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 2617: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --

2613: SELECT *
2614: FROM FND_LANGUAGES
2615: WHERE INSTALLED_FLAG IN ('I', 'B');
2616: ----------------------------------------------
2617: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --
2618: ----------------------------------------------
2619: FUNCTION Set_Attributes (
2620: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
2621: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type

Line 2620: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,

2616: ----------------------------------------------
2617: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --
2618: ----------------------------------------------
2619: FUNCTION Set_Attributes (
2620: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
2621: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
2622: ) RETURN VARCHAR2 IS
2623: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2624: BEGIN

Line 2621: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type

2617: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --
2618: ----------------------------------------------
2619: FUNCTION Set_Attributes (
2620: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
2621: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
2622: ) RETURN VARCHAR2 IS
2623: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2624: BEGIN
2625: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;

Line 2625: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;

2621: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
2622: ) RETURN VARCHAR2 IS
2623: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2624: BEGIN
2625: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;
2626: x_okl_txl_ap_inv_lns_tl_rec.LANGUAGE := USERENV('LANG');
2627: x_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
2628: RETURN(l_return_status);
2629: END Set_Attributes;

Line 2626: x_okl_txl_ap_inv_lns_tl_rec.LANGUAGE := USERENV('LANG');

2622: ) RETURN VARCHAR2 IS
2623: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2624: BEGIN
2625: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;
2626: x_okl_txl_ap_inv_lns_tl_rec.LANGUAGE := USERENV('LANG');
2627: x_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
2628: RETURN(l_return_status);
2629: END Set_Attributes;
2630: BEGIN

Line 2627: x_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG := USERENV('LANG');

2623: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2624: BEGIN
2625: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;
2626: x_okl_txl_ap_inv_lns_tl_rec.LANGUAGE := USERENV('LANG');
2627: x_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
2628: RETURN(l_return_status);
2629: END Set_Attributes;
2630: BEGIN
2631: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2642: p_okl_txl_ap_inv_lns_tl_rec, -- IN

2638: RAISE OKL_API.G_EXCEPTION_ERROR;
2639: END IF;
2640: --- Setting item attributes
2641: l_return_status := Set_Attributes(
2642: p_okl_txl_ap_inv_lns_tl_rec, -- IN
2643: l_okl_txl_ap_inv_lns_tl_rec); -- OUT
2644: --- If any errors happen abort API
2645: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2646: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2643: l_okl_txl_ap_inv_lns_tl_rec); -- OUT

2639: END IF;
2640: --- Setting item attributes
2641: l_return_status := Set_Attributes(
2642: p_okl_txl_ap_inv_lns_tl_rec, -- IN
2643: l_okl_txl_ap_inv_lns_tl_rec); -- OUT
2644: --- If any errors happen abort API
2645: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2646: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2647: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2651: l_okl_txl_ap_inv_lns_tl_rec.language := l_lang_rec.language_code;

2647: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2648: RAISE OKL_API.G_EXCEPTION_ERROR;
2649: END IF;
2650: FOR l_lang_rec IN get_languages LOOP
2651: l_okl_txl_ap_inv_lns_tl_rec.language := l_lang_rec.language_code;
2652: INSERT INTO OKL_TXL_AP_INV_LNS_TL(
2653: id,
2654: language,
2655: source_lang,

Line 2652: INSERT INTO OKL_TXL_AP_INV_LNS_TL(

2648: RAISE OKL_API.G_EXCEPTION_ERROR;
2649: END IF;
2650: FOR l_lang_rec IN get_languages LOOP
2651: l_okl_txl_ap_inv_lns_tl_rec.language := l_lang_rec.language_code;
2652: INSERT INTO OKL_TXL_AP_INV_LNS_TL(
2653: id,
2654: language,
2655: source_lang,
2656: sfwt_flag,

Line 2664: l_okl_txl_ap_inv_lns_tl_rec.id,

2660: last_updated_by,
2661: last_update_date,
2662: last_update_login)
2663: VALUES (
2664: l_okl_txl_ap_inv_lns_tl_rec.id,
2665: l_okl_txl_ap_inv_lns_tl_rec.language,
2666: l_okl_txl_ap_inv_lns_tl_rec.source_lang,
2667: l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag,
2668: l_okl_txl_ap_inv_lns_tl_rec.description,

Line 2665: l_okl_txl_ap_inv_lns_tl_rec.language,

2661: last_update_date,
2662: last_update_login)
2663: VALUES (
2664: l_okl_txl_ap_inv_lns_tl_rec.id,
2665: l_okl_txl_ap_inv_lns_tl_rec.language,
2666: l_okl_txl_ap_inv_lns_tl_rec.source_lang,
2667: l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag,
2668: l_okl_txl_ap_inv_lns_tl_rec.description,
2669: l_okl_txl_ap_inv_lns_tl_rec.created_by,

Line 2666: l_okl_txl_ap_inv_lns_tl_rec.source_lang,

2662: last_update_login)
2663: VALUES (
2664: l_okl_txl_ap_inv_lns_tl_rec.id,
2665: l_okl_txl_ap_inv_lns_tl_rec.language,
2666: l_okl_txl_ap_inv_lns_tl_rec.source_lang,
2667: l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag,
2668: l_okl_txl_ap_inv_lns_tl_rec.description,
2669: l_okl_txl_ap_inv_lns_tl_rec.created_by,
2670: l_okl_txl_ap_inv_lns_tl_rec.creation_date,

Line 2667: l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag,

2663: VALUES (
2664: l_okl_txl_ap_inv_lns_tl_rec.id,
2665: l_okl_txl_ap_inv_lns_tl_rec.language,
2666: l_okl_txl_ap_inv_lns_tl_rec.source_lang,
2667: l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag,
2668: l_okl_txl_ap_inv_lns_tl_rec.description,
2669: l_okl_txl_ap_inv_lns_tl_rec.created_by,
2670: l_okl_txl_ap_inv_lns_tl_rec.creation_date,
2671: l_okl_txl_ap_inv_lns_tl_rec.last_updated_by,

Line 2668: l_okl_txl_ap_inv_lns_tl_rec.description,

2664: l_okl_txl_ap_inv_lns_tl_rec.id,
2665: l_okl_txl_ap_inv_lns_tl_rec.language,
2666: l_okl_txl_ap_inv_lns_tl_rec.source_lang,
2667: l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag,
2668: l_okl_txl_ap_inv_lns_tl_rec.description,
2669: l_okl_txl_ap_inv_lns_tl_rec.created_by,
2670: l_okl_txl_ap_inv_lns_tl_rec.creation_date,
2671: l_okl_txl_ap_inv_lns_tl_rec.last_updated_by,
2672: l_okl_txl_ap_inv_lns_tl_rec.last_update_date,

Line 2669: l_okl_txl_ap_inv_lns_tl_rec.created_by,

2665: l_okl_txl_ap_inv_lns_tl_rec.language,
2666: l_okl_txl_ap_inv_lns_tl_rec.source_lang,
2667: l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag,
2668: l_okl_txl_ap_inv_lns_tl_rec.description,
2669: l_okl_txl_ap_inv_lns_tl_rec.created_by,
2670: l_okl_txl_ap_inv_lns_tl_rec.creation_date,
2671: l_okl_txl_ap_inv_lns_tl_rec.last_updated_by,
2672: l_okl_txl_ap_inv_lns_tl_rec.last_update_date,
2673: l_okl_txl_ap_inv_lns_tl_rec.last_update_login);

Line 2670: l_okl_txl_ap_inv_lns_tl_rec.creation_date,

2666: l_okl_txl_ap_inv_lns_tl_rec.source_lang,
2667: l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag,
2668: l_okl_txl_ap_inv_lns_tl_rec.description,
2669: l_okl_txl_ap_inv_lns_tl_rec.created_by,
2670: l_okl_txl_ap_inv_lns_tl_rec.creation_date,
2671: l_okl_txl_ap_inv_lns_tl_rec.last_updated_by,
2672: l_okl_txl_ap_inv_lns_tl_rec.last_update_date,
2673: l_okl_txl_ap_inv_lns_tl_rec.last_update_login);
2674: END LOOP;

Line 2671: l_okl_txl_ap_inv_lns_tl_rec.last_updated_by,

2667: l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag,
2668: l_okl_txl_ap_inv_lns_tl_rec.description,
2669: l_okl_txl_ap_inv_lns_tl_rec.created_by,
2670: l_okl_txl_ap_inv_lns_tl_rec.creation_date,
2671: l_okl_txl_ap_inv_lns_tl_rec.last_updated_by,
2672: l_okl_txl_ap_inv_lns_tl_rec.last_update_date,
2673: l_okl_txl_ap_inv_lns_tl_rec.last_update_login);
2674: END LOOP;
2675: -- Set OUT values

Line 2672: l_okl_txl_ap_inv_lns_tl_rec.last_update_date,

2668: l_okl_txl_ap_inv_lns_tl_rec.description,
2669: l_okl_txl_ap_inv_lns_tl_rec.created_by,
2670: l_okl_txl_ap_inv_lns_tl_rec.creation_date,
2671: l_okl_txl_ap_inv_lns_tl_rec.last_updated_by,
2672: l_okl_txl_ap_inv_lns_tl_rec.last_update_date,
2673: l_okl_txl_ap_inv_lns_tl_rec.last_update_login);
2674: END LOOP;
2675: -- Set OUT values
2676: x_okl_txl_ap_inv_lns_tl_rec := l_okl_txl_ap_inv_lns_tl_rec;

Line 2673: l_okl_txl_ap_inv_lns_tl_rec.last_update_login);

2669: l_okl_txl_ap_inv_lns_tl_rec.created_by,
2670: l_okl_txl_ap_inv_lns_tl_rec.creation_date,
2671: l_okl_txl_ap_inv_lns_tl_rec.last_updated_by,
2672: l_okl_txl_ap_inv_lns_tl_rec.last_update_date,
2673: l_okl_txl_ap_inv_lns_tl_rec.last_update_login);
2674: END LOOP;
2675: -- Set OUT values
2676: x_okl_txl_ap_inv_lns_tl_rec := l_okl_txl_ap_inv_lns_tl_rec;
2677: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2676: x_okl_txl_ap_inv_lns_tl_rec := l_okl_txl_ap_inv_lns_tl_rec;

2672: l_okl_txl_ap_inv_lns_tl_rec.last_update_date,
2673: l_okl_txl_ap_inv_lns_tl_rec.last_update_login);
2674: END LOOP;
2675: -- Set OUT values
2676: x_okl_txl_ap_inv_lns_tl_rec := l_okl_txl_ap_inv_lns_tl_rec;
2677: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2678: EXCEPTION
2679: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2680: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 2729: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;

2725: l_tplv_rec tplv_rec_type;
2726: l_def_tplv_rec tplv_rec_type;
2727: l_tpl_rec tpl_rec_type;
2728: lx_tpl_rec tpl_rec_type;
2729: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
2730: lx_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
2731: -------------------------------
2732: -- FUNCTION fill_who_columns --
2733: -------------------------------

Line 2730: lx_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;

2726: l_def_tplv_rec tplv_rec_type;
2727: l_tpl_rec tpl_rec_type;
2728: lx_tpl_rec tpl_rec_type;
2729: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
2730: lx_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
2731: -------------------------------
2732: -- FUNCTION fill_who_columns --
2733: -------------------------------
2734: FUNCTION fill_who_columns (

Line 2820: migrate(l_def_tplv_rec, l_okl_txl_ap_inv_lns_tl_rec);

2816: --------------------------------------
2817: -- Move VIEW record to "Child" records
2818: --------------------------------------
2819: migrate(l_def_tplv_rec, l_tpl_rec);
2820: migrate(l_def_tplv_rec, l_okl_txl_ap_inv_lns_tl_rec);
2821: --------------------------------------------
2822: -- Call the INSERT_ROW for each child record
2823: --------------------------------------------
2824: insert_row(

Line 2843: l_okl_txl_ap_inv_lns_tl_rec,

2839: p_init_msg_list,
2840: x_return_status,
2841: x_msg_count,
2842: x_msg_data,
2843: l_okl_txl_ap_inv_lns_tl_rec,
2844: lx_okl_txl_ap_inv_lns_tl_rec
2845: );
2846: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2844: lx_okl_txl_ap_inv_lns_tl_rec

2840: x_return_status,
2841: x_msg_count,
2842: x_msg_data,
2843: l_okl_txl_ap_inv_lns_tl_rec,
2844: lx_okl_txl_ap_inv_lns_tl_rec
2845: );
2846: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2848: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2851: migrate(lx_okl_txl_ap_inv_lns_tl_rec, l_def_tplv_rec);

2847: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2848: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2849: RAISE OKL_API.G_EXCEPTION_ERROR;
2850: END IF;
2851: migrate(lx_okl_txl_ap_inv_lns_tl_rec, l_def_tplv_rec);
2852: -- Set OUT values
2853: x_tplv_rec := l_def_tplv_rec;
2854: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2855: EXCEPTION

Line 3076: -- lock_row for:OKL_TXL_AP_INV_LNS_TL --

3072: '_PVT'
3073: );
3074: END lock_row;
3075: ----------------------------------------
3076: -- lock_row for:OKL_TXL_AP_INV_LNS_TL --
3077: ----------------------------------------
3078: PROCEDURE lock_row(
3079: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3080: x_return_status OUT NOCOPY VARCHAR2,

Line 3083: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS

3079: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3080: x_return_status OUT NOCOPY VARCHAR2,
3081: x_msg_count OUT NOCOPY NUMBER,
3082: x_msg_data OUT NOCOPY VARCHAR2,
3083: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS
3084:
3085: E_Resource_Busy EXCEPTION;
3086: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3087: CURSOR lock_csr (p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS

Line 3087: CURSOR lock_csr (p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS

3083: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS
3084:
3085: E_Resource_Busy EXCEPTION;
3086: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3087: CURSOR lock_csr (p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS
3088: SELECT *
3089: FROM OKL_TXL_AP_INV_LNS_TL
3090: WHERE ID = p_okl_txl_ap_inv_lns_tl_rec.id
3091: FOR UPDATE NOWAIT;

Line 3089: FROM OKL_TXL_AP_INV_LNS_TL

3085: E_Resource_Busy EXCEPTION;
3086: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3087: CURSOR lock_csr (p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS
3088: SELECT *
3089: FROM OKL_TXL_AP_INV_LNS_TL
3090: WHERE ID = p_okl_txl_ap_inv_lns_tl_rec.id
3091: FOR UPDATE NOWAIT;
3092:
3093: l_api_version CONSTANT NUMBER := 1;

Line 3090: WHERE ID = p_okl_txl_ap_inv_lns_tl_rec.id

3086: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3087: CURSOR lock_csr (p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS
3088: SELECT *
3089: FROM OKL_TXL_AP_INV_LNS_TL
3090: WHERE ID = p_okl_txl_ap_inv_lns_tl_rec.id
3091: FOR UPDATE NOWAIT;
3092:
3093: l_api_version CONSTANT NUMBER := 1;
3094: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 3110: OPEN lock_csr(p_okl_txl_ap_inv_lns_tl_rec);

3106: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3107: RAISE OKL_API.G_EXCEPTION_ERROR;
3108: END IF;
3109: BEGIN
3110: OPEN lock_csr(p_okl_txl_ap_inv_lns_tl_rec);
3111: FETCH lock_csr INTO l_lock_var;
3112: l_row_notfound := lock_csr%NOTFOUND;
3113: CLOSE lock_csr;
3114: EXCEPTION

Line 3175: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;

3171: l_api_version CONSTANT NUMBER := 1;
3172: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
3173: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3174: l_tpl_rec tpl_rec_type;
3175: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
3176: BEGIN
3177: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
3178: G_PKG_NAME,
3179: p_init_msg_list,

Line 3193: migrate(p_tplv_rec, l_okl_txl_ap_inv_lns_tl_rec);

3189: --------------------------------------
3190: -- Move VIEW record to "Child" records
3191: --------------------------------------
3192: migrate(p_tplv_rec, l_tpl_rec);
3193: migrate(p_tplv_rec, l_okl_txl_ap_inv_lns_tl_rec);
3194: --------------------------------------------
3195: -- Call the LOCK_ROW for each child record
3196: --------------------------------------------
3197: lock_row(

Line 3214: l_okl_txl_ap_inv_lns_tl_rec

3210: p_init_msg_list,
3211: x_return_status,
3212: x_msg_count,
3213: x_msg_data,
3214: l_okl_txl_ap_inv_lns_tl_rec
3215: );
3216: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3218: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3707: -- update_row for:OKL_TXL_AP_INV_LNS_TL --

3703: '_PVT'
3704: );
3705: END update_row;
3706: ------------------------------------------
3707: -- update_row for:OKL_TXL_AP_INV_LNS_TL --
3708: ------------------------------------------
3709: PROCEDURE update_row(
3710: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3711: x_return_status OUT NOCOPY VARCHAR2,

Line 3714: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,

3710: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3711: x_return_status OUT NOCOPY VARCHAR2,
3712: x_msg_count OUT NOCOPY NUMBER,
3713: x_msg_data OUT NOCOPY VARCHAR2,
3714: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
3715: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type) IS
3716:
3717: l_api_version CONSTANT NUMBER := 1;
3718: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 3715: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type) IS

3711: x_return_status OUT NOCOPY VARCHAR2,
3712: x_msg_count OUT NOCOPY NUMBER,
3713: x_msg_data OUT NOCOPY VARCHAR2,
3714: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
3715: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type) IS
3716:
3717: l_api_version CONSTANT NUMBER := 1;
3718: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3719: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3720: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type := p_okl_txl_ap_inv_lns_tl_rec;

3716:
3717: l_api_version CONSTANT NUMBER := 1;
3718: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3719: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3720: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type := p_okl_txl_ap_inv_lns_tl_rec;
3721: ldefokltxlapinvlnstlrec okl_txl_ap_inv_lns_tl_rec_type;
3722: l_row_notfound BOOLEAN := TRUE;
3723: ----------------------------------
3724: -- FUNCTION populate_new_record --

Line 3721: ldefokltxlapinvlnstlrec okl_txl_ap_inv_lns_tl_rec_type;

3717: l_api_version CONSTANT NUMBER := 1;
3718: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3719: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3720: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type := p_okl_txl_ap_inv_lns_tl_rec;
3721: ldefokltxlapinvlnstlrec okl_txl_ap_inv_lns_tl_rec_type;
3722: l_row_notfound BOOLEAN := TRUE;
3723: ----------------------------------
3724: -- FUNCTION populate_new_record --
3725: ----------------------------------

Line 3727: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,

3723: ----------------------------------
3724: -- FUNCTION populate_new_record --
3725: ----------------------------------
3726: FUNCTION populate_new_record (
3727: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
3728: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
3729: ) RETURN VARCHAR2 IS
3730: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
3731: l_row_notfound BOOLEAN := TRUE;

Line 3728: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type

3724: -- FUNCTION populate_new_record --
3725: ----------------------------------
3726: FUNCTION populate_new_record (
3727: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
3728: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
3729: ) RETURN VARCHAR2 IS
3730: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
3731: l_row_notfound BOOLEAN := TRUE;
3732: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3730: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;

3726: FUNCTION populate_new_record (
3727: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
3728: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
3729: ) RETURN VARCHAR2 IS
3730: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
3731: l_row_notfound BOOLEAN := TRUE;
3732: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3733: BEGIN
3734: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;

Line 3734: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;

3730: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
3731: l_row_notfound BOOLEAN := TRUE;
3732: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3733: BEGIN
3734: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;
3735: -- Get current database values
3736: l_okl_txl_ap_inv_lns_tl_rec := get_rec(p_okl_txl_ap_inv_lns_tl_rec, l_row_notfound);
3737: IF (l_row_notfound) THEN
3738: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 3736: l_okl_txl_ap_inv_lns_tl_rec := get_rec(p_okl_txl_ap_inv_lns_tl_rec, l_row_notfound);

3732: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3733: BEGIN
3734: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;
3735: -- Get current database values
3736: l_okl_txl_ap_inv_lns_tl_rec := get_rec(p_okl_txl_ap_inv_lns_tl_rec, l_row_notfound);
3737: IF (l_row_notfound) THEN
3738: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3739: END IF;
3740: IF (x_okl_txl_ap_inv_lns_tl_rec.id = OKL_API.G_MISS_NUM)

Line 3740: IF (x_okl_txl_ap_inv_lns_tl_rec.id = OKL_API.G_MISS_NUM)

3736: l_okl_txl_ap_inv_lns_tl_rec := get_rec(p_okl_txl_ap_inv_lns_tl_rec, l_row_notfound);
3737: IF (l_row_notfound) THEN
3738: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3739: END IF;
3740: IF (x_okl_txl_ap_inv_lns_tl_rec.id = OKL_API.G_MISS_NUM)
3741: THEN
3742: x_okl_txl_ap_inv_lns_tl_rec.id := l_okl_txl_ap_inv_lns_tl_rec.id;
3743: END IF;
3744: IF (x_okl_txl_ap_inv_lns_tl_rec.language = OKL_API.G_MISS_CHAR)

Line 3742: x_okl_txl_ap_inv_lns_tl_rec.id := l_okl_txl_ap_inv_lns_tl_rec.id;

3738: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3739: END IF;
3740: IF (x_okl_txl_ap_inv_lns_tl_rec.id = OKL_API.G_MISS_NUM)
3741: THEN
3742: x_okl_txl_ap_inv_lns_tl_rec.id := l_okl_txl_ap_inv_lns_tl_rec.id;
3743: END IF;
3744: IF (x_okl_txl_ap_inv_lns_tl_rec.language = OKL_API.G_MISS_CHAR)
3745: THEN
3746: x_okl_txl_ap_inv_lns_tl_rec.language := l_okl_txl_ap_inv_lns_tl_rec.language;

Line 3744: IF (x_okl_txl_ap_inv_lns_tl_rec.language = OKL_API.G_MISS_CHAR)

3740: IF (x_okl_txl_ap_inv_lns_tl_rec.id = OKL_API.G_MISS_NUM)
3741: THEN
3742: x_okl_txl_ap_inv_lns_tl_rec.id := l_okl_txl_ap_inv_lns_tl_rec.id;
3743: END IF;
3744: IF (x_okl_txl_ap_inv_lns_tl_rec.language = OKL_API.G_MISS_CHAR)
3745: THEN
3746: x_okl_txl_ap_inv_lns_tl_rec.language := l_okl_txl_ap_inv_lns_tl_rec.language;
3747: END IF;
3748: IF (x_okl_txl_ap_inv_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

Line 3746: x_okl_txl_ap_inv_lns_tl_rec.language := l_okl_txl_ap_inv_lns_tl_rec.language;

3742: x_okl_txl_ap_inv_lns_tl_rec.id := l_okl_txl_ap_inv_lns_tl_rec.id;
3743: END IF;
3744: IF (x_okl_txl_ap_inv_lns_tl_rec.language = OKL_API.G_MISS_CHAR)
3745: THEN
3746: x_okl_txl_ap_inv_lns_tl_rec.language := l_okl_txl_ap_inv_lns_tl_rec.language;
3747: END IF;
3748: IF (x_okl_txl_ap_inv_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
3749: THEN
3750: x_okl_txl_ap_inv_lns_tl_rec.source_lang := l_okl_txl_ap_inv_lns_tl_rec.source_lang;

Line 3748: IF (x_okl_txl_ap_inv_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

3744: IF (x_okl_txl_ap_inv_lns_tl_rec.language = OKL_API.G_MISS_CHAR)
3745: THEN
3746: x_okl_txl_ap_inv_lns_tl_rec.language := l_okl_txl_ap_inv_lns_tl_rec.language;
3747: END IF;
3748: IF (x_okl_txl_ap_inv_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
3749: THEN
3750: x_okl_txl_ap_inv_lns_tl_rec.source_lang := l_okl_txl_ap_inv_lns_tl_rec.source_lang;
3751: END IF;
3752: IF (x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

Line 3750: x_okl_txl_ap_inv_lns_tl_rec.source_lang := l_okl_txl_ap_inv_lns_tl_rec.source_lang;

3746: x_okl_txl_ap_inv_lns_tl_rec.language := l_okl_txl_ap_inv_lns_tl_rec.language;
3747: END IF;
3748: IF (x_okl_txl_ap_inv_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
3749: THEN
3750: x_okl_txl_ap_inv_lns_tl_rec.source_lang := l_okl_txl_ap_inv_lns_tl_rec.source_lang;
3751: END IF;
3752: IF (x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
3753: THEN
3754: x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag := l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag;

Line 3752: IF (x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

3748: IF (x_okl_txl_ap_inv_lns_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
3749: THEN
3750: x_okl_txl_ap_inv_lns_tl_rec.source_lang := l_okl_txl_ap_inv_lns_tl_rec.source_lang;
3751: END IF;
3752: IF (x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
3753: THEN
3754: x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag := l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag;
3755: END IF;
3756: IF (x_okl_txl_ap_inv_lns_tl_rec.description = OKL_API.G_MISS_CHAR)

Line 3754: x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag := l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag;

3750: x_okl_txl_ap_inv_lns_tl_rec.source_lang := l_okl_txl_ap_inv_lns_tl_rec.source_lang;
3751: END IF;
3752: IF (x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
3753: THEN
3754: x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag := l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag;
3755: END IF;
3756: IF (x_okl_txl_ap_inv_lns_tl_rec.description = OKL_API.G_MISS_CHAR)
3757: THEN
3758: x_okl_txl_ap_inv_lns_tl_rec.description := l_okl_txl_ap_inv_lns_tl_rec.description;

Line 3756: IF (x_okl_txl_ap_inv_lns_tl_rec.description = OKL_API.G_MISS_CHAR)

3752: IF (x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
3753: THEN
3754: x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag := l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag;
3755: END IF;
3756: IF (x_okl_txl_ap_inv_lns_tl_rec.description = OKL_API.G_MISS_CHAR)
3757: THEN
3758: x_okl_txl_ap_inv_lns_tl_rec.description := l_okl_txl_ap_inv_lns_tl_rec.description;
3759: END IF;
3760: IF (x_okl_txl_ap_inv_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)

Line 3758: x_okl_txl_ap_inv_lns_tl_rec.description := l_okl_txl_ap_inv_lns_tl_rec.description;

3754: x_okl_txl_ap_inv_lns_tl_rec.sfwt_flag := l_okl_txl_ap_inv_lns_tl_rec.sfwt_flag;
3755: END IF;
3756: IF (x_okl_txl_ap_inv_lns_tl_rec.description = OKL_API.G_MISS_CHAR)
3757: THEN
3758: x_okl_txl_ap_inv_lns_tl_rec.description := l_okl_txl_ap_inv_lns_tl_rec.description;
3759: END IF;
3760: IF (x_okl_txl_ap_inv_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)
3761: THEN
3762: x_okl_txl_ap_inv_lns_tl_rec.created_by := l_okl_txl_ap_inv_lns_tl_rec.created_by;

Line 3760: IF (x_okl_txl_ap_inv_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)

3756: IF (x_okl_txl_ap_inv_lns_tl_rec.description = OKL_API.G_MISS_CHAR)
3757: THEN
3758: x_okl_txl_ap_inv_lns_tl_rec.description := l_okl_txl_ap_inv_lns_tl_rec.description;
3759: END IF;
3760: IF (x_okl_txl_ap_inv_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)
3761: THEN
3762: x_okl_txl_ap_inv_lns_tl_rec.created_by := l_okl_txl_ap_inv_lns_tl_rec.created_by;
3763: END IF;
3764: IF (x_okl_txl_ap_inv_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)

Line 3762: x_okl_txl_ap_inv_lns_tl_rec.created_by := l_okl_txl_ap_inv_lns_tl_rec.created_by;

3758: x_okl_txl_ap_inv_lns_tl_rec.description := l_okl_txl_ap_inv_lns_tl_rec.description;
3759: END IF;
3760: IF (x_okl_txl_ap_inv_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)
3761: THEN
3762: x_okl_txl_ap_inv_lns_tl_rec.created_by := l_okl_txl_ap_inv_lns_tl_rec.created_by;
3763: END IF;
3764: IF (x_okl_txl_ap_inv_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)
3765: THEN
3766: x_okl_txl_ap_inv_lns_tl_rec.creation_date := l_okl_txl_ap_inv_lns_tl_rec.creation_date;

Line 3764: IF (x_okl_txl_ap_inv_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)

3760: IF (x_okl_txl_ap_inv_lns_tl_rec.created_by = OKL_API.G_MISS_NUM)
3761: THEN
3762: x_okl_txl_ap_inv_lns_tl_rec.created_by := l_okl_txl_ap_inv_lns_tl_rec.created_by;
3763: END IF;
3764: IF (x_okl_txl_ap_inv_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)
3765: THEN
3766: x_okl_txl_ap_inv_lns_tl_rec.creation_date := l_okl_txl_ap_inv_lns_tl_rec.creation_date;
3767: END IF;
3768: IF (x_okl_txl_ap_inv_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 3766: x_okl_txl_ap_inv_lns_tl_rec.creation_date := l_okl_txl_ap_inv_lns_tl_rec.creation_date;

3762: x_okl_txl_ap_inv_lns_tl_rec.created_by := l_okl_txl_ap_inv_lns_tl_rec.created_by;
3763: END IF;
3764: IF (x_okl_txl_ap_inv_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)
3765: THEN
3766: x_okl_txl_ap_inv_lns_tl_rec.creation_date := l_okl_txl_ap_inv_lns_tl_rec.creation_date;
3767: END IF;
3768: IF (x_okl_txl_ap_inv_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
3769: THEN
3770: x_okl_txl_ap_inv_lns_tl_rec.last_updated_by := l_okl_txl_ap_inv_lns_tl_rec.last_updated_by;

Line 3768: IF (x_okl_txl_ap_inv_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

3764: IF (x_okl_txl_ap_inv_lns_tl_rec.creation_date = OKL_API.G_MISS_DATE)
3765: THEN
3766: x_okl_txl_ap_inv_lns_tl_rec.creation_date := l_okl_txl_ap_inv_lns_tl_rec.creation_date;
3767: END IF;
3768: IF (x_okl_txl_ap_inv_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
3769: THEN
3770: x_okl_txl_ap_inv_lns_tl_rec.last_updated_by := l_okl_txl_ap_inv_lns_tl_rec.last_updated_by;
3771: END IF;
3772: IF (x_okl_txl_ap_inv_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 3770: x_okl_txl_ap_inv_lns_tl_rec.last_updated_by := l_okl_txl_ap_inv_lns_tl_rec.last_updated_by;

3766: x_okl_txl_ap_inv_lns_tl_rec.creation_date := l_okl_txl_ap_inv_lns_tl_rec.creation_date;
3767: END IF;
3768: IF (x_okl_txl_ap_inv_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
3769: THEN
3770: x_okl_txl_ap_inv_lns_tl_rec.last_updated_by := l_okl_txl_ap_inv_lns_tl_rec.last_updated_by;
3771: END IF;
3772: IF (x_okl_txl_ap_inv_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
3773: THEN
3774: x_okl_txl_ap_inv_lns_tl_rec.last_update_date := l_okl_txl_ap_inv_lns_tl_rec.last_update_date;

Line 3772: IF (x_okl_txl_ap_inv_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

3768: IF (x_okl_txl_ap_inv_lns_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
3769: THEN
3770: x_okl_txl_ap_inv_lns_tl_rec.last_updated_by := l_okl_txl_ap_inv_lns_tl_rec.last_updated_by;
3771: END IF;
3772: IF (x_okl_txl_ap_inv_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
3773: THEN
3774: x_okl_txl_ap_inv_lns_tl_rec.last_update_date := l_okl_txl_ap_inv_lns_tl_rec.last_update_date;
3775: END IF;
3776: IF (x_okl_txl_ap_inv_lns_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 3774: x_okl_txl_ap_inv_lns_tl_rec.last_update_date := l_okl_txl_ap_inv_lns_tl_rec.last_update_date;

3770: x_okl_txl_ap_inv_lns_tl_rec.last_updated_by := l_okl_txl_ap_inv_lns_tl_rec.last_updated_by;
3771: END IF;
3772: IF (x_okl_txl_ap_inv_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
3773: THEN
3774: x_okl_txl_ap_inv_lns_tl_rec.last_update_date := l_okl_txl_ap_inv_lns_tl_rec.last_update_date;
3775: END IF;
3776: IF (x_okl_txl_ap_inv_lns_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
3777: THEN
3778: x_okl_txl_ap_inv_lns_tl_rec.last_update_login := l_okl_txl_ap_inv_lns_tl_rec.last_update_login;

Line 3776: IF (x_okl_txl_ap_inv_lns_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

3772: IF (x_okl_txl_ap_inv_lns_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
3773: THEN
3774: x_okl_txl_ap_inv_lns_tl_rec.last_update_date := l_okl_txl_ap_inv_lns_tl_rec.last_update_date;
3775: END IF;
3776: IF (x_okl_txl_ap_inv_lns_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
3777: THEN
3778: x_okl_txl_ap_inv_lns_tl_rec.last_update_login := l_okl_txl_ap_inv_lns_tl_rec.last_update_login;
3779: END IF;
3780: RETURN(l_return_status);

Line 3778: x_okl_txl_ap_inv_lns_tl_rec.last_update_login := l_okl_txl_ap_inv_lns_tl_rec.last_update_login;

3774: x_okl_txl_ap_inv_lns_tl_rec.last_update_date := l_okl_txl_ap_inv_lns_tl_rec.last_update_date;
3775: END IF;
3776: IF (x_okl_txl_ap_inv_lns_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
3777: THEN
3778: x_okl_txl_ap_inv_lns_tl_rec.last_update_login := l_okl_txl_ap_inv_lns_tl_rec.last_update_login;
3779: END IF;
3780: RETURN(l_return_status);
3781: END populate_new_record;
3782: ----------------------------------------------

Line 3783: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --

3779: END IF;
3780: RETURN(l_return_status);
3781: END populate_new_record;
3782: ----------------------------------------------
3783: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --
3784: ----------------------------------------------
3785: FUNCTION Set_Attributes (
3786: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
3787: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type

Line 3786: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,

3782: ----------------------------------------------
3783: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --
3784: ----------------------------------------------
3785: FUNCTION Set_Attributes (
3786: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
3787: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
3788: ) RETURN VARCHAR2 IS
3789: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3790: BEGIN

Line 3787: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type

3783: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --
3784: ----------------------------------------------
3785: FUNCTION Set_Attributes (
3786: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
3787: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
3788: ) RETURN VARCHAR2 IS
3789: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3790: BEGIN
3791: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;

Line 3791: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;

3787: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
3788: ) RETURN VARCHAR2 IS
3789: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3790: BEGIN
3791: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;
3792: x_okl_txl_ap_inv_lns_tl_rec.LANGUAGE := USERENV('LANG');
3793: x_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
3794: RETURN(l_return_status);
3795: END Set_Attributes;

Line 3792: x_okl_txl_ap_inv_lns_tl_rec.LANGUAGE := USERENV('LANG');

3788: ) RETURN VARCHAR2 IS
3789: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3790: BEGIN
3791: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;
3792: x_okl_txl_ap_inv_lns_tl_rec.LANGUAGE := USERENV('LANG');
3793: x_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
3794: RETURN(l_return_status);
3795: END Set_Attributes;
3796: BEGIN

Line 3793: x_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG := USERENV('LANG');

3789: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3790: BEGIN
3791: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;
3792: x_okl_txl_ap_inv_lns_tl_rec.LANGUAGE := USERENV('LANG');
3793: x_okl_txl_ap_inv_lns_tl_rec.SOURCE_LANG := USERENV('LANG');
3794: RETURN(l_return_status);
3795: END Set_Attributes;
3796: BEGIN
3797: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 3808: p_okl_txl_ap_inv_lns_tl_rec, -- IN

3804: RAISE OKL_API.G_EXCEPTION_ERROR;
3805: END IF;
3806: --- Setting item attributes
3807: l_return_status := Set_Attributes(
3808: p_okl_txl_ap_inv_lns_tl_rec, -- IN
3809: l_okl_txl_ap_inv_lns_tl_rec); -- OUT
3810: --- If any errors happen abort API
3811: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3809: l_okl_txl_ap_inv_lns_tl_rec); -- OUT

3805: END IF;
3806: --- Setting item attributes
3807: l_return_status := Set_Attributes(
3808: p_okl_txl_ap_inv_lns_tl_rec, -- IN
3809: l_okl_txl_ap_inv_lns_tl_rec); -- OUT
3810: --- If any errors happen abort API
3811: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3813: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3816: l_return_status := populate_new_record(l_okl_txl_ap_inv_lns_tl_rec, ldefokltxlapinvlnstlrec);

3812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3813: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3814: RAISE OKL_API.G_EXCEPTION_ERROR;
3815: END IF;
3816: l_return_status := populate_new_record(l_okl_txl_ap_inv_lns_tl_rec, ldefokltxlapinvlnstlrec);
3817: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3819: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3820: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3822: UPDATE OKL_TXL_AP_INV_LNS_TL

3818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3819: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3820: RAISE OKL_API.G_EXCEPTION_ERROR;
3821: END IF;
3822: UPDATE OKL_TXL_AP_INV_LNS_TL
3823: SET DESCRIPTION = ldefokltxlapinvlnstlrec.description,
3824: SOURCE_LANG = ldefokltxlapinvlnstlrec.source_lang,
3825: CREATED_BY = ldefokltxlapinvlnstlrec.created_by,
3826: CREATION_DATE = ldefokltxlapinvlnstlrec.creation_date,

Line 3833: UPDATE OKL_TXL_AP_INV_LNS_TL

3829: LAST_UPDATE_LOGIN = ldefokltxlapinvlnstlrec.last_update_login
3830: WHERE ID = ldefokltxlapinvlnstlrec.id
3831: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
3832:
3833: UPDATE OKL_TXL_AP_INV_LNS_TL
3834: SET SFWT_FLAG = 'Y'
3835: WHERE ID = ldefokltxlapinvlnstlrec.id
3836: AND SOURCE_LANG <> USERENV('LANG');
3837:

Line 3838: x_okl_txl_ap_inv_lns_tl_rec := ldefokltxlapinvlnstlrec;

3834: SET SFWT_FLAG = 'Y'
3835: WHERE ID = ldefokltxlapinvlnstlrec.id
3836: AND SOURCE_LANG <> USERENV('LANG');
3837:
3838: x_okl_txl_ap_inv_lns_tl_rec := ldefokltxlapinvlnstlrec;
3839: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3840: EXCEPTION
3841: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3842: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 3889: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;

3885: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3886: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3887: l_tplv_rec tplv_rec_type := p_tplv_rec;
3888: l_def_tplv_rec tplv_rec_type;
3889: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
3890: lx_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
3891: l_tpl_rec tpl_rec_type;
3892: lx_tpl_rec tpl_rec_type;
3893: -------------------------------

Line 3890: lx_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;

3886: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3887: l_tplv_rec tplv_rec_type := p_tplv_rec;
3888: l_def_tplv_rec tplv_rec_type;
3889: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
3890: lx_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
3891: l_tpl_rec tpl_rec_type;
3892: lx_tpl_rec tpl_rec_type;
3893: -------------------------------
3894: -- FUNCTION fill_who_columns --

Line 4221: migrate(l_def_tplv_rec, l_okl_txl_ap_inv_lns_tl_rec);

4217:
4218: --------------------------------------
4219: -- Move VIEW record to "Child" records
4220: --------------------------------------
4221: migrate(l_def_tplv_rec, l_okl_txl_ap_inv_lns_tl_rec);
4222: migrate(l_def_tplv_rec, l_tpl_rec);
4223: --------------------------------------------
4224: -- Call the UPDATE_ROW for each child record
4225: --------------------------------------------

Line 4231: l_okl_txl_ap_inv_lns_tl_rec,

4227: p_init_msg_list,
4228: x_return_status,
4229: x_msg_count,
4230: x_msg_data,
4231: l_okl_txl_ap_inv_lns_tl_rec,
4232: lx_okl_txl_ap_inv_lns_tl_rec
4233: );
4234: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4232: lx_okl_txl_ap_inv_lns_tl_rec

4228: x_return_status,
4229: x_msg_count,
4230: x_msg_data,
4231: l_okl_txl_ap_inv_lns_tl_rec,
4232: lx_okl_txl_ap_inv_lns_tl_rec
4233: );
4234: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4236: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 4239: migrate(lx_okl_txl_ap_inv_lns_tl_rec, l_def_tplv_rec);

4235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4236: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4237: RAISE OKL_API.G_EXCEPTION_ERROR;
4238: END IF;
4239: migrate(lx_okl_txl_ap_inv_lns_tl_rec, l_def_tplv_rec);
4240: update_row(
4241: p_init_msg_list,
4242: x_return_status,
4243: x_msg_count,

Line 4432: -- delete_row for:OKL_TXL_AP_INV_LNS_TL --

4428: '_PVT'
4429: );
4430: END delete_row;
4431: ------------------------------------------
4432: -- delete_row for:OKL_TXL_AP_INV_LNS_TL --
4433: ------------------------------------------
4434: PROCEDURE delete_row(
4435: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4436: x_return_status OUT NOCOPY VARCHAR2,

Line 4439: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS

4435: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4436: x_return_status OUT NOCOPY VARCHAR2,
4437: x_msg_count OUT NOCOPY NUMBER,
4438: x_msg_data OUT NOCOPY VARCHAR2,
4439: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS
4440:
4441: l_api_version CONSTANT NUMBER := 1;
4442: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
4443: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 4444: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type:= p_okl_txl_ap_inv_lns_tl_rec;

4440:
4441: l_api_version CONSTANT NUMBER := 1;
4442: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
4443: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4444: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type:= p_okl_txl_ap_inv_lns_tl_rec;
4445: l_row_notfound BOOLEAN := TRUE;
4446: ----------------------------------------------
4447: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --
4448: ----------------------------------------------

Line 4447: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --

4443: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4444: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type:= p_okl_txl_ap_inv_lns_tl_rec;
4445: l_row_notfound BOOLEAN := TRUE;
4446: ----------------------------------------------
4447: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --
4448: ----------------------------------------------
4449: FUNCTION Set_Attributes (
4450: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
4451: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type

Line 4450: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,

4446: ----------------------------------------------
4447: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --
4448: ----------------------------------------------
4449: FUNCTION Set_Attributes (
4450: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
4451: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
4452: ) RETURN VARCHAR2 IS
4453: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4454: BEGIN

Line 4451: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type

4447: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_TL --
4448: ----------------------------------------------
4449: FUNCTION Set_Attributes (
4450: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,
4451: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
4452: ) RETURN VARCHAR2 IS
4453: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4454: BEGIN
4455: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;

Line 4455: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;

4451: x_okl_txl_ap_inv_lns_tl_rec OUT NOCOPY okl_txl_ap_inv_lns_tl_rec_type
4452: ) RETURN VARCHAR2 IS
4453: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4454: BEGIN
4455: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;
4456: x_okl_txl_ap_inv_lns_tl_rec.LANGUAGE := USERENV('LANG');
4457: RETURN(l_return_status);
4458: END Set_Attributes;
4459: BEGIN

Line 4456: x_okl_txl_ap_inv_lns_tl_rec.LANGUAGE := USERENV('LANG');

4452: ) RETURN VARCHAR2 IS
4453: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4454: BEGIN
4455: x_okl_txl_ap_inv_lns_tl_rec := p_okl_txl_ap_inv_lns_tl_rec;
4456: x_okl_txl_ap_inv_lns_tl_rec.LANGUAGE := USERENV('LANG');
4457: RETURN(l_return_status);
4458: END Set_Attributes;
4459: BEGIN
4460: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 4471: p_okl_txl_ap_inv_lns_tl_rec, -- IN

4467: RAISE OKL_API.G_EXCEPTION_ERROR;
4468: END IF;
4469: --- Setting item attributes
4470: l_return_status := Set_Attributes(
4471: p_okl_txl_ap_inv_lns_tl_rec, -- IN
4472: l_okl_txl_ap_inv_lns_tl_rec); -- OUT
4473: --- If any errors happen abort API
4474: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4472: l_okl_txl_ap_inv_lns_tl_rec); -- OUT

4468: END IF;
4469: --- Setting item attributes
4470: l_return_status := Set_Attributes(
4471: p_okl_txl_ap_inv_lns_tl_rec, -- IN
4472: l_okl_txl_ap_inv_lns_tl_rec); -- OUT
4473: --- If any errors happen abort API
4474: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4476: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 4479: DELETE FROM OKL_TXL_AP_INV_LNS_TL

4475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4476: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4477: RAISE OKL_API.G_EXCEPTION_ERROR;
4478: END IF;
4479: DELETE FROM OKL_TXL_AP_INV_LNS_TL
4480: WHERE ID = l_okl_txl_ap_inv_lns_tl_rec.id;
4481:
4482: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
4483: EXCEPTION

Line 4480: WHERE ID = l_okl_txl_ap_inv_lns_tl_rec.id;

4476: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4477: RAISE OKL_API.G_EXCEPTION_ERROR;
4478: END IF;
4479: DELETE FROM OKL_TXL_AP_INV_LNS_TL
4480: WHERE ID = l_okl_txl_ap_inv_lns_tl_rec.id;
4481:
4482: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
4483: EXCEPTION
4484: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 4530: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;

4526: l_api_version CONSTANT NUMBER := 1;
4527: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
4528: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4529: l_tplv_rec tplv_rec_type := p_tplv_rec;
4530: l_okl_txl_ap_inv_lns_tl_rec okl_txl_ap_inv_lns_tl_rec_type;
4531: l_tpl_rec tpl_rec_type;
4532: BEGIN
4533: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
4534: G_PKG_NAME,

Line 4548: migrate(l_tplv_rec, l_okl_txl_ap_inv_lns_tl_rec);

4544: END IF;
4545: --------------------------------------
4546: -- Move VIEW record to "Child" records
4547: --------------------------------------
4548: migrate(l_tplv_rec, l_okl_txl_ap_inv_lns_tl_rec);
4549: migrate(l_tplv_rec, l_tpl_rec);
4550: --------------------------------------------
4551: -- Call the DELETE_ROW for each child record
4552: --------------------------------------------

Line 4558: l_okl_txl_ap_inv_lns_tl_rec

4554: p_init_msg_list,
4555: x_return_status,
4556: x_msg_count,
4557: x_msg_data,
4558: l_okl_txl_ap_inv_lns_tl_rec
4559: );
4560: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4562: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN