APPS.FTP_TP_PKG dependencies on DUAL

Line 545: select ftp_node_map_id_seq.nextval into map_id from dual;

541: e_e_date in date) return number
542: is
543: map_id number;
544: begin
545: select ftp_node_map_id_seq.nextval into map_id from dual;
546: insert into ftp_tp_pp_node_header (
547: node_map_id,
548: tp_process_object_def_id,
549: tp_object_def_id,

Line 1640: select INSTR(modify_valid_table_list,',') into pos from dual;

1636: If (valid_table_list IS NOT NULL) THEN
1637: modify_valid_table_list := valid_table_list || ',';
1638: i := 1;
1639: while( len2 > 0) LOOP
1640: select INSTR(modify_valid_table_list,',') into pos from dual;
1641: select length(modify_valid_table_list) into len from dual;
1642: select substr(modify_valid_table_list,0,pos-1) into token from dual;
1643: select LTRIM(RTRIM(token,''''),'''') into token from dual;
1644:

Line 1641: select length(modify_valid_table_list) into len from dual;

1637: modify_valid_table_list := valid_table_list || ',';
1638: i := 1;
1639: while( len2 > 0) LOOP
1640: select INSTR(modify_valid_table_list,',') into pos from dual;
1641: select length(modify_valid_table_list) into len from dual;
1642: select substr(modify_valid_table_list,0,pos-1) into token from dual;
1643: select LTRIM(RTRIM(token,''''),'''') into token from dual;
1644:
1645: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1642: select substr(modify_valid_table_list,0,pos-1) into token from dual;

1638: i := 1;
1639: while( len2 > 0) LOOP
1640: select INSTR(modify_valid_table_list,',') into pos from dual;
1641: select length(modify_valid_table_list) into len from dual;
1642: select substr(modify_valid_table_list,0,pos-1) into token from dual;
1643: select LTRIM(RTRIM(token,''''),'''') into token from dual;
1644:
1645: FEM_ENGINES_PKG.TECH_MESSAGE(
1646: p_severity => fnd_log.level_error,

Line 1643: select LTRIM(RTRIM(token,''''),'''') into token from dual;

1639: while( len2 > 0) LOOP
1640: select INSTR(modify_valid_table_list,',') into pos from dual;
1641: select length(modify_valid_table_list) into len from dual;
1642: select substr(modify_valid_table_list,0,pos-1) into token from dual;
1643: select LTRIM(RTRIM(token,''''),'''') into token from dual;
1644:
1645: FEM_ENGINES_PKG.TECH_MESSAGE(
1646: p_severity => fnd_log.level_error,
1647: p_module => g_block || '.tokens_generation',

Line 1659: select substr(modify_valid_table_list,pos+1,len) into modify_valid_table_list from dual;

1655: p_module => g_block || '.tokens_generation',
1656: p_msg_text => 'Before substr modify_valid_table_list= '|| modify_valid_table_list
1657: );
1658:
1659: select substr(modify_valid_table_list,pos+1,len) into modify_valid_table_list from dual;
1660:
1661: FEM_ENGINES_PKG.TECH_MESSAGE(
1662: p_severity => fnd_log.level_error,
1663: p_module => g_block || '.tokens_generation',

Line 1667: select length(modify_valid_table_list) into len2 from dual;

1663: p_module => g_block || '.tokens_generation',
1664: p_msg_text => 'After substr modify_valid_table_list= '|| modify_valid_table_list
1665: );
1666:
1667: select length(modify_valid_table_list) into len2 from dual;
1668: i := i + 1;
1669: END LOOP;
1670: ELSE
1671: OPEN l_cur_tables;

Line 2690: select RTRIM(valid_table_list,',') into new_valid_table_list from dual;

2686:
2687: LAST_OBJID_COL := 'last_updated_by_object_id';
2688: LAST_REQID_COL := 'last_updated_by_request_id';
2689:
2690: select RTRIM(valid_table_list,',') into new_valid_table_list from dual;
2691: valid_table_list := new_valid_table_list;
2692:
2693: FND_MSG_PUB.Count_And_Get
2694: (p_encoded => 'F',