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.10.12010000.3 2008/11/10 14:48:11 mpuranik 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.10.12010000.3 2008/11/10 14:48:11 mpuranik 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 1218: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required

1214: -- p_commit IN VARCHAR2 Optional
1215: -- Default = FND_API.G_FALSE
1216: -- p_validation_level IN NUMBER Optional
1217: -- Default = FND_API.G_VALID_LEVEL_FULL
1218: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required
1219: -- p_lcm_flag IN VARCHAR2 Optional
1220: --
1221: -- OUT : x_return_status OUT VARCHAR2(1)
1222: -- x_msg_count OUT NUMBER

Line 1244: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,

1240: p_validation_level IN NUMBER,
1241: x_return_status OUT NOCOPY VARCHAR2,
1242: x_msg_count OUT NOCOPY NUMBER,
1243: x_msg_data OUT NOCOPY VARCHAR2,
1244: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,
1245: p_asset_item_pricing_option IN NUMBER,
1246: p_expense_item_pricing_option IN NUMBER,
1247: /* Support for Landed Cost Management */
1248: p_lcm_flag IN VARCHAR2,

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

1321: IF(p_rcv_event.trx_flow_header_id IS NULL OR
1322: p_rcv_event.item_id IS NULL OR
1323: p_rcv_event.destination_type_code = 'SHOP FLOOR' OR
1324: (p_rcv_event.procurement_org_flag = 'Y' AND
1325: p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
1326: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))
1327: ) THEN
1328: l_ic_pricing_option := 1;
1329:

Line 1326: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))

1322: p_rcv_event.item_id IS NULL OR
1323: p_rcv_event.destination_type_code = 'SHOP FLOOR' OR
1324: (p_rcv_event.procurement_org_flag = 'Y' AND
1325: p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
1326: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))
1327: ) THEN
1328: l_ic_pricing_option := 1;
1329:
1330: ELSE

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

1400: -- passed. For Intercompany events, the from organization id is the same as
1401: -- organization_id on the event. For the remaining events, the from organization
1402: -- is the transfer_organization_id on the event.
1403:
1404: IF(p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
1405: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
1406: l_from_organization_id := p_rcv_event.organization_id;
1407: l_from_org_id := p_rcv_event.org_id;
1408: l_to_org_id := p_rcv_event.transfer_org_id;

Line 1405: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN

1401: -- organization_id on the event. For the remaining events, the from organization
1402: -- is the transfer_organization_id on the event.
1403:
1404: IF(p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
1405: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
1406: l_from_organization_id := p_rcv_event.organization_id;
1407: l_from_org_id := p_rcv_event.org_id;
1408: l_to_org_id := p_rcv_event.transfer_org_id;
1409: ELSE

Line 1578: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required

1574: -- p_commit IN VARCHAR2 Optional
1575: -- Default = FND_API.G_FALSE
1576: -- p_validation_level IN NUMBER Optional
1577: -- Default = FND_API.G_VALID_LEVEL_FULL
1578: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required
1579: --
1580: -- OUT : x_return_status OUT VARCHAR2(1)
1581: -- x_msg_count OUT NUMBER
1582: -- x_msg_data OUT VARCHAR2(2000)

Line 1603: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,

1599: x_return_status OUT NOCOPY VARCHAR2,
1600: x_msg_count OUT NOCOPY NUMBER,
1601: x_msg_data OUT NOCOPY VARCHAR2,
1602:
1603: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,
1604: x_unit_nr_tax OUT NOCOPY NUMBER,
1605: x_unit_rec_tax OUT NOCOPY NUMBER,
1606: x_prior_nr_tax OUT NOCOPY NUMBER,
1607: x_prior_rec_tax OUT NOCOPY NUMBER

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

1709:
1710: /* Bug 6405593 :Added hook call to override the recoverable and Non-Recoverable
1711: taxes for ENCUMBRANCE_REVERSAL event */
1712:
1713: IF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN
1714: l_stmt_num := 25;
1715: l_hook_used := CST_Common_hooks.Get_NRtax_amount(
1716: I_ACCT_TXN_ID =>p_rcv_event.rcv_transaction_id,
1717: I_SOURCE_DOC_TYPE =>'PO',

Line 1902: P_EVENT_REC IN RCV_SeedEvents_PVT.rcv_event_rec_type,

1898: P_VALIDATION_LEVEL IN NUMBER, -- := FND_API.G_VALID_LEVEL_FULL,
1899: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1900: X_MSG_COUNT OUT NOCOPY NUMBER,
1901: X_MSG_DATA OUT NOCOPY VARCHAR2,
1902: P_EVENT_REC IN RCV_SeedEvents_PVT.rcv_event_rec_type,
1903: X_TRANSACTION_QTY OUT NOCOPY NUMBER,
1904: X_PRIMARY_UOM OUT NOCOPY MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE,
1905: X_PRIMARY_QTY OUT NOCOPY NUMBER,
1906: X_TRX_UOM_CODE OUT NOCOPY VARCHAR2

Line 2171: P_RCV_EVENT IN RCV_SeedEvents_PVT.rcv_event_rec_type,

2167: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2168: X_MSG_COUNT OUT NOCOPY NUMBER,
2169: X_MSG_DATA OUT NOCOPY VARCHAR2,
2170:
2171: P_RCV_EVENT IN RCV_SeedEvents_PVT.rcv_event_rec_type,
2172: X_CURRENCY_CODE OUT NOCOPY VARCHAR2,
2173: X_CURRENCY_CONVERSION_RATE OUT NOCOPY NUMBER,
2174: X_CURRENCY_CONVERSION_DATE OUT NOCOPY DATE,
2175: X_CURRENCY_CONVERSION_TYPE OUT NOCOPY VARCHAR2

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

2217: -- API body
2218: l_stmt_num := 10;
2219:
2220: IF ((p_rcv_event.procurement_org_flag = 'Y') AND
2221: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2222: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))) THEN
2223:
2224: l_currency_code := p_rcv_event.currency_code;
2225:

Line 2222: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))) THEN

