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_TAI_PVT dependencies on OKL_TRX_AR_INVOICES_TL

Line 1060: DELETE FROM OKL_TRX_AR_INVOICES_TL T

1056: -- PROCEDURE add_language
1057: ---------------------------------------------------------------------------
1058: PROCEDURE add_language IS
1059: BEGIN
1060: DELETE FROM OKL_TRX_AR_INVOICES_TL T
1061: WHERE NOT EXISTS (
1062: SELECT NULL
1063: FROM OKL_TRX_AR_INVOICES_B B
1064: WHERE B.ID = T.ID

Line 1068: UPDATE OKL_TRX_AR_INVOICES_TL T SET (

1064: WHERE B.ID = T.ID
1065: AND T.LANGUAGE = USERENV('LANG')
1066: );
1067:
1068: UPDATE OKL_TRX_AR_INVOICES_TL T SET (
1069: DESCRIPTION) = (SELECT
1070: B.DESCRIPTION
1071: FROM OKL_TRX_AR_INVOICES_TL B
1072: WHERE B.ID = T.ID

Line 1071: FROM OKL_TRX_AR_INVOICES_TL B

1067:
1068: UPDATE OKL_TRX_AR_INVOICES_TL T SET (
1069: DESCRIPTION) = (SELECT
1070: B.DESCRIPTION
1071: FROM OKL_TRX_AR_INVOICES_TL B
1072: WHERE B.ID = T.ID
1073: AND B.LANGUAGE = T.SOURCE_LANG)
1074: WHERE (
1075: T.ID,

Line 1080: FROM OKL_TRX_AR_INVOICES_TL SUBB, OKL_TRX_AR_INVOICES_TL SUBT

1076: T.LANGUAGE)
1077: IN (SELECT
1078: SUBT.ID,
1079: SUBT.LANGUAGE
1080: FROM OKL_TRX_AR_INVOICES_TL SUBB, OKL_TRX_AR_INVOICES_TL SUBT
1081: WHERE SUBB.ID = SUBT.ID
1082: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1083: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1084: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 1088: INSERT INTO OKL_TRX_AR_INVOICES_TL (

1084: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
1085: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
1086: ));
1087:
1088: INSERT INTO OKL_TRX_AR_INVOICES_TL (
1089: ID,
1090: LANGUAGE,
1091: SOURCE_LANG,
1092: SFWT_FLAG,

Line 1110: FROM OKL_TRX_AR_INVOICES_TL B, FND_LANGUAGES L

1106: B.CREATION_DATE,
1107: B.LAST_UPDATED_BY,
1108: B.LAST_UPDATE_DATE,
1109: B.LAST_UPDATE_LOGIN
1110: FROM OKL_TRX_AR_INVOICES_TL B, FND_LANGUAGES L
1111: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1112: AND B.LANGUAGE = USERENV('LANG')
1113: AND NOT EXISTS(
1114: SELECT NULL

Line 1115: FROM OKL_TRX_AR_INVOICES_TL T

1111: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1112: AND B.LANGUAGE = USERENV('LANG')
1113: AND NOT EXISTS(
1114: SELECT NULL
1115: FROM OKL_TRX_AR_INVOICES_TL T
1116: WHERE T.ID = B.ID
1117: AND T.LANGUAGE = L.LANGUAGE_CODE
1118: );
1119:

Line 1312: -- FUNCTION get_rec for: OKL_TRX_AR_INVOICES_TL

1308: BEGIN
1309: RETURN(get_rec(p_tai_rec, l_row_notfound));
1310: END get_rec;
1311: ---------------------------------------------------------------------------
1312: -- FUNCTION get_rec for: OKL_TRX_AR_INVOICES_TL
1313: ---------------------------------------------------------------------------
1314: FUNCTION get_rec (
1315: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
1316: x_no_data_found OUT NOCOPY BOOLEAN

Line 1315: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,

1311: ---------------------------------------------------------------------------
1312: -- FUNCTION get_rec for: OKL_TRX_AR_INVOICES_TL
1313: ---------------------------------------------------------------------------
1314: FUNCTION get_rec (
1315: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
1316: x_no_data_found OUT NOCOPY BOOLEAN
1317: ) RETURN OklTrxArInvoicesTlRecType IS
1318: CURSOR okl_trx_ar_invoices_tl_pk_csr (p_id IN NUMBER,
1319: p_language IN VARCHAR2) IS

Line 1318: CURSOR okl_trx_ar_invoices_tl_pk_csr (p_id IN NUMBER,

1314: FUNCTION get_rec (
1315: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
1316: x_no_data_found OUT NOCOPY BOOLEAN
1317: ) RETURN OklTrxArInvoicesTlRecType IS
1318: CURSOR okl_trx_ar_invoices_tl_pk_csr (p_id IN NUMBER,
1319: p_language IN VARCHAR2) IS
1320: SELECT
1321: ID,
1322: LANGUAGE,

Line 1331: FROM Okl_Trx_Ar_Invoices_Tl

1327: CREATION_DATE,
1328: LAST_UPDATED_BY,
1329: LAST_UPDATE_DATE,
1330: LAST_UPDATE_LOGIN
1331: FROM Okl_Trx_Ar_Invoices_Tl
1332: WHERE okl_trx_ar_invoices_tl.id = p_id
1333: AND okl_trx_ar_invoices_tl.LANGUAGE = p_language;
1334: l_okl_trx_ar_invoices_tl_pk okl_trx_ar_invoices_tl_pk_csr%ROWTYPE;
1335: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;

Line 1332: WHERE okl_trx_ar_invoices_tl.id = p_id

1328: LAST_UPDATED_BY,
1329: LAST_UPDATE_DATE,
1330: LAST_UPDATE_LOGIN
1331: FROM Okl_Trx_Ar_Invoices_Tl
1332: WHERE okl_trx_ar_invoices_tl.id = p_id
1333: AND okl_trx_ar_invoices_tl.LANGUAGE = p_language;
1334: l_okl_trx_ar_invoices_tl_pk okl_trx_ar_invoices_tl_pk_csr%ROWTYPE;
1335: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
1336: BEGIN

Line 1333: AND okl_trx_ar_invoices_tl.LANGUAGE = p_language;

1329: LAST_UPDATE_DATE,
1330: LAST_UPDATE_LOGIN
1331: FROM Okl_Trx_Ar_Invoices_Tl
1332: WHERE okl_trx_ar_invoices_tl.id = p_id
1333: AND okl_trx_ar_invoices_tl.LANGUAGE = p_language;
1334: l_okl_trx_ar_invoices_tl_pk okl_trx_ar_invoices_tl_pk_csr%ROWTYPE;
1335: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
1336: BEGIN
1337: x_no_data_found := TRUE;

Line 1334: l_okl_trx_ar_invoices_tl_pk okl_trx_ar_invoices_tl_pk_csr%ROWTYPE;

1330: LAST_UPDATE_LOGIN
1331: FROM Okl_Trx_Ar_Invoices_Tl
1332: WHERE okl_trx_ar_invoices_tl.id = p_id
1333: AND okl_trx_ar_invoices_tl.LANGUAGE = p_language;
1334: l_okl_trx_ar_invoices_tl_pk okl_trx_ar_invoices_tl_pk_csr%ROWTYPE;
1335: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
1336: BEGIN
1337: x_no_data_found := TRUE;
1338: -- Get current database values

Line 1335: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;

1331: FROM Okl_Trx_Ar_Invoices_Tl
1332: WHERE okl_trx_ar_invoices_tl.id = p_id
1333: AND okl_trx_ar_invoices_tl.LANGUAGE = p_language;
1334: l_okl_trx_ar_invoices_tl_pk okl_trx_ar_invoices_tl_pk_csr%ROWTYPE;
1335: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
1336: BEGIN
1337: x_no_data_found := TRUE;
1338: -- Get current database values
1339: OPEN okl_trx_ar_invoices_tl_pk_csr (p_okl_trx_ar_invoices_tl_rec.id,

Line 1339: OPEN okl_trx_ar_invoices_tl_pk_csr (p_okl_trx_ar_invoices_tl_rec.id,

1335: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
1336: BEGIN
1337: x_no_data_found := TRUE;
1338: -- Get current database values
1339: OPEN okl_trx_ar_invoices_tl_pk_csr (p_okl_trx_ar_invoices_tl_rec.id,
1340: p_okl_trx_ar_invoices_tl_rec.LANGUAGE);
1341: FETCH okl_trx_ar_invoices_tl_pk_csr INTO
1342: l_okl_trx_ar_invoices_tl_rec.ID,
1343: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,

Line 1340: p_okl_trx_ar_invoices_tl_rec.LANGUAGE);

1336: BEGIN
1337: x_no_data_found := TRUE;
1338: -- Get current database values
1339: OPEN okl_trx_ar_invoices_tl_pk_csr (p_okl_trx_ar_invoices_tl_rec.id,
1340: p_okl_trx_ar_invoices_tl_rec.LANGUAGE);
1341: FETCH okl_trx_ar_invoices_tl_pk_csr INTO
1342: l_okl_trx_ar_invoices_tl_rec.ID,
1343: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
1344: l_okl_trx_ar_invoices_tl_rec.SOURCE_LANG,

Line 1341: FETCH okl_trx_ar_invoices_tl_pk_csr INTO

1337: x_no_data_found := TRUE;
1338: -- Get current database values
1339: OPEN okl_trx_ar_invoices_tl_pk_csr (p_okl_trx_ar_invoices_tl_rec.id,
1340: p_okl_trx_ar_invoices_tl_rec.LANGUAGE);
1341: FETCH okl_trx_ar_invoices_tl_pk_csr INTO
1342: l_okl_trx_ar_invoices_tl_rec.ID,
1343: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
1344: l_okl_trx_ar_invoices_tl_rec.SOURCE_LANG,
1345: l_okl_trx_ar_invoices_tl_rec.SFWT_FLAG,

Line 1342: l_okl_trx_ar_invoices_tl_rec.ID,

1338: -- Get current database values
1339: OPEN okl_trx_ar_invoices_tl_pk_csr (p_okl_trx_ar_invoices_tl_rec.id,
1340: p_okl_trx_ar_invoices_tl_rec.LANGUAGE);
1341: FETCH okl_trx_ar_invoices_tl_pk_csr INTO
1342: l_okl_trx_ar_invoices_tl_rec.ID,
1343: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
1344: l_okl_trx_ar_invoices_tl_rec.SOURCE_LANG,
1345: l_okl_trx_ar_invoices_tl_rec.SFWT_FLAG,
1346: l_okl_trx_ar_invoices_tl_rec.DESCRIPTION,

Line 1343: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,

1339: OPEN okl_trx_ar_invoices_tl_pk_csr (p_okl_trx_ar_invoices_tl_rec.id,
1340: p_okl_trx_ar_invoices_tl_rec.LANGUAGE);
1341: FETCH okl_trx_ar_invoices_tl_pk_csr INTO
1342: l_okl_trx_ar_invoices_tl_rec.ID,
1343: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
1344: l_okl_trx_ar_invoices_tl_rec.SOURCE_LANG,
1345: l_okl_trx_ar_invoices_tl_rec.SFWT_FLAG,
1346: l_okl_trx_ar_invoices_tl_rec.DESCRIPTION,
1347: l_okl_trx_ar_invoices_tl_rec.CREATED_BY,

Line 1344: l_okl_trx_ar_invoices_tl_rec.SOURCE_LANG,

1340: p_okl_trx_ar_invoices_tl_rec.LANGUAGE);
1341: FETCH okl_trx_ar_invoices_tl_pk_csr INTO
1342: l_okl_trx_ar_invoices_tl_rec.ID,
1343: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
1344: l_okl_trx_ar_invoices_tl_rec.SOURCE_LANG,
1345: l_okl_trx_ar_invoices_tl_rec.SFWT_FLAG,
1346: l_okl_trx_ar_invoices_tl_rec.DESCRIPTION,
1347: l_okl_trx_ar_invoices_tl_rec.CREATED_BY,
1348: l_okl_trx_ar_invoices_tl_rec.CREATION_DATE,

Line 1345: l_okl_trx_ar_invoices_tl_rec.SFWT_FLAG,

1341: FETCH okl_trx_ar_invoices_tl_pk_csr INTO
1342: l_okl_trx_ar_invoices_tl_rec.ID,
1343: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
1344: l_okl_trx_ar_invoices_tl_rec.SOURCE_LANG,
1345: l_okl_trx_ar_invoices_tl_rec.SFWT_FLAG,
1346: l_okl_trx_ar_invoices_tl_rec.DESCRIPTION,
1347: l_okl_trx_ar_invoices_tl_rec.CREATED_BY,
1348: l_okl_trx_ar_invoices_tl_rec.CREATION_DATE,
1349: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATED_BY,

Line 1346: l_okl_trx_ar_invoices_tl_rec.DESCRIPTION,

1342: l_okl_trx_ar_invoices_tl_rec.ID,
1343: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
1344: l_okl_trx_ar_invoices_tl_rec.SOURCE_LANG,
1345: l_okl_trx_ar_invoices_tl_rec.SFWT_FLAG,
1346: l_okl_trx_ar_invoices_tl_rec.DESCRIPTION,
1347: l_okl_trx_ar_invoices_tl_rec.CREATED_BY,
1348: l_okl_trx_ar_invoices_tl_rec.CREATION_DATE,
1349: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATED_BY,
1350: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_DATE,

Line 1347: l_okl_trx_ar_invoices_tl_rec.CREATED_BY,

1343: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
1344: l_okl_trx_ar_invoices_tl_rec.SOURCE_LANG,
1345: l_okl_trx_ar_invoices_tl_rec.SFWT_FLAG,
1346: l_okl_trx_ar_invoices_tl_rec.DESCRIPTION,
1347: l_okl_trx_ar_invoices_tl_rec.CREATED_BY,
1348: l_okl_trx_ar_invoices_tl_rec.CREATION_DATE,
1349: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATED_BY,
1350: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_DATE,
1351: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_LOGIN;

Line 1348: l_okl_trx_ar_invoices_tl_rec.CREATION_DATE,

1344: l_okl_trx_ar_invoices_tl_rec.SOURCE_LANG,
1345: l_okl_trx_ar_invoices_tl_rec.SFWT_FLAG,
1346: l_okl_trx_ar_invoices_tl_rec.DESCRIPTION,
1347: l_okl_trx_ar_invoices_tl_rec.CREATED_BY,
1348: l_okl_trx_ar_invoices_tl_rec.CREATION_DATE,
1349: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATED_BY,
1350: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_DATE,
1351: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_LOGIN;
1352: x_no_data_found := okl_trx_ar_invoices_tl_pk_csr%NOTFOUND;

Line 1349: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATED_BY,

1345: l_okl_trx_ar_invoices_tl_rec.SFWT_FLAG,
1346: l_okl_trx_ar_invoices_tl_rec.DESCRIPTION,
1347: l_okl_trx_ar_invoices_tl_rec.CREATED_BY,
1348: l_okl_trx_ar_invoices_tl_rec.CREATION_DATE,
1349: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATED_BY,
1350: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_DATE,
1351: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_LOGIN;
1352: x_no_data_found := okl_trx_ar_invoices_tl_pk_csr%NOTFOUND;
1353: CLOSE okl_trx_ar_invoices_tl_pk_csr;

Line 1350: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_DATE,

1346: l_okl_trx_ar_invoices_tl_rec.DESCRIPTION,
1347: l_okl_trx_ar_invoices_tl_rec.CREATED_BY,
1348: l_okl_trx_ar_invoices_tl_rec.CREATION_DATE,
1349: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATED_BY,
1350: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_DATE,
1351: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_LOGIN;
1352: x_no_data_found := okl_trx_ar_invoices_tl_pk_csr%NOTFOUND;
1353: CLOSE okl_trx_ar_invoices_tl_pk_csr;
1354: RETURN(l_okl_trx_ar_invoices_tl_rec);

Line 1351: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_LOGIN;

1347: l_okl_trx_ar_invoices_tl_rec.CREATED_BY,
1348: l_okl_trx_ar_invoices_tl_rec.CREATION_DATE,
1349: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATED_BY,
1350: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_DATE,
1351: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_LOGIN;
1352: x_no_data_found := okl_trx_ar_invoices_tl_pk_csr%NOTFOUND;
1353: CLOSE okl_trx_ar_invoices_tl_pk_csr;
1354: RETURN(l_okl_trx_ar_invoices_tl_rec);
1355: END get_rec;

Line 1352: x_no_data_found := okl_trx_ar_invoices_tl_pk_csr%NOTFOUND;

1348: l_okl_trx_ar_invoices_tl_rec.CREATION_DATE,
1349: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATED_BY,
1350: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_DATE,
1351: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_LOGIN;
1352: x_no_data_found := okl_trx_ar_invoices_tl_pk_csr%NOTFOUND;
1353: CLOSE okl_trx_ar_invoices_tl_pk_csr;
1354: RETURN(l_okl_trx_ar_invoices_tl_rec);
1355: END get_rec;
1356:

Line 1353: CLOSE okl_trx_ar_invoices_tl_pk_csr;

1349: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATED_BY,
1350: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_DATE,
1351: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_LOGIN;
1352: x_no_data_found := okl_trx_ar_invoices_tl_pk_csr%NOTFOUND;
1353: CLOSE okl_trx_ar_invoices_tl_pk_csr;
1354: RETURN(l_okl_trx_ar_invoices_tl_rec);
1355: END get_rec;
1356:
1357: FUNCTION get_rec (

Line 1354: RETURN(l_okl_trx_ar_invoices_tl_rec);

1350: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_DATE,
1351: l_okl_trx_ar_invoices_tl_rec.LAST_UPDATE_LOGIN;
1352: x_no_data_found := okl_trx_ar_invoices_tl_pk_csr%NOTFOUND;
1353: CLOSE okl_trx_ar_invoices_tl_pk_csr;
1354: RETURN(l_okl_trx_ar_invoices_tl_rec);
1355: END get_rec;
1356:
1357: FUNCTION get_rec (
1358: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType

Line 1358: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType

1354: RETURN(l_okl_trx_ar_invoices_tl_rec);
1355: END get_rec;
1356:
1357: FUNCTION get_rec (
1358: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType
1359: ) RETURN OklTrxArInvoicesTlRecType IS
1360: l_row_notfound BOOLEAN := TRUE;
1361: BEGIN
1362: RETURN(get_rec(p_okl_trx_ar_invoices_tl_rec, l_row_notfound));

Line 1362: RETURN(get_rec(p_okl_trx_ar_invoices_tl_rec, l_row_notfound));

1358: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType
1359: ) RETURN OklTrxArInvoicesTlRecType IS
1360: l_row_notfound BOOLEAN := TRUE;
1361: BEGIN
1362: RETURN(get_rec(p_okl_trx_ar_invoices_tl_rec, l_row_notfound));
1363: END get_rec;
1364: ---------------------------------------------------------------------------
1365: -- FUNCTION get_rec for: OKL_TRX_AR_INVOICES_V
1366: ---------------------------------------------------------------------------

Line 2450: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;

2446: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
2447: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2448: l_taiv_rec taiv_rec_type := p_taiv_rec;
2449: l_tai_rec tai_rec_type;
2450: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
2451: BEGIN
2452: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2453: G_PKG_NAME,
2454: p_init_msg_list,

Line 2864: -- insert_row for:OKL_TRX_AR_INVOICES_TL --

2860: );
2861: */
2862: END insert_row;
2863: -------------------------------------------
2864: -- insert_row for:OKL_TRX_AR_INVOICES_TL --
2865: -------------------------------------------
2866: PROCEDURE insert_row(
2867: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2868: x_return_status OUT NOCOPY VARCHAR2,

Line 2871: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,

2867: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2868: x_return_status OUT NOCOPY VARCHAR2,
2869: x_msg_count OUT NOCOPY NUMBER,
2870: x_msg_data OUT NOCOPY VARCHAR2,
2871: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
2872: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType) IS
2873:
2874: l_api_version CONSTANT NUMBER := 1;
2875: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 2872: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType) IS

2868: x_return_status OUT NOCOPY VARCHAR2,
2869: x_msg_count OUT NOCOPY NUMBER,
2870: x_msg_data OUT NOCOPY VARCHAR2,
2871: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
2872: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType) IS
2873:
2874: l_api_version CONSTANT NUMBER := 1;
2875: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2876: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2877: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType := p_okl_trx_ar_invoices_tl_rec;

2873:
2874: l_api_version CONSTANT NUMBER := 1;
2875: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2876: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2877: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType := p_okl_trx_ar_invoices_tl_rec;
2878: ldefokltrxarinvoicestlrec OklTrxArInvoicesTlRecType;
2879: CURSOR get_languages IS
2880: SELECT *
2881: FROM FND_LANGUAGES

Line 2884: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --

2880: SELECT *
2881: FROM FND_LANGUAGES
2882: WHERE INSTALLED_FLAG IN ('I', 'B');
2883: -----------------------------------------------
2884: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --
2885: -----------------------------------------------
2886: FUNCTION Set_Attributes (
2887: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
2888: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType

Line 2887: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,

2883: -----------------------------------------------
2884: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --
2885: -----------------------------------------------
2886: FUNCTION Set_Attributes (
2887: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
2888: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
2889: ) RETURN VARCHAR2 IS
2890: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2891: BEGIN

Line 2888: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType

2884: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --
2885: -----------------------------------------------
2886: FUNCTION Set_Attributes (
2887: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
2888: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
2889: ) RETURN VARCHAR2 IS
2890: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2891: BEGIN
2892: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;

Line 2892: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;

2888: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
2889: ) RETURN VARCHAR2 IS
2890: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2891: BEGIN
2892: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;
2893: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := USERENV('LANG');
2894: x_okl_trx_ar_invoices_tl_rec.SOURCE_LANG := USERENV('LANG');
2895: RETURN(l_return_status);
2896: END Set_Attributes;

Line 2893: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := USERENV('LANG');

2889: ) RETURN VARCHAR2 IS
2890: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2891: BEGIN
2892: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;
2893: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := USERENV('LANG');
2894: x_okl_trx_ar_invoices_tl_rec.SOURCE_LANG := USERENV('LANG');
2895: RETURN(l_return_status);
2896: END Set_Attributes;
2897: BEGIN

Line 2894: x_okl_trx_ar_invoices_tl_rec.SOURCE_LANG := USERENV('LANG');

2890: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2891: BEGIN
2892: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;
2893: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := USERENV('LANG');
2894: x_okl_trx_ar_invoices_tl_rec.SOURCE_LANG := USERENV('LANG');
2895: RETURN(l_return_status);
2896: END Set_Attributes;
2897: BEGIN
2898: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2909: p_okl_trx_ar_invoices_tl_rec, -- IN

2905: RAISE Okl_Api.G_EXCEPTION_ERROR;
2906: END IF;
2907: --- Setting item attributes
2908: l_return_status := Set_Attributes(
2909: p_okl_trx_ar_invoices_tl_rec, -- IN
2910: l_okl_trx_ar_invoices_tl_rec); -- OUT
2911: --- If any errors happen abort API
2912: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2913: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2910: l_okl_trx_ar_invoices_tl_rec); -- OUT

2906: END IF;
2907: --- Setting item attributes
2908: l_return_status := Set_Attributes(
2909: p_okl_trx_ar_invoices_tl_rec, -- IN
2910: l_okl_trx_ar_invoices_tl_rec); -- OUT
2911: --- If any errors happen abort API
2912: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2913: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2914: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 2918: l_okl_trx_ar_invoices_tl_rec.LANGUAGE := l_lang_rec.language_code;

2914: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2915: RAISE Okl_Api.G_EXCEPTION_ERROR;
2916: END IF;
2917: FOR l_lang_rec IN get_languages LOOP
2918: l_okl_trx_ar_invoices_tl_rec.LANGUAGE := l_lang_rec.language_code;
2919: INSERT INTO OKL_TRX_AR_INVOICES_TL(
2920: id,
2921: LANGUAGE,
2922: source_lang,

Line 2919: INSERT INTO OKL_TRX_AR_INVOICES_TL(

2915: RAISE Okl_Api.G_EXCEPTION_ERROR;
2916: END IF;
2917: FOR l_lang_rec IN get_languages LOOP
2918: l_okl_trx_ar_invoices_tl_rec.LANGUAGE := l_lang_rec.language_code;
2919: INSERT INTO OKL_TRX_AR_INVOICES_TL(
2920: id,
2921: LANGUAGE,
2922: source_lang,
2923: sfwt_flag,

Line 2931: l_okl_trx_ar_invoices_tl_rec.id,

2927: last_updated_by,
2928: last_update_date,
2929: last_update_login)
2930: VALUES (
2931: l_okl_trx_ar_invoices_tl_rec.id,
2932: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
2933: l_okl_trx_ar_invoices_tl_rec.source_lang,
2934: l_okl_trx_ar_invoices_tl_rec.sfwt_flag,
2935: l_okl_trx_ar_invoices_tl_rec.description,

Line 2932: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,

2928: last_update_date,
2929: last_update_login)
2930: VALUES (
2931: l_okl_trx_ar_invoices_tl_rec.id,
2932: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
2933: l_okl_trx_ar_invoices_tl_rec.source_lang,
2934: l_okl_trx_ar_invoices_tl_rec.sfwt_flag,
2935: l_okl_trx_ar_invoices_tl_rec.description,
2936: l_okl_trx_ar_invoices_tl_rec.created_by,

Line 2933: l_okl_trx_ar_invoices_tl_rec.source_lang,

2929: last_update_login)
2930: VALUES (
2931: l_okl_trx_ar_invoices_tl_rec.id,
2932: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
2933: l_okl_trx_ar_invoices_tl_rec.source_lang,
2934: l_okl_trx_ar_invoices_tl_rec.sfwt_flag,
2935: l_okl_trx_ar_invoices_tl_rec.description,
2936: l_okl_trx_ar_invoices_tl_rec.created_by,
2937: l_okl_trx_ar_invoices_tl_rec.creation_date,

Line 2934: l_okl_trx_ar_invoices_tl_rec.sfwt_flag,

2930: VALUES (
2931: l_okl_trx_ar_invoices_tl_rec.id,
2932: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
2933: l_okl_trx_ar_invoices_tl_rec.source_lang,
2934: l_okl_trx_ar_invoices_tl_rec.sfwt_flag,
2935: l_okl_trx_ar_invoices_tl_rec.description,
2936: l_okl_trx_ar_invoices_tl_rec.created_by,
2937: l_okl_trx_ar_invoices_tl_rec.creation_date,
2938: l_okl_trx_ar_invoices_tl_rec.last_updated_by,

Line 2935: l_okl_trx_ar_invoices_tl_rec.description,

2931: l_okl_trx_ar_invoices_tl_rec.id,
2932: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
2933: l_okl_trx_ar_invoices_tl_rec.source_lang,
2934: l_okl_trx_ar_invoices_tl_rec.sfwt_flag,
2935: l_okl_trx_ar_invoices_tl_rec.description,
2936: l_okl_trx_ar_invoices_tl_rec.created_by,
2937: l_okl_trx_ar_invoices_tl_rec.creation_date,
2938: l_okl_trx_ar_invoices_tl_rec.last_updated_by,
2939: l_okl_trx_ar_invoices_tl_rec.last_update_date,

Line 2936: l_okl_trx_ar_invoices_tl_rec.created_by,

2932: l_okl_trx_ar_invoices_tl_rec.LANGUAGE,
2933: l_okl_trx_ar_invoices_tl_rec.source_lang,
2934: l_okl_trx_ar_invoices_tl_rec.sfwt_flag,
2935: l_okl_trx_ar_invoices_tl_rec.description,
2936: l_okl_trx_ar_invoices_tl_rec.created_by,
2937: l_okl_trx_ar_invoices_tl_rec.creation_date,
2938: l_okl_trx_ar_invoices_tl_rec.last_updated_by,
2939: l_okl_trx_ar_invoices_tl_rec.last_update_date,
2940: l_okl_trx_ar_invoices_tl_rec.last_update_login);

Line 2937: l_okl_trx_ar_invoices_tl_rec.creation_date,

2933: l_okl_trx_ar_invoices_tl_rec.source_lang,
2934: l_okl_trx_ar_invoices_tl_rec.sfwt_flag,
2935: l_okl_trx_ar_invoices_tl_rec.description,
2936: l_okl_trx_ar_invoices_tl_rec.created_by,
2937: l_okl_trx_ar_invoices_tl_rec.creation_date,
2938: l_okl_trx_ar_invoices_tl_rec.last_updated_by,
2939: l_okl_trx_ar_invoices_tl_rec.last_update_date,
2940: l_okl_trx_ar_invoices_tl_rec.last_update_login);
2941: END LOOP;

Line 2938: l_okl_trx_ar_invoices_tl_rec.last_updated_by,

2934: l_okl_trx_ar_invoices_tl_rec.sfwt_flag,
2935: l_okl_trx_ar_invoices_tl_rec.description,
2936: l_okl_trx_ar_invoices_tl_rec.created_by,
2937: l_okl_trx_ar_invoices_tl_rec.creation_date,
2938: l_okl_trx_ar_invoices_tl_rec.last_updated_by,
2939: l_okl_trx_ar_invoices_tl_rec.last_update_date,
2940: l_okl_trx_ar_invoices_tl_rec.last_update_login);
2941: END LOOP;
2942: -- Set OUT values

Line 2939: l_okl_trx_ar_invoices_tl_rec.last_update_date,

2935: l_okl_trx_ar_invoices_tl_rec.description,
2936: l_okl_trx_ar_invoices_tl_rec.created_by,
2937: l_okl_trx_ar_invoices_tl_rec.creation_date,
2938: l_okl_trx_ar_invoices_tl_rec.last_updated_by,
2939: l_okl_trx_ar_invoices_tl_rec.last_update_date,
2940: l_okl_trx_ar_invoices_tl_rec.last_update_login);
2941: END LOOP;
2942: -- Set OUT values
2943: x_okl_trx_ar_invoices_tl_rec := l_okl_trx_ar_invoices_tl_rec;

Line 2940: l_okl_trx_ar_invoices_tl_rec.last_update_login);

2936: l_okl_trx_ar_invoices_tl_rec.created_by,
2937: l_okl_trx_ar_invoices_tl_rec.creation_date,
2938: l_okl_trx_ar_invoices_tl_rec.last_updated_by,
2939: l_okl_trx_ar_invoices_tl_rec.last_update_date,
2940: l_okl_trx_ar_invoices_tl_rec.last_update_login);
2941: END LOOP;
2942: -- Set OUT values
2943: x_okl_trx_ar_invoices_tl_rec := l_okl_trx_ar_invoices_tl_rec;
2944: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2943: x_okl_trx_ar_invoices_tl_rec := l_okl_trx_ar_invoices_tl_rec;

