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.POR_AME_REQ_WF_PVT dependencies on PO_ACTION_HISTORY

Line 2181: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;

2177:
2178: is
2179: pragma AUTONOMOUS_TRANSACTION;
2180:
2181: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2182: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2183: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2184: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2185: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

Line 2182: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;

2178: is
2179: pragma AUTONOMOUS_TRANSACTION;
2180:
2181: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2182: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2183: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2184: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2185: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2186: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

Line 2183: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;

2179: pragma AUTONOMOUS_TRANSACTION;
2180:
2181: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2182: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2183: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2184: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2185: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2186: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2187: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

Line 2184: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;

2180:
2181: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2182: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2183: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2184: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2185: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2186: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2187: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2188: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

Line 2185: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

2181: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2182: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2183: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2184: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2185: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2186: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2187: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2188: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2189: l_progress VARCHAR2(100) := '000';

Line 2186: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

2182: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2183: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2184: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2185: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2186: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2187: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2188: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2189: l_progress VARCHAR2(100) := '000';
2190:

Line 2187: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

2183: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2184: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2185: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2186: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2187: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2188: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2189: l_progress VARCHAR2(100) := '000';
2190:
2191: begin

Line 2188: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

2184: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2185: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2186: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2187: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2188: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2189: l_progress VARCHAR2(100) := '000';
2190:
2191: begin
2192:

Line 2195: FROM PO_ACTION_HISTORY

2191: begin
2192:
2193: SELECT max(sequence_num)
2194: INTO l_sequence_num
2195: FROM PO_ACTION_HISTORY
2196: WHERE object_type_code = 'REQUISITION'
2197: AND object_id = p_req_header_id;
2198:
2199: SELECT object_sub_type_code,

Line 2205: FROM PO_ACTION_HISTORY

2201: program_application_id, program_date, program_id
2202: INTO l_object_sub_type_code,
2203: l_object_revision_num, l_approval_path_id, l_request_id,
2204: l_program_application_id, l_program_date, l_program_id
2205: FROM PO_ACTION_HISTORY
2206: WHERE object_type_code = 'REQUISITION'
2207: AND object_id = p_req_header_id
2208: AND sequence_num = l_sequence_num;
2209:

Line 2210: /* update po action history */

