[Home] [Help]
12: P_Errbuf OUT NOCOPY Varchar2
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;
63: where batch_source_id = p_order_invoice_type_id;
64:
65: Cursor c_get_register(p_orgn_id number,p_locn_id number,p_order_flag varchar2) is
66: select a.register_code
67: from JAI_OM_OE_BOND_REG_HDRS a , JAI_OM_OE_BOND_REG_DTLS b
68: where a.organization_id = p_orgn_id
69: and a.location_id = p_locn_id
70: and a.register_id = b.register_id
71: and b.order_flag = p_order_flag
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;
831:
832: -- start commted by Uday on 23-0CT-2001
833: /* Cursor register_code_cur ( s_orgn_code IN Varchar2 ) Is
834: SELECT a.register_code
835: FROM JAI_OM_OE_BOND_REG_HDRS a, JAI_OM_OE_BOND_REG_DTLS b,sy_orgn_mst c
836: WHERE a.organization_id = c.organization_id
837: AND UPPER(c.orgn_code) = UPPER(s_orgn_code) ------org_changed
838: AND a.register_id = b.register_id
839: AND b.order_flag = 'Y'
845:
846: -- start modified above code on 23-oct-2001 by Uday.
847: Cursor register_code_cur ( s_orgn_code IN Varchar2 ) Is
848: SELECT a.register_code
849: FROM JAI_OM_OE_BOND_REG_HDRS a, JAI_OM_OE_BOND_REG_DTLS b,org_organization_definitions c
850: WHERE a.organization_id = c.organization_id
851: AND UPPER(c.organization_code) = UPPER(s_orgn_code) ------org_changed
852: AND a.register_id = b.register_id
853: AND b.order_flag = 'Y'