[Home] [Help]
PACKAGE: APPS.GMF_RCV_ACCOUNTING_PKG
Source
1 PACKAGE GMF_RCV_ACCOUNTING_PKG AS
2 /* $Header: gmfrcvas.pls 120.0 2006/07/19 17:23:03 rseshadr noship $ */
3
4 RECEIVE CONSTANT NUMBER := 1;
5 DELIVER CONSTANT NUMBER := 2;
6 CORRECT CONSTANT NUMBER := 3;
7 MATCH CONSTANT NUMBER := 4;
8 RETURN_TO_RECEIVING CONSTANT NUMBER := 5;
9 RETURN_TO_VENDOR CONSTANT NUMBER := 6;
10 ADJUST_RECEIVE CONSTANT NUMBER := 7;
11 ADJUST_DELIVER CONSTANT NUMBER := 8;
12 LOGICAL_RECEIVE CONSTANT NUMBER := 9;
13 LOGICAL_RETURN_TO_VENDOR CONSTANT NUMBER := 10;
14 INTERCOMPANY_INVOICE CONSTANT NUMBER := 11;
15 INTERCOMPANY_REVERSAL CONSTANT NUMBER := 12;
16 ENCUMBRANCE_REVERSAL CONSTANT NUMBER := 13;
17
18 TYPE rcv_accttxn_rec_type is RECORD
19 (
20 event_type_id NUMBER,
21 event_source VARCHAR2(25),
22 rcv_transaction_id NUMBER := NULL,
23 direct_delivery_flag VARCHAR2(1) := 'N',
24 inv_distribution_id NUMBER := NULL,
25 transaction_date DATE := sysdate,
26 po_header_id NUMBER := NULL,
27 po_release_id NUMBER := NULL,
28 po_line_id NUMBER := NULL,
29 po_line_location_id NUMBER := NULL,
30 po_distribution_id NUMBER := NULL,
31 trx_flow_header_id NUMBER := NULL,
32 ledger_id NUMBER := NULL,
33 org_id NUMBER := NULL,
34 transfer_org_id NUMBER := NULL,
35 organization_id NUMBER := NULL,
36 transfer_organization_id NUMBER := NULL,
37 item_id NUMBER := NULL,
38 unit_price NUMBER := NULL,
39 unit_nr_tax NUMBER := NULL,
40 unit_rec_tax NUMBER := NULL,
41 prior_unit_price NUMBER := NULL,
42 prior_nr_tax NUMBER := NULL,
43 prior_rec_tax NUMBER := NULL,
44 intercompany_pricing_option NUMBER := 1,
45 service_flag VARCHAR2(1) := 'N',
46 transaction_amount NUMBER := NULL,
47 currency_code VARCHAR2(15) := NULL,
48 currency_conversion_type VARCHAR2(30) := NULL,
49 currency_conversion_rate NUMBER := 1,
50 currency_conversion_date DATE := sysdate,
51 intercompany_price NUMBER := NULL,
52 intercompany_curr_code VARCHAR2(15) := NULL,
53 transaction_uom VARCHAR2(25) := NULL,
54 trx_uom_code VARCHAR2(3) := NULL,
55 transaction_quantity NUMBER := NULL,
56 primary_uom VARCHAR2(25) := NULL,
57 primary_quantity NUMBER := NULL,
58 source_doc_uom VARCHAR2(25) := NULL,
59 source_doc_quantity NUMBER := NULL,
60 destination_type_code VARCHAR2(25) := NULL,
61 cross_ou_flag VARCHAR2(1) := 'N',
62 procurement_org_flag VARCHAR2(1) := 'N',
63 ship_to_org_flag VARCHAR2(1) := 'N',
64 drop_ship_flag NUMBER := 0,
65 debit_account_id NUMBER := NULL,
66 credit_account_id NUMBER := NULL,
67 intercompany_cogs_account_id NUMBER := NULL,
68 ussgl_transaction_code VARCHAR2(30) := NULL,
69 gl_group_id NUMBER := NULL
70 );
71
72 TYPE rcv_accttxn_tbl_type is TABLE OF rcv_accttxn_rec_type INDEX BY BINARY_INTEGER;
73
74 PROCEDURE CREATE_ACCOUNTING_TXNS
75 (
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2,
78 p_commit IN VARCHAR2,
79 p_validation_level IN NUMBER,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_source_type IN VARCHAR2,
84 p_rcv_transaction_id IN NUMBER,
85 p_direct_delivery_flag IN VARCHAR2
86 );
87
88 PROCEDURE CREATE_ADJUST_TXNS
89 (
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2,
92 p_commit IN VARCHAR2,
93 p_validation_level IN NUMBER,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_po_header_id IN NUMBER,
98 p_po_release_id IN NUMBER,
99 p_po_line_id IN NUMBER,
100 p_po_line_location_id IN NUMBER,
101 p_old_po_price IN NUMBER,
102 p_new_po_price IN NUMBER
103 );
104 END GMF_RCV_ACCOUNTING_PKG;