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.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_WF_NTF_PERFORMERS

Line 2151: FROM pa_wf_ntf_performers pwnp,

2147: and item_type = 'PAWFAAP';
2148:
2149: CURSOR get_user_id IS
2150: SELECT fu.user_id
2151: FROM pa_wf_ntf_performers pwnp,
2152: fnd_user fu
2153: WHERE pwnp.object_id1 = p_assignment_id
2154: AND pwnp.object_id2 = p_project_id
2155: AND pwnp.item_type = l_item_type

Line 2168: FROM pa_wf_ntf_performers pwnp,

2164: WHERE assignment_id = p_assignment_id;
2165:
2166: CURSOR get_user_id_mflow IS
2167: SELECT fu.user_id
2168: FROM pa_wf_ntf_performers pwnp,
2169: fnd_user fu
2170: WHERE wf_type_code = 'MASS_ASSIGNMENT_APPROVAL'
2171: AND object_id1 = p_assignment_id
2172: AND object_id2 = -1

Line 2175: FROM pa_wf_ntf_performers

2171: AND object_id1 = p_assignment_id
2172: AND object_id2 = -1
2173: AND fu.user_name = pwnp.user_name
2174: AND (group_id, routing_order) in (SELECT max(group_id), min(routing_order)
2175: FROM pa_wf_ntf_performers
2176: WHERE wf_type_code = 'MASS_ASSIGNMENT_APPROVAL'
2177: AND object_id1 = p_assignment_id
2178: AND object_id2 = -1);
2179:

Line 2894: FROM pa_wf_ntf_performers ntf,

2890: l_approver_group_id NUMBER;
2891:
2892: CURSOR distinct_approvers IS
2893: SELECT distinct user_name
2894: FROM pa_wf_ntf_performers ntf,
2895: pa_project_assignments asgn
2896: WHERE ntf.group_id = l_group_id
2897: AND ntf.object_id1 = asgn.assignment_id
2898: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted

Line 2982: --This group id is inserted for every record in PA_WF_NTF_PERFORMERS

2978: END IF;
2979:
2980: ---------------------------------------------------------------------
2981: --Generate the group id for this mass transaction
2982: --This group id is inserted for every record in PA_WF_NTF_PERFORMERS
2983: --The group_id is inserted from the sequence PA_WF_NTF_PERFORMERS_S
2984: --The approver_group_id is initialy null
2985: --The group id is used to group all records which belong to this
2986: --mass transaction and is used in sending FYI notifications to

Line 2983: --The group_id is inserted from the sequence PA_WF_NTF_PERFORMERS_S

2979:
2980: ---------------------------------------------------------------------
2981: --Generate the group id for this mass transaction
2982: --This group id is inserted for every record in PA_WF_NTF_PERFORMERS
2983: --The group_id is inserted from the sequence PA_WF_NTF_PERFORMERS_S
2984: --The approver_group_id is initialy null
2985: --The group id is used to group all records which belong to this
2986: --mass transaction and is used in sending FYI notifications to
2987: --managers in the end when there are no pending approvals

Line 2989: SELECT PA_WF_NTF_PERFORMERS_S.nextval

2985: --The group id is used to group all records which belong to this
2986: --mass transaction and is used in sending FYI notifications to
2987: --managers in the end when there are no pending approvals
2988: ---------------------------------------------------------------------
2989: SELECT PA_WF_NTF_PERFORMERS_S.nextval
2990: INTO l_group_id
2991: FROM dual;
2992:
2993: OPEN get_submitter_details;

Line 3260: --pa_wf_ntf_performers table

3256: END IF; --end l_assignment_status = 'SUBMIT'
3257:
3258: ----------------------------------------------------------
3259: --Store previous value of assignment status to be inserted into
3260: --pa_wf_ntf_performers table
3261: ----------------------------------------------------------
3262: BEGIN
3263: SELECT apprvl_status_code
3264: INTO l_asgn_approval_status

