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.RCV_SEEDEVENTS_PVT dependencies on RCV_SEEDEVENTS_PVT

Line 1: PACKAGE BODY RCV_SeedEvents_PVT AS

1: PACKAGE BODY RCV_SeedEvents_PVT AS
2: /* $Header: RCVVRUTB.pls 120.14 2010/12/30 18:46:21 hyu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_SeedEvents_PVT';
5: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_SeedEvents_PVT';

1: PACKAGE BODY RCV_SeedEvents_PVT AS
2: /* $Header: RCVVRUTB.pls 120.14 2010/12/30 18:46:21 hyu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_SeedEvents_PVT';
5: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'po.plsql.'||G_PKG_NAME;
7:
8: -- API name : Seed_RAEEvent

Line 42: -- x_rcv_event OUT RCV_SeedEvents_PVT.rcv_event_tbl_type;

38: --
39: -- OUT : x_return_status OUT VARCHAR2(1)
40: -- x_msg_count OUT NUMBER
41: -- x_msg_data OUT VARCHAR2(2000)
42: -- x_rcv_event OUT RCV_SeedEvents_PVT.rcv_event_tbl_type;
43: -- Version :
44: -- Initial version 1.0
45: --
46: --

Line 81: x_rcv_event OUT NOCOPY RCV_SeedEvents_PVT.rcv_event_rec_type

77: p_unit_price IN NUMBER,
78: p_prior_unit_price IN NUMBER,
79: /* Support for Landed Cost Management */
80: p_lcm_flag IN VARCHAR2,
81: x_rcv_event OUT NOCOPY RCV_SeedEvents_PVT.rcv_event_rec_type
82:
83:
84: ) IS
85: l_api_name CONSTANT VARCHAR2(30) := 'Seed_RAEEvent';

Line 94: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;

90: l_msg_data VARCHAR2(8000) := '';
91: l_stmt_num NUMBER := 0;
92: l_api_message VARCHAR2(1000);
93:
94: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
95: l_transaction_amount NUMBER := 0;
96: l_source_doc_quantity NUMBER := 0;
97: l_transaction_quantity NUMBER := 0;
98: l_ic_pricing_option NUMBER := 1;

