APPS.PA_BILLING_WRKBNCH_EVENTS dependencies on PA_EVENTS

Line 15: select nvl(max(event_num), 0) + 1 from pa_events

11: P_Task_ID IN NUMBER,
12: X_Event_Num OUT NOCOPY NUMBER ) AS --File.Sql.39 bug 4440895
13:
14: Cursor c_Event_Num_Project Is
15: select nvl(max(event_num), 0) + 1 from pa_events
16: where project_id = P_Project_ID
17: and task_id is null;
18:
19: Cursor c_Event_Num_Task Is

Line 20: select nvl(max(event_num), 0) + 1 from pa_events

16: where project_id = P_Project_ID
17: and task_id is null;
18:
19: Cursor c_Event_Num_Task Is
20: select nvl(max(event_num), 0) + 1 from pa_events
21: where project_id = P_Project_ID
22: and task_id = P_Task_ID;
23: BEGIN
24:

Line 88: l_rec_ver_num pa_events.record_version_number%type;

84: Invalid_event_action exception; /* Added for bug 3850381 */
85: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
86: l_err_message varchar2(240) := null;
87: l_event_processed varchar2(1) := 'Y';
88: l_rec_ver_num pa_events.record_version_number%type;
89: /* Added for bug 3850381 */
90: l_msg_count NUMBER := 0;
91: l_data VARCHAR2(2000) := null;
92: l_msg_data VARCHAR2(2000) := null;

Line 327: from pa_events

323: Then
324: Begin
325: select record_version_number
326: into l_rec_ver_num
327: from pa_events
328: where event_id = p_event_id;
329:
330: If l_rec_ver_num <> p_rec_ver_num
331: Then

Line 398: l_event_Id pa_events.event_id%type;

394: RETURN VARCHAR2
395: IS
396:
397: l_return_status varchar2(1) := 'Y';
398: l_event_Id pa_events.event_id%type;
399:
400: BEGIN
401:
402: SELECT event_id

Line 404: FROM pa_events

400: BEGIN
401:
402: SELECT event_id
403: INTO l_event_id
404: FROM pa_events
405: WHERE project_id = P_Project_Id
406: AND deliverable_id = P_Deliverable_Id
407: AND action_id = P_Action_Id;
408:

Line 440: select rowid from pa_events

436: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
437: l_err_message varchar2(240) := null;
438: l_tmp_rowid rowid;
439: cursor c_rowid is
440: select rowid from pa_events
441: where project_id = P_Project_Id
442: and deliverable_id = P_Deliverable_Id
443: and action_id = P_Action_Id;
444:

Line 467: PA_EVENTS_PKG.Delete_Row (X_RowId => l_tmp_rowid);

463: fetch c_rowid into l_tmp_rowid;
464:
465: if c_rowid%rowcount = 1
466: then
467: PA_EVENTS_PKG.Delete_Row (X_RowId => l_tmp_rowid);
468: end if;
469:
470: close c_rowid;
471:

Line 506: l_Deliverable_Id pa_events.deliverable_id%TYPE;

502: p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
503: ) RETURN VARCHAR2
504: IS
505:
506: l_Deliverable_Id pa_events.deliverable_id%TYPE;
507: l_Dlv_Count Number := 0;
508:
509: Begin
510:

Line 522: from pa_events e

518: If nvl(l_Deliverable_Id, 0) > 0 Then
519:
520: Select count(*)
521: into l_Dlv_Count
522: from pa_events e
523: where e.project_id = p_project_id
524: and e.deliverable_id = l_deliverable_id;
525: End If;
526:

Line 550: Update PA_EVENTS

546: IS
547: BEGIN
548: IF nvl(P_Deliverable_Id, 0) > 0 AND nvl(P_Action_Id, 0) > 0
549: Then
550: Update PA_EVENTS
551: set Completion_Date = trunc(P_Event_Date)
552: Where deliverable_id = P_Deliverable_Id
553: and action_id = P_Action_Id;
554: End If;