APPS.ZPB_PUBLISH dependencies on ZPB_TASK_PARAMETERS

Line 206: from ZPB_TASK_PARAMETERS

202: textVarValArray Wf_Engine.TextTabTyp; -- Text Array of Item Attribute Values
203:
204: CURSOR c_recipient is
205: select NAME, value
206: from ZPB_TASK_PARAMETERS
207: where TASK_ID = TaskID and name = 'SPECIFIED_NOTIFICATION_RECIPIENT';
208:
209: v_recipient c_recipient%ROWTYPE;
210:

Line 213: from ZPB_TASK_PARAMETERS

209: v_recipient c_recipient%ROWTYPE;
210:
211: CURSOR c_datasources is
212: select NAME, value
213: from ZPB_TASK_PARAMETERS
214: where TASK_ID = TaskID and name = 'TEMPLATE_DATASOURCE';
215:
216: v_datasources c_datasources%ROWTYPE;
217:

Line 282: FROM zpb_task_parameters

278: length(datasources_list) - length(l_char_delim));
279:
280: --Getting the Template Name used to create the Document
281: SELECT value INTO template_name
282: FROM zpb_task_parameters
283: WHERE task_ID = taskID and NAME = 'DOCUMENT_TEMPLATE_NAME';
284:
285: --Getting the Document Security used
286: SELECT value INTO read_access

Line 287: FROM zpb_task_parameters

283: WHERE task_ID = taskID and NAME = 'DOCUMENT_TEMPLATE_NAME';
284:
285: --Getting the Document Security used
286: SELECT value INTO read_access
287: FROM zpb_task_parameters
288: WHERE task_ID = taskID and NAME = 'DOCUMENT_SECURITY';
289: IF read_access = 'USER_READSCOPE' THEN
290: read_access := fnd_message.get_string('ZPB', 'ZPB_RECIPIENT_READ_SCOPE');
291: ELSE

Line 297: FROM zpb_task_parameters

293: END IF;
294:
295: --To find whether the Approval required CheckBox is selected
296: SELECT value INTO appr_flag
297: FROM zpb_task_parameters
298: WHERE task_ID = taskID and NAME = 'DOCUMENT_WAIT_FOR_APPROVAL';
299:
300: --To find whether Send Status Report CheckBox is selected
301: SELECT value INTO send_status_flag

Line 302: FROM zpb_task_parameters

298: WHERE task_ID = taskID and NAME = 'DOCUMENT_WAIT_FOR_APPROVAL';
299:
300: --To find whether Send Status Report CheckBox is selected
301: SELECT value INTO send_status_flag
302: FROM zpb_task_parameters
303: WHERE task_ID = taskID and NAME = 'DOCUMENT_SEND_STATUS_BPO';
304:
305: -- Get the short text from fnd messages
306: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_CAL_JAVA_XML_GEN_ISSUE_MSG');