APPS.AP_WEB_DB_EXP_ATTENDEES_PKG dependencies on OIE_ATTENDEES

Line 7: l_temp OIE_ATTENDEES.EMPLOYEE_FLAG%type;

3:
4: -----------------------------------------------------------------------------
5: PROCEDURE DeleteAttendees(P_ReportID IN NUMBER) IS
6: --------------------------------------------------------------------------------
7: l_temp OIE_ATTENDEES.EMPLOYEE_FLAG%type;
8: l_curr_calling_sequence VARCHAR2(100) := 'DeleteAttendees';
9:
10: -- Selects report lines to delete. The actual value being selected does not
11: -- matter. For some reason the compiler complains when the OF column-name

Line 16: FROM OIE_ATTENDEES oat, AP_EXPENSE_REPORT_LINES el

12: -- in the FOR UPDATE is missing and NOWAIT is used, so the OF
13: -- EMPLOYEE_FLAG is used as a place holder.
14: CURSOR ExpAttendees IS
15: SELECT EMPLOYEE_FLAG
16: FROM OIE_ATTENDEES oat, AP_EXPENSE_REPORT_LINES el
17: WHERE (el.REPORT_HEADER_ID = P_ReportID AND
18: el.REPORT_LINE_ID = oat.REPORT_LINE_ID)
19: FOR UPDATE OF EMPLOYEE_FLAG NOWAIT;
20:

Line 32: DELETE OIE_ATTENDEES WHERE CURRENT OF ExpAttendees;

28: FETCH ExpAttendees into l_temp;
29: EXIT WHEN ExpAttendees%NOTFOUND;
30:
31: -- Delete matching line
32: DELETE OIE_ATTENDEES WHERE CURRENT OF ExpAttendees;
33: END LOOP;
34:
35: CLOSE ExpAttendees;
36:

Line 55: FROM OIE_ATTENDEES

51: l_attendee_id NUMBER(15);
52:
53: CURSOR Attendees IS
54: SELECT ATTENDEE_LINE_ID
55: FROM OIE_ATTENDEES
56: WHERE REPORT_LINE_ID = p_source_report_line_id;
57:
58:
59: BEGIN

Line 71: SELECT OIE_ATTENDEES_S.NEXTVAL

67:
68: EXIT WHEN Attendees%NOTFOUND;
69:
70: -- Get new ID from sequence
71: SELECT OIE_ATTENDEES_S.NEXTVAL
72: INTO l_new_attendee_id
73: FROM DUAL;
74:
75: -- For each line, duplicate its columns

Line 76: INSERT INTO OIE_ATTENDEES

72: INTO l_new_attendee_id
73: FROM DUAL;
74:
75: -- For each line, duplicate its columns
76: INSERT INTO OIE_ATTENDEES
77: (
78: ATTENDEE_LINE_ID,
79: REPORT_LINE_ID,
80: EMPLOYEE_FLAG,

Line 109: FROM OIE_ATTENDEES

105: sysdate AS CREATION_DATE,
106: p_user_id AS CREATED_BY,
107: sysdate AS LAST_UPDATE_DATE,
108: p_user_id AS LAST_UPDATED_BY
109: FROM OIE_ATTENDEES
110: WHERE ATTENDEE_LINE_ID = l_attendee_id;
111:
112: END LOOP;
113: