DBA Data[Home] [Help]

APPS.CST_RECEIPTACCRUALPEREND_PVT dependencies on RCV_RECEIVING_SUB_LEDGER

Line 167: -- Create accounting entries in RCV_RECEIVING_SUB_LEDGER

163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:
166: -------------------------------------------------------------------------
167: -- Create accounting entries in RCV_RECEIVING_SUB_LEDGER
168: -------------------------------------------------------------------------
169: l_stmt_num := 60;
170: Create_AccrualAccount (
171: p_api_version => 1.0,

Line 438: -- RCV_RECEIVING_SUB_LEDGER

434: -- corresponding to po_distribution_id.
435: --
436: -- This index table will be used to map the accounting_event_id and
437: -- po_distribution_id, while creating accounting entries
438: -- RCV_RECEIVING_SUB_LEDGER
439: ---------------------------------------------------------------------
440: g_accrual_index_tbl(l_accounting_events_rec.distribution_id) := l_ctr;
441: /*Bug6987381: g_rae_pnt_event_id_tbl to be used only for encumbrance
442: reversal events

Line 642: -- RCV_RECEIVING_SUB_LEDGER.

638: ------------------------------------------------------------------------
639: -- Clear the PL/SQL tables,
640: -- Do not clear the table g_rae_event_id_tbl, since we need the
641: -- accounting_event_ids while creating accounting entries in
642: -- RCV_RECEIVING_SUB_LEDGER.
643: ------------------------------------------------------------------------
644: l_stmt_num := 70;
645: g_rae_distribution_id_tbl.DELETE;
646: g_rae_qty_received_tbl.DELETE;

Line 729: -- with the corresponding accrual info for RCV_RECEIVING_SUB_LEDGER

725: -----------------------------------------------------------------------------
726: -- PROCEDURE : Create_AccrualAccount
727: -- DESCRIPTION : The procedure fetches data from temp table
728: -- CST_PER_END_ACCRUALS_TEMP, and populates PL/SQL tables
729: -- with the corresponding accrual info for RCV_RECEIVING_SUB_LEDGER
730: -----------------------------------------------------------------------------
731: PROCEDURE Create_AccrualAccount
732: (
733: p_api_version IN NUMBER,

Line 1100: -- Insert the data in RCV_RECEIVING_SUB_LEDGER table

1096:
1097: END LOOP;
1098:
1099: -------------------------------------------------------------------------
1100: -- Insert the data in RCV_RECEIVING_SUB_LEDGER table
1101: -------------------------------------------------------------------------
1102: l_stmt_num := 160;
1103: Insert_AccrualSubLedger (
1104: p_api_version => 1.0,

Line 1115: l_msg_data := 'Failed inserting data in RCV_RECEIVING_SUB_LEDGER';

1111: p_sys_setup_rec => p_sys_setup_rec
1112: );
1113: -- If return status is not success, add message to the log
1114: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1115: l_msg_data := 'Failed inserting data in RCV_RECEIVING_SUB_LEDGER';
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: END IF;
1118:
1119: IF (g_counter = 0) THEN

Line 1492: -- Insert the data in RCV_RECEIVING_SUB_LEDGER table

1488: -------------------------------------------------------------------------
1489: IF (g_counter >= 1000) THEN
1490:
1491: -------------------------------------------------------------------------
1492: -- Insert the data in RCV_RECEIVING_SUB_LEDGER table
1493: -------------------------------------------------------------------------
1494: l_stmt_num := 40;
1495: Insert_AccrualSubLedger (
1496: p_api_version => 1.0,

Line 1507: l_msg_data := 'Failed inserting data in RCV_RECEIVING_SUB_LEDGER';

1503: p_sys_setup_rec => p_sys_setup_rec
1504: );
1505: -- If return status is not success, add message to the log
1506: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1507: l_msg_data := 'Failed inserting data in RCV_RECEIVING_SUB_LEDGER';
1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1509: END IF;
1510:
1511: END IF;

Line 1584: -- DESCRIPTION : Insert accounting entries in RCV_RECEIVING_SUB_LEDGER

1580: END Insert_Account;
1581:
1582: -----------------------------------------------------------------------------
1583: -- PROCEDURE : Insert_AccrualSubLedger
1584: -- DESCRIPTION : Insert accounting entries in RCV_RECEIVING_SUB_LEDGER
1585: ----------------------------------------------------------------------------
1586: PROCEDURE Insert_AccrualSubLedger
1587: (
1588: p_api_version IN NUMBER,

Line 1656: -- Bulk insert the values in RCV_RECEIVING_SUB_LEDGER

1652: l_user_id := FND_GLOBAL.USER_ID;
1653: l_login_id := FND_GLOBAL.LOGIN_ID;
1654:
1655: -------------------------------------------------------------------------
1656: -- Bulk insert the values in RCV_RECEIVING_SUB_LEDGER
1657: -------------------------------------------------------------------------
1658: l_stmt_num := 20;
1659: FORALL l_ctr IN g_distribution_id_tbl.FIRST..g_distribution_id_tbl.LAST
1660: INSERT INTO rcv_receiving_sub_ledger (

Line 1660: INSERT INTO rcv_receiving_sub_ledger (

1656: -- Bulk insert the values in RCV_RECEIVING_SUB_LEDGER
1657: -------------------------------------------------------------------------
1658: l_stmt_num := 20;
1659: FORALL l_ctr IN g_distribution_id_tbl.FIRST..g_distribution_id_tbl.LAST
1660: INSERT INTO rcv_receiving_sub_ledger (
1661: rcv_sub_ledger_id,
1662: rcv_transaction_id,
1663: last_update_date,
1664: last_updated_by,

Line 1701: rcv_receiving_sub_ledger_s.nextval,

1697: accounting_event_id,
1698: accounting_line_type
1699: )
1700: VALUES (
1701: rcv_receiving_sub_ledger_s.nextval,
1702: 0,
1703: SYSDATE,
1704: l_user_id,
1705: SYSDATE,