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 608: l_item_type wf_items.item_type%TYPE;

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

Line 609: l_item_key wf_items.item_key%TYPE;

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

Line 852: l_item_type wf_items.item_type%TYPE;

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

Line 853: l_item_key wf_items.item_key%TYPE;

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