APPS.BOMPLDCI dependencies on DUAL

Line 137: select length(ci_delimiter) into del_len from dual;

133: */
134:
135: /* ATOPUTIL.info('In BOMPLDCI'); */
136: stmt_num := 5;
137: select length(ci_delimiter) into del_len from dual;
138: if (del_len <> 1 ) then
139: raise del_error;
140: else
141: ci_del := substrb(ci_delimiter,1,1);

Line 623: from dual;

619: 18,'and S2.segment18 = I.segment18',
620: 19,'and S2.segment19 = I.segment19',
621: 20,'and S2.segment20 = I.segment20')
622: into dupl_tmp_stmt
623: from dual;
624: dupl_total_stmt := dupl_total_stmt || ' ' || dupl_tmp_stmt ;
625:
626: else
627:

Line 649: from dual;

645: 18,'and nvl(S2.segment18,'' '') = nvl(I.segment18,'' '')',
646: 19,'and nvl(S2.segment19,'' '') = nvl(I.segment19,'' '')',
647: 20,'and nvl(S2.segment20,'' '') = nvl(I.segment20,'' '')')
648: into dupl_tmp_stmt
649: from dual;
650: dupl_total_stmt := dupl_total_stmt || ' ' || dupl_tmp_stmt;
651:
652: end if;
653: end loop;

Line 692: from dual;

688: 18,'and I2.segment18 = I.segment18',
689: 19,'and I2.segment19 = I.segment19',
690: 20,'and I2.segment20 = I.segment20')
691: into dupl_tmp_stmt
692: from dual;
693: dupl_total_stmt := dupl_total_stmt || ' ' || dupl_tmp_stmt ;
694:
695: else
696:

Line 718: from dual;

714: 18,'and nvl(I2.segment18,'' '') = nvl(I.segment18,'' '')',
715: 19,'and nvl(I2.segment19,'' '') = nvl(I.segment19,'' '')',
716: 20,'and nvl(I2.segment20,'' '') = nvl(I.segment20,'' '')')
717: into dupl_tmp_stmt
718: from dual;
719: dupl_total_stmt := dupl_total_stmt || ' ' || dupl_tmp_stmt;
720:
721: end if;
722: end loop;

Line 785: from dual;

781:
782: stmt_num := 37;
783: select TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL)
784: into hold_next_seq
785: from dual;
786:
787: /* ATOPUTIL.info('About to update MSI_Intf'); */
788:
789: table_name := 'UPDATE MTL_SYSTEM_ITEMS_IF ';