The following lines contain the word 'select', 'insert', 'update' or 'delete':
select cp.concurrent_program_name, col.column_seq_num seq, col.srw_param token, col.required_flag
from fnd_concurrent_programs_vl cp, fnd_descr_flex_column_usages col
where col.application_id = 300 and cp.application_id = 300
and col.descriptive_flexfield_name = '$SRS$.'||cp.Concurrent_program_name
and cp.enabled_flag = 'Y'
and ( cp.concurrent_program_name ='WSHRDPIK')
and col.srw_param is not null
order by cp.concurrent_program_name,col.column_seq_num,col.application_column_name
*/
/* Included P_PROG_REQUEST_ID as a fix for bug 859003 */
PROCEDURE Print_Document_Sets (X_report_set_id IN number,
P_BATCH_NAME in varchar2 DEFAULT NULL,
P_BATCH_ID in varchar2 DEFAULT NULL,
P_PROG_REQUEST_ID in varchar2 DEFAULT NULL,
P_CATEGORY_HIGH in varchar2 DEFAULT NULL, /* oexshski only */
P_CATEGORY_LOW in varchar2 DEFAULT NULL, /* oexshski only */
P_CUSTOMER_ITEMS in varchar2 DEFAULT NULL,
P_DELIVERY_ID in varchar2 DEFAULT NULL,
P_DEPARTURE_DATE_HI in varchar2 DEFAULT NULL,
P_DEPARTURE_DATE_LO in varchar2 DEFAULT NULL,
P_DEPARTURE_ID in varchar2 DEFAULT NULL,
P_FREIGHT_CARRIER in varchar2 DEFAULT NULL,
P_ITEM in varchar2 DEFAULT NULL,
P_ITEM_DISPLAY in varchar2 DEFAULT NULL,
P_ITEM_FLEX_CODE in varchar2 DEFAULT NULL,
P_LINE_FLAG in varchar2 DEFAULT NULL, /* oexshski only */
P_LOCATOR_FLEX_CODE in varchar2 DEFAULT NULL,
P_ORDER_CATEGORY in varchar2 DEFAULT NULL, /* oexshobr only */
P_ORDER_TYPE_HIGH in varchar2 DEFAULT NULL, /* oexshski only */
P_ORDER_TYPE_LOW in varchar2 DEFAULT NULL, /* oexshski only */
P_ORGANIZATION_ID in varchar2 DEFAULT NULL, /* oexshobr only */
P_PICK_SLIP_NUMBER_HIGH in varchar2 DEFAULT NULL, /* oexshobr only */
P_PICK_SLIP_NUMBER_LOW in varchar2 DEFAULT NULL, /* oexshobr only */
P_PRINT_DESCRIPTION in varchar2 DEFAULT NULL, /* oexshobr only */
P_RELEASE_DATE_HIGH in varchar2 DEFAULT NULL, /* oexshobr only */
P_RELEASE_DATE_LOW in varchar2 DEFAULT NULL, /* oexshobr only */
P_RESERVATIONS in varchar2 DEFAULT NULL, /* oexshobr only */
P_SHIP_DATE_HIGH in varchar2 DEFAULT NULL, /* oexshski only */
P_SHIP_DATE_LOW in varchar2 DEFAULT NULL, /* oexshski only */
P_SOB_ID in varchar2 DEFAULT NULL,
P_USE_FUNCTIONAL_CURRENCY in varchar2 DEFAULT NULL,
P_WAREHOUSE in varchar2 DEFAULT NULL, /* oexshobr only */
P_WAREHOUSE_HIGH in varchar2 DEFAULT NULL, /* oexshski only */
P_WAREHOUSE_ID in varchar2 DEFAULT NULL,
P_WAREHOUSE_LOW in varchar2 DEFAULT NULL, /* oexshski only */
P_TEXT1 in varchar2 default null,
P_TEXT2 in varchar2 default null,
P_TEXT3 in varchar2 default null,
P_TEXT4 in varchar2 default null,
message_string in out varchar2,
status in out boolean) is
BEGIN
declare
shipping_style VARCHAR2(15);
select a.application_id,
a.application_short_name,
f.concurrent_program_id,
f.concurrent_program_name,
f.user_concurrent_program_name,
f.printer_name default_printer_name,
f.output_print_style,
f.save_output_flag,
f.print_flag,
f.execution_method_code
from fnd_concurrent_programs_vl f,
so_report_set_lines rs, fnd_application a
where rs.report_set_id = X_report_set_id
and rs.report_id = f.concurrent_program_id
and rs.application_id = f.application_id
and a.application_id = f.application_id
and f.enabled_flag = 'Y'
order by rs.report_sequence;
select decode (upper(decode(x_execution_method_code,'P',srw_param,end_user_column_name)),
'P_BATCH_NAME',P_BATCH_NAME,
'P_BATCH_ID',P_BATCH_ID,
'P_PROG_REQUEST_ID',P_PROG_REQUEST_ID,
'P_CATEGORY_HIGH',P_CATEGORY_HIGH,
'P_CATEGORY_LOW',P_CATEGORY_LOW,
'P_CUSTOMER_ITEMS',P_CUSTOMER_ITEMS,
'P_DELIVERY_ID',P_DELIVERY_ID,
'P_DEPARTURE_DATE_HI',P_DEPARTURE_DATE_HI,
'P_DEPARTURE_DATE_LO',P_DEPARTURE_DATE_LO,
'P_DEPARTURE_ID',P_DEPARTURE_ID,
'P_FREIGHT_CARRIER',P_FREIGHT_CARRIER,
'P_ITEM',P_ITEM,
'P_ITEM_DISPLAY',P_ITEM_DISPLAY,
'P_ITEM_FLEX_CODE',P_ITEM_FLEX_CODE,
'P_LINE_FLAG',P_LINE_FLAG,
'P_LOCATOR_FLEX_CODE',P_LOCATOR_FLEX_CODE,
'P_ORDER_CATEGORY',P_ORDER_CATEGORY,
'P_ORDER_TYPE_HIGH',P_ORDER_TYPE_HIGH,
'P_ORDER_TYPE_LOW',P_ORDER_TYPE_LOW,
'P_ORGANIZATION_ID',P_ORGANIZATION_ID,
'P_PICK_SLIP_NUMBER_HIGH',P_PICK_SLIP_NUMBER_HIGH,
'P_PICK_SLIP_NUMBER_LOW',P_PICK_SLIP_NUMBER_LOW,
'P_PRINT_DESCRIPTION',P_PRINT_DESCRIPTION,
'P_RELEASE_DATE_HIGH',P_RELEASE_DATE_HIGH,
'P_RELEASE_DATE_LOW',P_RELEASE_DATE_LOW,
'P_RESERVATIONS',P_RESERVATIONS,
'P_SHIP_DATE_HIGH',P_SHIP_DATE_HIGH,
'P_SHIP_DATE_LOW',P_SHIP_DATE_LOW,
'P_SOB_ID',P_SOB_ID,
'P_USE_FUNCTIONAL_CURRENCY',P_USE_FUNCTIONAL_CURRENCY,
'P_WAREHOUSE',P_WAREHOUSE,
'P_WAREHOUSE_HIGH',P_WAREHOUSE_HIGH,
'P_WAREHOUSE_ID',P_WAREHOUSE_ID,
'P_WAREHOUSE_LOW',P_WAREHOUSE_LOW,
'P_TEXT1',P_TEXT1,
'P_TEXT2',P_TEXT2,
'P_TEXT3',P_TEXT3,
'P_TEXT4',P_TEXT4,
'UNSUPPORTED') arg_value,
end_user_column_name,
required_flag,
default_value,
default_type,
flex_value_set_id
from fnd_descr_flex_column_usages
where application_id = x_application_id
and descriptive_flexfield_name = '$SRS$.'||x_concurrent_program_name
and enabled_flag = 'Y'
order by column_seq_num;
select
'select '||ID_COLUMN_NAME||
' from '||APPLICATION_TABLE_NAME,
ADDITIONAL_WHERE_CLAUSE,
' and '|| VALUE_COLUMN_NAME||'=:value'||
' and '|| ENABLED_COLUMN_NAME||'=''Y'''||
' and nvl('|| START_DATE_COLUMN_NAME||',sysdate)<=sysdate'||
' and nvl('|| END_DATE_COLUMN_NAME||',sysdate)>=sysdate'
from fnd_flex_validation_tables
where flex_value_set_id = X_value_set_id
and id_column_name is not null;
select_clause varchar2(250);
SELECT MAX(LEVEL_TYPE_ID)
FROM SO_REPORT_PRINTERS
WHERE REPORT_ID = X_concurrent_program_id
AND APPLICATION_id = x_application_id
AND LEVEL_VALUE_ID = DECODE(LEVEL_TYPE_ID,
10001,0, 10002, FND_GLOBAL.RESP_APPL_ID,
10003,FND_GLOBAL.RESP_ID, 10004, FND_GLOBAL.USER_ID)
AND ENABLE_FLAG = 'Y';
SELECT NVL(PRINTER_NAME, 'No Printer')
FROM SO_REPORT_PRINTERS
WHERE REPORT_ID = X_concurrent_program_id
AND APPLICATION_id = X_application_id
AND LEVEL_TYPE_ID = X_printer_level
AND LEVEL_VALUE_ID = DECODE(X_printer_level,
10001,0, 10002, FND_GLOBAL.RESP_APPL_ID,
10003,FND_GLOBAL.RESP_ID, 10004, FND_GLOBAL.USER_ID)
AND ENABLE_FLAG = 'Y';
fetch value_set_cursor into select_clause, where_clause, additional_clause;
value_set_lookup := select_clause||' where 1=1 ' || additional_clause ||' '|| where_clause;