DBA Data[Home] [Help]

APPS.JAI_CMN_RG_23AC_I_TRXS_PKG dependencies on JAI_GENERAL_PKG

Line 126: ln_fin_year := jai_general_pkg.get_fin_year(p_organization_id);

122: ln_last_updated_by := ln_created_by;
123: ln_last_update_login := FND_GLOBAL.login_id;
124:
125: lv_statement_id := '1';
126: ln_fin_year := jai_general_pkg.get_fin_year(p_organization_id);
127: lv_statement_id := '2';
128: lv_primary_uom_code := jai_general_pkg.get_primary_uom_code(p_organization_id, p_inventory_item_id);
129: lv_statement_id := '3';
130: lv_master_flag := jai_general_pkg.get_orgn_master_flag(p_organization_id, p_location_id);

Line 128: lv_primary_uom_code := jai_general_pkg.get_primary_uom_code(p_organization_id, p_inventory_item_id);

124:
125: lv_statement_id := '1';
126: ln_fin_year := jai_general_pkg.get_fin_year(p_organization_id);
127: lv_statement_id := '2';
128: lv_primary_uom_code := jai_general_pkg.get_primary_uom_code(p_organization_id, p_inventory_item_id);
129: lv_statement_id := '3';
130: lv_master_flag := jai_general_pkg.get_orgn_master_flag(p_organization_id, p_location_id);
131:
132: lv_transaction_type := p_transaction_type;

Line 130: lv_master_flag := jai_general_pkg.get_orgn_master_flag(p_organization_id, p_location_id);

126: ln_fin_year := jai_general_pkg.get_fin_year(p_organization_id);
127: lv_statement_id := '2';
128: lv_primary_uom_code := jai_general_pkg.get_primary_uom_code(p_organization_id, p_inventory_item_id);
129: lv_statement_id := '3';
130: lv_master_flag := jai_general_pkg.get_orgn_master_flag(p_organization_id, p_location_id);
131:
132: lv_transaction_type := p_transaction_type;
133: lv_statement_id := '4';
134: get_trxn_type_and_id(lv_transaction_type, p_transaction_source, ln_transaction_id);

Line 148: jai_general_pkg.get_range_division(p_vendor_id, p_vendor_site_id, lv_range, lv_division);

144: END IF; */
145: --commented by Ramananda for Bug#4516650
146:
147: lv_statement_id := '6';
148: jai_general_pkg.get_range_division(p_vendor_id, p_vendor_site_id, lv_range, lv_division);
149:
150: lv_statement_id := '7';
151: vTransToPrimaryUOMConv := jai_general_pkg.trxn_to_primary_conv_rate
152: (p_transaction_uom_code, lv_primary_uom_code, p_inventory_item_id);

Line 151: vTransToPrimaryUOMConv := jai_general_pkg.trxn_to_primary_conv_rate

147: lv_statement_id := '6';
148: jai_general_pkg.get_range_division(p_vendor_id, p_vendor_site_id, lv_range, lv_division);
149:
150: lv_statement_id := '7';
151: vTransToPrimaryUOMConv := jai_general_pkg.trxn_to_primary_conv_rate
152: (p_transaction_uom_code, lv_primary_uom_code, p_inventory_item_id);
153:
154: ln_quantity := nvl(p_quantity_received, 0) * vTransToPrimaryUOMConv;
155:

Line 157: lv_last_register_id := jai_general_pkg.get_last_record_of_rg

153:
154: ln_quantity := nvl(p_quantity_received, 0) * vTransToPrimaryUOMConv;
155:
156: lv_statement_id := '8';
157: lv_last_register_id := jai_general_pkg.get_last_record_of_rg
158: ('RG23'||p_register_type||'_1', p_organization_id, p_location_id, p_inventory_item_id, ln_fin_year);
159:
160: lv_statement_id := '9';
161: OPEN c_get_last_record(lv_last_register_id);