[Home] [Help]
PACKAGE: APPS.JAI_RCV_TRANSACTIONS_PKG
Source
1 PACKAGE jai_rcv_transactions_pkg AS
2 /* $Header: jai_rcv_trx.pls 120.1 2005/07/20 12:59:19 avallabh ship $ */
3
4 PROCEDURE insert_row(
5 p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
6 p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
7 p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
8 p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
9 p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
10 p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
11 p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
12 p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
13 p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
14 p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
15 p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
16 p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
17 p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
18 p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
19 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
20 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
21 p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
22 p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
23 p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
24 p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
25 p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
26 p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
27 p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
28 p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
29 p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
30 p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
31 p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE,
32 p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
33 p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
34 p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
35 p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
36 p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
37 p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
38 p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
39 p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
40 p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
41 p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
42 p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
43 p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
44 p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
45 p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
46 p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
47 p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
48 p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
49 );
50
51 PROCEDURE update_row(
52 p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
53 p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
54 p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
55 p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
56 p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
57 p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
58 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
59 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
60 p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
61 p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
62 p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
63 p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
64 p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
65 p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
66 p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
67 p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
68 p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
69 p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
70 p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
71 p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_asset_inventory%TYPE DEFAULT NULL,
72 p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
73 p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
74 p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
75 p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
76 p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
77 p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
78 p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
79 p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
80 p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
81 p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
82 p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
83 p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
84 p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
85 p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
86 p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
87 p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
88 p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
89 p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
90 );
91
92 PROCEDURE update_process_flags(
93 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
94 p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_status%TYPE,
95 p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE,
96 p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE,
97 p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
98 p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
99 p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
100 /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
101 p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
102 p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
103 );
104
105 PROCEDURE update_excise_invoice_no(
106 p_transaction_id IN NUMBER,
107 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
108 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
109 );
110
111 PROCEDURE update_attributes(
112 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
113 p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
114 p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
115 p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
116 p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
117 p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
118 p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
119 p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
120 p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
121 p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
122 p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
123 p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
124 );
125
126 END jai_rcv_transactions_pkg;