APPS.JAI_OM_RMA_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;

46: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;
47: v_tax_category_id JAI_OM_WSH_LINES_ALL.tax_category_id % TYPE;
48: v_tax_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;
49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
51: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
52: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE; -- added, Harshita for bug#4245062
53: v_excise_flag VARCHAR2(1);
54: v_sales_flag VARCHAR2(1);

Line 51: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;

47: v_tax_category_id JAI_OM_WSH_LINES_ALL.tax_category_id % TYPE;
48: v_tax_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;
49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
51: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
52: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE; -- added, Harshita for bug#4245062
53: v_excise_flag VARCHAR2(1);
54: v_sales_flag VARCHAR2(1);
55: v_vat_flag VARCHAR2(1); -- added, Harshita for bug#4245062

Line 52: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE; -- added, Harshita for bug#4245062

48: v_tax_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;
49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
51: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
52: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE; -- added, Harshita for bug#4245062
53: v_excise_flag VARCHAR2(1);
54: v_sales_flag VARCHAR2(1);
55: v_vat_flag VARCHAR2(1); -- added, Harshita for bug#4245062
56: v_vat_attribute VARCHAR2(1); -- added, Harshita for bug#4245062

Line 73: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type; --Added by Nagaraj.s for Bug3113027

69: v_rate_per_unit JAI_OM_OE_RMA_LINES.rate_per_unit % TYPE;
70: v_excise_total NUMBER;
71: v_rate_total NUMBER;
72: v_qty_total NUMBER;
73: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type; --Added by Nagaraj.s for Bug3113027
74: v_trading JAI_CMN_INVENTORY_ORGS.trading%type; --Added by Nagaraj.s for Bug3113027
75: v_service_type_code JAI_OM_OE_SO_LINES.service_type_code%type; /* added by ssawant for bug 5879769 */
76:
77: CURSOR Localized_Order_Cur(c_delivery_detail_id NUMBER) IS

Line 74: v_trading JAI_CMN_INVENTORY_ORGS.trading%type; --Added by Nagaraj.s for Bug3113027

70: v_excise_total NUMBER;
71: v_rate_total NUMBER;
72: v_qty_total NUMBER;
73: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type; --Added by Nagaraj.s for Bug3113027
74: v_trading JAI_CMN_INVENTORY_ORGS.trading%type; --Added by Nagaraj.s for Bug3113027
75: v_service_type_code JAI_OM_OE_SO_LINES.service_type_code%type; /* added by ssawant for bug 5879769 */
76:
77: CURSOR Localized_Order_Cur(c_delivery_detail_id NUMBER) IS
78: SELECT 1

Line 140: FROM JAI_CMN_INVENTORY_ORGS

136: wnd.delivery_id = wda.delivery_id;
137:
138: Cursor c_hr_organizations_cur( v_organization_id number ) is
139: SELECT vat_return_days
140: FROM JAI_CMN_INVENTORY_ORGS
141: WHERE organization_id = v_organization_id
142: AND location_id = 0;
143:
144: v_ordered_date date ;

Line 492: FROM JAI_CMN_INVENTORY_ORGS

488: sales_return_days,
489: vat_return_days , -- added, Harshita for bug#4245062
490: nvl(manufacturing,'N') manufacturing, --Added Manufacturing and Trading by Nagaraj.s for bug3113027
491: nvl(trading,'N') trading
492: FROM JAI_CMN_INVENTORY_ORGS
493: WHERE organization_id = p_warehouse_id
494: AND location_id = 0)
495: LOOP
496: v_excise_return_days := hr_rec.excise_return_days;