2206: WHERE object_type_code = 'REQUISITION'
2207: AND object_id = p_req_header_id
2208: AND sequence_num = l_sequence_num;
2209:
2210: /* update po action history */
2211: po_forward_sv1.insert_action_history (
2212: p_req_header_id,
2213: 'REQUISITION',
2214: l_object_sub_type_code,

Line 2402: -- This procedure updates the po_action_history table based on the approvers response.

2398: --Locks:
2399: -- None.
2400: --Function:
2401: -- Workflow activity PL/SQL handler.
2402: -- This procedure updates the po_action_history table based on the approvers response.
2403: --Parameters:
2404: --IN:
2405: -- Standard workflow IN parameters
2406: --OUT:

Line 2553: -- This procedure updates the po_action_history table based on the approvers response.

2549: --Locks:
2550: -- None.
2551: --Function:
2552: -- Workflow activity PL/SQL handler.
2553: -- This procedure updates the po_action_history table based on the approvers response.
2554: --Parameters:
2555: --IN:
2556: -- Standard workflow IN parameters
2557: --OUT:

Line 2703: -- This procedure updates the po_action_history table based on the approvers response.

2699: --Locks:
2700: -- None.
2701: --Function:
2702: -- Workflow activity PL/SQL handler.
2703: -- This procedure updates the po_action_history table based on the approvers response.
2704: --Parameters:
2705: --IN:
2706: -- Standard workflow IN parameters
2707: --OUT:

Line 2846: -- This procedure updates the po_action_history table based on the approvers response.

2842: --Locks:
2843: -- None.
2844: --Function:
2845: -- Workflow activity PL/SQL handler.
2846: -- This procedure updates the po_action_history table based on the approvers response.
2847: --Parameters:
2848: --IN:
2849: -- Standard workflow IN parameters
2850: --OUT:

Line 3092: -- This procedure updates the po_action_history table based on the approvers response.

3088: -- None.
3089: --Locks:
3090: -- None.
3091: --Function:
3092: -- This procedure updates the po_action_history table based on the approvers response.
3093: --Parameters:
3094: --IN:
3095: -- p_document_id : Requisition Header Id
3096: -- p_action : Action

Line 3114: UPDATE po_action_history

3110: BEGIN
3111:
3112: if (p_current_approver is not null) then
3113:
3114: UPDATE po_action_history
3115: SET action_code = p_action,
3116: note = p_note,
3117: action_date = sysdate
3118: WHERE object_id = p_document_id and

Line 3126: UPDATE po_action_history

3122: and rownum=1;
3123:
3124: else
3125:
3126: UPDATE po_action_history
3127: SET action_code = p_action,
3128: note = p_note,
3129: action_date = sysdate
3130: WHERE object_id = p_document_id and

Line 3441: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;

3437:
3438: is
3439: pragma AUTONOMOUS_TRANSACTION;
3440:
3441: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
3442: l_object_type_code PO_ACTION_HISTORY.OBJECT_TYPE_CODE%TYPE;
3443: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
3444: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
3445: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;

Line 3442: l_object_type_code PO_ACTION_HISTORY.OBJECT_TYPE_CODE%TYPE;

3438: is
3439: pragma AUTONOMOUS_TRANSACTION;
3440:
3441: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
3442: l_object_type_code PO_ACTION_HISTORY.OBJECT_TYPE_CODE%TYPE;
3443: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
3444: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
3445: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
3446: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

Line 3443: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;

3439: pragma AUTONOMOUS_TRANSACTION;
3440:
3441: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
3442: l_object_type_code PO_ACTION_HISTORY.OBJECT_TYPE_CODE%TYPE;
3443: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
3444: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
3445: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
3446: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
3447: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

Line 3444: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;

3440:
3441: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
3442: l_object_type_code PO_ACTION_HISTORY.OBJECT_TYPE_CODE%TYPE;
3443: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
3444: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
3445: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
3446: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
3447: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
3448: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

Line 3445: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;

3441: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
3442: l_object_type_code PO_ACTION_HISTORY.OBJECT_TYPE_CODE%TYPE;
3443: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
3444: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
3445: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
3446: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
3447: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
3448: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
3449: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

Line 3446: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

3442: l_object_type_code PO_ACTION_HISTORY.OBJECT_TYPE_CODE%TYPE;
3443: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
3444: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
3445: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
3446: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
3447: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
3448: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
3449: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
3450: l_progress VARCHAR2(100) := '000';

Line 3447: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

3443: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
3444: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
3445: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
3446: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
3447: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
3448: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
3449: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
3450: l_progress VARCHAR2(100) := '000';
3451: l_object_id NUMBER;

Line 3448: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

3444: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
3445: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
3446: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
3447: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
3448: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
3449: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
3450: l_progress VARCHAR2(100) := '000';
3451: l_object_id NUMBER;
3452: --l_record_exists VARCHAR2(1) := 'N';

Line 3449: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

3445: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
3446: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
3447: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
3448: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
3449: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
3450: l_progress VARCHAR2(100) := '000';
3451: l_object_id NUMBER;
3452: --l_record_exists VARCHAR2(1) := 'N';
3453:

Line 3462: FROM PO_ACTION_HISTORY

3458: if (p_draft_id is NULL or p_draft_id = -1) then
3459:
3460: SELECT max(sequence_num)
3461: INTO l_sequence_num
3462: FROM PO_ACTION_HISTORY
3463: WHERE object_type_code = p_document_type --'PO'
3464: AND object_sub_type_code = p_document_subtype --'STANDARD'
3465: AND object_id = p_document_id;
3466:

Line 3472: FROM PO_ACTION_HISTORY

3468: /*
3469: BEGIN
3470: SELECT 'Y'
3471: INTO l_record_exists
3472: FROM PO_ACTION_HISTORY
3473: WHERE object_type_code = p_document_type --'PO'
3474: AND object_sub_type_code = p_document_subtype --'STANDARD'
3475: AND object_id = p_document_id
3476: AND action_code is null;

Line 3488: FROM PO_ACTION_HISTORY

3484: program_application_id, program_date, program_id
3485: INTO l_object_id, l_object_type_code, l_object_sub_type_code,
3486: l_object_revision_num, l_approval_path_id, l_request_id,
3487: l_program_application_id, l_program_date, l_program_id
3488: FROM PO_ACTION_HISTORY
3489: WHERE object_type_code = p_document_type --'PO'
3490: AND object_sub_type_code = p_document_subtype --'STANDARD'
3491: AND object_id = p_document_id
3492: AND sequence_num = l_sequence_num;

Line 3498: FROM PO_ACTION_HISTORY

3494: else
3495:
3496: SELECT max(sequence_num)
3497: INTO l_sequence_num
3498: FROM PO_ACTION_HISTORY
3499: WHERE object_type_code = p_document_type --'PO'
3500: AND object_sub_type_code IN ('MODIFICATION', 'POST_AWARD_REQUEST') -- PAR Approval
3501: AND object_id = p_draft_id;
3502:

Line 3508: FROM PO_ACTION_HISTORY

3504: /*
3505: BEGIN
3506: SELECT 'Y'
3507: INTO l_record_exists
3508: FROM PO_ACTION_HISTORY
3509: WHERE object_type_code = p_document_type --'PO'
3510: AND object_sub_type_code = 'MODIFICATION' --'STANDARD'
3511: AND object_id = p_draft_id
3512: AND action_code is null;

Line 3524: FROM PO_ACTION_HISTORY

3520: program_application_id, program_date, program_id
3521: INTO l_object_id,l_object_type_code, l_object_sub_type_code,
3522: l_object_revision_num, l_approval_path_id, l_request_id,
3523: l_program_application_id, l_program_date, l_program_id
3524: FROM PO_ACTION_HISTORY
3525: WHERE object_type_code = p_document_type --'PO'
3526: AND object_sub_type_code IN ('MODIFICATION', 'POST_AWARD_REQUEST') -- PAR Approval
3527: AND object_id = p_draft_id
3528: AND sequence_num = l_sequence_num;

Line 3533: update po_action_history

3529:
3530: end if;
3531: --Bug 12944203
3532: /*if l_record_exists = 'Y' then
3533: update po_action_history
3534: set employee_id = p_employee_id,
3535: approval_group_id = p_approval_group_id
3536: where object_type_code = l_object_type_code
3537: AND object_sub_type_code = l_object_sub_type_code

Line 3541: /* update po action history */

3537: AND object_sub_type_code = l_object_sub_type_code
3538: AND object_id = l_object_id
3539: AND action_code is null;
3540: else*/
3541: /* update po action history */
3542: po_forward_sv1.insert_action_history (
3543: l_object_id,
3544: l_object_type_code,
3545: l_object_sub_type_code,

Line 3577: -- This procedure updates the po_action_history table based on the approvers response.

3573: -- None.
3574: --Locks:
3575: -- None.
3576: --Function:
3577: -- This procedure updates the po_action_history table based on the approvers response.
3578: --Parameters:
3579: --IN:
3580: -- p_transaction_type
3581: -- p_document_id : po_header_id

Line 3605: UPDATE po_action_history

3601:
3602: if p_transaction_type = 'PURCHASE_ORDER' then
3603: if (p_current_approver is not null) then
3604:
3605: UPDATE po_action_history
3606: SET action_code = p_action,
3607: note = p_note,
3608: action_date = sysdate
3609: WHERE object_id = p_document_id and

Line 3618: UPDATE po_action_history

3614: and rownum=1;
3615:
3616: else
3617:
3618: UPDATE po_action_history
3619: SET action_code = p_action,
3620: note = p_note,
3621: action_date = sysdate
3622: WHERE object_id = p_document_id and

Line 3631: UPDATE po_action_history

3627: end if;
3628: elsif p_transaction_type = 'PURCHASE_MOD' then
3629: if (p_current_approver is not null) then
3630:
3631: UPDATE po_action_history
3632: SET action_code = p_action,
3633: note = p_note,
3634: action_date = sysdate
3635: WHERE object_id = p_draft_id and

Line 3644: UPDATE po_action_history

3640: and rownum=1;
3641:
3642: else
3643:
3644: UPDATE po_action_history
3645: SET action_code = p_action,
3646: note = p_note,
3647: action_date = sysdate
3648: WHERE object_id = p_draft_id and

Line 3658: UPDATE po_action_history

3654: -- PAR Approval
3655: elsif p_transaction_type = 'PURCHASE_PAR' then
3656: if (p_current_approver is not null) then
3657:
3658: UPDATE po_action_history
3659: SET action_code = p_action,
3660: note = p_note,
3661: action_date = sysdate
3662: WHERE object_id = p_draft_id and

Line 3671: UPDATE po_action_history

3667: and rownum=1;
3668:
3669: else
3670:
3671: UPDATE po_action_history
3672: SET action_code = p_action,
3673: note = p_note,
3674: action_date = sysdate
3675: WHERE object_id = p_draft_id and