Line 3312: --Insert this assignment into pa_wf_ntf_performers for sending manager

3308: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3309: END IF;
3310:
3311: ----------------------------------------------------------------------------
3312: --Insert this assignment into pa_wf_ntf_performers for sending manager
3313: --notifications. The approver is the submitter in this case
3314: ----------------------------------------------------------------------------
3315: IF l_submitter_user_name is not null THEN
3316:

Line 3317: INSERT INTO pa_wf_ntf_performers(

3313: --notifications. The approver is the submitter in this case
3314: ----------------------------------------------------------------------------
3315: IF l_submitter_user_name is not null THEN
3316:
3317: INSERT INTO pa_wf_ntf_performers(
3318: WF_TYPE_CODE
3319: ,ITEM_TYPE
3320: ,ITEM_KEY
3321: ,OBJECT_ID1

Line 3391: -- ii. insert into PA_WF_NTF_PERFORMERS (insert Approvers and assignment)

3387: ---------------------------------------------------------------------------
3388: --If no errors for this assignment then :
3389: -- i. call PA_CLIENT_EXTN_ASGMT_WF.Generate_Assignment_Approvers(..) to get
3390: -- any client defined Approvers.
3391: -- ii. insert into PA_WF_NTF_PERFORMERS (insert Approvers and assignment)
3392: --Note: All the inserted records have a unique identifier Group_id
3393: -- We can recognize all the records in PA_WF_NTF_PERFORMERS
3394: --for a given transaction using this identifier.
3395: ---------------------------------------------------------------------------

Line 3393: -- We can recognize all the records in PA_WF_NTF_PERFORMERS

3389: -- i. call PA_CLIENT_EXTN_ASGMT_WF.Generate_Assignment_Approvers(..) to get
3390: -- any client defined Approvers.
3391: -- ii. insert into PA_WF_NTF_PERFORMERS (insert Approvers and assignment)
3392: --Note: All the inserted records have a unique identifier Group_id
3393: -- We can recognize all the records in PA_WF_NTF_PERFORMERS
3394: --for a given transaction using this identifier.
3395: ---------------------------------------------------------------------------
3396:
3397: IF l_approvers_list_tbl.COUNT > 0 THEN

Line 3453: --Insert All approvers into PA_WF_NTF_PERFORMERS Table

3449:
3450: log_message('OUT Count:' || l_out_approvers_list_tbl.COUNT);
3451:
3452: -------------------------------------------------------
3453: --Insert All approvers into PA_WF_NTF_PERFORMERS Table
3454: -------------------------------------------------------
3455: l_routing_order := 0;
3456: FOR k in 1..l_out_approvers_list_tbl.COUNT LOOP
3457:

Line 3460: INSERT INTO pa_wf_ntf_performers(

3456: FOR k in 1..l_out_approvers_list_tbl.COUNT LOOP
3457:
3458: IF l_out_approvers_list_tbl(k).user_name is not null THEN
3459:
3460: INSERT INTO pa_wf_ntf_performers(
3461: WF_TYPE_CODE
3462: ,ITEM_TYPE
3463: ,ITEM_KEY
3464: ,OBJECT_ID1

Line 3539: log_message('After populating pa_wf_ntf_performers');

3535: END;
3536:
3537: END LOOP; --end i loop for all assignments for this mass transaction
3538:
3539: log_message('After populating pa_wf_ntf_performers');
3540:
3541: -----------------------------------------------------------------------------------------
3542: /*FOR each distinct approver one in PA_WF_NTF_PERFORMERS belonging
3543: to mass transaction group l_group_id

Line 3542: /*FOR each distinct approver one in PA_WF_NTF_PERFORMERS belonging

3538:
3539: log_message('After populating pa_wf_ntf_performers');
3540:
3541: -----------------------------------------------------------------------------------------
3542: /*FOR each distinct approver one in PA_WF_NTF_PERFORMERS belonging
3543: to mass transaction group l_group_id
3544: update the approver_group_id in PA_WF_NTF_PERFORMERS for these assignments with a
3545: new sequence value. Store this value in l_approver_group_id
3546: The l_approver_group_id is the approver transaction id which is used

Line 3544: update the approver_group_id in PA_WF_NTF_PERFORMERS for these assignments with a

3540:
3541: -----------------------------------------------------------------------------------------
3542: /*FOR each distinct approver one in PA_WF_NTF_PERFORMERS belonging
3543: to mass transaction group l_group_id
3544: update the approver_group_id in PA_WF_NTF_PERFORMERS for these assignments with a
3545: new sequence value. Store this value in l_approver_group_id
3546: The l_approver_group_id is the approver transaction id which is used
3547: in grouping and sending approval required notifications for the next (second) set of approvers.
3548: Approver group id is used in grouping the approvers in the next routing order

Line 3553: SELECT PA_WF_NTF_PERFORMERS_S.nextval

3549: */
3550: -----------------------------------------------------------------------------------------
3551: FOR rec IN distinct_approvers LOOP
3552:
3553: SELECT PA_WF_NTF_PERFORMERS_S.nextval
3554: INTO l_approver_group_id
3555: FROM dual;
3556:
3557: UPDATE pa_wf_ntf_performers

Line 3557: UPDATE pa_wf_ntf_performers

3553: SELECT PA_WF_NTF_PERFORMERS_S.nextval
3554: INTO l_approver_group_id
3555: FROM dual;
3556:
3557: UPDATE pa_wf_ntf_performers
3558: SET approver_group_id = l_approver_group_id
3559: WHERE group_id = l_group_id
3560: AND user_name = rec.user_name
3561: AND routing_order = 1;

Line 3603: FROM pa_wf_ntf_performers ntf,

3599: BEGIN
3600:
3601: SELECT count(*)
3602: INTO l_num_apr_asgns
3603: FROM pa_wf_ntf_performers ntf,
3604: pa_project_assignments asgn
3605: WHERE ntf.group_id = l_group_id
3606: AND ntf.routing_order = 1
3607: AND ntf.object_id1 = asgn.assignment_id

Line 3621: FROM pa_wf_ntf_performers ntf,

3617: BEGIN
3618:
3619: SELECT count(*)
3620: INTO l_num_rej_asgns
3621: FROM pa_wf_ntf_performers ntf,
3622: pa_project_assignments asgn
3623: WHERE ntf.group_id = l_group_id
3624: AND ntf.routing_order = 1
3625: AND ntf.object_id1 = asgn.assignment_id

Line 3669: FROM pa_wf_ntf_performers ntf,

3665: --Get all assignments in this mass transaction
3666: --which have been approved
3667: SELECT ntf.object_id1
3668: BULK COLLECT INTO l_appr_asgmt_id_tbl
3669: FROM pa_wf_ntf_performers ntf,
3670: pa_project_assignments asgn
3671: WHERE ntf.group_id = l_group_id
3672: AND ntf.routing_order = 1
3673: AND ntf.object_id1 = asgn.assignment_id

Line 3894: --in pa_wf_ntf_performers table to differentiate

3890: END IF;
3891:
3892: --------------------------------------------------------
3893: --Update object_id2 column to 100 for these assignments
3894: --in pa_wf_ntf_performers table to differentiate
3895: --between assignments for which user has aproved/rejected
3896: --and those for which notification is pending
3897: ---------------------------------------------------------
3898: UPDATE pa_wf_ntf_performers

Line 3898: UPDATE pa_wf_ntf_performers

3894: --in pa_wf_ntf_performers table to differentiate
3895: --between assignments for which user has aproved/rejected
3896: --and those for which notification is pending
3897: ---------------------------------------------------------
3898: UPDATE pa_wf_ntf_performers
3899: SET object_id2 = 100
3900: where group_id = p_group_id
3901: and routing_order = p_routing_order
3902: and approver_group_id = p_approver_group_id;