Line 325: IF (p_event_type_id IN (RCV_SeedEvents_PVT.ADJUST_RECEIVE, RCV_SeedEvents_PVT.ADJUST_DELIVER,

321: WHERE organization_id = p_organization_id;
322:
323:
324: -- Initialize transaction date
325: IF (p_event_type_id IN (RCV_SeedEvents_PVT.ADJUST_RECEIVE, RCV_SeedEvents_PVT.ADJUST_DELIVER,
326: RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
327: l_rcv_event.transaction_date := SYSDATE;
328: END IF;
329:

Line 326: RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN

322:
323:
324: -- Initialize transaction date
325: IF (p_event_type_id IN (RCV_SeedEvents_PVT.ADJUST_RECEIVE, RCV_SeedEvents_PVT.ADJUST_DELIVER,
326: RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
327: l_rcv_event.transaction_date := SYSDATE;
328: END IF;
329:
330: -- Encumbrance cannot be enabled for global procurement scenarios.

Line 347: RCV_SeedEvents_PVT.Check_EncumbranceFlag(

343: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
344: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
345: ,'Checking if encumbrance is enabled.');
346: END IF;
347: RCV_SeedEvents_PVT.Check_EncumbranceFlag(
348: p_api_version => 1.0,
349: x_return_status => l_return_status,
350: x_msg_count => l_msg_count,
351: x_msg_data => l_msg_data,

Line 379: IF(p_event_type_id IN (RCV_SeedEvents_PVT.ADJUST_RECEIVE,RCV_SeedEvents_PVT.ADJUST_DELIVER)) THEN

375: l_stmt_num := 90;
376:
377:
378: -- Initialize Unit Price
379: IF(p_event_type_id IN (RCV_SeedEvents_PVT.ADJUST_RECEIVE,RCV_SeedEvents_PVT.ADJUST_DELIVER)) THEN
380: l_rcv_event.unit_price := p_unit_price;
381: l_rcv_event.prior_unit_price := p_prior_unit_price;
382: ELSIF l_rcv_event.service_flag = 'Y' THEN
383: l_stmt_num := 100;

Line 414: IF (p_event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,

410: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
411: ,'Non Service Line Type : Getting Unit Price');
412: END IF;
413:
414: IF (p_event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
415: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
416: l_asset_option := p_transaction_reverse_flow_rec.asset_item_pricing_option;
417: l_expense_option := p_transaction_reverse_flow_rec.expense_item_pricing_option;
418: ELSE

Line 415: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN

411: ,'Non Service Line Type : Getting Unit Price');
412: END IF;
413:
414: IF (p_event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
415: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
416: l_asset_option := p_transaction_reverse_flow_rec.asset_item_pricing_option;
417: l_expense_option := p_transaction_reverse_flow_rec.expense_item_pricing_option;
418: ELSE
419: l_asset_option := p_transaction_forward_flow_rec.asset_item_pricing_option;

Line 701: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required

697: -- p_commit IN VARCHAR2 Optional
698: -- Default = FND_API.G_FALSE
699: -- p_validation_level IN NUMBER Optional
700: -- Default = FND_API.G_VALID_LEVEL_FULL
701: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required
702: --
703: -- OUT : x_return_status OUT VARCHAR2(1)
704: -- x_msg_count OUT NUMBER
705: -- x_msg_data OUT VARCHAR2(2000)

Line 723: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,

719: x_return_status OUT NOCOPY VARCHAR2,
720: x_msg_count OUT NOCOPY NUMBER,
721: x_msg_data OUT NOCOPY VARCHAR2,
722:
723: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,
724: x_transaction_amount OUT NOCOPY NUMBER
725: ) IS
726: l_api_name CONSTANT VARCHAR2(30) := 'Get_TransactionAmount';
727: l_api_version CONSTANT NUMBER := 1.0;

Line 813: IF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN

809: -- For encumbrance reversal events , only reverse encumbrance
810: -- upto amount_ordered. If amount received exceeds the
811: -- ordered amount, transaction amount should be reduced such that
812: -- it does not exceed amount ordered.
813: IF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN
814: l_abs_rt_amount := ABS(l_transaction_amount);
815:
816: l_stmt_num := 40;
817: SELECT RT.transaction_type, RT.parent_transaction_id

Line 955: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required

951: -- p_commit IN VARCHAR2 Optional
952: -- Default = FND_API.G_FALSE
953: -- p_validation_level IN NUMBER Optional
954: -- Default = FND_API.G_VALID_LEVEL_FULL
955: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required
956: --
957: -- OUT : x_return_status OUT VARCHAR2(1)
958: -- x_msg_count OUT NUMBER
959: -- x_msg_data OUT VARCHAR2(2000)

Line 978: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,

974: x_return_status OUT NOCOPY VARCHAR2,
975: x_msg_count OUT NOCOPY NUMBER,
976: x_msg_data OUT NOCOPY VARCHAR2,
977:
978: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,
979: x_source_doc_quantity OUT NOCOPY NUMBER
980: ) IS
981: l_api_name CONSTANT VARCHAR2(30) := 'Get_Quantity';
982: l_api_version CONSTANT NUMBER := 1.0;

Line 1045: IF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ADJUST_RECEIVE) THEN

1041: AND POLL.line_location_id = p_rcv_event.po_line_location_id
1042: AND POD.po_distribution_id = p_rcv_event.po_distribution_id;
1043:
1044: ELSIF (p_rcv_event.event_source = 'RETROPRICE') THEN
1045: IF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ADJUST_RECEIVE) THEN
1046: l_stmt_num := 30;
1047: l_source_doc_quantity := RCV_ACCRUAL_SV.get_received_quantity(p_rcv_event.rcv_transaction_id, sysdate);
1048: ELSE
1049: l_stmt_num := 40;

Line 1071: IF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN

1067: -- For encumbrance reversal events only match
1068: -- upto quantity_ordered. If quantity received/invoiced exceeds the
1069: -- ordered quantity, transaction quantity should be reduced such that
1070: -- it does not exceed quantity ordered.
1071: IF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN
1072: l_abs_rt_quantity := ABS(l_source_doc_quantity);
1073:
1074: l_stmt_num := 60;
1075: SELECT RT.transaction_type, RT.parent_transaction_id

Line 1225: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required

1221: -- p_commit IN VARCHAR2 Optional
1222: -- Default = FND_API.G_FALSE
1223: -- p_validation_level IN NUMBER Optional
1224: -- Default = FND_API.G_VALID_LEVEL_FULL
1225: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required
1226: -- p_lcm_flag IN VARCHAR2 Optional
1227: --
1228: -- OUT : x_return_status OUT VARCHAR2(1)
1229: -- x_msg_count OUT NUMBER

Line 1251: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,

1247: p_validation_level IN NUMBER,
1248: x_return_status OUT NOCOPY VARCHAR2,
1249: x_msg_count OUT NOCOPY NUMBER,
1250: x_msg_data OUT NOCOPY VARCHAR2,
1251: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,
1252: p_asset_item_pricing_option IN NUMBER,
1253: p_expense_item_pricing_option IN NUMBER,
1254: /* Support for Landed Cost Management */
1255: p_lcm_flag IN VARCHAR2,

Line 1332: p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,

1328: IF(p_rcv_event.trx_flow_header_id IS NULL OR
1329: p_rcv_event.item_id IS NULL OR
1330: p_rcv_event.destination_type_code = 'SHOP FLOOR' OR
1331: (p_rcv_event.procurement_org_flag = 'Y' AND
1332: p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
1333: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))
1334: ) THEN
1335: l_ic_pricing_option := 1;
1336:

Line 1333: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))

1329: p_rcv_event.item_id IS NULL OR
1330: p_rcv_event.destination_type_code = 'SHOP FLOOR' OR
1331: (p_rcv_event.procurement_org_flag = 'Y' AND
1332: p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
1333: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))
1334: ) THEN
1335: l_ic_pricing_option := 1;
1336:
1337: ELSE

Line 1411: IF(p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,

1407: -- passed. For Intercompany events, the from organization id is the same as
1408: -- organization_id on the event. For the remaining events, the from organization
1409: -- is the transfer_organization_id on the event.
1410:
1411: IF(p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
1412: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
1413: l_from_organization_id := p_rcv_event.organization_id;
1414: l_from_org_id := p_rcv_event.org_id;
1415: l_to_org_id := p_rcv_event.transfer_org_id;

Line 1412: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN

1408: -- organization_id on the event. For the remaining events, the from organization
1409: -- is the transfer_organization_id on the event.
1410:
1411: IF(p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
1412: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
1413: l_from_organization_id := p_rcv_event.organization_id;
1414: l_from_org_id := p_rcv_event.org_id;
1415: l_to_org_id := p_rcv_event.transfer_org_id;
1416: ELSE

Line 1585: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required

1581: -- p_commit IN VARCHAR2 Optional
1582: -- Default = FND_API.G_FALSE
1583: -- p_validation_level IN NUMBER Optional
1584: -- Default = FND_API.G_VALID_LEVEL_FULL
1585: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required
1586: --
1587: -- OUT : x_return_status OUT VARCHAR2(1)
1588: -- x_msg_count OUT NUMBER
1589: -- x_msg_data OUT VARCHAR2(2000)

Line 1610: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,

1606: x_return_status OUT NOCOPY VARCHAR2,
1607: x_msg_count OUT NOCOPY NUMBER,
1608: x_msg_data OUT NOCOPY VARCHAR2,
1609:
1610: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,
1611: x_unit_nr_tax OUT NOCOPY NUMBER,
1612: x_unit_rec_tax OUT NOCOPY NUMBER,
1613: x_prior_nr_tax OUT NOCOPY NUMBER,
1614: x_prior_rec_tax OUT NOCOPY NUMBER

Line 1720: IF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN

1716:
1717: /* Bug 6405593 :Added hook call to override the recoverable and Non-Recoverable
1718: taxes for ENCUMBRANCE_REVERSAL event */
1719:
1720: IF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN
1721: l_stmt_num := 25;
1722: l_hook_used := CST_Common_hooks.Get_NRtax_amount(
1723: I_ACCT_TXN_ID =>p_rcv_event.rcv_transaction_id,
1724: I_SOURCE_DOC_TYPE =>'PO',

Line 1909: P_EVENT_REC IN RCV_SeedEvents_PVT.rcv_event_rec_type,

1905: P_VALIDATION_LEVEL IN NUMBER, -- := FND_API.G_VALID_LEVEL_FULL,
1906: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1907: X_MSG_COUNT OUT NOCOPY NUMBER,
1908: X_MSG_DATA OUT NOCOPY VARCHAR2,
1909: P_EVENT_REC IN RCV_SeedEvents_PVT.rcv_event_rec_type,
1910: X_TRANSACTION_QTY OUT NOCOPY NUMBER,
1911: X_PRIMARY_UOM OUT NOCOPY MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE,
1912: X_PRIMARY_QTY OUT NOCOPY NUMBER,
1913: X_TRX_UOM_CODE OUT NOCOPY VARCHAR2

Line 2178: P_RCV_EVENT IN RCV_SeedEvents_PVT.rcv_event_rec_type,

2174: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2175: X_MSG_COUNT OUT NOCOPY NUMBER,
2176: X_MSG_DATA OUT NOCOPY VARCHAR2,
2177:
2178: P_RCV_EVENT IN RCV_SeedEvents_PVT.rcv_event_rec_type,
2179: X_CURRENCY_CODE OUT NOCOPY VARCHAR2,
2180: X_CURRENCY_CONVERSION_RATE OUT NOCOPY NUMBER,
2181: X_CURRENCY_CONVERSION_DATE OUT NOCOPY DATE,
2182: X_CURRENCY_CONVERSION_TYPE OUT NOCOPY VARCHAR2

Line 2228: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,

2224: -- API body
2225: l_stmt_num := 10;
2226:
2227: IF ((p_rcv_event.procurement_org_flag = 'Y') AND
2228: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2229: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))) THEN
2230:
2231: l_currency_code := p_rcv_event.currency_code;
2232:

Line 2229: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))) THEN

