DBA Data[Home] [Help]

APPS.OKL_CAT_PVT dependencies on OKL_CASH_ALLCTN_RLS

Line 108: CURSOR c1( p_name OKL_CASH_ALLCTN_RLS.name%TYPE) IS

104:
105: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
106: l_dummy VARCHAR2(1);
107: l_row_found BOOLEAN := FALSE;
108: CURSOR c1( p_name OKL_CASH_ALLCTN_RLS.name%TYPE) IS
109: SELECT 1
110: FROM OKL_CASH_ALLCTN_RLS
111: WHERE name = p_name
112: AND id <> NVL(p_catv_rec.id,-9999);

Line 110: FROM OKL_CASH_ALLCTN_RLS

106: l_dummy VARCHAR2(1);
107: l_row_found BOOLEAN := FALSE;
108: CURSOR c1( p_name OKL_CASH_ALLCTN_RLS.name%TYPE) IS
109: SELECT 1
110: FROM OKL_CASH_ALLCTN_RLS
111: WHERE name = p_name
112: AND id <> NVL(p_catv_rec.id,-9999);
113:
114: BEGIN

Line 479: p_token2_value => 'OKL_CASH_ALLCTN_RLS',

475: p_msg_name => G_NO_PARENT_RECORD,
476: p_token1 => G_COL_NAME_TOKEN,
477: p_token1_value => 'CAU_ID',
478: p_token2 => G_CHILD_TABLE_TOKEN,
479: p_token2_value => 'OKL_CASH_ALLCTN_RLS',
480: p_token3 => G_PARENT_TABLE_TOKEN,
481: p_token3_value => 'OKL_CSH_ALLCTN_RL_HDR');
482: l_return_status := OKL_API.G_RET_STS_ERROR;
483: END IF;

Line 539: -- FUNCTION get_rec for: OKL_CASH_ALLCTN_RLS

535:
536: /************************** END HAND-CODED *****************************/
537:
538: ---------------------------------------------------------------------------
539: -- FUNCTION get_rec for: OKL_CASH_ALLCTN_RLS
540: ---------------------------------------------------------------------------
541: -- Start of comments
542: --
543: -- Function Name : get_rec

Line 544: -- Description : To get the record from the okl_cash_allctn_rls table.

540: ---------------------------------------------------------------------------
541: -- Start of comments
542: --
543: -- Function Name : get_rec
544: -- Description : To get the record from the okl_cash_allctn_rls table.
545: -- Business Rules :
546: -- Parameters : p_cat_rec, x_no_data_found
547: -- Version : 1.0
548: -- History : 25-AUG-04 abindal modified to include NUM_OF_DAYS_TO_HOLD_ADV_PAY column.

Line 598: FROM Okl_Cash_Allctn_Rls

594: LAST_UPDATE_LOGIN,
595: CAU_ID,
596: -- column added to hold the number of days for advanced receipts
597: NUM_DAYS_HOLD_ADV_PAY
598: FROM Okl_Cash_Allctn_Rls
599: WHERE okl_cash_allctn_rls.id = p_id;
600: l_cat_pk cat_pk_csr%ROWTYPE;
601: l_cat_rec cat_rec_type;
602: BEGIN

Line 599: WHERE okl_cash_allctn_rls.id = p_id;

595: CAU_ID,
596: -- column added to hold the number of days for advanced receipts
597: NUM_DAYS_HOLD_ADV_PAY
598: FROM Okl_Cash_Allctn_Rls
599: WHERE okl_cash_allctn_rls.id = p_id;
600: l_cat_pk cat_pk_csr%ROWTYPE;
601: l_cat_rec cat_rec_type;
602: BEGIN
603: x_no_data_found := TRUE;

Line 658: -- FUNCTION get_rec for: OKL_CASH_ALLCTN_RLS_V

654: BEGIN
655: RETURN(get_rec(p_cat_rec, l_row_notfound));
656: END get_rec;
657: ---------------------------------------------------------------------------
658: -- FUNCTION get_rec for: OKL_CASH_ALLCTN_RLS_V
659: ---------------------------------------------------------------------------
660: ---------------------------------------------------------------------------
661: -- Start of comments
662: --

Line 664: -- Description : To get the record from the okl_cash_allctn_rls table.

660: ---------------------------------------------------------------------------
661: -- Start of comments
662: --
663: -- Function Name : get_rec
664: -- Description : To get the record from the okl_cash_allctn_rls table.
665: -- Business Rules :
666: -- Parameters : p_catv_rec, x_no_data_found
667: -- Version : 1.0
668: -- History : 25-AUG-04 abindal modified to include NUM_OF_DAYS_TO_HOLD_ADV_PAY column.

Line 718: FROM OKL_CASH_ALLCTN_RLS

714: LAST_UPDATE_LOGIN,
715: CAU_ID,
716: -- new column to hold number of days to reserve advanced payment for contract.
717: NUM_DAYS_HOLD_ADV_PAY
718: FROM OKL_CASH_ALLCTN_RLS
719: WHERE OKL_CASH_ALLCTN_RLS.id = p_id;
720: l_okl_catv_pk okl_catv_pk_csr%ROWTYPE;
721: l_catv_rec catv_rec_type;
722: BEGIN

Line 719: WHERE OKL_CASH_ALLCTN_RLS.id = p_id;

715: CAU_ID,
716: -- new column to hold number of days to reserve advanced payment for contract.
717: NUM_DAYS_HOLD_ADV_PAY
718: FROM OKL_CASH_ALLCTN_RLS
719: WHERE OKL_CASH_ALLCTN_RLS.id = p_id;
720: l_okl_catv_pk okl_catv_pk_csr%ROWTYPE;
721: l_catv_rec catv_rec_type;
722: BEGIN
723: x_no_data_found := TRUE;

Line 779: -- FUNCTION null_out_defaults for: OKL_CASH_ALLCTN_RLS_V --

775: RETURN(get_rec(p_catv_rec, l_row_notfound));
776: END get_rec;
777:
778: -----------------------------------------------------------
779: -- FUNCTION null_out_defaults for: OKL_CASH_ALLCTN_RLS_V --
780: -----------------------------------------------------------
781: ---------------------------------------------------------------------------
782: -- Start of comments
783: --

Line 920: -- Validate_Attributes for:OKL_CASH_ALLCTN_RLS_V --

916: ---------------------------------------------------------------------------
917: -- PROCEDURE Validate_Attributes
918: ---------------------------------------------------------------------------
919: ---------------------------------------------------
920: -- Validate_Attributes for:OKL_CASH_ALLCTN_RLS_V --
921: ---------------------------------------------------
922: FUNCTION Validate_Attributes (
923: p_catv_rec IN catv_rec_type
924: ) RETURN VARCHAR2 IS

