[Home] [Help]
98: and account_class = 'REV';
99:
100: cursor get_created_from is
101: select created_from
102: from ra_customer_trx_all
103: where customer_trx_id = pr_new.customer_trx_id;
104:
105: ld_gl_date date;
106: lv_created_from ra_customer_trx_all.created_from%type;
102: from ra_customer_trx_all
103: where customer_trx_id = pr_new.customer_trx_id;
104:
105: ld_gl_date date;
106: lv_created_from ra_customer_trx_all.created_from%type;
107: ----------------------------------------------------------
108: --added by Zhiwei for bug#14640257 end
109:
110: Cursor complete_info_cur IS
216:
217:
218: v_ref_10 gl_interface.reference10%type; -- := 'India Localization Entry for Invoice # '; -- will hold a standard text such as 'India Localization Entry for sales order'
219: v_ref_23 gl_interface.reference23%type; -- := 'ja_in_ar_hdr_complete_trg'; -- holds the object name -- 'ja_in_ar_hdr_complete_trg'
220: v_ref_24 gl_interface.reference24%type; -- := 'ra_customer_trx_lines_all'; -- holds the table name -- ' ra_customer_trx_all'
221: v_ref_25 gl_interface.reference25%type; -- := 'customer_trx_line_id'; -- holds the column name -- 'customer_trx_id'
222: v_ref_26 gl_interface.reference26%type; -- := v_customer_trx_id; -- holds the column value -- eg -- 13645
223:
224:
305: v_source_name := 'Receivables India'; --Ramananda for File.Sql.35
306: v_category_name := jai_constants.je_category_rg_entry ; -- modified by csahoo for bug#6155839 --'RG Register Data Entry'; --Ramananda for File.Sql.35
307: v_ref_10 := 'India Localization Entry for Invoice # '; -- will hold a standard text such as 'India Localization Entry for sales order'
308: v_ref_23 := 'ja_in_ar_hdr_complete_trg'; -- holds the object name -- 'ja_in_ar_hdr_complete_trg'
309: v_ref_24 := 'ra_customer_trx_lines_all'; -- holds the table name -- ' ra_customer_trx_all'
310: v_ref_25 := 'customer_trx_line_id'; -- holds the column name -- 'customer_trx_id'
311: v_ref_26 := v_customer_trx_id; -- holds the column value -- eg -- 13645
312:
313: OPEN complete_info_cur;