[Home] [Help]
PACKAGE: APPS.JAI_RCV_JOURNAL_PKG
Source
1 PACKAGE jai_rcv_journal_pkg AS
2 /* $Header: jai_rcv_jrnl.pls 120.1 2005/07/20 12:59:07 avallabh ship $ */
3
4 PROCEDURE insert_row(
5 P_ORGANIZATION_ID IN NUMBER,
6 P_ORGANIZATION_CODE IN JAI_RCV_JOURNAL_ENTRIES.organization_code%TYPE,
7 P_RECEIPT_NUM IN JAI_RCV_JOURNAL_ENTRIES.receipt_num%TYPE,
8 P_TRANSACTION_ID IN JAI_RCV_JOURNAL_ENTRIES.transaction_id%TYPE,
9 P_TRANSACTION_DATE IN JAI_RCV_JOURNAL_ENTRIES.transaction_date%TYPE,
10 P_SHIPMENT_LINE_ID IN JAI_RCV_JOURNAL_ENTRIES.shipment_line_id%TYPE,
11 P_ACCT_TYPE IN JAI_RCV_JOURNAL_ENTRIES.acct_type%TYPE,
12 P_ACCT_NATURE IN JAI_RCV_JOURNAL_ENTRIES.acct_nature%TYPE,
13 P_SOURCE_NAME IN JAI_RCV_JOURNAL_ENTRIES.source_name%TYPE,
14 P_CATEGORY_NAME IN JAI_RCV_JOURNAL_ENTRIES.category_name%TYPE,
15 P_CODE_COMBINATION_ID IN JAI_RCV_JOURNAL_ENTRIES.code_combination_id%TYPE,
16 P_ENTERED_DR IN JAI_RCV_JOURNAL_ENTRIES.entered_dr%TYPE,
17 P_ENTERED_CR IN JAI_RCV_JOURNAL_ENTRIES.entered_cr%TYPE,
18 P_TRANSACTION_TYPE IN JAI_RCV_JOURNAL_ENTRIES.transaction_type%TYPE,
19 P_PERIOD_NAME IN JAI_RCV_JOURNAL_ENTRIES.period_name%TYPE,
20 P_CURRENCY_CODE IN JAI_RCV_JOURNAL_ENTRIES.currency_code%TYPE,
21 P_CURRENCY_CONVERSION_TYPE IN JAI_RCV_JOURNAL_ENTRIES.currency_conversion_type%TYPE,
22 P_CURRENCY_CONVERSION_DATE IN JAI_RCV_JOURNAL_ENTRIES.currency_conversion_date%TYPE,
23 P_CURRENCY_CONVERSION_RATE IN JAI_RCV_JOURNAL_ENTRIES.currency_conversion_rate%TYPE,
24 P_SIMULATE_FLAG IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
25 P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
26 P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2,
27 /* two parameters added by Vijay Shankar for Bug#4250236(4245089). VAT Implementation */
28 p_reference_name in varchar2 ,
29 p_reference_id in number
30 );
31
32 PROCEDURE update_row(
33 P_ORGANIZATION_CODE IN JAI_RCV_JOURNAL_ENTRIES.organization_code%TYPE DEFAULT NULL,
34 P_RECEIPT_NUM IN JAI_RCV_JOURNAL_ENTRIES.receipt_num%TYPE DEFAULT NULL,
35 P_TRANSACTION_ID IN JAI_RCV_JOURNAL_ENTRIES.transaction_id%TYPE DEFAULT NULL,
36 P_CREATION_DATE IN JAI_RCV_JOURNAL_ENTRIES.creation_date%TYPE DEFAULT NULL,
37 P_TRANSACTION_DATE IN JAI_RCV_JOURNAL_ENTRIES.transaction_date%TYPE DEFAULT NULL,
38 P_SHIPMENT_LINE_ID IN JAI_RCV_JOURNAL_ENTRIES.shipment_line_id%TYPE DEFAULT NULL,
39 P_ACCT_TYPE IN JAI_RCV_JOURNAL_ENTRIES.acct_type%TYPE DEFAULT NULL,
40 P_ACCT_NATURE IN JAI_RCV_JOURNAL_ENTRIES.acct_nature%TYPE DEFAULT NULL,
41 P_SOURCE_NAME IN JAI_RCV_JOURNAL_ENTRIES.source_name%TYPE DEFAULT NULL,
42 P_CATEGORY_NAME IN JAI_RCV_JOURNAL_ENTRIES.category_name%TYPE DEFAULT NULL,
43 P_CODE_COMBINATION_ID IN JAI_RCV_JOURNAL_ENTRIES.code_combination_id%TYPE DEFAULT NULL,
44 P_ENTERED_DR IN JAI_RCV_JOURNAL_ENTRIES.entered_dr%TYPE DEFAULT NULL,
45 P_ENTERED_CR IN JAI_RCV_JOURNAL_ENTRIES.entered_cr%TYPE DEFAULT NULL,
46 P_TRANSACTION_TYPE IN JAI_RCV_JOURNAL_ENTRIES.transaction_type%TYPE DEFAULT NULL,
47 P_PERIOD_NAME IN JAI_RCV_JOURNAL_ENTRIES.period_name%TYPE DEFAULT NULL,
48 P_CREATED_BY IN JAI_RCV_JOURNAL_ENTRIES.created_by%TYPE DEFAULT NULL,
49 P_CURRENCY_CODE IN JAI_RCV_JOURNAL_ENTRIES.currency_code%TYPE DEFAULT NULL,
50 P_CURRENCY_CONVERSION_TYPE IN JAI_RCV_JOURNAL_ENTRIES.currency_conversion_type%TYPE DEFAULT NULL,
51 P_CURRENCY_CONVERSION_DATE IN JAI_RCV_JOURNAL_ENTRIES.currency_conversion_date%TYPE DEFAULT NULL,
52 P_CURRENCY_CONVERSION_RATE IN JAI_RCV_JOURNAL_ENTRIES.currency_conversion_rate%TYPE DEFAULT NULL
53 );
54
55 PROCEDURE create_subledger_entry
56 (
57 p_transaction_id number,
58 p_organization_id number,
59 p_currency_code varchar2,
60 p_credit_amount number,
61 p_debit_amount number,
62 p_cc_id number,
63 p_created_by number,
64 p_accounting_date date default null,
65 p_currency_conversion_date date default null,
66 p_currency_conversion_type varchar2 default null,
67 p_currency_conversion_rate number default null
68 );
69
70 END jai_rcv_journal_pkg;