APPS.PO_NEGOTIATION_REQ_NOTIF dependencies on WF_ITEMS

Line 121: from wf_items

117: -- if it has, don't create process again.
118: begin
119: select count(*)
120: into x_wf_created
121: from wf_items
122: where item_type = ItemType
123: and item_key = ItemKey;
124: exception
125: when others then

Line 336: l_item_type wf_items.item_type%TYPE;

332: l_line line_record;
333: NL VARCHAR2(1) := fnd_global.newline;
334: l_document varchar2(32000) := '';
335: l_document_id number;
336: l_item_type wf_items.item_type%TYPE;
337: l_item_key wf_items.item_key%TYPE;
338: l_message_text varchar2(2000);
339: l_message_text1 varchar2(2000);
340: l_negotiation_num varchar2(50);

Line 337: l_item_key wf_items.item_key%TYPE;

333: NL VARCHAR2(1) := fnd_global.newline;
334: l_document varchar2(32000) := '';
335: l_document_id number;
336: l_item_type wf_items.item_type%TYPE;
337: l_item_key wf_items.item_key%TYPE;
338: l_message_text varchar2(2000);
339: l_message_text1 varchar2(2000);
340: l_negotiation_num varchar2(50);
341: l_source varchar2(60);

Line 609: l_item_type wf_items.item_type%TYPE;

605: l_line line_record;
606: NL VARCHAR2(1) := fnd_global.newline;
607: l_document varchar2(32000) := '';
608: l_document_id number;
609: l_item_type wf_items.item_type%TYPE;
610: l_item_key wf_items.item_key%TYPE;
611: l_message_text varchar2(2000) := null;
612: l_message_text1 varchar2(2000) := null;
613: l_message_ct varchar2(240);

Line 610: l_item_key wf_items.item_key%TYPE;

606: NL VARCHAR2(1) := fnd_global.newline;
607: l_document varchar2(32000) := '';
608: l_document_id number;
609: l_item_type wf_items.item_type%TYPE;
610: l_item_key wf_items.item_key%TYPE;
611: l_message_text varchar2(2000) := null;
612: l_message_text1 varchar2(2000) := null;
613: l_message_ct varchar2(240);
614: l_negotiation_num varchar2(50);

Line 855: l_item_type wf_items.item_type%TYPE;

851: document_type in out NOCOPY varchar2) IS
852:
853: NL VARCHAR2(1) := fnd_global.newline;
854: l_document varchar2(32000) := '';
855: l_item_type wf_items.item_type%TYPE;
856: l_item_key wf_items.item_key%TYPE;
857: l_message_text varchar2(30000) := null;
858: x_progress varchar2(3) := null;
859:

Line 856: l_item_key wf_items.item_key%TYPE;

852:
853: NL VARCHAR2(1) := fnd_global.newline;
854: l_document varchar2(32000) := '';
855: l_item_type wf_items.item_type%TYPE;
856: l_item_key wf_items.item_key%TYPE;
857: l_message_text varchar2(30000) := null;
858: x_progress varchar2(3) := null;
859:
860: BEGIN