APPS.JAI_CMN_SETUP_PKG dependencies on JA_LOOKUPS

Line 17: v_register_meaning ja_lookups.meaning%type;

13: )
14: As
15:
16: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%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;

Line 75: Cursor c_register_meaning_cur(v_lookup_code JAI_OM_OE_BOND_REG_HDRS.register_code%type, cp_lookup_type ja_lookups.lookup_type%type) is

71: and b.order_flag = p_order_flag
72: and b.order_type_id = p_order_invoice_type_id;
73:
74:
75: Cursor c_register_meaning_cur(v_lookup_code JAI_OM_OE_BOND_REG_HDRS.register_code%type, cp_lookup_type ja_lookups.lookup_type%type) is
76: SELECT meaning
77: FROM ja_lookups
78: WHERE lookup_type = cp_lookup_type --'JAI_REGISTER_TYPE' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
79: AND lookup_code = v_lookup_code;

Line 77: FROM ja_lookups

73:
74:
75: Cursor c_register_meaning_cur(v_lookup_code JAI_OM_OE_BOND_REG_HDRS.register_code%type, cp_lookup_type ja_lookups.lookup_type%type) is
76: SELECT meaning
77: FROM ja_lookups
78: WHERE lookup_type = cp_lookup_type --'JAI_REGISTER_TYPE' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
79: AND lookup_code = v_lookup_code;
80:
81: Cursor c_def_excise_cur(p_orgn_id Number , p_loc_id number) is

Line 860: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_register_type ja_lookups.lookup_type%type ) IS

856: where bol_id = P_BOL_ID
857: and bolline_no = P_BOLLINE_NO ));
858: -- ended
859:
860: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_register_type ja_lookups.lookup_type%type ) IS
861: Select meaning
862: From ja_lookups
863: Where UPPER(lookup_code) LIKE UPPER(p_register_code)
864: And UPPER(lookup_type) = cp_register_type ; --UPPER('JAI_REGISTER_TYPE'); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980

Line 862: From ja_lookups

858: -- ended
859:
860: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_register_type ja_lookups.lookup_type%type ) IS
861: Select meaning
862: From ja_lookups
863: Where UPPER(lookup_code) LIKE UPPER(p_register_code)
864: And UPPER(lookup_type) = cp_register_type ; --UPPER('JAI_REGISTER_TYPE'); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980
865:
866: