APPS.PA_PROJECT_REQUEST_PVT dependencies on PA_WF_NTF_PERFORMERS

Line 1689: FROM pa_wf_ntf_performers

1685: CURSOR cur_wf_ntf_info2 (p_group_id NUMBER) IS
1686: SELECT user_name,
1687: object_id1 project_id,
1688: object_id2 lead_id
1689: FROM pa_wf_ntf_performers
1690: WHERE group_id = p_group_id
1691: ORDER BY user_name,
1692: object_id1;
1693:

Line 1759: l_guest_user pa_wf_ntf_performers.user_name%type;

1755: l_position_1 NUMBER;
1756: l_position_2 NUMBER;
1757:
1758: -- Added by Sachin for P1 bug 3765557
1759: l_guest_user pa_wf_ntf_performers.user_name%type;
1760:
1761: BEGIN
1762: x_return_status := FND_API.G_RET_STS_SUCCESS;
1763: Debug('In procedure update_projects for classification ['||p_classification||']');

Line 1877: SELECT pa_wf_ntf_performers_s.nextval

1873:
1874:
1875: --Generate group_id for each run of update projects.
1876: --Used by workflow notification.
1877: SELECT pa_wf_ntf_performers_s.nextval
1878: INTO l_group_id
1879: FROM dual;
1880:
1881: -- Added by Sachin for P1 bug 3765557

Line 2195: -- Insert notification related info into pa_wf_ntf_performers

2191: Debug('***** x_return_status = ' || x_return_status );
2192:
2193: IF x_return_status = 'S' THEN
2194:
2195: -- Insert notification related info into pa_wf_ntf_performers
2196: FOR cur_wf_ntf_info_rec in cur_wf_ntf_info(l_project_id) LOOP
2197:
2198: --get user id for the project manager and staffing owners of this project
2199:

Line 2210: INSERT INTO pa_wf_ntf_performers

2206: /* start of bug 3632727 */ -- Bug 4015199
2207: if l_recipient_user_name IS NOT NULL then
2208: /* end of bug 3632727*/
2209:
2210: INSERT INTO pa_wf_ntf_performers
2211: (wf_type_code,
2212: item_type,
2213: item_key,
2214: object_id1,

Line 2246: INSERT INTO pa_wf_ntf_performers

2242: END LOOP;
2243:
2244: -- Added by Sachin for P1 bug 3765557
2245: if l_guest_user is not null then
2246: INSERT INTO pa_wf_ntf_performers
2247: (wf_type_code,
2248: item_type,
2249: item_key,
2250: object_id1,

Line 2383: FROM pa_wf_ntf_performers

2379: --Get the number of projects updated for this recipient
2380:
2381: SELECT distinct object_id1
2382: BULK COLLECT INTO l_project_count_tab
2383: FROM pa_wf_ntf_performers
2384: WHERE group_id = l_group_id
2385: AND user_name = l_recipient_tab(i-1);
2386:
2387: -- Setting the attribute value for recipient count

Line 2467: FROM pa_wf_ntf_performers

2463: --Get the number of projects updated for the last recipient
2464:
2465: SELECT distinct object_id1
2466: BULK COLLECT INTO l_project_count_tab
2467: FROM pa_wf_ntf_performers
2468: WHERE group_id = l_group_id
2469: AND user_name = l_end_recipient;
2470:
2471: -- Setting the attribute value for recipient count