DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_IN_SRV_PKG dependencies on DUAL

Line 216: FROM sys.dual;

212: BEGIN
213:
214: SELECT csi_pa_interface_s.nextval
215: INTO l_ref_suffix_inner -- Changes for bug 7368371
216: FROM sys.dual;
217:
218: x_nl_pa_interface_rec.transaction_source := p_ei_rec.transaction_source;
219: x_nl_pa_interface_rec.batch_name := p_in_srv_pa_attr_rec.transaction_id;
220: x_nl_pa_interface_rec.expenditure_ending_date := p_ei_rec.expenditure_ending_date;

Line 476: FROM sys.dual;

472: debug(' capitalizable quantity : '||l_exp_item_rec.quantity);
473:
474: SELECT csi_pa_interface_s.nextval
475: INTO l_ref_sufix
476: FROM sys.dual;
477:
478: l_nl_pa_interface_tbl(i).transaction_source := ei_rec.transaction_source;
479: l_nl_pa_interface_tbl(i).batch_name := p_in_srv_pa_attr_rec.transaction_id;
480: l_nl_pa_interface_tbl(i).expenditure_ending_date := ei_rec.expenditure_ending_date;

Line 568: FROM sys.dual;

564: l_nl_pa_interface_tbl(i) := l_nl_pa_interface_tbl(i-1);
565:
566: SELECT csi_pa_interface_s.nextval
567: INTO l_ref_sufix
568: FROM sys.dual;
569:
570: l_nl_pa_interface_tbl(i).orig_transaction_reference := p_in_srv_pa_attr_rec.transaction_id;
571: l_nl_pa_interface_tbl(i).attribute8 := null;
572: l_nl_pa_interface_tbl(i).attribute9 := null;