Line 1125: -- Validate_Record for:OKL_CASH_ALLCTN_RLS_V --

1121: ---------------------------------------------------------------------------
1122: -- PROCEDURE Validate_Record
1123: ---------------------------------------------------------------------------
1124: -----------------------------------------------
1125: -- Validate_Record for:OKL_CASH_ALLCTN_RLS_V --
1126: -----------------------------------------------
1127: FUNCTION Validate_Record (
1128: p_catv_rec IN catv_rec_type
1129: ) RETURN VARCHAR2 IS

Line 1264: p_to IN OUT NOCOPY okl_cash_allctn_rls_h_rec_type

1260: END migrate;
1261: /*
1262: PROCEDURE migrate (
1263: p_from IN cat_rec_type,
1264: p_to IN OUT NOCOPY okl_cash_allctn_rls_h_rec_type
1265: ) IS
1266: BEGIN
1267: p_to.id := p_from.id;
1268: p_to.name := p_from.name;

Line 1304: -- validate_row for:OKL_CASH_ALLCTN_RLS_V --

1300: ---------------------------------------------------------------------------
1301: -- PROCEDURE validate_row
1302: ---------------------------------------------------------------------------
1303: --------------------------------------------
1304: -- validate_row for:OKL_CASH_ALLCTN_RLS_V --
1305: --------------------------------------------
1306: PROCEDURE validate_row(
1307: p_api_version IN NUMBER,
1308: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1463: -- insert_row for:OKL_CASH_ALLCTN_RLS_H --

1459: ---------------------------------------------------------------------------
1460: -- PROCEDURE insert_row
1461: ---------------------------------------------------------------------------
1462: ------------------------------------------
1463: -- insert_row for:OKL_CASH_ALLCTN_RLS_H --
1464: ------------------------------------------
1465: /* -- history tables not supported -- 04 APR 2002
1466: PROCEDURE insert_row(
1467: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1471: p_okl_cash_allctn_rls_h_rec IN okl_cash_allctn_rls_h_rec_type,

1467: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1468: x_return_status OUT NOCOPY VARCHAR2,
1469: x_msg_count OUT NOCOPY NUMBER,
1470: x_msg_data OUT NOCOPY VARCHAR2,
1471: p_okl_cash_allctn_rls_h_rec IN okl_cash_allctn_rls_h_rec_type,
1472: x_okl_cash_allctn_rls_h_rec OUT NOCOPY okl_cash_allctn_rls_h_rec_type) IS
1473:
1474: l_api_version CONSTANT NUMBER := 1;
1475: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';

Line 1472: x_okl_cash_allctn_rls_h_rec OUT NOCOPY okl_cash_allctn_rls_h_rec_type) IS

1468: x_return_status OUT NOCOPY VARCHAR2,
1469: x_msg_count OUT NOCOPY NUMBER,
1470: x_msg_data OUT NOCOPY VARCHAR2,
1471: p_okl_cash_allctn_rls_h_rec IN okl_cash_allctn_rls_h_rec_type,
1472: x_okl_cash_allctn_rls_h_rec OUT NOCOPY okl_cash_allctn_rls_h_rec_type) IS
1473:
1474: l_api_version CONSTANT NUMBER := 1;
1475: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
1476: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1477: l_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type := p_okl_cash_allctn_rls_h_rec;

1473:
1474: l_api_version CONSTANT NUMBER := 1;
1475: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
1476: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1477: l_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type := p_okl_cash_allctn_rls_h_rec;
1478: ldefoklcashallctnrlshrec okl_cash_allctn_rls_h_rec_type;
1479: ----------------------------------------------
1480: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS_H --
1481: ----------------------------------------------

Line 1478: ldefoklcashallctnrlshrec okl_cash_allctn_rls_h_rec_type;

1474: l_api_version CONSTANT NUMBER := 1;
1475: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
1476: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1477: l_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type := p_okl_cash_allctn_rls_h_rec;
1478: ldefoklcashallctnrlshrec okl_cash_allctn_rls_h_rec_type;
1479: ----------------------------------------------
1480: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS_H --
1481: ----------------------------------------------
1482: FUNCTION Set_Attributes (

Line 1480: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS_H --

1476: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1477: l_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type := p_okl_cash_allctn_rls_h_rec;
1478: ldefoklcashallctnrlshrec okl_cash_allctn_rls_h_rec_type;
1479: ----------------------------------------------
1480: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS_H --
1481: ----------------------------------------------
1482: FUNCTION Set_Attributes (
1483: p_okl_cash_allctn_rls_h_rec IN okl_cash_allctn_rls_h_rec_type,
1484: x_okl_cash_allctn_rls_h_rec OUT NOCOPY okl_cash_allctn_rls_h_rec_type

Line 1483: p_okl_cash_allctn_rls_h_rec IN okl_cash_allctn_rls_h_rec_type,

1479: ----------------------------------------------
1480: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS_H --
1481: ----------------------------------------------
1482: FUNCTION Set_Attributes (
1483: p_okl_cash_allctn_rls_h_rec IN okl_cash_allctn_rls_h_rec_type,
1484: x_okl_cash_allctn_rls_h_rec OUT NOCOPY okl_cash_allctn_rls_h_rec_type
1485: ) RETURN VARCHAR2 IS
1486: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1487: BEGIN

Line 1484: x_okl_cash_allctn_rls_h_rec OUT NOCOPY okl_cash_allctn_rls_h_rec_type

1480: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS_H --
1481: ----------------------------------------------
1482: FUNCTION Set_Attributes (
1483: p_okl_cash_allctn_rls_h_rec IN okl_cash_allctn_rls_h_rec_type,
1484: x_okl_cash_allctn_rls_h_rec OUT NOCOPY okl_cash_allctn_rls_h_rec_type
1485: ) RETURN VARCHAR2 IS
1486: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1487: BEGIN
1488: x_okl_cash_allctn_rls_h_rec := p_okl_cash_allctn_rls_h_rec;

Line 1488: x_okl_cash_allctn_rls_h_rec := p_okl_cash_allctn_rls_h_rec;

1484: x_okl_cash_allctn_rls_h_rec OUT NOCOPY okl_cash_allctn_rls_h_rec_type
1485: ) RETURN VARCHAR2 IS
1486: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1487: BEGIN
1488: x_okl_cash_allctn_rls_h_rec := p_okl_cash_allctn_rls_h_rec;
1489: RETURN(l_return_status);
1490: END Set_Attributes;
1491: BEGIN
1492: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1504: p_okl_cash_allctn_rls_h_rec, -- IN

1500: RAISE Okl_Api.G_EXCEPTION_ERROR;
1501: END IF;
1502: --- Setting item attributes
1503: l_return_status := Set_Attributes(
1504: p_okl_cash_allctn_rls_h_rec, -- IN
1505: l_okl_cash_allctn_rls_h_rec); -- OUT
1506: --- If any errors happen abort API
1507:
1508: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1505: l_okl_cash_allctn_rls_h_rec); -- OUT

1501: END IF;
1502: --- Setting item attributes
1503: l_return_status := Set_Attributes(
1504: p_okl_cash_allctn_rls_h_rec, -- IN
1505: l_okl_cash_allctn_rls_h_rec); -- OUT
1506: --- If any errors happen abort API
1507:
1508: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1509: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1514: l_okl_cash_allctn_rls_h_rec.ID := get_seq_id;

1510: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1511: RAISE Okl_Api.G_EXCEPTION_ERROR;
1512: END IF;
1513:
1514: l_okl_cash_allctn_rls_h_rec.ID := get_seq_id;
1515:
1516: INSERT INTO OKL_CASH_ALLCTN_RLS_H(
1517: id,
1518: major_version,

Line 1516: INSERT INTO OKL_CASH_ALLCTN_RLS_H(

1512: END IF;
1513:
1514: l_okl_cash_allctn_rls_h_rec.ID := get_seq_id;
1515:
1516: INSERT INTO OKL_CASH_ALLCTN_RLS_H(
1517: id,
1518: major_version,
1519: name,
1520: object_version_number,

Line 1550: l_okl_cash_allctn_rls_h_rec.id,

1546: last_updated_by,
1547: last_update_date,
1548: last_update_login)
1549: VALUES (
1550: l_okl_cash_allctn_rls_h_rec.id,
1551: -- l_okl_cash_allctn_rls_h_rec.major_version,
1552: 1,
1553: l_okl_cash_allctn_rls_h_rec.name,
1554: l_okl_cash_allctn_rls_h_rec.object_version_number,

Line 1551: -- l_okl_cash_allctn_rls_h_rec.major_version,

1547: last_update_date,
1548: last_update_login)
1549: VALUES (
1550: l_okl_cash_allctn_rls_h_rec.id,
1551: -- l_okl_cash_allctn_rls_h_rec.major_version,
1552: 1,
1553: l_okl_cash_allctn_rls_h_rec.name,
1554: l_okl_cash_allctn_rls_h_rec.object_version_number,
1555: l_okl_cash_allctn_rls_h_rec.description,

Line 1553: l_okl_cash_allctn_rls_h_rec.name,

1549: VALUES (
1550: l_okl_cash_allctn_rls_h_rec.id,
1551: -- l_okl_cash_allctn_rls_h_rec.major_version,
1552: 1,
1553: l_okl_cash_allctn_rls_h_rec.name,
1554: l_okl_cash_allctn_rls_h_rec.object_version_number,
1555: l_okl_cash_allctn_rls_h_rec.description,
1556: l_okl_cash_allctn_rls_h_rec.amount_tolerance_percent,
1557: l_okl_cash_allctn_rls_h_rec.days_past_quote_valid_toleranc,

Line 1554: l_okl_cash_allctn_rls_h_rec.object_version_number,

1550: l_okl_cash_allctn_rls_h_rec.id,
1551: -- l_okl_cash_allctn_rls_h_rec.major_version,
1552: 1,
1553: l_okl_cash_allctn_rls_h_rec.name,
1554: l_okl_cash_allctn_rls_h_rec.object_version_number,
1555: l_okl_cash_allctn_rls_h_rec.description,
1556: l_okl_cash_allctn_rls_h_rec.amount_tolerance_percent,
1557: l_okl_cash_allctn_rls_h_rec.days_past_quote_valid_toleranc,
1558: l_okl_cash_allctn_rls_h_rec.months_to_bill_ahead,

Line 1555: l_okl_cash_allctn_rls_h_rec.description,

1551: -- l_okl_cash_allctn_rls_h_rec.major_version,
1552: 1,
1553: l_okl_cash_allctn_rls_h_rec.name,
1554: l_okl_cash_allctn_rls_h_rec.object_version_number,
1555: l_okl_cash_allctn_rls_h_rec.description,
1556: l_okl_cash_allctn_rls_h_rec.amount_tolerance_percent,
1557: l_okl_cash_allctn_rls_h_rec.days_past_quote_valid_toleranc,
1558: l_okl_cash_allctn_rls_h_rec.months_to_bill_ahead,
1559: l_okl_cash_allctn_rls_h_rec.under_payment_allocation_code,

Line 1556: l_okl_cash_allctn_rls_h_rec.amount_tolerance_percent,

1552: 1,
1553: l_okl_cash_allctn_rls_h_rec.name,
1554: l_okl_cash_allctn_rls_h_rec.object_version_number,
1555: l_okl_cash_allctn_rls_h_rec.description,
1556: l_okl_cash_allctn_rls_h_rec.amount_tolerance_percent,
1557: l_okl_cash_allctn_rls_h_rec.days_past_quote_valid_toleranc,
1558: l_okl_cash_allctn_rls_h_rec.months_to_bill_ahead,
1559: l_okl_cash_allctn_rls_h_rec.under_payment_allocation_code,
1560: l_okl_cash_allctn_rls_h_rec.over_payment_allocation_code,

Line 1557: l_okl_cash_allctn_rls_h_rec.days_past_quote_valid_toleranc,

1553: l_okl_cash_allctn_rls_h_rec.name,
1554: l_okl_cash_allctn_rls_h_rec.object_version_number,
1555: l_okl_cash_allctn_rls_h_rec.description,
1556: l_okl_cash_allctn_rls_h_rec.amount_tolerance_percent,
1557: l_okl_cash_allctn_rls_h_rec.days_past_quote_valid_toleranc,
1558: l_okl_cash_allctn_rls_h_rec.months_to_bill_ahead,
1559: l_okl_cash_allctn_rls_h_rec.under_payment_allocation_code,
1560: l_okl_cash_allctn_rls_h_rec.over_payment_allocation_code,
1561: l_okl_cash_allctn_rls_h_rec.receipt_msmtch_allocation_code,

Line 1558: l_okl_cash_allctn_rls_h_rec.months_to_bill_ahead,

1554: l_okl_cash_allctn_rls_h_rec.object_version_number,
1555: l_okl_cash_allctn_rls_h_rec.description,
1556: l_okl_cash_allctn_rls_h_rec.amount_tolerance_percent,
1557: l_okl_cash_allctn_rls_h_rec.days_past_quote_valid_toleranc,
1558: l_okl_cash_allctn_rls_h_rec.months_to_bill_ahead,
1559: l_okl_cash_allctn_rls_h_rec.under_payment_allocation_code,
1560: l_okl_cash_allctn_rls_h_rec.over_payment_allocation_code,
1561: l_okl_cash_allctn_rls_h_rec.receipt_msmtch_allocation_code,
1562: l_okl_cash_allctn_rls_h_rec.attribute_category,

Line 1559: l_okl_cash_allctn_rls_h_rec.under_payment_allocation_code,

1555: l_okl_cash_allctn_rls_h_rec.description,
1556: l_okl_cash_allctn_rls_h_rec.amount_tolerance_percent,
1557: l_okl_cash_allctn_rls_h_rec.days_past_quote_valid_toleranc,
1558: l_okl_cash_allctn_rls_h_rec.months_to_bill_ahead,
1559: l_okl_cash_allctn_rls_h_rec.under_payment_allocation_code,
1560: l_okl_cash_allctn_rls_h_rec.over_payment_allocation_code,
1561: l_okl_cash_allctn_rls_h_rec.receipt_msmtch_allocation_code,
1562: l_okl_cash_allctn_rls_h_rec.attribute_category,
1563: l_okl_cash_allctn_rls_h_rec.attribute1,

Line 1560: l_okl_cash_allctn_rls_h_rec.over_payment_allocation_code,

1556: l_okl_cash_allctn_rls_h_rec.amount_tolerance_percent,
1557: l_okl_cash_allctn_rls_h_rec.days_past_quote_valid_toleranc,
1558: l_okl_cash_allctn_rls_h_rec.months_to_bill_ahead,
1559: l_okl_cash_allctn_rls_h_rec.under_payment_allocation_code,
1560: l_okl_cash_allctn_rls_h_rec.over_payment_allocation_code,
1561: l_okl_cash_allctn_rls_h_rec.receipt_msmtch_allocation_code,
1562: l_okl_cash_allctn_rls_h_rec.attribute_category,
1563: l_okl_cash_allctn_rls_h_rec.attribute1,
1564: l_okl_cash_allctn_rls_h_rec.attribute2,

Line 1561: l_okl_cash_allctn_rls_h_rec.receipt_msmtch_allocation_code,

1557: l_okl_cash_allctn_rls_h_rec.days_past_quote_valid_toleranc,
1558: l_okl_cash_allctn_rls_h_rec.months_to_bill_ahead,
1559: l_okl_cash_allctn_rls_h_rec.under_payment_allocation_code,
1560: l_okl_cash_allctn_rls_h_rec.over_payment_allocation_code,
1561: l_okl_cash_allctn_rls_h_rec.receipt_msmtch_allocation_code,
1562: l_okl_cash_allctn_rls_h_rec.attribute_category,
1563: l_okl_cash_allctn_rls_h_rec.attribute1,
1564: l_okl_cash_allctn_rls_h_rec.attribute2,
1565: l_okl_cash_allctn_rls_h_rec.attribute3,

Line 1562: l_okl_cash_allctn_rls_h_rec.attribute_category,

1558: l_okl_cash_allctn_rls_h_rec.months_to_bill_ahead,
1559: l_okl_cash_allctn_rls_h_rec.under_payment_allocation_code,
1560: l_okl_cash_allctn_rls_h_rec.over_payment_allocation_code,
1561: l_okl_cash_allctn_rls_h_rec.receipt_msmtch_allocation_code,
1562: l_okl_cash_allctn_rls_h_rec.attribute_category,
1563: l_okl_cash_allctn_rls_h_rec.attribute1,
1564: l_okl_cash_allctn_rls_h_rec.attribute2,
1565: l_okl_cash_allctn_rls_h_rec.attribute3,
1566: l_okl_cash_allctn_rls_h_rec.attribute4,

Line 1563: l_okl_cash_allctn_rls_h_rec.attribute1,

1559: l_okl_cash_allctn_rls_h_rec.under_payment_allocation_code,
1560: l_okl_cash_allctn_rls_h_rec.over_payment_allocation_code,
1561: l_okl_cash_allctn_rls_h_rec.receipt_msmtch_allocation_code,
1562: l_okl_cash_allctn_rls_h_rec.attribute_category,
1563: l_okl_cash_allctn_rls_h_rec.attribute1,
1564: l_okl_cash_allctn_rls_h_rec.attribute2,
1565: l_okl_cash_allctn_rls_h_rec.attribute3,
1566: l_okl_cash_allctn_rls_h_rec.attribute4,
1567: l_okl_cash_allctn_rls_h_rec.attribute5,

Line 1564: l_okl_cash_allctn_rls_h_rec.attribute2,

1560: l_okl_cash_allctn_rls_h_rec.over_payment_allocation_code,
1561: l_okl_cash_allctn_rls_h_rec.receipt_msmtch_allocation_code,
1562: l_okl_cash_allctn_rls_h_rec.attribute_category,
1563: l_okl_cash_allctn_rls_h_rec.attribute1,
1564: l_okl_cash_allctn_rls_h_rec.attribute2,
1565: l_okl_cash_allctn_rls_h_rec.attribute3,
1566: l_okl_cash_allctn_rls_h_rec.attribute4,
1567: l_okl_cash_allctn_rls_h_rec.attribute5,
1568: l_okl_cash_allctn_rls_h_rec.attribute6,

Line 1565: l_okl_cash_allctn_rls_h_rec.attribute3,

1561: l_okl_cash_allctn_rls_h_rec.receipt_msmtch_allocation_code,
1562: l_okl_cash_allctn_rls_h_rec.attribute_category,
1563: l_okl_cash_allctn_rls_h_rec.attribute1,
1564: l_okl_cash_allctn_rls_h_rec.attribute2,
1565: l_okl_cash_allctn_rls_h_rec.attribute3,
1566: l_okl_cash_allctn_rls_h_rec.attribute4,
1567: l_okl_cash_allctn_rls_h_rec.attribute5,
1568: l_okl_cash_allctn_rls_h_rec.attribute6,
1569: l_okl_cash_allctn_rls_h_rec.attribute7,

Line 1566: l_okl_cash_allctn_rls_h_rec.attribute4,

1562: l_okl_cash_allctn_rls_h_rec.attribute_category,
1563: l_okl_cash_allctn_rls_h_rec.attribute1,
1564: l_okl_cash_allctn_rls_h_rec.attribute2,
1565: l_okl_cash_allctn_rls_h_rec.attribute3,
1566: l_okl_cash_allctn_rls_h_rec.attribute4,
1567: l_okl_cash_allctn_rls_h_rec.attribute5,
1568: l_okl_cash_allctn_rls_h_rec.attribute6,
1569: l_okl_cash_allctn_rls_h_rec.attribute7,
1570: l_okl_cash_allctn_rls_h_rec.attribute8,

Line 1567: l_okl_cash_allctn_rls_h_rec.attribute5,

1563: l_okl_cash_allctn_rls_h_rec.attribute1,
1564: l_okl_cash_allctn_rls_h_rec.attribute2,
1565: l_okl_cash_allctn_rls_h_rec.attribute3,
1566: l_okl_cash_allctn_rls_h_rec.attribute4,
1567: l_okl_cash_allctn_rls_h_rec.attribute5,
1568: l_okl_cash_allctn_rls_h_rec.attribute6,
1569: l_okl_cash_allctn_rls_h_rec.attribute7,
1570: l_okl_cash_allctn_rls_h_rec.attribute8,
1571: l_okl_cash_allctn_rls_h_rec.attribute9,

Line 1568: l_okl_cash_allctn_rls_h_rec.attribute6,

1564: l_okl_cash_allctn_rls_h_rec.attribute2,
1565: l_okl_cash_allctn_rls_h_rec.attribute3,
1566: l_okl_cash_allctn_rls_h_rec.attribute4,
1567: l_okl_cash_allctn_rls_h_rec.attribute5,
1568: l_okl_cash_allctn_rls_h_rec.attribute6,
1569: l_okl_cash_allctn_rls_h_rec.attribute7,
1570: l_okl_cash_allctn_rls_h_rec.attribute8,
1571: l_okl_cash_allctn_rls_h_rec.attribute9,
1572: l_okl_cash_allctn_rls_h_rec.attribute10,

Line 1569: l_okl_cash_allctn_rls_h_rec.attribute7,

1565: l_okl_cash_allctn_rls_h_rec.attribute3,
1566: l_okl_cash_allctn_rls_h_rec.attribute4,
1567: l_okl_cash_allctn_rls_h_rec.attribute5,
1568: l_okl_cash_allctn_rls_h_rec.attribute6,
1569: l_okl_cash_allctn_rls_h_rec.attribute7,
1570: l_okl_cash_allctn_rls_h_rec.attribute8,
1571: l_okl_cash_allctn_rls_h_rec.attribute9,
1572: l_okl_cash_allctn_rls_h_rec.attribute10,
1573: l_okl_cash_allctn_rls_h_rec.attribute11,

Line 1570: l_okl_cash_allctn_rls_h_rec.attribute8,

1566: l_okl_cash_allctn_rls_h_rec.attribute4,
1567: l_okl_cash_allctn_rls_h_rec.attribute5,
1568: l_okl_cash_allctn_rls_h_rec.attribute6,
1569: l_okl_cash_allctn_rls_h_rec.attribute7,
1570: l_okl_cash_allctn_rls_h_rec.attribute8,
1571: l_okl_cash_allctn_rls_h_rec.attribute9,
1572: l_okl_cash_allctn_rls_h_rec.attribute10,
1573: l_okl_cash_allctn_rls_h_rec.attribute11,
1574: l_okl_cash_allctn_rls_h_rec.attribute12,

Line 1571: l_okl_cash_allctn_rls_h_rec.attribute9,

1567: l_okl_cash_allctn_rls_h_rec.attribute5,
1568: l_okl_cash_allctn_rls_h_rec.attribute6,
1569: l_okl_cash_allctn_rls_h_rec.attribute7,
1570: l_okl_cash_allctn_rls_h_rec.attribute8,
1571: l_okl_cash_allctn_rls_h_rec.attribute9,
1572: l_okl_cash_allctn_rls_h_rec.attribute10,
1573: l_okl_cash_allctn_rls_h_rec.attribute11,
1574: l_okl_cash_allctn_rls_h_rec.attribute12,
1575: l_okl_cash_allctn_rls_h_rec.attribute13,

Line 1572: l_okl_cash_allctn_rls_h_rec.attribute10,

1568: l_okl_cash_allctn_rls_h_rec.attribute6,
1569: l_okl_cash_allctn_rls_h_rec.attribute7,
1570: l_okl_cash_allctn_rls_h_rec.attribute8,
1571: l_okl_cash_allctn_rls_h_rec.attribute9,
1572: l_okl_cash_allctn_rls_h_rec.attribute10,
1573: l_okl_cash_allctn_rls_h_rec.attribute11,
1574: l_okl_cash_allctn_rls_h_rec.attribute12,
1575: l_okl_cash_allctn_rls_h_rec.attribute13,
1576: l_okl_cash_allctn_rls_h_rec.attribute14,

Line 1573: l_okl_cash_allctn_rls_h_rec.attribute11,

1569: l_okl_cash_allctn_rls_h_rec.attribute7,
1570: l_okl_cash_allctn_rls_h_rec.attribute8,
1571: l_okl_cash_allctn_rls_h_rec.attribute9,
1572: l_okl_cash_allctn_rls_h_rec.attribute10,
1573: l_okl_cash_allctn_rls_h_rec.attribute11,
1574: l_okl_cash_allctn_rls_h_rec.attribute12,
1575: l_okl_cash_allctn_rls_h_rec.attribute13,
1576: l_okl_cash_allctn_rls_h_rec.attribute14,
1577: l_okl_cash_allctn_rls_h_rec.attribute15,

Line 1574: l_okl_cash_allctn_rls_h_rec.attribute12,

1570: l_okl_cash_allctn_rls_h_rec.attribute8,
1571: l_okl_cash_allctn_rls_h_rec.attribute9,
1572: l_okl_cash_allctn_rls_h_rec.attribute10,
1573: l_okl_cash_allctn_rls_h_rec.attribute11,
1574: l_okl_cash_allctn_rls_h_rec.attribute12,
1575: l_okl_cash_allctn_rls_h_rec.attribute13,
1576: l_okl_cash_allctn_rls_h_rec.attribute14,
1577: l_okl_cash_allctn_rls_h_rec.attribute15,
1578: l_okl_cash_allctn_rls_h_rec.created_by,

Line 1575: l_okl_cash_allctn_rls_h_rec.attribute13,

1571: l_okl_cash_allctn_rls_h_rec.attribute9,
1572: l_okl_cash_allctn_rls_h_rec.attribute10,
1573: l_okl_cash_allctn_rls_h_rec.attribute11,
1574: l_okl_cash_allctn_rls_h_rec.attribute12,
1575: l_okl_cash_allctn_rls_h_rec.attribute13,
1576: l_okl_cash_allctn_rls_h_rec.attribute14,
1577: l_okl_cash_allctn_rls_h_rec.attribute15,
1578: l_okl_cash_allctn_rls_h_rec.created_by,
1579: l_okl_cash_allctn_rls_h_rec.creation_date,

Line 1576: l_okl_cash_allctn_rls_h_rec.attribute14,

1572: l_okl_cash_allctn_rls_h_rec.attribute10,
1573: l_okl_cash_allctn_rls_h_rec.attribute11,
1574: l_okl_cash_allctn_rls_h_rec.attribute12,
1575: l_okl_cash_allctn_rls_h_rec.attribute13,
1576: l_okl_cash_allctn_rls_h_rec.attribute14,
1577: l_okl_cash_allctn_rls_h_rec.attribute15,
1578: l_okl_cash_allctn_rls_h_rec.created_by,
1579: l_okl_cash_allctn_rls_h_rec.creation_date,
1580: l_okl_cash_allctn_rls_h_rec.last_updated_by,

Line 1577: l_okl_cash_allctn_rls_h_rec.attribute15,

1573: l_okl_cash_allctn_rls_h_rec.attribute11,
1574: l_okl_cash_allctn_rls_h_rec.attribute12,
1575: l_okl_cash_allctn_rls_h_rec.attribute13,
1576: l_okl_cash_allctn_rls_h_rec.attribute14,
1577: l_okl_cash_allctn_rls_h_rec.attribute15,
1578: l_okl_cash_allctn_rls_h_rec.created_by,
1579: l_okl_cash_allctn_rls_h_rec.creation_date,
1580: l_okl_cash_allctn_rls_h_rec.last_updated_by,
1581: l_okl_cash_allctn_rls_h_rec.last_update_date,

Line 1578: l_okl_cash_allctn_rls_h_rec.created_by,

1574: l_okl_cash_allctn_rls_h_rec.attribute12,
1575: l_okl_cash_allctn_rls_h_rec.attribute13,
1576: l_okl_cash_allctn_rls_h_rec.attribute14,
1577: l_okl_cash_allctn_rls_h_rec.attribute15,
1578: l_okl_cash_allctn_rls_h_rec.created_by,
1579: l_okl_cash_allctn_rls_h_rec.creation_date,
1580: l_okl_cash_allctn_rls_h_rec.last_updated_by,
1581: l_okl_cash_allctn_rls_h_rec.last_update_date,
1582: l_okl_cash_allctn_rls_h_rec.last_update_login);

Line 1579: l_okl_cash_allctn_rls_h_rec.creation_date,

1575: l_okl_cash_allctn_rls_h_rec.attribute13,
1576: l_okl_cash_allctn_rls_h_rec.attribute14,
1577: l_okl_cash_allctn_rls_h_rec.attribute15,
1578: l_okl_cash_allctn_rls_h_rec.created_by,
1579: l_okl_cash_allctn_rls_h_rec.creation_date,
1580: l_okl_cash_allctn_rls_h_rec.last_updated_by,
1581: l_okl_cash_allctn_rls_h_rec.last_update_date,
1582: l_okl_cash_allctn_rls_h_rec.last_update_login);
1583: -- Set OUT values

Line 1580: l_okl_cash_allctn_rls_h_rec.last_updated_by,

1576: l_okl_cash_allctn_rls_h_rec.attribute14,
1577: l_okl_cash_allctn_rls_h_rec.attribute15,
1578: l_okl_cash_allctn_rls_h_rec.created_by,
1579: l_okl_cash_allctn_rls_h_rec.creation_date,
1580: l_okl_cash_allctn_rls_h_rec.last_updated_by,
1581: l_okl_cash_allctn_rls_h_rec.last_update_date,
1582: l_okl_cash_allctn_rls_h_rec.last_update_login);
1583: -- Set OUT values
1584: x_okl_cash_allctn_rls_h_rec := l_okl_cash_allctn_rls_h_rec;

Line 1581: l_okl_cash_allctn_rls_h_rec.last_update_date,

1577: l_okl_cash_allctn_rls_h_rec.attribute15,
1578: l_okl_cash_allctn_rls_h_rec.created_by,
1579: l_okl_cash_allctn_rls_h_rec.creation_date,
1580: l_okl_cash_allctn_rls_h_rec.last_updated_by,
1581: l_okl_cash_allctn_rls_h_rec.last_update_date,
1582: l_okl_cash_allctn_rls_h_rec.last_update_login);
1583: -- Set OUT values
1584: x_okl_cash_allctn_rls_h_rec := l_okl_cash_allctn_rls_h_rec;
1585:

Line 1582: l_okl_cash_allctn_rls_h_rec.last_update_login);

1578: l_okl_cash_allctn_rls_h_rec.created_by,
1579: l_okl_cash_allctn_rls_h_rec.creation_date,
1580: l_okl_cash_allctn_rls_h_rec.last_updated_by,
1581: l_okl_cash_allctn_rls_h_rec.last_update_date,
1582: l_okl_cash_allctn_rls_h_rec.last_update_login);
1583: -- Set OUT values
1584: x_okl_cash_allctn_rls_h_rec := l_okl_cash_allctn_rls_h_rec;
1585:
1586: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1584: x_okl_cash_allctn_rls_h_rec := l_okl_cash_allctn_rls_h_rec;

1580: l_okl_cash_allctn_rls_h_rec.last_updated_by,
1581: l_okl_cash_allctn_rls_h_rec.last_update_date,
1582: l_okl_cash_allctn_rls_h_rec.last_update_login);
1583: -- Set OUT values
1584: x_okl_cash_allctn_rls_h_rec := l_okl_cash_allctn_rls_h_rec;
1585:
1586: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1587:
1588: EXCEPTION

Line 1623: -- insert_row for:OKL_CASH_ALLCTN_RLS --

1619: END insert_row;
1620: */
1621:
1622: ----------------------------------------
1623: -- insert_row for:OKL_CASH_ALLCTN_RLS --
1624: ----------------------------------------
1625: ---------------------------------------------------------------------------
1626: -- Start of comments
1627: --

Line 1629: -- Description : Inserts the row in the table OKL_CASH_ALLCTN_RLS.

1625: ---------------------------------------------------------------------------
1626: -- Start of comments
1627: --
1628: -- Procedure Name : insert_row
1629: -- Description : Inserts the row in the table OKL_CASH_ALLCTN_RLS.
1630: -- Business Rules :
1631: -- Parameters : p_init_msg_list, x_return_status, x_msg_count, x_msg_data,
1632: -- p_cat_rec, x_cat_rec
1633: -- Version : 1.0

Line 1654: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS --

1650: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1651: l_cat_rec cat_rec_type := p_cat_rec;
1652: l_def_cat_rec cat_rec_type;
1653: --------------------------------------------
1654: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS --
1655: --------------------------------------------
1656:
1657: FUNCTION Set_Attributes (
1658: p_cat_rec IN cat_rec_type,

Line 1686: INSERT INTO OKL_CASH_ALLCTN_RLS(

1682: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1683: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1684: RAISE Okl_Api.G_EXCEPTION_ERROR;
1685: END IF;
1686: INSERT INTO OKL_CASH_ALLCTN_RLS(
1687: id,
1688: name,
1689: object_version_number,
1690: description,

Line 1812: -- insert_row for:OKL_CASH_ALLCTN_RLS_V --

1808: );
1809: */
1810: END insert_row;
1811: ------------------------------------------
1812: -- insert_row for:OKL_CASH_ALLCTN_RLS_V --
1813: ------------------------------------------
1814: PROCEDURE insert_row(
1815: p_api_version IN NUMBER,
1816: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1846: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS_V --

1842: l_catv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1843: RETURN(l_catv_rec);
1844: END fill_who_columns;
1845: ----------------------------------------------
1846: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS_V --
1847: ----------------------------------------------
1848: FUNCTION Set_Attributes (
1849: p_catv_rec IN catv_rec_type,
1850: x_catv_rec OUT NOCOPY catv_rec_type

Line 2052: -- lock_row for:OKL_CASH_ALLCTN_RLS --

2048: ---------------------------------------------------------------------------
2049: -- PROCEDURE lock_row
2050: ---------------------------------------------------------------------------
2051: --------------------------------------
2052: -- lock_row for:OKL_CASH_ALLCTN_RLS --
2053: --------------------------------------
2054: PROCEDURE lock_row(
2055: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2056: x_return_status OUT NOCOPY VARCHAR2,

Line 2065: FROM OKL_CASH_ALLCTN_RLS

2061: E_Resource_Busy EXCEPTION;
2062: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2063: CURSOR lock_csr (p_cat_rec IN cat_rec_type) IS
2064: SELECT OBJECT_VERSION_NUMBER
2065: FROM OKL_CASH_ALLCTN_RLS
2066: WHERE ID = p_cat_rec.id
2067: AND OBJECT_VERSION_NUMBER = p_cat_rec.object_version_number
2068: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2069:

Line 2072: FROM OKL_CASH_ALLCTN_RLS

2068: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2069:
2070: CURSOR lchk_csr (p_cat_rec IN cat_rec_type) IS
2071: SELECT OBJECT_VERSION_NUMBER
2072: FROM OKL_CASH_ALLCTN_RLS
2073: WHERE ID = p_cat_rec.id;
2074: l_api_version CONSTANT NUMBER := 1;
2075: l_api_name CONSTANT VARCHAR2(30) := 'RLS_lock_row';
2076: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2077: l_object_version_number OKL_CASH_ALLCTN_RLS.OBJECT_VERSION_NUMBER%TYPE;

2073: WHERE ID = p_cat_rec.id;
2074: l_api_version CONSTANT NUMBER := 1;
2075: l_api_name CONSTANT VARCHAR2(30) := 'RLS_lock_row';
2076: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2077: l_object_version_number OKL_CASH_ALLCTN_RLS.OBJECT_VERSION_NUMBER%TYPE;
2078: lc_object_version_number OKL_CASH_ALLCTN_RLS.OBJECT_VERSION_NUMBER%TYPE;
2079: l_row_notfound BOOLEAN := FALSE;
2080: lc_row_notfound BOOLEAN := FALSE;
2081: BEGIN

Line 2078: lc_object_version_number OKL_CASH_ALLCTN_RLS.OBJECT_VERSION_NUMBER%TYPE;

2074: l_api_version CONSTANT NUMBER := 1;
2075: l_api_name CONSTANT VARCHAR2(30) := 'RLS_lock_row';
2076: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2077: l_object_version_number OKL_CASH_ALLCTN_RLS.OBJECT_VERSION_NUMBER%TYPE;
2078: lc_object_version_number OKL_CASH_ALLCTN_RLS.OBJECT_VERSION_NUMBER%TYPE;
2079: l_row_notfound BOOLEAN := FALSE;
2080: lc_row_notfound BOOLEAN := FALSE;
2081: BEGIN
2082: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2158: -- lock_row for:OKL_CASH_ALLCTN_RLS_V --

2154: '_PVT'
2155: );
2156: END lock_row;
2157: ----------------------------------------
2158: -- lock_row for:OKL_CASH_ALLCTN_RLS_V --
2159: ----------------------------------------
2160: PROCEDURE lock_row(
2161: p_api_version IN NUMBER,
2162: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 2321: -- update_row for:OKL_CASH_ALLCTN_RLS --

2317: ---------------------------------------------------------------------------
2318: -- PROCEDURE update_row
2319: ---------------------------------------------------------------------------
2320: ----------------------------------------
2321: -- update_row for:OKL_CASH_ALLCTN_RLS --
2322: ----------------------------------------
2323: ---------------------------------------------------------------------------
2324: -- Start of comments
2325: --

Line 2327: -- Description : Update the existing row in the table OKL_CASH_ALLCTN_RLS

2323: ---------------------------------------------------------------------------
2324: -- Start of comments
2325: --
2326: -- Procedure Name : update_row
2327: -- Description : Update the existing row in the table OKL_CASH_ALLCTN_RLS
2328: -- Business Rules :
2329: -- Parameters : p_init_msg_list, x_return_status, x_msg_count, x_msg_data,
2330: -- p_cat_rec, x_cat_rec
2331: -- Version : 1.0

Line 2354: -- l_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;

2350: l_def_cat_rec cat_rec_type;
2351: l_row_notfound BOOLEAN := TRUE;
2352:
2353: -- history tables not supported -- 04 APR 2002
2354: -- l_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;
2355: -- lx_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;
2356: ----------------------------------
2357: -- FUNCTION populate_new_record --
2358: ----------------------------------

Line 2355: -- lx_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;

2351: l_row_notfound BOOLEAN := TRUE;
2352:
2353: -- history tables not supported -- 04 APR 2002
2354: -- l_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;
2355: -- lx_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;
2356: ----------------------------------
2357: -- FUNCTION populate_new_record --
2358: ----------------------------------
2359:

Line 2379: -- migrate(l_cat_rec, l_okl_cash_allctn_rls_h_rec);

2375: -- (1) to get the "old" version
2376: -- (2) to avoid 2 hits to the database
2377:
2378: -- history tables not supported -- 04 APR 2002
2379: -- migrate(l_cat_rec, l_okl_cash_allctn_rls_h_rec);
2380:
2381: IF (x_cat_rec.id = Okl_Api.G_MISS_NUM)
2382: THEN
2383: x_cat_rec.id := l_cat_rec.id;

Line 2538: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS --

2534:
2535: RETURN(l_return_status);
2536: END populate_new_record;
2537: --------------------------------------------
2538: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS --
2539: --------------------------------------------
2540:
2541: FUNCTION Set_Attributes (
2542: p_cat_rec IN cat_rec_type,

Line 2580: UPDATE OKL_CASH_ALLCTN_RLS

2576: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2577: RAISE Okl_Api.G_EXCEPTION_ERROR;
2578: END IF;
2579:
2580: UPDATE OKL_CASH_ALLCTN_RLS
2581: SET NAME = l_def_cat_rec.name,
2582: OBJECT_VERSION_NUMBER = l_def_cat_rec.object_version_number,
2583: DESCRIPTION = l_def_cat_rec.description,
2584: start_date = l_def_cat_rec.start_date,

Line 2628: l_okl_cash_allctn_rls_h_rec,

2624: p_init_msg_list,
2625: x_return_status,
2626: x_msg_count,
2627: x_msg_data,
2628: l_okl_cash_allctn_rls_h_rec,
2629: lx_okl_cash_allctn_rls_h_rec
2630: );
2631:
2632: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2629: lx_okl_cash_allctn_rls_h_rec

2625: x_return_status,
2626: x_msg_count,
2627: x_msg_data,
2628: l_okl_cash_allctn_rls_h_rec,
2629: lx_okl_cash_allctn_rls_h_rec
2630: );
2631:
2632: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2633: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2687: -- update_row for:OKL_CASH_ALLCTN_RLS_V --

2683: */
2684:
2685: END update_row;
2686: ------------------------------------------
2687: -- update_row for:OKL_CASH_ALLCTN_RLS_V --
2688: ------------------------------------------
2689: ---------------------------------------------------------------------------
2690: -- Start of comments
2691: --

Line 2693: -- Description : Update the row in the table OKL_CASH_ALLCTN_RLS.

2689: ---------------------------------------------------------------------------
2690: -- Start of comments
2691: --
2692: -- Procedure Name : update_row
2693: -- Description : Update the row in the table OKL_CASH_ALLCTN_RLS.
2694: -- Business Rules :
2695: -- Parameters : p_init_msg_list, x_return_status, x_msg_count, x_msg_data,
2696: -- p_catv_rec, x_catv_rec
2697: -- Version : 1.0

Line 2908: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS_V --

2904:
2905: RETURN(l_return_status);
2906: END populate_new_record;
2907: ----------------------------------------------
2908: -- Set_Attributes for:OKL_CASH_ALLCTN_RLS_V --
2909: ----------------------------------------------
2910: FUNCTION Set_Attributes (
2911: p_catv_rec IN catv_rec_type,
2912: x_catv_rec OUT NOCOPY catv_rec_type

Line 3128: -- delete_row for:OKL_CASH_ALLCTN_RLS --

3124: ---------------------------------------------------------------------------
3125: -- PROCEDURE delete_row
3126: ---------------------------------------------------------------------------
3127: ----------------------------------------
3128: -- delete_row for:OKL_CASH_ALLCTN_RLS --
3129: ----------------------------------------
3130: PROCEDURE delete_row(
3131: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
3132: x_return_status OUT NOCOPY VARCHAR2,

Line 3144: -- l_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;

3140: l_cat_rec cat_rec_type:= p_cat_rec;
3141: l_row_notfound BOOLEAN := TRUE;
3142:
3143: -- history tables not supported -- 04 APR 2002
3144: -- l_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;
3145: -- lx_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;
3146:
3147: BEGIN
3148: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 3145: -- lx_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;

3141: l_row_notfound BOOLEAN := TRUE;
3142:
3143: -- history tables not supported -- 04 APR 2002
3144: -- l_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;
3145: -- lx_okl_cash_allctn_rls_h_rec okl_cash_allctn_rls_h_rec_type;
3146:
3147: BEGIN
3148: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
3149: p_init_msg_list,

Line 3164: -- migrate(l_cat_rec, l_okl_cash_allctn_rls_h_rec);

3160: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3161: END IF;
3162:
3163: -- history tables not supported -- 04 APR 2002
3164: -- migrate(l_cat_rec, l_okl_cash_allctn_rls_h_rec);
3165: /*
3166: insert_row(
3167: p_init_msg_list,
3168: x_return_status,

Line 3171: l_okl_cash_allctn_rls_h_rec,

3167: p_init_msg_list,
3168: x_return_status,
3169: x_msg_count,
3170: x_msg_data,
3171: l_okl_cash_allctn_rls_h_rec,
3172: lx_okl_cash_allctn_rls_h_rec
3173: );
3174: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3175: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3172: lx_okl_cash_allctn_rls_h_rec

3168: x_return_status,
3169: x_msg_count,
3170: x_msg_data,
3171: l_okl_cash_allctn_rls_h_rec,
3172: lx_okl_cash_allctn_rls_h_rec
3173: );
3174: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3175: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3176: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3181: DELETE FROM OKL_CASH_ALLCTN_RLS

3177: RAISE Okl_Api.G_EXCEPTION_ERROR;
3178: END IF;
3179: */
3180:
3181: DELETE FROM OKL_CASH_ALLCTN_RLS
3182: WHERE ID = l_cat_rec.id;
3183:
3184: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3185: EXCEPTION

Line 3218: -- delete_row for:OKL_CASH_ALLCTN_RLS_V --

3214: '_PVT'
3215: );
3216: END delete_row;
3217: ------------------------------------------
3218: -- delete_row for:OKL_CASH_ALLCTN_RLS_V --
3219: ------------------------------------------
3220: PROCEDURE delete_row(
3221: p_api_version IN NUMBER,
3222: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,