DBA Data[Home] [Help]

APPS.RCV_SEEDEVENTS_PVT dependencies on RCV_ACCOUNTING_EVENTS

Line 10: -- Function : To seed accounting event in RCV_ACCOUNTING_EVENTS.

6: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'po.plsql.'||G_PKG_NAME;
7:
8: -- API name : Seed_RAEEvent
9: -- Type : Private
10: -- Function : To seed accounting event in RCV_ACCOUNTING_EVENTS.
11: -- Pre-reqs :
12: -- Parameters :
13: -- IN : p_api_version IN NUMBER Required
14: -- p_init_msg_list IN VARCHAR2 Optional

Line 47: -- Notes : This API is used to seed events in RCV_ACCOUNTING_EVENTS table.

43: -- Version :
44: -- Initial version 1.0
45: --
46: --
47: -- Notes : This API is used to seed events in RCV_ACCOUNTING_EVENTS table.
48: --
49: -- End of comments
50: -------------------------------------------------------------------------------
51: PROCEDURE Seed_RAEEvent(

Line 1272: l_currency_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;

1268: l_ic_pricing_option NUMBER := 1;
1269: l_transfer_price NUMBER;
1270: l_unit_price NUMBER;
1271: l_transaction_uom VARCHAR2(3);
1272: l_currency_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;
1273: l_item_exists NUMBER;
1274: l_from_organization_id NUMBER;
1275: l_from_org_id NUMBER;
1276: l_to_org_id NUMBER;

Line 1278: l_incr_currency_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;

1274: l_from_organization_id NUMBER;
1275: l_from_org_id NUMBER;
1276: l_to_org_id NUMBER;
1277:
1278: l_incr_currency_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;
1279: l_incr_transfer_price NUMBER;
1280:
1281: BEGIN
1282: -- Standard start of API savepoint

Line 2412: -- in RCV_ACCOUNTING_EVENTS.

2408: -- Initial version 1.0
2409: --
2410: --
2411: -- Notes : This API creates all accounting events for RETURN TO VENDOR transactions
2412: -- in RCV_ACCOUNTING_EVENTS.
2413: --
2414: -- End of comments
2415: PROCEDURE Get_Accounts(
2416: p_api_version IN NUMBER,

Line 2965: -- in RCV_ACCOUNTING_EVENTS.

2961: -- Initial version 1.0
2962: --
2963: --
2964: -- Notes : This API creates all accounting events for RETURN TO VENDOR transactions
2965: -- in RCV_ACCOUNTING_EVENTS.
2966: --
2967: -- End of comments
2968: PROCEDURE Get_HookAccount(
2969: p_api_version IN NUMBER,

Line 3153: -- into RCV_ACCOUNTING_EVENTS.

3149: -- Initial version 1.0
3150: --
3151: --
3152: -- Notes : This API inserts all events for a given receiving transaction
3153: -- into RCV_ACCOUNTING_EVENTS.
3154: --
3155: -- End of comments
3156: PROCEDURE Insert_RAEEvents(
3157: p_api_version IN NUMBER,

Line 3264: INSERT into RCV_ACCOUNTING_EVENTS(

3260: -- multiple tables of scalar types. The expense of converting the table of records
3261: -- to multiple tables is not worthwhile in this case since we do not expect the
3262: -- number of rows to exceed 10.
3263: l_stmt_num := 40;
3264: INSERT into RCV_ACCOUNTING_EVENTS(
3265: accounting_event_id,
3266: last_update_date,
3267: last_updated_by,
3268: last_update_login,

Line 3758: l_intercompany_curr_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;

3754: -- events are for a correction or not
3755: l_rcv_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
3756: l_parent_txn_flag NUMBER := 1;
3757: l_intercompany_price NUMBER; -- may include nr tax depending on the pricing option
3758: l_intercompany_curr_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;
3759: l_transfer_organization_id NUMBER := NULL;
3760:
3761: invalid_event EXCEPTION;
3762: BEGIN