2225: l_stmt_num := 10;
2226:
2227: IF ((p_rcv_event.procurement_org_flag = 'Y') AND
2228: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2229: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))) THEN
2230:
2231: l_currency_code := p_rcv_event.currency_code;
2232:
2233: l_stmt_num := 20;

Line 2246: IF (l_match_option = 'P' OR (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL)) THEN

2242: FROM po_line_locations
2243: WHERE line_location_id = l_po_line_location_id;
2244:
2245: -- Always use rate on the PO distribution for encumbrance reversals.
2246: IF (l_match_option = 'P' OR (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL)) THEN
2247:
2248: l_stmt_num := 40;
2249: SELECT nvl(POD.rate,1),
2250: POH.rate_type,

Line 2404: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required

2400: -- p_commit IN VARCHAR2 Optional
2401: -- Default = FND_API.G_FALSE
2402: -- p_validation_level IN NUMBER Optional
2403: -- Default = FND_API.G_VALID_LEVEL_FULL
2404: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required
2405: -- p_transaction_forward_flow_rec mtl_transaction_flow_rec_type,
2406: -- p_transaction_reverse_flow_rec mtl_transaction_flow_rec_type,
2407: --
2408: -- OUT : x_return_status OUT VARCHAR2(1)

Line 2431: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,

2427: x_return_status OUT NOCOPY VARCHAR2,
2428: x_msg_count OUT NOCOPY NUMBER,
2429: x_msg_data OUT NOCOPY VARCHAR2,
2430:
2431: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,
2432: p_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type,
2433: p_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type,
2434: /* Support for Landed Cost Management */
2435: p_lcm_flag IN VARCHAR2,

Line 2509: IF(p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,

2505: x_lcm_acct_id := NULL;
2506:
2507: -- No accounts are stored for IC events.
2508: l_stmt_num := 5;
2509: IF(p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2510: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
2511: return;
2512: END IF;
2513:

Line 2510: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN

2506:
2507: -- No accounts are stored for IC events.
2508: l_stmt_num := 5;
2509: IF(p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2510: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
2511: return;
2512: END IF;
2513:
2514: l_stmt_num := 10;

Line 2546: p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.RECEIVE, RCV_SeedEvents_PVT.MATCH,

2542: -- where encumbrance is enabled. Hence this is not applicable to Global Procurement,
2543: -- Drop Ship or retroactive pricing.
2544: -- Modified for bug #4893292: Call API to override balance segment for inventory destinations as well.
2545: IF(p_rcv_event.trx_flow_header_id IS NULL AND
2546: p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.RECEIVE, RCV_SeedEvents_PVT.MATCH,
2547: RCV_SeedEvents_PVT.DELIVER, RCV_SeedEvents_PVT.CORRECT,
2548: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING,
2549: RCV_SeedEvents_PVT.RETURN_TO_VENDOR) AND
2550: p_rcv_event.destination_type_code IN ('EXPENSE', 'INVENTORY')) THEN

Line 2547: RCV_SeedEvents_PVT.DELIVER, RCV_SeedEvents_PVT.CORRECT,

2543: -- Drop Ship or retroactive pricing.
2544: -- Modified for bug #4893292: Call API to override balance segment for inventory destinations as well.
2545: IF(p_rcv_event.trx_flow_header_id IS NULL AND
2546: p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.RECEIVE, RCV_SeedEvents_PVT.MATCH,
2547: RCV_SeedEvents_PVT.DELIVER, RCV_SeedEvents_PVT.CORRECT,
2548: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING,
2549: RCV_SeedEvents_PVT.RETURN_TO_VENDOR) AND
2550: p_rcv_event.destination_type_code IN ('EXPENSE', 'INVENTORY')) THEN
2551:

Line 2548: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING,

2544: -- Modified for bug #4893292: Call API to override balance segment for inventory destinations as well.
2545: IF(p_rcv_event.trx_flow_header_id IS NULL AND
2546: p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.RECEIVE, RCV_SeedEvents_PVT.MATCH,
2547: RCV_SeedEvents_PVT.DELIVER, RCV_SeedEvents_PVT.CORRECT,
2548: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING,
2549: RCV_SeedEvents_PVT.RETURN_TO_VENDOR) AND
2550: p_rcv_event.destination_type_code IN ('EXPENSE', 'INVENTORY')) THEN
2551:
2552: l_stmt_num := 30;