2939: l_okl_trx_ar_invoices_tl_rec.last_update_date,
2940: l_okl_trx_ar_invoices_tl_rec.last_update_login);
2941: END LOOP;
2942: -- Set OUT values
2943: x_okl_trx_ar_invoices_tl_rec := l_okl_trx_ar_invoices_tl_rec;
2944: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2945: EXCEPTION
2946: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2947: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 2996: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;

2992: l_taiv_rec taiv_rec_type;
2993: l_def_taiv_rec taiv_rec_type;
2994: l_tai_rec tai_rec_type;
2995: lx_tai_rec tai_rec_type;
2996: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
2997: lx_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
2998: l_legal_entity_id OKL_TRX_AR_INVOICES_V.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
2999: -------------------------------
3000: -- FUNCTION fill_who_columns --

Line 2997: lx_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;

2993: l_def_taiv_rec taiv_rec_type;
2994: l_tai_rec tai_rec_type;
2995: lx_tai_rec tai_rec_type;
2996: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
2997: lx_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
2998: l_legal_entity_id OKL_TRX_AR_INVOICES_V.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
2999: -------------------------------
3000: -- FUNCTION fill_who_columns --
3001: -------------------------------

Line 3120: migrate(l_def_taiv_rec, l_okl_trx_ar_invoices_tl_rec);

