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 1279: l_currency_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;

1275: l_ic_pricing_option NUMBER := 1;
1276: l_transfer_price NUMBER;
1277: l_unit_price NUMBER;
1278: l_transaction_uom VARCHAR2(3);
1279: l_currency_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;
1280: l_item_exists NUMBER;
1281: l_from_organization_id NUMBER;
1282: l_from_org_id NUMBER;
1283: l_to_org_id NUMBER;

Line 1285: l_incr_currency_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;

1281: l_from_organization_id NUMBER;
1282: l_from_org_id NUMBER;
1283: l_to_org_id NUMBER;
1284:
1285: l_incr_currency_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;
1286: l_incr_transfer_price NUMBER;
1287:
1288: BEGIN
1289: -- Standard start of API savepoint

Line 2419: -- in RCV_ACCOUNTING_EVENTS.

2415: -- Initial version 1.0
2416: --
2417: --
2418: -- Notes : This API creates all accounting events for RETURN TO VENDOR transactions
2419: -- in RCV_ACCOUNTING_EVENTS.
2420: --
2421: -- End of comments
2422: PROCEDURE Get_Accounts(
2423: p_api_version IN NUMBER,

Line 2974: -- in RCV_ACCOUNTING_EVENTS.

2970: -- Initial version 1.0
2971: --
2972: --
2973: -- Notes : This API creates all accounting events for RETURN TO VENDOR transactions
2974: -- in RCV_ACCOUNTING_EVENTS.
2975: --
2976: -- End of comments
2977: PROCEDURE Get_HookAccount(
2978: p_api_version IN NUMBER,

Line 3162: -- into RCV_ACCOUNTING_EVENTS.

3158: -- Initial version 1.0
3159: --
3160: --
3161: -- Notes : This API inserts all events for a given receiving transaction
3162: -- into RCV_ACCOUNTING_EVENTS.
3163: --
3164: -- End of comments
3165: PROCEDURE Insert_RAEEvents(
3166: p_api_version IN NUMBER,

Line 3273: INSERT into RCV_ACCOUNTING_EVENTS(

3269: -- multiple tables of scalar types. The expense of converting the table of records
3270: -- to multiple tables is not worthwhile in this case since we do not expect the
3271: -- number of rows to exceed 10.
3272: l_stmt_num := 40;
3273: INSERT into RCV_ACCOUNTING_EVENTS(
3274: accounting_event_id,
3275: last_update_date,
3276: last_updated_by,
3277: last_update_login,

Line 3767: l_intercompany_curr_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;

3763: -- events are for a correction or not
3764: l_rcv_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
3765: l_parent_txn_flag NUMBER := 1;
3766: l_intercompany_price NUMBER; -- may include nr tax depending on the pricing option
3767: l_intercompany_curr_code RCV_ACCOUNTING_EVENTS.CURRENCY_CODE%TYPE;
3768: l_transfer_organization_id NUMBER := NULL;
3769:
3770: invalid_event EXCEPTION;
3771: BEGIN