Line 2549: RCV_SeedEvents_PVT.RETURN_TO_VENDOR) AND

2545: IF(p_rcv_event.trx_flow_header_id IS NULL AND
2546: p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.RECEIVE, RCV_SeedEvents_PVT.MATCH,
2547: RCV_SeedEvents_PVT.DELIVER, RCV_SeedEvents_PVT.CORRECT,
2548: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING,
2549: RCV_SeedEvents_PVT.RETURN_TO_VENDOR) AND
2550: p_rcv_event.destination_type_code IN ('EXPENSE', 'INVENTORY')) THEN
2551:
2552: l_stmt_num := 30;
2553: PO_Accounting_GRP.build_offset_account

Line 2568: IF( p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT) THEN

2564: l_receiving_insp_acct_id := l_overlaid_acct;
2565:
2566: END IF;
2567:
2568: IF( p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT) THEN
2569:
2570: l_stmt_num := 40;
2571: SELECT PARENT_TRX.transaction_type
2572: INTO l_parent_trx_type

Line 2580: IF((p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RECEIVE) OR

2576: AND TRX.parent_transaction_id = PARENT_TRX.transaction_id;
2577: END IF;
2578:
2579: l_stmt_num := 50;
2580: IF((p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RECEIVE) OR
2581: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.MATCH) OR
2582: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2583: l_parent_trx_type = 'RECEIVE') OR
2584: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND

Line 2581: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.MATCH) OR

2577: END IF;
2578:
2579: l_stmt_num := 50;
2580: IF((p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RECEIVE) OR
2581: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.MATCH) OR
2582: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2583: l_parent_trx_type = 'RECEIVE') OR
2584: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2585: l_parent_trx_type = 'MATCH') THEN

Line 2582: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND

2578:
2579: l_stmt_num := 50;
2580: IF((p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RECEIVE) OR
2581: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.MATCH) OR
2582: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2583: l_parent_trx_type = 'RECEIVE') OR
2584: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2585: l_parent_trx_type = 'MATCH') THEN
2586:

Line 2584: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND

2580: IF((p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RECEIVE) OR
2581: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.MATCH) OR
2582: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2583: l_parent_trx_type = 'RECEIVE') OR
2584: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2585: l_parent_trx_type = 'MATCH') THEN
2586:
2587: l_debit_acct_id := l_receiving_insp_acct_id;
2588:

Line 2597: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.LOGICAL_RECEIVE) THEN

2593: ELSE
2594: l_credit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2595: END IF;
2596:
2597: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.LOGICAL_RECEIVE) THEN
2598:
2599: -- Use clearing account for :
2600: -- a. destination type of Inventory
2601: -- b. destination type of Expense for inventory items.

Line 2619: RCV_SeedEvents_PVT.Get_HookAccount(

2615: FROM mtl_parameters MP
2616: WHERE MP.organization_id = p_rcv_event.organization_id;
2617:
2618: l_stmt_num := 70;
2619: RCV_SeedEvents_PVT.Get_HookAccount(
2620: p_api_version => l_api_version,
2621: x_return_status => l_return_status,
2622: x_msg_count => l_msg_count,
2623: x_msg_data => l_msg_data,

Line 2655: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.DELIVER OR

2651: ELSE
2652: l_credit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2653: END IF;
2654:
2655: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.DELIVER OR
2656: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2657: l_parent_trx_type = 'DELIVER')) THEN
2658: l_debit_acct_id := l_dest_pod_ccid;
2659: l_credit_acct_id := l_receiving_insp_acct_id;