3116: --------------------------------------
3117: -- Move VIEW record to "Child" records
3118: --------------------------------------
3119: migrate(l_def_taiv_rec, l_tai_rec);
3120: migrate(l_def_taiv_rec, l_okl_trx_ar_invoices_tl_rec);
3121: --------------------------------------------
3122: -- Call the INSERT_ROW for each child record
3123: --------------------------------------------
3124: insert_row(

Line 3143: l_okl_trx_ar_invoices_tl_rec,

3139: p_init_msg_list,
3140: x_return_status,
3141: x_msg_count,
3142: x_msg_data,
3143: l_okl_trx_ar_invoices_tl_rec,
3144: lx_okl_trx_ar_invoices_tl_rec
3145: );
3146: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3147: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3144: lx_okl_trx_ar_invoices_tl_rec

3140: x_return_status,
3141: x_msg_count,
3142: x_msg_data,
3143: l_okl_trx_ar_invoices_tl_rec,
3144: lx_okl_trx_ar_invoices_tl_rec
3145: );
3146: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3147: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3148: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3151: migrate(lx_okl_trx_ar_invoices_tl_rec, l_def_taiv_rec);

3147: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3148: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3149: RAISE Okl_Api.G_EXCEPTION_ERROR;
3150: END IF;
3151: migrate(lx_okl_trx_ar_invoices_tl_rec, l_def_taiv_rec);
3152: -- Set OUT values
3153: x_taiv_rec := l_def_taiv_rec;
3154: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3155: EXCEPTION