2218: l_stmt_num := 10;
2219:
2220: IF ((p_rcv_event.procurement_org_flag = 'Y') AND
2221: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2222: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL))) THEN
2223:
2224: l_currency_code := p_rcv_event.currency_code;
2225:
2226: l_stmt_num := 20;

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

2235: FROM po_line_locations
2236: WHERE line_location_id = l_po_line_location_id;
2237:
2238: -- Always use rate on the PO distribution for encumbrance reversals.
2239: IF (l_match_option = 'P' OR (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL)) THEN
2240:
2241: l_stmt_num := 40;
2242: SELECT nvl(POD.rate,1),
2243: POH.rate_type,

Line 2397: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required

2393: -- p_commit IN VARCHAR2 Optional
2394: -- Default = FND_API.G_FALSE
2395: -- p_validation_level IN NUMBER Optional
2396: -- Default = FND_API.G_VALID_LEVEL_FULL
2397: -- p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type Required
2398: -- p_transaction_forward_flow_rec mtl_transaction_flow_rec_type,
2399: -- p_transaction_reverse_flow_rec mtl_transaction_flow_rec_type,
2400: --
2401: -- OUT : x_return_status OUT VARCHAR2(1)

Line 2424: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,

2420: x_return_status OUT NOCOPY VARCHAR2,
2421: x_msg_count OUT NOCOPY NUMBER,
2422: x_msg_data OUT NOCOPY VARCHAR2,
2423:
2424: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,
2425: p_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type,
2426: p_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type,
2427: /* Support for Landed Cost Management */
2428: p_lcm_flag IN VARCHAR2,

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