Line 2656: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND

2652: l_credit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2653: END IF;
2654:
2655: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.DELIVER OR
2656: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2657: l_parent_trx_type = 'DELIVER')) THEN
2658: l_debit_acct_id := l_dest_pod_ccid;
2659: l_credit_acct_id := l_receiving_insp_acct_id;
2660:

Line 2661: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RETURN_TO_VENDOR OR

2657: l_parent_trx_type = 'DELIVER')) THEN
2658: l_debit_acct_id := l_dest_pod_ccid;
2659: l_credit_acct_id := l_receiving_insp_acct_id;
2660:
2661: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RETURN_TO_VENDOR OR
2662: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2663: l_parent_trx_type = 'RETURN TO VENDOR')) THEN
2664: l_credit_acct_id := l_receiving_insp_acct_id;
2665:

Line 2662: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND

2658: l_debit_acct_id := l_dest_pod_ccid;
2659: l_credit_acct_id := l_receiving_insp_acct_id;
2660:
2661: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RETURN_TO_VENDOR OR
2662: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2663: l_parent_trx_type = 'RETURN TO VENDOR')) THEN
2664: l_credit_acct_id := l_receiving_insp_acct_id;
2665:
2666: IF(p_rcv_event.procurement_org_flag = 'Y') THEN

Line 2674: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.LOGICAL_RETURN_TO_VENDOR) THEN

2670: ELSE
2671: l_debit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2672: END IF;
2673:
2674: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.LOGICAL_RETURN_TO_VENDOR) THEN
2675: IF(p_rcv_event.destination_type_code = 'INVENTORY' OR
2676: (p_rcv_event.destination_type_code = 'EXPENSE' AND
2677: p_rcv_event.item_id is not null)) THEN
2678: l_credit_acct_id := l_clearing_acct_id;

Line 2689: RCV_SeedEvents_PVT.Get_HookAccount(

2685: FROM mtl_parameters MP
2686: WHERE MP.organization_id = p_rcv_event.organization_id;
2687:
2688: l_stmt_num := 100;
2689: RCV_SeedEvents_PVT.Get_HookAccount(
2690: p_api_version => l_api_version,
2691: x_return_status => l_return_status,
2692: x_msg_count => l_msg_count,
2693: x_msg_data => l_msg_data,

Line 2724: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RETURN_TO_RECEIVING OR

2720: ELSE
2721: l_debit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2722: END IF;
2723:
2724: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RETURN_TO_RECEIVING OR
2725: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2726: l_parent_trx_type = 'RETURN TO RECEIVING')) THEN
2727: l_credit_acct_id := l_dest_pod_ccid;
2728: l_debit_acct_id := l_receiving_insp_acct_id;

Line 2725: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND

2721: l_debit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2722: END IF;
2723:
2724: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RETURN_TO_RECEIVING OR
2725: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2726: l_parent_trx_type = 'RETURN TO RECEIVING')) THEN
2727: l_credit_acct_id := l_dest_pod_ccid;
2728: l_debit_acct_id := l_receiving_insp_acct_id;
2729:

Line 2730: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ADJUST_RECEIVE) THEN

2726: l_parent_trx_type = 'RETURN TO RECEIVING')) THEN
2727: l_credit_acct_id := l_dest_pod_ccid;
2728: l_debit_acct_id := l_receiving_insp_acct_id;
2729:
2730: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ADJUST_RECEIVE) THEN
2731: -- In the case of drop shipments, we always use the clearing account instead of the Receiving
2732: -- Inspection account. In these scenarios, we should be posting the adjustment for the entire
2733: -- Receipt to the retroactive price adjustment account.
2734: IF(p_rcv_event.trx_flow_header_id IS NOT NULL OR p_rcv_event.drop_ship_flag IN (1,2)) THEN

