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 69: 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

65: and b.order_flag = p_order_flag
66: and b.order_type_id = p_order_invoice_type_id;
67:
68:
69: 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
70: SELECT meaning
71: FROM ja_lookups
72: WHERE lookup_type = cp_lookup_type --'JAI_REGISTER_TYPE' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
73: AND lookup_code = v_lookup_code;

Line 71: FROM ja_lookups

67:
68:
69: 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
70: SELECT meaning
71: FROM ja_lookups
72: WHERE lookup_type = cp_lookup_type --'JAI_REGISTER_TYPE' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
73: AND lookup_code = v_lookup_code;
74:
75: Cursor c_def_excise_cur(p_orgn_id Number , p_loc_id number) is

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

801: where bol_id = P_BOL_ID
802: and bolline_no = P_BOLLINE_NO ));
803: -- ended
804:
805: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_register_type ja_lookups.lookup_type%type ) IS
806: Select meaning
807: From ja_lookups
808: Where UPPER(lookup_code) LIKE UPPER(p_register_code)
809: And UPPER(lookup_type) = cp_register_type ; --UPPER('JAI_REGISTER_TYPE'); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980

Line 807: From ja_lookups

803: -- ended
804:
805: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_register_type ja_lookups.lookup_type%type ) IS
806: Select meaning
807: From ja_lookups
808: Where UPPER(lookup_code) LIKE UPPER(p_register_code)
809: And UPPER(lookup_type) = cp_register_type ; --UPPER('JAI_REGISTER_TYPE'); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980
810:
811: