eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_SETUP_PKG dependencies on JAI_CMN_RG_EXC_INV_NOS

Line 21: v_prefix JAI_CMN_RG_EXC_INV_NOS.prefix%type;

17: v_register_meaning ja_lookups.meaning%type;
18: v_order_type ra_batch_sources_all.name%type; --Ramananda bug#4171671
19: v_invoice_type ra_batch_sources_all.name%type;
20: v_start_number Number;
21: v_prefix JAI_CMN_RG_EXC_INV_NOS.prefix%type;
22: v_jump_by Number;
23: v_end_number Number;
24: v_ec_code Varchar2(50);
25: v_master_org_flag char(1);

Line 77: From JAI_CMN_RG_EXC_INV_NOS

73: AND lookup_code = v_lookup_code;
74:
75: Cursor c_def_excise_cur(p_orgn_id Number , p_loc_id number) is
76: Select start_number , prefix , jump_by , end_number
77: From JAI_CMN_RG_EXC_INV_NOS
78: where organization_id = p_orgn_id
79: and location_id = p_loc_id
80: and fin_year = p_fin_year
81: and order_invoice_type = v_order_type

Line 114: From JAI_CMN_RG_EXC_INV_NOS

110:
111:
112: Cursor c_excise_cur(p_orgn_id Number , p_loc_id number) is
113: Select nvl(gp1,0) , nvl(gp2,0)
114: From JAI_CMN_RG_EXC_INV_NOS
115: where organization_id = p_orgn_id
116: and location_id = p_loc_id
117: and fin_year = p_fin_year
118: AND order_invoice_type IS NULL

Line 187: 2) Added if condition to update table JAI_CMN_RG_EXC_INV_NOS for the records where EXCISE_INVNO_AT_EC_CODE = 'N'

183: FP: Modified the code to generate excise invoice number for Projects Billing.
184:
185: 3. 28-Jan-2009 JMEENA for bug#7719911
186: 1) Removed the condition of EXCISE_INVNO_AT_EC_CODE flag from cursor c_tr_ec_code_cur as this should not be checked for trading organizations.
187: 2) Added if condition to update table JAI_CMN_RG_EXC_INV_NOS for the records where EXCISE_INVNO_AT_EC_CODE = 'N'
188: for the manufacturing organizations because such records will not be fetched by cursor c_ec_code_cur so invoice number
189: will not be updated to next number for that organization.
190: 3) FP of bug#7505975
191: Issue: Excise Invoice Number for a Trading organization with Master-- Child setup

Line 358: -- in the case of RTV transactions , the value 'RTV' is hard coded in the JAI_CMN_RG_EXC_INV_NOS

354: Fetch c_register_meaning_cur into v_register_meaning;
355: Close c_register_meaning_cur;
356:
357: elsif P_CALLED_FROM = 'P' then
358: -- in the case of RTV transactions , the value 'RTV' is hard coded in the JAI_CMN_RG_EXC_INV_NOS
359: -- when preferences are setup for a RTV transaction.
360: v_register_code := 'RTV';
361: v_order_type := 'RTV';
362: v_register_meaning := 'RTV';

Line 372: update JAI_CMN_RG_EXC_INV_NOS

368: -- get updated after excise invoice generation has occured and this is used to prevent a deadlock.
369:
370: Fnd_File.PUT_LINE(Fnd_File.LOG,'Before update time is ' || to_char(sysdate,'dd-mon-yyyy hh:mi:ss'));
371:
372: update JAI_CMN_RG_EXC_INV_NOS
373: set last_update_date = last_update_date
374: where fin_year = p_fin_year
375: AND order_invoice_type IS NULL
376: AND register_code IS NULL

Line 617: UPDATE JAI_CMN_RG_EXC_INV_NOS

613: -- we have not used gp1 , gp2 hence should not update those columns.
614: -- instead should update the column start number instead.
615:
616: IF v_trans_type_up IN ('DOM','EXP') THEN
617: UPDATE JAI_CMN_RG_EXC_INV_NOS
618: SET start_number = v_start_number,
619: last_update_date = sysdate
620: WHERE organization_id = v_act_organization_id
621: AND location_id = v_act_location_id