2498: x_lcm_acct_id := NULL;
2499:
2500: -- No accounts are stored for IC events.
2501: l_stmt_num := 5;
2502: IF(p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2503: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
2504: return;
2505: END IF;
2506:

Line 2503: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN

2499:
2500: -- No accounts are stored for IC events.
2501: l_stmt_num := 5;
2502: IF(p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2503: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
2504: return;
2505: END IF;
2506:
2507: l_stmt_num := 10;

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

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

Line 2540: RCV_SeedEvents_PVT.DELIVER, RCV_SeedEvents_PVT.CORRECT,

2536: -- Drop Ship or retroactive pricing.
2537: -- Modified for bug #4893292: Call API to override balance segment for inventory destinations as well.
2538: IF(p_rcv_event.trx_flow_header_id IS NULL AND
2539: p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.RECEIVE, RCV_SeedEvents_PVT.MATCH,
2540: RCV_SeedEvents_PVT.DELIVER, RCV_SeedEvents_PVT.CORRECT,
2541: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING,
2542: RCV_SeedEvents_PVT.RETURN_TO_VENDOR) AND
2543: p_rcv_event.destination_type_code IN ('EXPENSE', 'INVENTORY')) THEN
2544:

Line 2541: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING,

2537: -- Modified for bug #4893292: Call API to override balance segment for inventory destinations as well.
2538: IF(p_rcv_event.trx_flow_header_id IS NULL AND
2539: p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.RECEIVE, RCV_SeedEvents_PVT.MATCH,
2540: RCV_SeedEvents_PVT.DELIVER, RCV_SeedEvents_PVT.CORRECT,
2541: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING,
2542: RCV_SeedEvents_PVT.RETURN_TO_VENDOR) AND
2543: p_rcv_event.destination_type_code IN ('EXPENSE', 'INVENTORY')) THEN
2544:
2545: l_stmt_num := 30;

Line 2542: RCV_SeedEvents_PVT.RETURN_TO_VENDOR) AND

2538: IF(p_rcv_event.trx_flow_header_id IS NULL AND
2539: p_rcv_event.event_type_id IN (RCV_SeedEvents_PVT.RECEIVE, RCV_SeedEvents_PVT.MATCH,
2540: RCV_SeedEvents_PVT.DELIVER, RCV_SeedEvents_PVT.CORRECT,
2541: RCV_SeedEvents_PVT.RETURN_TO_RECEIVING,
2542: RCV_SeedEvents_PVT.RETURN_TO_VENDOR) AND
2543: p_rcv_event.destination_type_code IN ('EXPENSE', 'INVENTORY')) THEN
2544:
2545: l_stmt_num := 30;
2546: PO_Accounting_GRP.build_offset_account

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

2557: l_receiving_insp_acct_id := l_overlaid_acct;
2558:
2559: END IF;
2560:
2561: IF( p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT) THEN
2562:
2563: l_stmt_num := 40;
2564: SELECT PARENT_TRX.transaction_type
2565: INTO l_parent_trx_type

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

2569: AND TRX.parent_transaction_id = PARENT_TRX.transaction_id;
2570: END IF;
2571:
2572: l_stmt_num := 50;
2573: IF((p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RECEIVE) OR
2574: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.MATCH) OR
2575: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2576: l_parent_trx_type = 'RECEIVE') OR
2577: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND

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

2570: END IF;
2571:
2572: l_stmt_num := 50;
2573: IF((p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RECEIVE) OR
2574: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.MATCH) OR
2575: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2576: l_parent_trx_type = 'RECEIVE') OR
2577: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2578: l_parent_trx_type = 'MATCH') THEN

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

2571:
2572: l_stmt_num := 50;
2573: IF((p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RECEIVE) OR
2574: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.MATCH) OR
2575: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2576: l_parent_trx_type = 'RECEIVE') OR
2577: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2578: l_parent_trx_type = 'MATCH') THEN
2579:

Line 2577: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND

2573: IF((p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RECEIVE) OR
2574: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.MATCH) OR
2575: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2576: l_parent_trx_type = 'RECEIVE') OR
2577: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2578: l_parent_trx_type = 'MATCH') THEN
2579:
2580: l_debit_acct_id := l_receiving_insp_acct_id;
2581:

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

2586: ELSE
2587: l_credit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2588: END IF;
2589:
2590: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.LOGICAL_RECEIVE) THEN
2591:
2592: -- Use clearing account for :
2593: -- a. destination type of Inventory
2594: -- b. destination type of Expense for inventory items.