Line 3390: -- lock_row for:OKL_TRX_AR_INVOICES_TL --

3386: '_PVT'
3387: );
3388: END lock_row;
3389: -----------------------------------------
3390: -- lock_row for:OKL_TRX_AR_INVOICES_TL --
3391: -----------------------------------------
3392: PROCEDURE lock_row(
3393: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
3394: x_return_status OUT NOCOPY VARCHAR2,

Line 3397: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType) IS

3393: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
3394: x_return_status OUT NOCOPY VARCHAR2,
3395: x_msg_count OUT NOCOPY NUMBER,
3396: x_msg_data OUT NOCOPY VARCHAR2,
3397: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType) IS
3398:
3399: E_Resource_Busy EXCEPTION;
3400: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3401: CURSOR lock_csr (p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType) IS

Line 3401: CURSOR lock_csr (p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType) IS

3397: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType) IS
3398:
3399: E_Resource_Busy EXCEPTION;
3400: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3401: CURSOR lock_csr (p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType) IS
3402: SELECT *
3403: FROM OKL_TRX_AR_INVOICES_TL
3404: WHERE ID = p_okl_trx_ar_invoices_tl_rec.id
3405: FOR UPDATE NOWAIT;

Line 3403: FROM OKL_TRX_AR_INVOICES_TL

