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 3665: l_action_code po_action_history.action_code%type;

3661: p_path_id number) is
3662:
3663: pragma AUTONOMOUS_TRANSACTION;
3664:
3665: l_action_code po_action_history.action_code%type;
3666: l_revision_num number := NULL;
3667: l_hist_count number := NULL;
3668: l_sequence_num number := NULL;
3669: l_approval_path_id number;

Line 3673: from po_action_history

3669: l_approval_path_id number;
3670:
3671: CURSOR action_hist_cursor(doc_id number , doc_type varchar2) is
3672: select max(sequence_num)
3673: from po_action_history
3674: where object_id= doc_id and
3675: object_type_code = doc_type;
3676:
3677: CURSOR action_hist_code_cursor (doc_id number , doc_type varchar2, seq_num number) is

Line 3679: from po_action_history

3675: object_type_code = doc_type;
3676:
3677: CURSOR action_hist_code_cursor (doc_id number , doc_type varchar2, seq_num number) is
3678: select action_code
3679: from po_action_history
3680: where object_id = doc_id and
3681: object_type_code = doc_type and
3682: sequence_num = seq_num;
3683:

Line 3743: INSERT into PO_ACTION_HISTORY

3739: IF ((l_sequence_num = 0)
3740: OR
3741: (l_sequence_num > 0 and l_action_code is NOT NULL)) THEN
3742: x_progress := '007';
3743: INSERT into PO_ACTION_HISTORY
3744: (object_id,
3745: object_type_code,
3746: object_sub_type_code,
3747: sequence_num,

Line 3791: UPDATE PO_ACTION_HISTORY

3787: ELSE
3788: l_sequence_num := l_sequence_num - 1;
3789: x_progress := '009';
3790:
3791: UPDATE PO_ACTION_HISTORY
3792: set object_id = p_doc_id,
3793: object_type_code = p_doc_type,
3794: object_sub_type_code = p_doc_subtype,
3795: sequence_num = l_sequence_num,

Line 3827: INSERT into PO_ACTION_HISTORY

3823: -- AME Integration phase II enhancement.
3824: -- No need to insert null action code.
3825:
3826: if (p_action not in ('ACCEPT', 'REJECT')) then
3827: INSERT into PO_ACTION_HISTORY
3828: (object_id,
3829: object_type_code,
3830: object_sub_type_code,
3831: sequence_num,

Line 4112: l_note po_action_history.note%TYPE;

4108: and pcr.document_header_id=por.requisition_header_id;
4109:
4110: l_old_req_amount varchar2(40);
4111: l_old_tax_amount varchar2(40);
4112: l_note po_action_history.note%TYPE;
4113: l_old_amount_currency varchar2(40);
4114: l_new_amount_currency varchar2(40);
4115: l_old_tax_currency varchar2(40);
4116: l_new_tax_currency varchar2(40);

Line 4927: l_note PO_ACTION_HISTORY.note%TYPE;

4923:
4924: l_doc_id number;
4925: l_doc_type varchar2(25);
4926: l_doc_subtype varchar2(25);
4927: l_note PO_ACTION_HISTORY.note%TYPE;
4928: l_employee_id number;
4929: l_orgid number;
4930:
4931: x_progress varchar2(100);

Line 5640: INSERT into PO_ACTION_HISTORY

5636:
5637: pragma AUTONOMOUS_TRANSACTION;
5638:
5639: begin
5640: INSERT into PO_ACTION_HISTORY
5641: (object_id,
5642: object_type_code,
5643: object_sub_type_code,
5644: sequence_num,

Line 5724: l_action_code po_action_history.action_code%type;

5720:
5721: l_change_request_group_id number;
5722: l_change_request_id number;
5723:
5724: l_action_code po_action_history.action_code%type;
5725: l_new_action_code po_action_history.action_code%type;
5726: l_employee_id number;
5727: l_sequence_num number;
5728:

Line 5725: l_new_action_code po_action_history.action_code%type;

5721: l_change_request_group_id number;
5722: l_change_request_id number;
5723:
5724: l_action_code po_action_history.action_code%type;
5725: l_new_action_code po_action_history.action_code%type;
5726: l_employee_id number;
5727: l_sequence_num number;
5728:
5729: cursor l_approved_change_request_csr(grp_id number) is

Line 5784: FROM PO_ACTION_HISTORY

5780: END IF;
5781:
5782: SELECT max(sequence_num)
5783: INTO l_sequence_num
5784: FROM PO_ACTION_HISTORY
5785: WHERE object_type_code = 'REQUISITION'
5786: AND object_id = l_document_id;
5787:
5788: select action_code, employee_id, object_revision_num, approval_path_id

Line 5790: from po_action_history

5786: AND object_id = l_document_id;
5787:
5788: select action_code, employee_id, object_revision_num, approval_path_id
5789: into l_action_code, l_employee_id, l_object_rev_num, l_approval_path_id
5790: from po_action_history
5791: where object_id=l_document_id
5792: and object_type_code='REQUISITION'
5793: and sequence_num=l_sequence_num;
5794:

Line 5942: /* update po action history */

5938: l_progress := 'Update_Action_History_Return: 002-'||
5939: to_char(l_document_id)||'-'||
5940: l_document_type||'-'||l_document_subtype;
5941:
5942: /* update po action history */
5943: PO_APPROVAL_LIST_HISTORY_SV.Update_Action_History(itemtype=>itemtype,
5944: itemkey=>itemkey,
5945: x_action=>l_action,
5946: x_req_header_id=>l_document_id,

Line 6888: l_note PO_ACTION_HISTORY.note%TYPE;

6884:
6885: l_doc_id number;
6886: l_doc_type varchar2(25);
6887: l_doc_subtype varchar2(25);
6888: l_note PO_ACTION_HISTORY.note%TYPE;
6889: l_employee_id number;
6890: l_orgid number;
6891: l_count number;
6892: l_action varchar2(10);

Line 7678: l_note po_action_history.note%TYPE;

7674: t_varname Wf_Engine.NameTabTyp;
7675: t_varval Wf_Engine.TextTabTyp;
7676: l_doc_string varchar2(200);
7677: l_preparer_user_name varchar2(100);
7678: l_note po_action_history.note%TYPE;
7679: l_old_amount_currency varchar2(40);
7680: l_old_tax_currency varchar2(40);
7681: l_new_amount_currency number;
7682: L_NEW_TAX_CURRENCY number;

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

10211: avalue => l_document_number );
10212:
10213: l_progress := 'PO_ReqChangeRequestWF_PVT.Accept_Po_Changes: 05';
10214:
10215: -- update PO action history as accepted by buyer
10216: InsertActionHist(itemtype, itemkey, l_document_id, l_document_type,
10217: l_document_subtype, l_buyer_id, 'ACCEPT', '', null);
10218:
10219: l_progress := 'PO_ReqChangeRequestWF_PVT.Accept_Po_Changes: 06';