Line 2744: RCV_SeedEvents_PVT.Get_HookAccount(

2740: IF ( p_rcv_event.item_id IS NOT NULL OR
2741: p_rcv_event.destination_type_code = 'SHOP FLOOR') THEN
2742:
2743: l_stmt_num := 110;
2744: RCV_SeedEvents_PVT.Get_HookAccount(
2745: p_api_version => l_api_version,
2746: x_return_status => l_return_status,
2747: x_msg_count => l_msg_count,
2748: x_msg_data => l_msg_data,

Line 2778: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ADJUST_DELIVER) THEN

2774: END IF;
2775:
2776: l_credit_acct_id := l_pod_accrual_acct_id;
2777:
2778: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ADJUST_DELIVER) THEN
2779:
2780: -- Redundant check. Transaction flow header id is always NULL. We only
2781: -- get ADJUST_RECEIVE events for global procurement.
2782: /* Modified for bug 8832353

Line 2790: RCV_SeedEvents_PVT.Get_HookAccount(

2786: l_debit_acct_id := l_dest_pod_ccid;
2787: ELSE
2788:
2789: l_stmt_num := 120;
2790: RCV_SeedEvents_PVT.Get_HookAccount(
2791: p_api_version => l_api_version,
2792: x_return_status => l_return_status,
2793: x_msg_count => l_msg_count,
2794: x_msg_data => l_msg_data,

Line 2820: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE OR

2816: l_stmt_num := 130;
2817: l_credit_acct_id := l_receiving_insp_acct_id;
2818: END IF;
2819:
2820: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE OR
2821: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)THEN
2822: l_credit_acct_id := NULL;
2823: l_debit_acct_id := NULL;
2824:

Line 2821: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)THEN

2817: l_credit_acct_id := l_receiving_insp_acct_id;
2818: END IF;
2819:
2820: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE OR
2821: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)THEN
2822: l_credit_acct_id := NULL;
2823: l_debit_acct_id := NULL;
2824:
2825: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN

Line 2825: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN

2821: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)THEN
2822: l_credit_acct_id := NULL;
2823: l_debit_acct_id := NULL;
2824:
2825: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN
2826:
2827:
2828: l_stmt_num := 140;
2829: SELECT RT.transaction_type, RT.parent_transaction_id

Line 2874: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,

2870: ,l_api_message);
2871: END IF;
2872:
2873: IF ((l_debit_acct_id IS NULL OR l_credit_acct_id IS NULL) AND
2874: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2875: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,
2876: RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL))) THEN
2877: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2878: l_api_message := 'Unable to find credit and/or debit account. Setup is incomplete. ';

Line 2875: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,

2871: END IF;
2872:
2873: IF ((l_debit_acct_id IS NULL OR l_credit_acct_id IS NULL) AND
2874: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2875: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,
2876: RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL))) THEN
2877: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2878: l_api_message := 'Unable to find credit and/or debit account. Setup is incomplete. ';
2879: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

Line 2876: RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL))) THEN

2872:
2873: IF ((l_debit_acct_id IS NULL OR l_credit_acct_id IS NULL) AND
2874: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2875: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,
2876: RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL))) THEN
2877: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2878: l_api_message := 'Unable to find credit and/or debit account. Setup is incomplete. ';
2879: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2880: ,l_api_message);

Line 3152: -- p_rcv_events_tbl IN RCV_SeedEvents_PVT.rcv_event_tbl_type Required

3148: -- p_commit IN VARCHAR2 Optional
3149: -- Default = FND_API.G_FALSE
3150: -- p_validation_level IN NUMBER Optional
3151: -- Default = FND_API.G_VALID_LEVEL_FULL
3152: -- p_rcv_events_tbl IN RCV_SeedEvents_PVT.rcv_event_tbl_type Required
3153: --
3154: -- OUT : x_return_status OUT VARCHAR2(1)
3155: -- x_msg_count OUT NUMBER
3156: -- x_msg_data OUT VARCHAR2(2000)

Line 3174: p_rcv_events_tbl IN RCV_SeedEvents_PVT.rcv_event_tbl_type,

3170: x_return_status OUT NOCOPY VARCHAR2,
3171: x_msg_count OUT NOCOPY NUMBER,
3172: x_msg_data OUT NOCOPY VARCHAR2,
3173:
3174: p_rcv_events_tbl IN RCV_SeedEvents_PVT.rcv_event_tbl_type,
3175: /* Support for Landed Cost Management */
3176: p_lcm_flag IN VARCHAR2
3177: ) IS
3178: l_api_name CONSTANT VARCHAR2(30) := 'Insert_RAEEvents';

Line 3403: RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,'N',