3399: E_Resource_Busy EXCEPTION;
3400: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3401: CURSOR lock_csr (p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType) IS
3402: SELECT *
3403: FROM OKL_TRX_AR_INVOICES_TL
3404: WHERE ID = p_okl_trx_ar_invoices_tl_rec.id
3405: FOR UPDATE NOWAIT;
3406:
3407: l_api_version CONSTANT NUMBER := 1;

Line 3404: WHERE ID = p_okl_trx_ar_invoices_tl_rec.id

3400: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3401: CURSOR lock_csr (p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType) IS
3402: SELECT *
3403: FROM OKL_TRX_AR_INVOICES_TL
3404: WHERE ID = p_okl_trx_ar_invoices_tl_rec.id
3405: FOR UPDATE NOWAIT;
3406:
3407: l_api_version CONSTANT NUMBER := 1;
3408: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 3424: OPEN lock_csr(p_okl_trx_ar_invoices_tl_rec);

3420: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3421: RAISE Okl_Api.G_EXCEPTION_ERROR;
3422: END IF;
3423: BEGIN
3424: OPEN lock_csr(p_okl_trx_ar_invoices_tl_rec);
3425: FETCH lock_csr INTO l_lock_var;
3426: l_row_notfound := lock_csr%NOTFOUND;
3427: CLOSE lock_csr;
3428: EXCEPTION

Line 3489: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;

3485: l_api_version CONSTANT NUMBER := 1;
3486: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
3487: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3488: l_tai_rec tai_rec_type;
3489: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
3490: BEGIN
3491: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
3492: G_PKG_NAME,
3493: p_init_msg_list,

Line 3507: migrate(p_taiv_rec, l_okl_trx_ar_invoices_tl_rec);

3503: --------------------------------------
3504: -- Move VIEW record to "Child" records
3505: --------------------------------------
3506: migrate(p_taiv_rec, l_tai_rec);
3507: migrate(p_taiv_rec, l_okl_trx_ar_invoices_tl_rec);
3508: --------------------------------------------
3509: -- Call the LOCK_ROW for each child record
3510: --------------------------------------------
3511: lock_row(

Line 3528: l_okl_trx_ar_invoices_tl_rec

3524: p_init_msg_list,
3525: x_return_status,
3526: x_msg_count,
3527: x_msg_data,
3528: l_okl_trx_ar_invoices_tl_rec
3529: );
3530: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3531: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3532: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 4176: -- update_row for:OKL_TRX_AR_INVOICES_TL --

4172: '_PVT'
4173: );
4174: END update_row;
4175: -------------------------------------------
4176: -- update_row for:OKL_TRX_AR_INVOICES_TL --
4177: -------------------------------------------
4178: PROCEDURE update_row(
4179: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
4180: x_return_status OUT NOCOPY VARCHAR2,

Line 4183: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,

4179: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
4180: x_return_status OUT NOCOPY VARCHAR2,
4181: x_msg_count OUT NOCOPY NUMBER,
4182: x_msg_data OUT NOCOPY VARCHAR2,
4183: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
4184: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType) IS
4185:
4186: l_api_version CONSTANT NUMBER := 1;
4187: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 4184: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType) IS

4180: x_return_status OUT NOCOPY VARCHAR2,
4181: x_msg_count OUT NOCOPY NUMBER,
4182: x_msg_data OUT NOCOPY VARCHAR2,
4183: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
4184: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType) IS
4185:
4186: l_api_version CONSTANT NUMBER := 1;
4187: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4188: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 4189: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType := p_okl_trx_ar_invoices_tl_rec;

4185:
4186: l_api_version CONSTANT NUMBER := 1;
4187: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4188: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4189: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType := p_okl_trx_ar_invoices_tl_rec;
4190: ldefokltrxarinvoicestlrec OklTrxArInvoicesTlRecType;
4191: l_row_notfound BOOLEAN := TRUE;
4192: ----------------------------------
4193: -- FUNCTION populate_new_record --

Line 4196: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,

4192: ----------------------------------
4193: -- FUNCTION populate_new_record --
4194: ----------------------------------
4195: FUNCTION populate_new_record (
4196: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
4197: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
4198: ) RETURN VARCHAR2 IS
4199: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
4200: l_row_notfound BOOLEAN := TRUE;

Line 4197: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType

4193: -- FUNCTION populate_new_record --
4194: ----------------------------------
4195: FUNCTION populate_new_record (
4196: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
4197: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
4198: ) RETURN VARCHAR2 IS
4199: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
4200: l_row_notfound BOOLEAN := TRUE;
4201: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 4199: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;

4195: FUNCTION populate_new_record (
4196: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
4197: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
4198: ) RETURN VARCHAR2 IS
4199: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
4200: l_row_notfound BOOLEAN := TRUE;
4201: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4202: BEGIN
4203: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;

Line 4203: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;

4199: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
4200: l_row_notfound BOOLEAN := TRUE;
4201: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4202: BEGIN
4203: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;
4204: -- Get current database values
4205: l_okl_trx_ar_invoices_tl_rec := get_rec(p_okl_trx_ar_invoices_tl_rec, l_row_notfound);
4206: IF (l_row_notfound) THEN
4207: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 4205: l_okl_trx_ar_invoices_tl_rec := get_rec(p_okl_trx_ar_invoices_tl_rec, l_row_notfound);

4201: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4202: BEGIN
4203: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;
4204: -- Get current database values
4205: l_okl_trx_ar_invoices_tl_rec := get_rec(p_okl_trx_ar_invoices_tl_rec, l_row_notfound);
4206: IF (l_row_notfound) THEN
4207: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
4208: END IF;
4209: IF (x_okl_trx_ar_invoices_tl_rec.id = Okl_Api.G_MISS_NUM)

Line 4209: IF (x_okl_trx_ar_invoices_tl_rec.id = Okl_Api.G_MISS_NUM)

