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.

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_ACTION_HISTORY

Line 3808: l_action_code po_action_history.action_code%type;

3804: p_path_id number) is
3805:
3806: pragma AUTONOMOUS_TRANSACTION;
3807:
3808: l_action_code po_action_history.action_code%type;
3809: l_revision_num number := NULL;
3810: l_hist_count number := NULL;
3811: l_sequence_num number := NULL;
3812: l_approval_path_id number;

Line 3817: from po_action_history

3813: l_buyer_id number;
3814:
3815: CURSOR action_hist_cursor(doc_id number , doc_type varchar2) is
3816: select max(sequence_num)
3817: from po_action_history
3818: where object_id= doc_id and
3819: object_type_code = doc_type;
3820:
3821: CURSOR action_hist_code_cursor (doc_id number , doc_type varchar2, seq_num number) is

Line 3823: from po_action_history

3819: object_type_code = doc_type;
3820:
3821: CURSOR action_hist_code_cursor (doc_id number , doc_type varchar2, seq_num number) is
3822: select action_code
3823: from po_action_history
3824: where object_id = doc_id and
3825: object_type_code = doc_type and
3826: sequence_num = seq_num;
3827:

Line 3887: INSERT into PO_ACTION_HISTORY

3883: IF ((l_sequence_num = 1)
3884: OR
3885: (l_sequence_num > 1 and l_action_code is NOT NULL)) THEN
3886: x_progress := '007';
3887: INSERT into PO_ACTION_HISTORY
3888: (object_id,
3889: object_type_code,
3890: object_sub_type_code,
3891: sequence_num,

Line 3935: UPDATE PO_ACTION_HISTORY

3931: ELSE
3932: l_sequence_num := l_sequence_num - 1;
3933: x_progress := '009';
3934:
3935: UPDATE PO_ACTION_HISTORY
3936: set object_id = p_doc_id,
3937: object_type_code = p_doc_type,
3938: object_sub_type_code = p_doc_subtype,
3939: sequence_num = l_sequence_num,

Line 3980: INSERT into PO_ACTION_HISTORY

3976: FROM po_headers_all
3977: WHERE PO_HEADER_ID = p_doc_id;
3978:
3979:
3980: INSERT into PO_ACTION_HISTORY
3981: (object_id,
3982: object_type_code,
3983: object_sub_type_code,
3984: sequence_num,

Line 4265: l_note po_action_history.note%TYPE;

4261: and pcr.document_header_id=por.requisition_header_id;
4262:
4263: l_old_req_amount varchar2(40);
4264: l_old_tax_amount varchar2(40);
4265: l_note po_action_history.note%TYPE;
4266: l_old_amount_currency varchar2(40);
4267: l_new_amount_currency varchar2(40);
4268: l_old_tax_currency varchar2(40);
4269: l_new_tax_currency varchar2(40);

Line 5115: l_note PO_ACTION_HISTORY.note%TYPE;

5111:
5112: l_doc_id number;
5113: l_doc_type varchar2(25);
5114: l_doc_subtype varchar2(25);
5115: l_note PO_ACTION_HISTORY.note%TYPE;
5116: l_employee_id number;
5117: l_orgid number;
5118:
5119: x_progress varchar2(100);

Line 5828: INSERT into PO_ACTION_HISTORY

5824:
5825: pragma AUTONOMOUS_TRANSACTION;
5826:
5827: begin
5828: INSERT into PO_ACTION_HISTORY
5829: (object_id,
5830: object_type_code,
5831: object_sub_type_code,
5832: sequence_num,

Line 5912: l_action_code po_action_history.action_code%type;

5908:
5909: l_change_request_group_id number;
5910: l_change_request_id number;
5911:
5912: l_action_code po_action_history.action_code%type;
5913: l_new_action_code po_action_history.action_code%type;
5914: l_employee_id number;
5915: l_sequence_num number;
5916:

Line 5913: l_new_action_code po_action_history.action_code%type;

5909: l_change_request_group_id number;
5910: l_change_request_id number;
5911:
5912: l_action_code po_action_history.action_code%type;
5913: l_new_action_code po_action_history.action_code%type;
5914: l_employee_id number;
5915: l_sequence_num number;
5916:
5917: cursor l_approved_change_request_csr(grp_id number) is

Line 5972: FROM PO_ACTION_HISTORY

5968: END IF;
5969:
5970: SELECT max(sequence_num)
5971: INTO l_sequence_num
5972: FROM PO_ACTION_HISTORY
5973: WHERE object_type_code = 'REQUISITION'
5974: AND object_id = l_document_id;
5975:
5976: select action_code, employee_id, object_revision_num, approval_path_id

Line 5978: from po_action_history

5974: AND object_id = l_document_id;
5975:
5976: select action_code, employee_id, object_revision_num, approval_path_id
5977: into l_action_code, l_employee_id, l_object_rev_num, l_approval_path_id
5978: from po_action_history
5979: where object_id=l_document_id
5980: and object_type_code='REQUISITION'
5981: and sequence_num=l_sequence_num;
5982:

Line 6130: /* update po action history */

6126: l_progress := 'Update_Action_History_Return: 002-'||
6127: to_char(l_document_id)||'-'||
6128: l_document_type||'-'||l_document_subtype;
6129:
6130: /* update po action history */
6131: PO_APPROVAL_LIST_HISTORY_SV.Update_Action_History(itemtype=>itemtype,
6132: itemkey=>itemkey,
6133: x_action=>l_action,
6134: x_req_header_id=>l_document_id,

Line 7121: l_note PO_ACTION_HISTORY.note%TYPE;

7117:
7118: l_doc_id number;
7119: l_doc_type varchar2(25);
7120: l_doc_subtype varchar2(25);
7121: l_note PO_ACTION_HISTORY.note%TYPE;
7122: l_employee_id number;
7123: l_orgid number;
7124: l_count number;
7125: l_action varchar2(10);

Line 7915: l_note po_action_history.note%TYPE;

7911: t_varname Wf_Engine.NameTabTyp;
7912: t_varval Wf_Engine.TextTabTyp;
7913: l_doc_string varchar2(200);
7914: l_preparer_user_name varchar2(100);
7915: l_note po_action_history.note%TYPE;
7916: l_old_amount_currency varchar2(40);
7917: l_old_tax_currency varchar2(40);
7918: l_new_amount_currency number;
7919: L_NEW_TAX_CURRENCY number;

Line 10602: -- update PO action history as accepted by buyer

10598: avalue => l_document_number );
10599:
10600: l_progress := 'PO_ReqChangeRequestWF_PVT.Accept_Po_Changes: 05';
10601:
10602: -- update PO action history as accepted by buyer
10603: InsertActionHist(itemtype, itemkey, l_document_id, l_document_type,
10604: l_document_subtype, l_buyer_id, 'ACCEPT', '', null);
10605:
10606: l_progress := 'PO_ReqChangeRequestWF_PVT.Accept_Po_Changes: 06';