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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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',
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,
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,
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 */
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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
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: (