Line 628: UPDATE JAI_CMN_RG_EXC_INV_NOS

624: AND register_code =v_register_meaning
625: AND transaction_type = v_trans_type_up;
626:
627: ELSIF NVL(v_ec_code_gen,'N') = 'N' Then /*Added by nprashar for bug 7344638*/
628: UPDATE JAI_CMN_RG_EXC_INV_NOS
629: SET start_number = v_start_number,
630: last_update_date = sysdate
631: WHERE organization_id = v_act_organization_id
632: AND location_id = v_act_location_id

Line 649: UPDATE JAI_CMN_RG_EXC_INV_NOS

645:
646: -- End of bug 3071342
647: FOR master_org_rec IN c_tr_ec_code_cur(v_act_organization_id, v_act_location_id) LOOP
648:
649: UPDATE JAI_CMN_RG_EXC_INV_NOS
650: SET start_number = v_start_number
651: WHERE organization_id = master_org_rec.organization_id
652: AND location_id = master_org_rec.location_id
653: AND fin_year = p_fin_year

Line 661: UPDATE JAI_CMN_RG_EXC_INV_NOS

657: END LOOP;
658:
659: ELSE
660: IF NVL(v_ec_code_gen,'N') = 'N' Then --Added by JMEENA for bug#7719911
661: UPDATE JAI_CMN_RG_EXC_INV_NOS
662: SET start_number = v_start_number
663: WHERE organization_id = v_act_organization_id
664: AND location_id = v_act_location_id
665: AND fin_year = p_fin_year

Line 670: UPDATE JAI_CMN_RG_EXC_INV_NOS

666: AND order_invoice_type = v_order_type
667: AND register_code = v_register_meaning;
668: ELSE
669: FOR master_org_rec IN c_ec_code_cur(v_act_organization_id, v_act_location_id) LOOP
670: UPDATE JAI_CMN_RG_EXC_INV_NOS
671: SET start_number = v_start_number
672: WHERE organization_id = master_org_rec.organization_id
673: AND location_id = master_org_rec.location_id
674: AND fin_year = p_fin_year

Line 697: UPDATE JAI_CMN_RG_EXC_INV_NOS

693: -- Start of bug 3071342
694: IF v_register_code IN ('23D_DOMESTIC_EXCISE') OR (p_Called_from = 'INTERORG_XFER' AND r_org_type.trading = 'Y' )/* vkaranam for bug #6030615*/THEN
695: -- End of bug 3071342
696: FOR master_org_rec IN c_tr_ec_code_cur(v_act_organization_id, v_act_location_id) LOOP
697: UPDATE JAI_CMN_RG_EXC_INV_NOS
698: SET gp1 = v_gp1,
699: gp2 = v_gp2
700: WHERE organization_id = master_org_rec.organization_id
701: AND location_id = master_org_rec.location_id

Line 709: UPDATE JAI_CMN_RG_EXC_INV_NOS

705: END LOOP;
706:
707: ELSE
708: IF NVL(v_ec_code_gen,'N') = 'N' Then --Added by JMEENA for bug#7719911
709: UPDATE JAI_CMN_RG_EXC_INV_NOS
710: SET gp1 = v_gp1,
711: gp2 = v_gp2
712: WHERE organization_id =v_act_organization_id
713: AND location_id = v_act_location_id

Line 719: UPDATE JAI_CMN_RG_EXC_INV_NOS

715: AND order_invoice_type IS NULL
716: AND register_code IS NULL;
717: ELSE
718: FOR master_org_rec IN c_ec_code_cur(v_act_organization_id, v_act_location_id) LOOP
719: UPDATE JAI_CMN_RG_EXC_INV_NOS
720: SET gp1 = v_gp1,
721: gp2 = v_gp2
722: WHERE organization_id = master_org_rec.organization_id
723: AND location_id = master_org_rec.location_id