3399: p_rcv_events_tbl(i).procurement_org_flag,
3400: p_rcv_events_tbl(i).Cross_ou_flag,
3401: p_rcv_events_tbl(i).trx_flow_header_id,
3402: decode(p_rcv_events_tbl(i).event_type_id,
3403: RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,'N',
3404: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,'N',NULL),
3405: 'N', -- Will be changed by PA process
3406: /* Support for Landed Cost Management */
3407: p_rcv_events_tbl(i).unit_landed_cost

Line 3404: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,'N',NULL),

3400: p_rcv_events_tbl(i).Cross_ou_flag,
3401: p_rcv_events_tbl(i).trx_flow_header_id,
3402: decode(p_rcv_events_tbl(i).event_type_id,
3403: RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,'N',
3404: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,'N',NULL),
3405: 'N', -- Will be changed by PA process
3406: /* Support for Landed Cost Management */
3407: p_rcv_events_tbl(i).unit_landed_cost
3408: FROM DUAL);

Line 3425: (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN

3421: be done online. */
3422: IF ((l_accrue_on_receipt_flag = 'Y' OR
3423: p_rcv_events_tbl(i).procurement_org_flag = 'N') AND
3424: p_rcv_events_tbl(i).event_type_id NOT IN
3425: (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
3426: l_stmt_num := 50;
3427: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3428: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3429: ,'Creating accounting entries in RRS');

Line 3748: P_RCV_EVENTS_TBL IN RCV_SeedEvents_PVT.rcv_event_tbl_type

3744: P_VALIDATION_LEVEL IN NUMBER,
3745: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3746: X_MSG_COUNT OUT NOCOPY NUMBER,
3747: X_MSG_DATA OUT NOCOPY VARCHAR2,
3748: P_RCV_EVENTS_TBL IN RCV_SeedEvents_PVT.rcv_event_tbl_type
3749: ) IS
3750: l_api_name CONSTANT VARCHAR2(30) := 'Insert_MMTEvents';
3751: l_api_version CONSTANT NUMBER := 1.0;
3752: l_api_message VARCHAR2(1000);

Line 3844: IF (p_rcv_events_tbl(l_ctr).event_type_id = RCV_SeedEvents_PVT.LOGICAL_RECEIVE) THEN

3840: -- will follow this logic for both transactions.
3841:
3842: l_transfer_organization_id := p_rcv_events_tbl(p_rcv_events_tbl.NEXT(l_ctr)).organization_id;
3843:
3844: IF (p_rcv_events_tbl(l_ctr).event_type_id = RCV_SeedEvents_PVT.LOGICAL_RECEIVE) THEN
3845:
3846: l_inv_trx_tbl_ctr := l_inv_trx_tbl_ctr + 1;
3847: IF (p_rcv_events_tbl(l_ctr).intercompany_pricing_option = 2) then
3848: l_intercompany_price := p_rcv_events_tbl(l_ctr).intercompany_price;

Line 3952: ELSIF (p_rcv_events_tbl(l_ctr).event_type_id = RCV_SeedEvents_PVT.LOGICAL_RETURN_TO_VENDOR) THEN

3948: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3949: RAISE FND_API.g_exc_error;
3950: END IF;
3951:
3952: ELSIF (p_rcv_events_tbl(l_ctr).event_type_id = RCV_SeedEvents_PVT.LOGICAL_RETURN_TO_VENDOR) THEN
3953: l_stmt_num := 80;
3954: l_inv_trx_tbl_ctr := l_inv_trx_tbl_ctr + 1;
3955: IF (p_rcv_events_tbl(l_ctr).intercompany_pricing_option = 2) then
3956: l_intercompany_price := p_rcv_events_tbl(l_ctr).intercompany_price;

Line 4222: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,

4218: p_validation_level IN NUMBER,
4219: x_return_status OUT NOCOPY VARCHAR2,
4220: x_msg_count OUT NOCOPY NUMBER,
4221: x_msg_data OUT NOCOPY VARCHAR2,
4222: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,
4223: p_txn_type_id IN NUMBER,
4224: p_intercompany_price IN NUMBER,
4225: p_intercompany_curr_code IN VARCHAR2,
4226: p_acct_id IN NUMBER,

Line 4562: END RCV_SeedEvents_PVT;

4558: );
4559:
4560: END Create_MMTRecord;
4561:
4562: END RCV_SeedEvents_PVT;