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.PV_PRGM_APPROVAL_PVT dependencies on PV_GE_TEMP_APPROVERS_PVT

Line 2400: l_approver_rec Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;

2396: l_return_status VARCHAR2(1);
2397: l_msg_count NUMBER;
2398: l_msg_data VARCHAR2(4000);
2399:
2400: l_approver_rec Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;
2401:
2402: CURSOR approver_dtl_cur (p_entity_appr_id number) IS
2403: SELECT object_version_number,approver_id
2404: FROM pv_ge_temp_approvers

Line 2442: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

2438: );
2439:
2440:
2441: --write to the approver logs with the itemkey for tracking purposes.
2442: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
2443: ( p_api_version_number => 1.0
2444: , p_init_msg_list => FND_API.g_false
2445: , p_commit => FND_API.G_FALSE
2446: , p_validation_level => FND_API.g_valid_level_full

Line 2628: l_approver_rec Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;

2624: l_attr_id_tbl PV_ENTY_ATTR_VALUE_PUB.NUMBER_TABLE;
2625:
2626: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
2627: pv_pg_prev_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
2628: l_approver_rec Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;
2629: l_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
2630: l_mmbr_tran_rec pv_pg_mmbr_transitions_PVT.mmbr_tran_rec_type;
2631: l_api_name CONSTANT VARCHAR2(30) := 'process_approved_requests';
2632: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 2667: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr(

2663: ----DBMS_OUTPUT.PUT_LINE('inside process response');
2664:
2665: l_approver_rec.approval_status_code:=approvalStatus;
2666:
2667: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr(
2668: p_api_version_number => 1.0
2669: ,p_init_msg_list => FND_API.g_false
2670: ,p_commit => FND_API.G_FALSE
2671: ,p_validation_level => FND_API.g_valid_level_full

Line 2689: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

2685: FOR x in pending_appovers_csr(enrl_request_id) LOOP
2686: l_approver_rec.entity_approver_id :=x.entity_approver_id;
2687: l_approver_rec.object_version_number:=x.object_version_number;
2688: l_approver_rec.approval_status_code:='PEER_RESPONDED';
2689: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
2690: ( p_api_version_number => 1.0
2691: , p_init_msg_list => FND_API.g_false
2692: , p_commit => FND_API.g_false
2693: , p_validation_level => FND_API.g_valid_level_full

Line 3266: l_approver_rec Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;

3262: l_isPartnerFlag VARCHAR2(1);
3263: --nextApprover AME_UTIL.APPROVERRECORD;
3264: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
3265: pv_pg_prev_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
3266: l_approver_rec Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;
3267: l_check_row_pa BOOLEAN :=FALSE;
3268: l_check_row BOOLEAN:=FALSE;
3269: l_checkrow_pending BOOLEAN:=FALSE;
3270: l_api_name CONSTANT VARCHAR2(30) := 'submit_enrl_req_for_approval';

Line 3293: l_rec_appr Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;

3289: x_role_name VARCHAR2(320);
3290: x_role_display_name VARCHAR2(360);
3291: l_approverPersonId NUMBER;
3292: l_approverUserId NUMBER;
3293: l_rec_appr Pv_Ge_Temp_Approvers_PVT.APPROVER_REC_TYPE;
3294: l_approval_status_code VARCHAR2(30);
3295: x_approvalProcessCompleteYNOut VARCHAR2(100);
3296: x_nextApproversOut ame_util.approversTable2;
3297: xitemIndexesOut ame_util.idList;

Line 3381: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3377: CLOSE approver_dtl_cur;
3378:
3379: IF l_rec_appr.entity_approver_id IS NOT NULL THEN
3380: l_rec_appr.approval_status_code:='APPROVED';
3381: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3382: ( p_api_version_number => 1.0
3383: , p_init_msg_list => FND_API.g_false
3384: , p_commit => FND_API.g_false
3385: , p_validation_level => FND_API.g_valid_level_full

Line 3424: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3420: FOR x in pending_appovers_csr(enrl_request_id) LOOP
3421: l_rec_appr.entity_approver_id :=x.entity_approver_id;
3422: l_rec_appr.object_version_number:=x.object_version_number;
3423: l_rec_appr.approval_status_code:='APPROVER_CHANGED';
3424: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3425: ( p_api_version_number => 1.0
3426: , p_init_msg_list => FND_API.g_false
3427: , p_commit => FND_API.g_false
3428: , p_validation_level => FND_API.g_valid_level_full

Line 3507: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3503: since the rule changed, they are no longer valid approvers and
3504: hence their approval status should be updated
3505: */
3506:
3507: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3508: ( p_api_version_number => 1.0
3509: , p_init_msg_list => FND_API.g_false
3510: , p_commit => FND_API.g_false
3511: , p_validation_level => FND_API.g_valid_level_full

Line 3533: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3529: FOR x in pending_appovers_csr(enrl_request_id) LOOP
3530: l_rec_appr.entity_approver_id :=x.entity_approver_id;
3531: l_rec_appr.object_version_number:=x.object_version_number;
3532: l_rec_appr.approval_status_code:='APPROVER_CHANGED';
3533: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3534: ( p_api_version_number => 1.0
3535: , p_init_msg_list => FND_API.g_false
3536: , p_commit => FND_API.g_false
3537: , p_validation_level => FND_API.g_valid_level_full

Line 3565: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3561: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3562: RAISE FND_API.g_exc_unexpected_error;
3563: END IF;
3564: ELSE
3565: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3566: ( p_api_version_number => 1.0
3567: , p_init_msg_list => FND_API.g_false
3568: , p_commit => FND_API.g_false
3569: , p_validation_level => FND_API.g_valid_level_full

Line 3603: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3599: END IF;
3600: ELSE
3601: -- means if its rejected
3602: l_approver_rec.approval_status_code:=g_approver_response;
3603: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3604: ( p_api_version_number => 1.0
3605: , p_init_msg_list => FND_API.g_false
3606: , p_commit => FND_API.g_false
3607: , p_validation_level => FND_API.g_valid_level_full

Line 3624: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3620: FOR x in pending_appovers_csr(enrl_request_id) LOOP
3621: l_rec_appr.entity_approver_id :=x.entity_approver_id;
3622: l_rec_appr.object_version_number:=x.object_version_number;
3623: l_rec_appr.approval_status_code:='APPROVER_CHANGED';
3624: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3625: ( p_api_version_number => 1.0
3626: , p_init_msg_list => FND_API.g_false
3627: , p_commit => FND_API.g_false
3628: , p_validation_level => FND_API.g_valid_level_full

Line 3665: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3661: FOR x in pending_appovers_csr(enrl_request_id) LOOP
3662: l_rec_appr.entity_approver_id :=x.entity_approver_id;
3663: l_rec_appr.object_version_number:=x.object_version_number;
3664: l_rec_appr.approval_status_code:='APPROVER_CHANGED';
3665: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3666: ( p_api_version_number => 1.0
3667: , p_init_msg_list => FND_API.g_false
3668: , p_commit => FND_API.g_false
3669: , p_validation_level => FND_API.g_valid_level_full

Line 3683: Pv_Ge_Temp_Approvers_PVT.Create_Ptr_Enr_Temp_Appr

3679: END IF;
3680: END LOOP;
3681:
3682: /* create a row for the new default approver with status pending_default */
3683: Pv_Ge_Temp_Approvers_PVT.Create_Ptr_Enr_Temp_Appr
3684: ( p_api_version_number =>l_api_version_number
3685: , x_return_status =>x_return_status
3686: , x_msg_count =>x_msg_count
3687: , x_msg_data =>x_msg_data

Line 3764: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3760:
3761: ----DBMS_OUTPUT.PUT_LINE('if after approval dtl _cur' || l_rec_appr.entity_approver_id );
3762: IF l_rec_appr.entity_approver_id IS NOT NULL THEN
3763: l_rec_appr.approval_status_code:=g_approver_response;
3764: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3765: ( p_api_version_number => 1.0
3766: , p_init_msg_list => FND_API.g_false
3767: , p_commit => FND_API.g_false
3768: , p_validation_level => FND_API.g_valid_level_full

Line 3834: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3830: -- update
3831: ----DBMS_OUTPUT.PUT_LINE('going for update');
3832: l_approver_rec.entity_approver_id :=l_entity_approver_id;
3833: l_approver_rec.object_version_number:=l_object_version_number;
3834: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3835: ( p_api_version_number => 1.0
3836: , p_init_msg_list => FND_API.g_false
3837: , p_commit => FND_API.g_false
3838: , p_validation_level => FND_API.g_valid_level_full

Line 3846: Pv_Ge_Temp_Approvers_PVT.Create_Ptr_Enr_Temp_Appr

3842: , p_approver_rec =>l_approver_rec
3843:
3844: );
3845: ELSE
3846: Pv_Ge_Temp_Approvers_PVT.Create_Ptr_Enr_Temp_Appr
3847: ( p_api_version_number =>l_api_version_number
3848: , x_return_status =>x_return_status
3849: , x_msg_count =>x_msg_count
3850: , x_msg_data =>x_msg_data

Line 3876: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3872: FOR x in pending_appovers_csr(enrl_request_id) LOOP
3873: l_approver_rec.entity_approver_id :=x.entity_approver_id;
3874: l_approver_rec.object_version_number:=x.object_version_number;
3875: l_approver_rec.approval_status_code:='PEER_RESPONDED';
3876: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3877: ( p_api_version_number => 1.0
3878: , p_init_msg_list => FND_API.g_false
3879: , p_commit => FND_API.g_false
3880: , p_validation_level => FND_API.g_valid_level_full

Line 3927: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

3923: -- update
3924: ----DBMS_OUTPUT.PUT_LINE('going for update');
3925: l_approver_rec.entity_approver_id :=l_entity_approver_id;
3926: l_approver_rec.object_version_number:=l_object_version_number;
3927: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
3928: ( p_api_version_number => 1.0
3929: , p_init_msg_list => FND_API.g_false
3930: , p_commit => FND_API.g_false
3931: , p_validation_level => FND_API.g_valid_level_full

Line 3939: Pv_Ge_Temp_Approvers_PVT.Create_Ptr_Enr_Temp_Appr(

3935: , p_approver_rec =>l_approver_rec
3936:
3937: );
3938: ELSE
3939: Pv_Ge_Temp_Approvers_PVT.Create_Ptr_Enr_Temp_Appr(
3940: p_api_version_number =>l_api_version_number
3941: ,x_return_status =>x_return_status
3942: ,x_msg_count =>x_msg_count
3943: ,x_msg_data =>x_msg_data

Line 4078: l_approver_rec Pv_Ge_Temp_Approvers_PVT.approver_rec_type;

4074: l_api_name CONSTANT VARCHAR2(30) := 'update_enrl_req_status';
4075: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
4076: l_api_version_number CONSTANT NUMBER := 1.0;
4077: l_checkrow_pending boolean:=false;
4078: l_approver_rec Pv_Ge_Temp_Approvers_PVT.approver_rec_type;
4079: pv_pg_memb_rec PV_Pg_Memberships_PVT.memb_rec_type;
4080: l_enrq_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
4081: l_membership_id number;
4082: l_approvalStatus varchar2(50);

Line 4318: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

4314: RAISE FND_API.g_exc_unexpected_error;
4315: END IF;
4316: ELSE
4317: -- means enrollment has been rejected
4318: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
4319: ( p_api_version_number => 1.0
4320: , p_init_msg_list => FND_API.g_false
4321: , p_commit => FND_API.g_false
4322: , p_validation_level => FND_API.g_valid_level_full

Line 4425: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr

4421: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
4422: RAISE FND_API.g_exc_unexpected_error;
4423: END IF;
4424: */
4425: Pv_Ge_Temp_Approvers_PVT.Update_Ptr_Enr_Temp_Appr
4426: ( p_api_version_number => 1.0
4427: , p_init_msg_list => FND_API.g_false
4428: , p_commit => FND_API.g_false
4429: , p_validation_level => FND_API.g_valid_level_full