1 PACKAGE DPP_XLA_EVENT_PUB AS
2 /* $Header: dppxlaes.pls 120.0.12010000.2 2008/08/05 05:20:28 sanagar ship $ */
3 /*============================================================================
4 API name : DPP_XLA_EVENT_PUB.CreateAccounting
5 Type : private
6 Pre-reqs : Create events and execute SLA create accounting program
7 Description : This API will do the following:
8 1) For inventory material transactions present in the Price
9 Protection extract table, raise exception for
10 records that have not been accounted in mtl_transaction accounts
11 2) Derive default code combinations for each account depending
12 on the type of transaction
13 3) Create events for eligible records present in the extract
14 table
15
16 Version : Current Version 1.0
17 Initial Version 1.0
18 Parameters :
19
20 OUT : retcode OUT NUMBER
21 errbuf OUT VARCHAR2
22 ============================================================================*/
23
24
25 PROCEDURE CreateAccounting( errbuf OUT NOCOPY VARCHAR2,
26 retcode OUT NOCOPY NUMBER,
27 p_org_id IN NUMBER,
28 p_source_application_id IN NUMBER,
29 p_application_id IN NUMBER,
30 p_dummy IN VARCHAR2,
31 p_ledger_id IN NUMBER,
32 P_PROCESS_CATEGORY_CODE IN VARCHAR2,
33 P_END_DATE IN VARCHAR2,
34 P_CREATE_ACCOUNTING_FLAG IN VARCHAR2,
35 P_DUMMY_PARAM_1 IN VARCHAR2,
36 P_ACCOUNTING_MODE IN VARCHAR2,
37 P_DUMMY_PARAM_2 IN VARCHAR2,
38 P_ERRORS_ONLY_FLAG IN VARCHAR2,
39 P_REPORT_STYLE IN VARCHAR2,
40 P_TRANSFER_TO_GL_FLAG IN VARCHAR2,
41 P_DUMMY_PARAM_3 IN VARCHAR2,
42 P_POST_IN_GL_FLAG IN VARCHAR2,
43 P_GL_BATCH_NAME IN VARCHAR2,
44 P_MIN_PRECISION IN NUMBER,
45 P_INCLUDE_ZERO_AMOUNT_LINES IN VARCHAR2,
46 P_REQUEST_ID IN NUMBER,
47 P_ENTITY_ID IN NUMBER,
48 P_SOURCE_APPLICATION_NAME IN VARCHAR2,
49 P_APPLICATION_NAME IN VARCHAR2,
50 P_LEDGER_NAME IN VARCHAR2,
51 P_PROCESS_CATEGORY_NAME IN VARCHAR2,
52 P_CREATE_ACCOUNTING IN VARCHAR2,
53 P_ACCOUNTING_MODE_NAME IN VARCHAR2,
54 P_ERRORS_ONLY IN VARCHAR2,
55 P_ACCOUNTING_REPORT_LEVEL IN VARCHAR2,
56 P_TRANSFER_TO_GL IN VARCHAR2,
57 P_POST_IN_GL IN VARCHAR2,
58 P_INCLUDE_ZERO_AMT_LINES IN VARCHAR2,
59 P_VALUATION_METHOD_CODE IN VARCHAR2,
60 P_SECURITY_INT_1 IN NUMBER,
61 P_SECURITY_INT_2 IN NUMBER,
62 P_SECURITY_INT_3 IN NUMBER,
63 P_SECURITY_CHAR_1 IN VARCHAR2,
64 P_SECURITY_CHAR_2 IN VARCHAR2,
65 P_SECURITY_CHAR_3 IN VARCHAR2,
66 P_CONC_REQUEST_ID IN NUMBER,
67 P_INCLUDE_USER_TRX_ID_FLAG IN VARCHAR2,
68 P_INCLUDE_USER_TRX_IDENTIFIERS IN VARCHAR2,
69 P_DebugFlag IN VARCHAR2,
70 P_USER_ID IN NUMBER --Bug#7280169
71 );
72
73
74 FUNCTION get_pp_accrual_ccid(p_org_id IN NUMBER,
75 p_vendor_id IN NUMBER,
76 p_vendor_site_id IN NUMBER
77 ) RETURN NUMBER;
78
79 FUNCTION get_pp_cost_adjustment_ccid(p_org_id IN NUMBER,
80 p_vendor_id IN NUMBER,
81 p_vendor_site_id IN NUMBER) RETURN NUMBER;
82
83 FUNCTION get_pp_ap_clearing_ccid(
84 p_claim_id IN NUMBER,
85 p_org_id IN NUMBER,
86 p_vendor_id IN NUMBER,
87 p_vendor_site_id IN NUMBER) RETURN NUMBER;
88
89 FUNCTION get_pp_ar_clearing_ccid(
90 p_claim_id IN NUMBER,
91 p_org_id IN NUMBER,
92 p_vendor_id IN NUMBER,
93 p_vendor_site_id IN NUMBER) RETURN NUMBER;
94
95 FUNCTION get_pp_contra_liab_ccid(
96
97 p_org_id IN NUMBER,
98 p_vendor_id IN NUMBER,
99 p_vendor_site_id IN NUMBER) RETURN NUMBER;
100 END;
101
[Home] [Help]