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 1105: -- Insert the data in RCV_RECEIVING_SUB_LEDGER table

1101:
1102: END LOOP;
1103:
1104: -------------------------------------------------------------------------
1105: -- Insert the data in RCV_RECEIVING_SUB_LEDGER table
1106: -------------------------------------------------------------------------
1107: l_stmt_num := 160;
1108: Insert_AccrualSubLedger (
1109: p_api_version => 1.0,

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

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

Line 1381: -- Insert the data in RCV_RECEIVING_SUB_LEDGER table

1377: -------------------------------------------------------------------------
1378: IF (g_counter >= 1000) THEN
1379:
1380: -------------------------------------------------------------------------
1381: -- Insert the data in RCV_RECEIVING_SUB_LEDGER table
1382: -------------------------------------------------------------------------
1383: l_stmt_num := 40;
1384: Insert_AccrualSubLedger (
1385: p_api_version => 1.0,

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

1392: p_sys_setup_rec => p_sys_setup_rec
1393: );
1394: -- If return status is not success, add message to the log
1395: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1396: l_msg_data := 'Failed inserting data in RCV_RECEIVING_SUB_LEDGER';
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: END IF;
1399:
1400: END IF;

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

1469: END Insert_Account;
1470:
1471: -----------------------------------------------------------------------------
1472: -- PROCEDURE : Insert_AccrualSubLedger
1473: -- DESCRIPTION : Insert accounting entries in RCV_RECEIVING_SUB_LEDGER
1474: ----------------------------------------------------------------------------
1475: PROCEDURE Insert_AccrualSubLedger
1476: (
1477: p_api_version IN NUMBER,

Line 1545: -- Bulk insert the values in RCV_RECEIVING_SUB_LEDGER

1541: l_user_id := FND_GLOBAL.USER_ID;
1542: l_login_id := FND_GLOBAL.LOGIN_ID;
1543:
1544: -------------------------------------------------------------------------
1545: -- Bulk insert the values in RCV_RECEIVING_SUB_LEDGER
1546: -------------------------------------------------------------------------
1547: l_stmt_num := 20;
1548: FORALL l_ctr IN g_distribution_id_tbl.FIRST..g_distribution_id_tbl.LAST
1549: INSERT INTO rcv_receiving_sub_ledger (

Line 1549: INSERT INTO rcv_receiving_sub_ledger (

1545: -- Bulk insert the values in RCV_RECEIVING_SUB_LEDGER
1546: -------------------------------------------------------------------------
1547: l_stmt_num := 20;
1548: FORALL l_ctr IN g_distribution_id_tbl.FIRST..g_distribution_id_tbl.LAST
1549: INSERT INTO rcv_receiving_sub_ledger (
1550: rcv_sub_ledger_id,
1551: rcv_transaction_id,
1552: last_update_date,
1553: last_updated_by,

Line 1590: DECODE( g_actual_flag_tbl(l_ctr),'E',-1,1) * rcv_receiving_sub_ledger_s.nextval,

1586: accounting_event_id,
1587: accounting_line_type
1588: )
1589: VALUES (
1590: DECODE( g_actual_flag_tbl(l_ctr),'E',-1,1) * rcv_receiving_sub_ledger_s.nextval,
1591: 0,
1592: SYSDATE,
1593: l_user_id,
1594: SYSDATE,