Line 2612: RCV_SeedEvents_PVT.Get_HookAccount(

2608: FROM mtl_parameters MP
2609: WHERE MP.organization_id = p_rcv_event.organization_id;
2610:
2611: l_stmt_num := 70;
2612: RCV_SeedEvents_PVT.Get_HookAccount(
2613: p_api_version => l_api_version,
2614: x_return_status => l_return_status,
2615: x_msg_count => l_msg_count,
2616: x_msg_data => l_msg_data,

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

2644: ELSE
2645: l_credit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2646: END IF;
2647:
2648: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.DELIVER OR
2649: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2650: l_parent_trx_type = 'DELIVER')) THEN
2651: l_debit_acct_id := l_dest_pod_ccid;
2652: l_credit_acct_id := l_receiving_insp_acct_id;

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

2645: l_credit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2646: END IF;
2647:
2648: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.DELIVER OR
2649: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2650: l_parent_trx_type = 'DELIVER')) THEN
2651: l_debit_acct_id := l_dest_pod_ccid;
2652: l_credit_acct_id := l_receiving_insp_acct_id;
2653:

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

2650: l_parent_trx_type = 'DELIVER')) THEN
2651: l_debit_acct_id := l_dest_pod_ccid;
2652: l_credit_acct_id := l_receiving_insp_acct_id;
2653:
2654: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RETURN_TO_VENDOR OR
2655: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2656: l_parent_trx_type = 'RETURN TO VENDOR')) THEN
2657: l_credit_acct_id := l_receiving_insp_acct_id;
2658:

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

2651: l_debit_acct_id := l_dest_pod_ccid;
2652: l_credit_acct_id := l_receiving_insp_acct_id;
2653:
2654: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RETURN_TO_VENDOR OR
2655: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2656: l_parent_trx_type = 'RETURN TO VENDOR')) THEN
2657: l_credit_acct_id := l_receiving_insp_acct_id;
2658:
2659: IF(p_rcv_event.procurement_org_flag = 'Y') THEN

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

2663: ELSE
2664: l_debit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2665: END IF;
2666:
2667: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.LOGICAL_RETURN_TO_VENDOR) THEN
2668: IF(p_rcv_event.destination_type_code = 'INVENTORY' OR
2669: (p_rcv_event.destination_type_code = 'EXPENSE' AND
2670: p_rcv_event.item_id is not null)) THEN
2671: l_credit_acct_id := l_clearing_acct_id;

Line 2682: RCV_SeedEvents_PVT.Get_HookAccount(

2678: FROM mtl_parameters MP
2679: WHERE MP.organization_id = p_rcv_event.organization_id;
2680:
2681: l_stmt_num := 100;
2682: RCV_SeedEvents_PVT.Get_HookAccount(
2683: p_api_version => l_api_version,
2684: x_return_status => l_return_status,
2685: x_msg_count => l_msg_count,
2686: x_msg_data => l_msg_data,

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

2713: ELSE
2714: l_debit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2715: END IF;
2716:
2717: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RETURN_TO_RECEIVING OR
2718: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2719: l_parent_trx_type = 'RETURN TO RECEIVING')) THEN
2720: l_credit_acct_id := l_dest_pod_ccid;
2721: l_debit_acct_id := l_receiving_insp_acct_id;

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

2714: l_debit_acct_id := p_transaction_reverse_flow_rec.inventory_accrual_account_id;
2715: END IF;
2716:
2717: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.RETURN_TO_RECEIVING OR
2718: (p_rcv_event.event_type_id = RCV_SeedEvents_PVT.CORRECT AND
2719: l_parent_trx_type = 'RETURN TO RECEIVING')) THEN
2720: l_credit_acct_id := l_dest_pod_ccid;
2721: l_debit_acct_id := l_receiving_insp_acct_id;
2722:

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

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

Line 2737: RCV_SeedEvents_PVT.Get_HookAccount(

2733: IF ( p_rcv_event.item_id IS NOT NULL OR
2734: p_rcv_event.destination_type_code = 'SHOP FLOOR') THEN
2735:
2736: l_stmt_num := 110;
2737: RCV_SeedEvents_PVT.Get_HookAccount(
2738: p_api_version => l_api_version,
2739: x_return_status => l_return_status,
2740: x_msg_count => l_msg_count,
2741: x_msg_data => l_msg_data,

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

2767: END IF;
2768:
2769: l_credit_acct_id := l_pod_accrual_acct_id;
2770:
2771: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ADJUST_DELIVER) THEN
2772:
2773: -- Redundant check. Transaction flow header id is always NULL. We only
2774: -- get ADJUST_RECEIVE events for global procurement.
2775: IF(p_rcv_event.trx_flow_header_id IS NULL AND p_rcv_event.drop_ship_flag NOT IN (1,2)) THEN

Line 2781: RCV_SeedEvents_PVT.Get_HookAccount(

2777: l_debit_acct_id := l_dest_pod_ccid;
2778: ELSE
2779:
2780: l_stmt_num := 120;
2781: RCV_SeedEvents_PVT.Get_HookAccount(
2782: p_api_version => l_api_version,
2783: x_return_status => l_return_status,
2784: x_msg_count => l_msg_count,
2785: x_msg_data => l_msg_data,

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

2807:
2808: l_stmt_num := 130;
2809: l_credit_acct_id := l_receiving_insp_acct_id;
2810:
2811: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE OR
2812: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)THEN
2813: l_credit_acct_id := NULL;
2814: l_debit_acct_id := NULL;
2815:

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

2808: l_stmt_num := 130;
2809: l_credit_acct_id := l_receiving_insp_acct_id;
2810:
2811: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE OR
2812: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)THEN
2813: l_credit_acct_id := NULL;
2814: l_debit_acct_id := NULL;
2815:
2816: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN

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

2812: p_rcv_event.event_type_id = RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)THEN
2813: l_credit_acct_id := NULL;
2814: l_debit_acct_id := NULL;
2815:
2816: ELSIF(p_rcv_event.event_type_id = RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL) THEN
2817:
2818:
2819: l_stmt_num := 140;
2820: SELECT RT.transaction_type, RT.parent_transaction_id

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

2861: ,l_api_message);
2862: END IF;
2863:
2864: IF ((l_debit_acct_id IS NULL OR l_credit_acct_id IS NULL) AND
2865: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2866: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,
2867: RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL))) THEN
2868: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2869: l_api_message := 'Unable to find credit and/or debit account. Setup is incomplete. ';

Line 2866: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,

2862: END IF;
2863:
2864: IF ((l_debit_acct_id IS NULL OR l_credit_acct_id IS NULL) AND
2865: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2866: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,
2867: RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL))) THEN
2868: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2869: l_api_message := 'Unable to find credit and/or debit account. Setup is incomplete. ';
2870: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

Line 2867: RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL))) THEN

2863:
2864: IF ((l_debit_acct_id IS NULL OR l_credit_acct_id IS NULL) AND
2865: (p_rcv_event.event_type_id NOT IN (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,
2866: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,
2867: RCV_SeedEvents_PVT.ENCUMBRANCE_REVERSAL))) THEN
2868: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2869: l_api_message := 'Unable to find credit and/or debit account. Setup is incomplete. ';
2870: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2871: ,l_api_message);

Line 3143: -- p_rcv_events_tbl IN RCV_SeedEvents_PVT.rcv_event_tbl_type Required

3139: -- p_commit IN VARCHAR2 Optional
3140: -- Default = FND_API.G_FALSE
3141: -- p_validation_level IN NUMBER Optional
3142: -- Default = FND_API.G_VALID_LEVEL_FULL
3143: -- p_rcv_events_tbl IN RCV_SeedEvents_PVT.rcv_event_tbl_type Required
3144: --
3145: -- OUT : x_return_status OUT VARCHAR2(1)
3146: -- x_msg_count OUT NUMBER
3147: -- x_msg_data OUT VARCHAR2(2000)

Line 3165: p_rcv_events_tbl IN RCV_SeedEvents_PVT.rcv_event_tbl_type,

3161: x_return_status OUT NOCOPY VARCHAR2,
3162: x_msg_count OUT NOCOPY NUMBER,
3163: x_msg_data OUT NOCOPY VARCHAR2,
3164:
3165: p_rcv_events_tbl IN RCV_SeedEvents_PVT.rcv_event_tbl_type,
3166: /* Support for Landed Cost Management */
3167: p_lcm_flag IN VARCHAR2
3168: ) IS
3169: l_api_name CONSTANT VARCHAR2(30) := 'Insert_RAEEvents';

Line 3394: RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,'N',