4205: l_okl_trx_ar_invoices_tl_rec := get_rec(p_okl_trx_ar_invoices_tl_rec, l_row_notfound);
4206: IF (l_row_notfound) THEN
4207: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
4208: END IF;
4209: IF (x_okl_trx_ar_invoices_tl_rec.id = Okl_Api.G_MISS_NUM)
4210: THEN
4211: x_okl_trx_ar_invoices_tl_rec.id := l_okl_trx_ar_invoices_tl_rec.id;
4212: END IF;
4213: IF (x_okl_trx_ar_invoices_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

Line 4211: x_okl_trx_ar_invoices_tl_rec.id := l_okl_trx_ar_invoices_tl_rec.id;

4207: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
4208: END IF;
4209: IF (x_okl_trx_ar_invoices_tl_rec.id = Okl_Api.G_MISS_NUM)
4210: THEN
4211: x_okl_trx_ar_invoices_tl_rec.id := l_okl_trx_ar_invoices_tl_rec.id;
4212: END IF;
4213: IF (x_okl_trx_ar_invoices_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
4214: THEN
4215: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := l_okl_trx_ar_invoices_tl_rec.LANGUAGE;

Line 4213: IF (x_okl_trx_ar_invoices_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)

4209: IF (x_okl_trx_ar_invoices_tl_rec.id = Okl_Api.G_MISS_NUM)
4210: THEN
4211: x_okl_trx_ar_invoices_tl_rec.id := l_okl_trx_ar_invoices_tl_rec.id;
4212: END IF;
4213: IF (x_okl_trx_ar_invoices_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
4214: THEN
4215: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := l_okl_trx_ar_invoices_tl_rec.LANGUAGE;
4216: END IF;
4217: IF (x_okl_trx_ar_invoices_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

Line 4215: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := l_okl_trx_ar_invoices_tl_rec.LANGUAGE;

4211: x_okl_trx_ar_invoices_tl_rec.id := l_okl_trx_ar_invoices_tl_rec.id;
4212: END IF;
4213: IF (x_okl_trx_ar_invoices_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
4214: THEN
4215: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := l_okl_trx_ar_invoices_tl_rec.LANGUAGE;
4216: END IF;
4217: IF (x_okl_trx_ar_invoices_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
4218: THEN
4219: x_okl_trx_ar_invoices_tl_rec.source_lang := l_okl_trx_ar_invoices_tl_rec.source_lang;

Line 4217: IF (x_okl_trx_ar_invoices_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)

4213: IF (x_okl_trx_ar_invoices_tl_rec.LANGUAGE = Okl_Api.G_MISS_CHAR)
4214: THEN
4215: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := l_okl_trx_ar_invoices_tl_rec.LANGUAGE;
4216: END IF;
4217: IF (x_okl_trx_ar_invoices_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
4218: THEN
4219: x_okl_trx_ar_invoices_tl_rec.source_lang := l_okl_trx_ar_invoices_tl_rec.source_lang;
4220: END IF;
4221: IF (x_okl_trx_ar_invoices_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

Line 4219: x_okl_trx_ar_invoices_tl_rec.source_lang := l_okl_trx_ar_invoices_tl_rec.source_lang;

4215: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := l_okl_trx_ar_invoices_tl_rec.LANGUAGE;
4216: END IF;
4217: IF (x_okl_trx_ar_invoices_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
4218: THEN
4219: x_okl_trx_ar_invoices_tl_rec.source_lang := l_okl_trx_ar_invoices_tl_rec.source_lang;
4220: END IF;
4221: IF (x_okl_trx_ar_invoices_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
4222: THEN
4223: x_okl_trx_ar_invoices_tl_rec.sfwt_flag := l_okl_trx_ar_invoices_tl_rec.sfwt_flag;

Line 4221: IF (x_okl_trx_ar_invoices_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)

4217: IF (x_okl_trx_ar_invoices_tl_rec.source_lang = Okl_Api.G_MISS_CHAR)
4218: THEN
4219: x_okl_trx_ar_invoices_tl_rec.source_lang := l_okl_trx_ar_invoices_tl_rec.source_lang;
4220: END IF;
4221: IF (x_okl_trx_ar_invoices_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
4222: THEN
4223: x_okl_trx_ar_invoices_tl_rec.sfwt_flag := l_okl_trx_ar_invoices_tl_rec.sfwt_flag;
4224: END IF;
4225: IF (x_okl_trx_ar_invoices_tl_rec.description = Okl_Api.G_MISS_CHAR)

Line 4223: x_okl_trx_ar_invoices_tl_rec.sfwt_flag := l_okl_trx_ar_invoices_tl_rec.sfwt_flag;

4219: x_okl_trx_ar_invoices_tl_rec.source_lang := l_okl_trx_ar_invoices_tl_rec.source_lang;
4220: END IF;
4221: IF (x_okl_trx_ar_invoices_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
4222: THEN
4223: x_okl_trx_ar_invoices_tl_rec.sfwt_flag := l_okl_trx_ar_invoices_tl_rec.sfwt_flag;
4224: END IF;
4225: IF (x_okl_trx_ar_invoices_tl_rec.description = Okl_Api.G_MISS_CHAR)
4226: THEN
4227: x_okl_trx_ar_invoices_tl_rec.description := l_okl_trx_ar_invoices_tl_rec.description;

Line 4225: IF (x_okl_trx_ar_invoices_tl_rec.description = Okl_Api.G_MISS_CHAR)

4221: IF (x_okl_trx_ar_invoices_tl_rec.sfwt_flag = Okl_Api.G_MISS_CHAR)
4222: THEN
4223: x_okl_trx_ar_invoices_tl_rec.sfwt_flag := l_okl_trx_ar_invoices_tl_rec.sfwt_flag;
4224: END IF;
4225: IF (x_okl_trx_ar_invoices_tl_rec.description = Okl_Api.G_MISS_CHAR)
4226: THEN
4227: x_okl_trx_ar_invoices_tl_rec.description := l_okl_trx_ar_invoices_tl_rec.description;
4228: END IF;
4229: IF (x_okl_trx_ar_invoices_tl_rec.created_by = Okl_Api.G_MISS_NUM)

Line 4227: x_okl_trx_ar_invoices_tl_rec.description := l_okl_trx_ar_invoices_tl_rec.description;

4223: x_okl_trx_ar_invoices_tl_rec.sfwt_flag := l_okl_trx_ar_invoices_tl_rec.sfwt_flag;
4224: END IF;
4225: IF (x_okl_trx_ar_invoices_tl_rec.description = Okl_Api.G_MISS_CHAR)
4226: THEN
4227: x_okl_trx_ar_invoices_tl_rec.description := l_okl_trx_ar_invoices_tl_rec.description;
4228: END IF;
4229: IF (x_okl_trx_ar_invoices_tl_rec.created_by = Okl_Api.G_MISS_NUM)
4230: THEN
4231: x_okl_trx_ar_invoices_tl_rec.created_by := l_okl_trx_ar_invoices_tl_rec.created_by;

Line 4229: IF (x_okl_trx_ar_invoices_tl_rec.created_by = Okl_Api.G_MISS_NUM)

4225: IF (x_okl_trx_ar_invoices_tl_rec.description = Okl_Api.G_MISS_CHAR)
4226: THEN
4227: x_okl_trx_ar_invoices_tl_rec.description := l_okl_trx_ar_invoices_tl_rec.description;
4228: END IF;
4229: IF (x_okl_trx_ar_invoices_tl_rec.created_by = Okl_Api.G_MISS_NUM)
4230: THEN
4231: x_okl_trx_ar_invoices_tl_rec.created_by := l_okl_trx_ar_invoices_tl_rec.created_by;
4232: END IF;
4233: IF (x_okl_trx_ar_invoices_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 4231: x_okl_trx_ar_invoices_tl_rec.created_by := l_okl_trx_ar_invoices_tl_rec.created_by;

4227: x_okl_trx_ar_invoices_tl_rec.description := l_okl_trx_ar_invoices_tl_rec.description;
4228: END IF;
4229: IF (x_okl_trx_ar_invoices_tl_rec.created_by = Okl_Api.G_MISS_NUM)
4230: THEN
4231: x_okl_trx_ar_invoices_tl_rec.created_by := l_okl_trx_ar_invoices_tl_rec.created_by;
4232: END IF;
4233: IF (x_okl_trx_ar_invoices_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
4234: THEN
4235: x_okl_trx_ar_invoices_tl_rec.creation_date := l_okl_trx_ar_invoices_tl_rec.creation_date;

Line 4233: IF (x_okl_trx_ar_invoices_tl_rec.creation_date = Okl_Api.G_MISS_DATE)

4229: IF (x_okl_trx_ar_invoices_tl_rec.created_by = Okl_Api.G_MISS_NUM)
4230: THEN
4231: x_okl_trx_ar_invoices_tl_rec.created_by := l_okl_trx_ar_invoices_tl_rec.created_by;
4232: END IF;
4233: IF (x_okl_trx_ar_invoices_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
4234: THEN
4235: x_okl_trx_ar_invoices_tl_rec.creation_date := l_okl_trx_ar_invoices_tl_rec.creation_date;
4236: END IF;
4237: IF (x_okl_trx_ar_invoices_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 4235: x_okl_trx_ar_invoices_tl_rec.creation_date := l_okl_trx_ar_invoices_tl_rec.creation_date;

4231: x_okl_trx_ar_invoices_tl_rec.created_by := l_okl_trx_ar_invoices_tl_rec.created_by;
4232: END IF;
4233: IF (x_okl_trx_ar_invoices_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
4234: THEN
4235: x_okl_trx_ar_invoices_tl_rec.creation_date := l_okl_trx_ar_invoices_tl_rec.creation_date;
4236: END IF;
4237: IF (x_okl_trx_ar_invoices_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
4238: THEN
4239: x_okl_trx_ar_invoices_tl_rec.last_updated_by := l_okl_trx_ar_invoices_tl_rec.last_updated_by;

Line 4237: IF (x_okl_trx_ar_invoices_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)

4233: IF (x_okl_trx_ar_invoices_tl_rec.creation_date = Okl_Api.G_MISS_DATE)
4234: THEN
4235: x_okl_trx_ar_invoices_tl_rec.creation_date := l_okl_trx_ar_invoices_tl_rec.creation_date;
4236: END IF;
4237: IF (x_okl_trx_ar_invoices_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
4238: THEN
4239: x_okl_trx_ar_invoices_tl_rec.last_updated_by := l_okl_trx_ar_invoices_tl_rec.last_updated_by;
4240: END IF;
4241: IF (x_okl_trx_ar_invoices_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 4239: x_okl_trx_ar_invoices_tl_rec.last_updated_by := l_okl_trx_ar_invoices_tl_rec.last_updated_by;

4235: x_okl_trx_ar_invoices_tl_rec.creation_date := l_okl_trx_ar_invoices_tl_rec.creation_date;
4236: END IF;
4237: IF (x_okl_trx_ar_invoices_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
4238: THEN
4239: x_okl_trx_ar_invoices_tl_rec.last_updated_by := l_okl_trx_ar_invoices_tl_rec.last_updated_by;
4240: END IF;
4241: IF (x_okl_trx_ar_invoices_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
4242: THEN
4243: x_okl_trx_ar_invoices_tl_rec.last_update_date := l_okl_trx_ar_invoices_tl_rec.last_update_date;

Line 4241: IF (x_okl_trx_ar_invoices_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)

4237: IF (x_okl_trx_ar_invoices_tl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
4238: THEN
4239: x_okl_trx_ar_invoices_tl_rec.last_updated_by := l_okl_trx_ar_invoices_tl_rec.last_updated_by;
4240: END IF;
4241: IF (x_okl_trx_ar_invoices_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
4242: THEN
4243: x_okl_trx_ar_invoices_tl_rec.last_update_date := l_okl_trx_ar_invoices_tl_rec.last_update_date;
4244: END IF;
4245: IF (x_okl_trx_ar_invoices_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 4243: x_okl_trx_ar_invoices_tl_rec.last_update_date := l_okl_trx_ar_invoices_tl_rec.last_update_date;

4239: x_okl_trx_ar_invoices_tl_rec.last_updated_by := l_okl_trx_ar_invoices_tl_rec.last_updated_by;
4240: END IF;
4241: IF (x_okl_trx_ar_invoices_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
4242: THEN
4243: x_okl_trx_ar_invoices_tl_rec.last_update_date := l_okl_trx_ar_invoices_tl_rec.last_update_date;
4244: END IF;
4245: IF (x_okl_trx_ar_invoices_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
4246: THEN
4247: x_okl_trx_ar_invoices_tl_rec.last_update_login := l_okl_trx_ar_invoices_tl_rec.last_update_login;

Line 4245: IF (x_okl_trx_ar_invoices_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)

4241: IF (x_okl_trx_ar_invoices_tl_rec.last_update_date = Okl_Api.G_MISS_DATE)
4242: THEN
4243: x_okl_trx_ar_invoices_tl_rec.last_update_date := l_okl_trx_ar_invoices_tl_rec.last_update_date;
4244: END IF;
4245: IF (x_okl_trx_ar_invoices_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
4246: THEN
4247: x_okl_trx_ar_invoices_tl_rec.last_update_login := l_okl_trx_ar_invoices_tl_rec.last_update_login;
4248: END IF;
4249: RETURN(l_return_status);

Line 4247: x_okl_trx_ar_invoices_tl_rec.last_update_login := l_okl_trx_ar_invoices_tl_rec.last_update_login;

4243: x_okl_trx_ar_invoices_tl_rec.last_update_date := l_okl_trx_ar_invoices_tl_rec.last_update_date;
4244: END IF;
4245: IF (x_okl_trx_ar_invoices_tl_rec.last_update_login = Okl_Api.G_MISS_NUM)
4246: THEN
4247: x_okl_trx_ar_invoices_tl_rec.last_update_login := l_okl_trx_ar_invoices_tl_rec.last_update_login;
4248: END IF;
4249: RETURN(l_return_status);
4250: END populate_new_record;
4251: -----------------------------------------------

Line 4252: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --

4248: END IF;
4249: RETURN(l_return_status);
4250: END populate_new_record;
4251: -----------------------------------------------
4252: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --
4253: -----------------------------------------------
4254: FUNCTION Set_Attributes (
4255: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
4256: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType

Line 4255: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,

4251: -----------------------------------------------
4252: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --
4253: -----------------------------------------------
4254: FUNCTION Set_Attributes (
4255: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
4256: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
4257: ) RETURN VARCHAR2 IS
4258: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4259: BEGIN

Line 4256: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType

4252: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --
4253: -----------------------------------------------
4254: FUNCTION Set_Attributes (
4255: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
4256: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
4257: ) RETURN VARCHAR2 IS
4258: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4259: BEGIN
4260: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;

Line 4260: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;

4256: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
4257: ) RETURN VARCHAR2 IS
4258: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4259: BEGIN
4260: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;
4261: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := USERENV('LANG');
4262: x_okl_trx_ar_invoices_tl_rec.SOURCE_LANG := USERENV('LANG');
4263: RETURN(l_return_status);
4264: END Set_Attributes;

Line 4261: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := USERENV('LANG');

4257: ) RETURN VARCHAR2 IS
4258: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4259: BEGIN
4260: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;
4261: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := USERENV('LANG');
4262: x_okl_trx_ar_invoices_tl_rec.SOURCE_LANG := USERENV('LANG');
4263: RETURN(l_return_status);
4264: END Set_Attributes;
4265: BEGIN

Line 4262: x_okl_trx_ar_invoices_tl_rec.SOURCE_LANG := USERENV('LANG');

4258: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4259: BEGIN
4260: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;
4261: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := USERENV('LANG');
4262: x_okl_trx_ar_invoices_tl_rec.SOURCE_LANG := USERENV('LANG');
4263: RETURN(l_return_status);
4264: END Set_Attributes;
4265: BEGIN
4266: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 4277: p_okl_trx_ar_invoices_tl_rec, -- IN

4273: RAISE Okl_Api.G_EXCEPTION_ERROR;
4274: END IF;
4275: --- Setting item attributes
4276: l_return_status := Set_Attributes(
4277: p_okl_trx_ar_invoices_tl_rec, -- IN
4278: l_okl_trx_ar_invoices_tl_rec); -- OUT
4279: --- If any errors happen abort API
4280: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4281: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4278: l_okl_trx_ar_invoices_tl_rec); -- OUT

4274: END IF;
4275: --- Setting item attributes
4276: l_return_status := Set_Attributes(
4277: p_okl_trx_ar_invoices_tl_rec, -- IN
4278: l_okl_trx_ar_invoices_tl_rec); -- OUT
4279: --- If any errors happen abort API
4280: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4281: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4282: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 4285: l_return_status := populate_new_record(l_okl_trx_ar_invoices_tl_rec, ldefokltrxarinvoicestlrec);

4281: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4282: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4283: RAISE Okl_Api.G_EXCEPTION_ERROR;
4284: END IF;
4285: l_return_status := populate_new_record(l_okl_trx_ar_invoices_tl_rec, ldefokltrxarinvoicestlrec);
4286: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4287: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4288: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4289: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 4291: UPDATE OKL_TRX_AR_INVOICES_TL

4287: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4288: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4289: RAISE Okl_Api.G_EXCEPTION_ERROR;
4290: END IF;
4291: UPDATE OKL_TRX_AR_INVOICES_TL
4292: SET DESCRIPTION = ldefokltrxarinvoicestlrec.description,
4293: SOURCE_LANG = ldefokltrxarinvoicestlrec.source_lang,
4294: CREATED_BY = ldefokltrxarinvoicestlrec.created_by,
4295: CREATION_DATE = ldefokltrxarinvoicestlrec.creation_date,

Line 4302: UPDATE OKL_TRX_AR_INVOICES_TL

4298: LAST_UPDATE_LOGIN = ldefokltrxarinvoicestlrec.last_update_login
4299: WHERE ID = ldefokltrxarinvoicestlrec.id
4300: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
4301:
4302: UPDATE OKL_TRX_AR_INVOICES_TL
4303: SET SFWT_FLAG = 'Y'
4304: WHERE ID = ldefokltrxarinvoicestlrec.id
4305: AND SOURCE_LANG <> USERENV('LANG');
4306:

Line 4307: x_okl_trx_ar_invoices_tl_rec := ldefokltrxarinvoicestlrec;

4303: SET SFWT_FLAG = 'Y'
4304: WHERE ID = ldefokltrxarinvoicestlrec.id
4305: AND SOURCE_LANG <> USERENV('LANG');
4306:
4307: x_okl_trx_ar_invoices_tl_rec := ldefokltrxarinvoicestlrec;
4308: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
4309: EXCEPTION
4310: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
4311: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 4358: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;

4354: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
4355: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4356: l_taiv_rec taiv_rec_type := p_taiv_rec;
4357: l_def_taiv_rec taiv_rec_type;
4358: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
4359: lx_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
4360: l_tai_rec tai_rec_type;
4361: lx_tai_rec tai_rec_type;
4362: -------------------------------

Line 4359: lx_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;

4355: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4356: l_taiv_rec taiv_rec_type := p_taiv_rec;
4357: l_def_taiv_rec taiv_rec_type;
4358: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
4359: lx_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
4360: l_tai_rec tai_rec_type;
4361: lx_tai_rec tai_rec_type;
4362: -------------------------------
4363: -- FUNCTION fill_who_columns --

Line 4803: migrate(l_def_taiv_rec, l_okl_trx_ar_invoices_tl_rec);

4799:
4800: --------------------------------------
4801: -- Move VIEW record to "Child" records
4802: --------------------------------------
4803: migrate(l_def_taiv_rec, l_okl_trx_ar_invoices_tl_rec);
4804: migrate(l_def_taiv_rec, l_tai_rec);
4805: --------------------------------------------
4806: -- Call the UPDATE_ROW for each child record
4807: --------------------------------------------

Line 4813: l_okl_trx_ar_invoices_tl_rec,

4809: p_init_msg_list,
4810: x_return_status,
4811: x_msg_count,
4812: x_msg_data,
4813: l_okl_trx_ar_invoices_tl_rec,
4814: lx_okl_trx_ar_invoices_tl_rec
4815: );
4816: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4817: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4814: lx_okl_trx_ar_invoices_tl_rec

4810: x_return_status,
4811: x_msg_count,
4812: x_msg_data,
4813: l_okl_trx_ar_invoices_tl_rec,
4814: lx_okl_trx_ar_invoices_tl_rec
4815: );
4816: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4817: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4818: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 4821: migrate(lx_okl_trx_ar_invoices_tl_rec, l_def_taiv_rec);

4817: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4818: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4819: RAISE Okl_Api.G_EXCEPTION_ERROR;
4820: END IF;
4821: migrate(lx_okl_trx_ar_invoices_tl_rec, l_def_taiv_rec);
4822: update_row(
4823: p_init_msg_list,
4824: x_return_status,
4825: x_msg_count,

Line 5020: -- delete_row for:OKL_TRX_AR_INVOICES_TL --

5016: '_PVT'
5017: );
5018: END delete_row;
5019: -------------------------------------------
5020: -- delete_row for:OKL_TRX_AR_INVOICES_TL --
5021: -------------------------------------------
5022: PROCEDURE delete_row(
5023: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
5024: x_return_status OUT NOCOPY VARCHAR2,

Line 5027: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType) IS

5023: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
5024: x_return_status OUT NOCOPY VARCHAR2,
5025: x_msg_count OUT NOCOPY NUMBER,
5026: x_msg_data OUT NOCOPY VARCHAR2,
5027: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType) IS
5028:
5029: l_api_version CONSTANT NUMBER := 1;
5030: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
5031: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 5032: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType:= p_okl_trx_ar_invoices_tl_rec;

5028:
5029: l_api_version CONSTANT NUMBER := 1;
5030: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
5031: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5032: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType:= p_okl_trx_ar_invoices_tl_rec;
5033: l_row_notfound BOOLEAN := TRUE;
5034: -----------------------------------------------
5035: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --
5036: -----------------------------------------------

Line 5035: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --

5031: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5032: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType:= p_okl_trx_ar_invoices_tl_rec;
5033: l_row_notfound BOOLEAN := TRUE;
5034: -----------------------------------------------
5035: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --
5036: -----------------------------------------------
5037: FUNCTION Set_Attributes (
5038: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
5039: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType

Line 5038: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,

5034: -----------------------------------------------
5035: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --
5036: -----------------------------------------------
5037: FUNCTION Set_Attributes (
5038: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
5039: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
5040: ) RETURN VARCHAR2 IS
5041: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5042: BEGIN

Line 5039: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType

5035: -- Set_Attributes for:OKL_TRX_AR_INVOICES_TL --
5036: -----------------------------------------------
5037: FUNCTION Set_Attributes (
5038: p_okl_trx_ar_invoices_tl_rec IN OklTrxArInvoicesTlRecType,
5039: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
5040: ) RETURN VARCHAR2 IS
5041: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5042: BEGIN
5043: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;

Line 5043: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;

5039: x_okl_trx_ar_invoices_tl_rec OUT NOCOPY OklTrxArInvoicesTlRecType
5040: ) RETURN VARCHAR2 IS
5041: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5042: BEGIN
5043: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;
5044: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := USERENV('LANG');
5045: RETURN(l_return_status);
5046: END Set_Attributes;
5047: BEGIN

Line 5044: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := USERENV('LANG');

5040: ) RETURN VARCHAR2 IS
5041: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5042: BEGIN
5043: x_okl_trx_ar_invoices_tl_rec := p_okl_trx_ar_invoices_tl_rec;
5044: x_okl_trx_ar_invoices_tl_rec.LANGUAGE := USERENV('LANG');
5045: RETURN(l_return_status);
5046: END Set_Attributes;
5047: BEGIN
5048: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 5059: p_okl_trx_ar_invoices_tl_rec, -- IN

5055: RAISE Okl_Api.G_EXCEPTION_ERROR;
5056: END IF;
5057: --- Setting item attributes
5058: l_return_status := Set_Attributes(
5059: p_okl_trx_ar_invoices_tl_rec, -- IN
5060: l_okl_trx_ar_invoices_tl_rec); -- OUT
5061: --- If any errors happen abort API
5062: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
5063: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5060: l_okl_trx_ar_invoices_tl_rec); -- OUT

5056: END IF;
5057: --- Setting item attributes
5058: l_return_status := Set_Attributes(
5059: p_okl_trx_ar_invoices_tl_rec, -- IN
5060: l_okl_trx_ar_invoices_tl_rec); -- OUT
5061: --- If any errors happen abort API
5062: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
5063: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
5064: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 5067: DELETE FROM OKL_TRX_AR_INVOICES_TL

5063: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
5064: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
5065: RAISE Okl_Api.G_EXCEPTION_ERROR;
5066: END IF;
5067: DELETE FROM OKL_TRX_AR_INVOICES_TL
5068: WHERE ID = l_okl_trx_ar_invoices_tl_rec.id;
5069:
5070: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
5071: EXCEPTION

Line 5068: WHERE ID = l_okl_trx_ar_invoices_tl_rec.id;

5064: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
5065: RAISE Okl_Api.G_EXCEPTION_ERROR;
5066: END IF;
5067: DELETE FROM OKL_TRX_AR_INVOICES_TL
5068: WHERE ID = l_okl_trx_ar_invoices_tl_rec.id;
5069:
5070: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
5071: EXCEPTION
5072: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 5118: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;

5114: l_api_version CONSTANT NUMBER := 1;
5115: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
5116: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5117: l_taiv_rec taiv_rec_type := p_taiv_rec;
5118: l_okl_trx_ar_invoices_tl_rec OklTrxArInvoicesTlRecType;
5119: l_tai_rec tai_rec_type;
5120: BEGIN
5121: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
5122: G_PKG_NAME,

Line 5136: migrate(l_taiv_rec, l_okl_trx_ar_invoices_tl_rec);

5132: END IF;
5133: --------------------------------------
5134: -- Move VIEW record to "Child" records
5135: --------------------------------------
5136: migrate(l_taiv_rec, l_okl_trx_ar_invoices_tl_rec);
5137: migrate(l_taiv_rec, l_tai_rec);
5138: --------------------------------------------
5139: -- Call the DELETE_ROW for each child record
5140: --------------------------------------------

Line 5146: l_okl_trx_ar_invoices_tl_rec

5142: p_init_msg_list,
5143: x_return_status,
5144: x_msg_count,
5145: x_msg_data,
5146: l_okl_trx_ar_invoices_tl_rec
5147: );
5148: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
5149: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
5150: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN