eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_FLOW_REQUESTS_PKG dependencies on PARAM_DETAIL

Line 49: p_param_details in out NOCOPY PARAM_DETAIL_ARRAY,

45: procedure create_request ( p_process_flow_id in number,
46: p_no_of_params in number,
47: p_asg_action in number,
48: p_asg_set_var_id in number,
49: p_param_details in out NOCOPY PARAM_DETAIL_ARRAY,
50: p_process_request_id OUT NOCOPY number
51: ) IS
52:
53: -- Variable Declaration

Line 108: hr_utility.trace(nvl(to_char(p_param_details(table_row).param_name),'null')||' '||

104: where process_flow_id = p_process_flow_id;
105:
106: FOR table_row in 1 .. p_no_of_params
107: LOOP
108: hr_utility.trace(nvl(to_char(p_param_details(table_row).param_name),'null')||' '||
109: nvl(to_char(p_param_details(table_row).param_id),'null')||' '||
110: nvl(to_char(p_param_details(table_row).set_var_id),'null')||' '||
111: nvl(to_char(p_param_details(table_row).set_var_seq),'null')||' '||
112: nvl(to_char(p_param_details(table_row).set_var_val),'null')||' '||

Line 109: nvl(to_char(p_param_details(table_row).param_id),'null')||' '||

105:
106: FOR table_row in 1 .. p_no_of_params
107: LOOP
108: hr_utility.trace(nvl(to_char(p_param_details(table_row).param_name),'null')||' '||
109: nvl(to_char(p_param_details(table_row).param_id),'null')||' '||
110: nvl(to_char(p_param_details(table_row).set_var_id),'null')||' '||
111: nvl(to_char(p_param_details(table_row).set_var_seq),'null')||' '||
112: nvl(to_char(p_param_details(table_row).set_var_val),'null')||' '||
113: nvl(to_char(p_param_details(table_row).default_type),'null'));

Line 110: nvl(to_char(p_param_details(table_row).set_var_id),'null')||' '||

106: FOR table_row in 1 .. p_no_of_params
107: LOOP
108: hr_utility.trace(nvl(to_char(p_param_details(table_row).param_name),'null')||' '||
109: nvl(to_char(p_param_details(table_row).param_id),'null')||' '||
110: nvl(to_char(p_param_details(table_row).set_var_id),'null')||' '||
111: nvl(to_char(p_param_details(table_row).set_var_seq),'null')||' '||
112: nvl(to_char(p_param_details(table_row).set_var_val),'null')||' '||
113: nvl(to_char(p_param_details(table_row).default_type),'null'));
114: END LOOP;

Line 111: nvl(to_char(p_param_details(table_row).set_var_seq),'null')||' '||

107: LOOP
108: hr_utility.trace(nvl(to_char(p_param_details(table_row).param_name),'null')||' '||
109: nvl(to_char(p_param_details(table_row).param_id),'null')||' '||
110: nvl(to_char(p_param_details(table_row).set_var_id),'null')||' '||
111: nvl(to_char(p_param_details(table_row).set_var_seq),'null')||' '||
112: nvl(to_char(p_param_details(table_row).set_var_val),'null')||' '||
113: nvl(to_char(p_param_details(table_row).default_type),'null'));
114: END LOOP;
115:

Line 112: nvl(to_char(p_param_details(table_row).set_var_val),'null')||' '||

108: hr_utility.trace(nvl(to_char(p_param_details(table_row).param_name),'null')||' '||
109: nvl(to_char(p_param_details(table_row).param_id),'null')||' '||
110: nvl(to_char(p_param_details(table_row).set_var_id),'null')||' '||
111: nvl(to_char(p_param_details(table_row).set_var_seq),'null')||' '||
112: nvl(to_char(p_param_details(table_row).set_var_val),'null')||' '||
113: nvl(to_char(p_param_details(table_row).default_type),'null'));
114: END LOOP;
115:
116: END if;

Line 113: nvl(to_char(p_param_details(table_row).default_type),'null'));

109: nvl(to_char(p_param_details(table_row).param_id),'null')||' '||
110: nvl(to_char(p_param_details(table_row).set_var_id),'null')||' '||
111: nvl(to_char(p_param_details(table_row).set_var_seq),'null')||' '||
112: nvl(to_char(p_param_details(table_row).set_var_val),'null')||' '||
113: nvl(to_char(p_param_details(table_row).default_type),'null'));
114: END LOOP;
115:
116: END if;
117:

Line 206: FOR source_set_var in csr_override_set_vars(p_param_details(no_of_row).set_var_id)

202:
203: FOR no_of_row in 1 .. p_no_of_params
204: LOOP
205:
206: FOR source_set_var in csr_override_set_vars(p_param_details(no_of_row).set_var_id)
207: LOOP
208:
209: update pay_para_set_var_values
210: set set_variable_value = p_param_details(no_of_row).set_var_val,

Line 210: set set_variable_value = p_param_details(no_of_row).set_var_val,

206: FOR source_set_var in csr_override_set_vars(p_param_details(no_of_row).set_var_id)
207: LOOP
208:
209: update pay_para_set_var_values
210: set set_variable_value = p_param_details(no_of_row).set_var_val,
211: last_update_date = sysdate,
212: last_updated_by = fnd_global.user_id,
213: last_update_login = fnd_global.login_id
214: where set_variable_id = source_set_var.destin_set_var_id

Line 222: if(p_param_details(no_of_row).default_type = 'INCREMENT_VALUE') THEN

218: from pay_para_set_var_values
219: where set_Variable_id = source_set_var.destin_set_var_id
220: and process_req_seq_id = l_curr_request_id;
221:
222: if(p_param_details(no_of_row).default_type = 'INCREMENT_VALUE') THEN
223: --
224: p_param_details(no_of_row).set_var_val := p_param_details(no_of_row).set_var_val + 1;
225: --
226: END IF;

Line 224: p_param_details(no_of_row).set_var_val := p_param_details(no_of_row).set_var_val + 1;

220: and process_req_seq_id = l_curr_request_id;
221:
222: if(p_param_details(no_of_row).default_type = 'INCREMENT_VALUE') THEN
223: --
224: p_param_details(no_of_row).set_var_val := p_param_details(no_of_row).set_var_val + 1;
225: --
226: END IF;
227:
228: END LOOP;