3390: p_rcv_events_tbl(i).procurement_org_flag,
3391: p_rcv_events_tbl(i).Cross_ou_flag,
3392: p_rcv_events_tbl(i).trx_flow_header_id,
3393: decode(p_rcv_events_tbl(i).event_type_id,
3394: RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,'N',
3395: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,'N',NULL),
3396: 'N', -- Will be changed by PA process
3397: /* Support for Landed Cost Management */
3398: p_rcv_events_tbl(i).unit_landed_cost

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

3391: p_rcv_events_tbl(i).Cross_ou_flag,
3392: p_rcv_events_tbl(i).trx_flow_header_id,
3393: decode(p_rcv_events_tbl(i).event_type_id,
3394: RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,'N',
3395: RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL,'N',NULL),
3396: 'N', -- Will be changed by PA process
3397: /* Support for Landed Cost Management */
3398: p_rcv_events_tbl(i).unit_landed_cost
3399: FROM DUAL);

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

3412: be done online. */
3413: IF ((l_accrue_on_receipt_flag = 'Y' OR
3414: p_rcv_events_tbl(i).procurement_org_flag = 'N') AND
3415: p_rcv_events_tbl(i).event_type_id NOT IN
3416: (RCV_SeedEvents_PVT.INTERCOMPANY_INVOICE,RCV_SeedEvents_PVT.INTERCOMPANY_REVERSAL)) THEN
3417: l_stmt_num := 50;
3418: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3419: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3420: ,'Creating accounting entries in RRS');

Line 3739: P_RCV_EVENTS_TBL IN RCV_SeedEvents_PVT.rcv_event_tbl_type

3735: P_VALIDATION_LEVEL IN NUMBER,
3736: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3737: X_MSG_COUNT OUT NOCOPY NUMBER,
3738: X_MSG_DATA OUT NOCOPY VARCHAR2,
3739: P_RCV_EVENTS_TBL IN RCV_SeedEvents_PVT.rcv_event_tbl_type
3740: ) IS
3741: l_api_name CONSTANT VARCHAR2(30) := 'Insert_MMTEvents';
3742: l_api_version CONSTANT NUMBER := 1.0;
3743: l_api_message VARCHAR2(1000);

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

3831: -- will follow this logic for both transactions.
3832:
3833: l_transfer_organization_id := p_rcv_events_tbl(p_rcv_events_tbl.NEXT(l_ctr)).organization_id;
3834:
3835: IF (p_rcv_events_tbl(l_ctr).event_type_id = RCV_SeedEvents_PVT.LOGICAL_RECEIVE) THEN
3836:
3837: l_inv_trx_tbl_ctr := l_inv_trx_tbl_ctr + 1;
3838: IF (p_rcv_events_tbl(l_ctr).intercompany_pricing_option = 2) then
3839: l_intercompany_price := p_rcv_events_tbl(l_ctr).intercompany_price;

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

3939: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3940: RAISE FND_API.g_exc_error;
3941: END IF;
3942:
3943: ELSIF (p_rcv_events_tbl(l_ctr).event_type_id = RCV_SeedEvents_PVT.LOGICAL_RETURN_TO_VENDOR) THEN
3944: l_stmt_num := 80;
3945: l_inv_trx_tbl_ctr := l_inv_trx_tbl_ctr + 1;
3946: IF (p_rcv_events_tbl(l_ctr).intercompany_pricing_option = 2) then
3947: l_intercompany_price := p_rcv_events_tbl(l_ctr).intercompany_price;

Line 4213: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,

4209: p_validation_level IN NUMBER,
4210: x_return_status OUT NOCOPY VARCHAR2,
4211: x_msg_count OUT NOCOPY NUMBER,
4212: x_msg_data OUT NOCOPY VARCHAR2,
4213: p_rcv_event IN RCV_SeedEvents_PVT.rcv_event_rec_type,
4214: p_txn_type_id IN NUMBER,
4215: p_intercompany_price IN NUMBER,
4216: p_intercompany_curr_code IN VARCHAR2,
4217: p_acct_id IN NUMBER,

Line 4553: END RCV_SeedEvents_PVT;

4549: );
4550:
4551: END Create_MMTRecord;
4552:
4553: END RCV_SeedEvents_PVT;