APPS.PQH_PROCESS_EMP_REVIEW dependencies on PER_BOOKINGS

Line 969: from per_bookings

965: l_booking_id Number;
966:
967: Cursor getBookingRowid(p_Booking_id In Number) is
968: select rowid
969: from per_bookings
970: where Booking_id = p_Booking_id;
971:
972: Cursor getBookingRowidForBooking(p_personId In Number,p_event_id In Number) is
973: Select rowid

Line 974: From per_bookings

970: where Booking_id = p_Booking_id;
971:
972: Cursor getBookingRowidForBooking(p_personId In Number,p_event_id In Number) is
973: Select rowid
974: From per_bookings
975: Where person_id =p_personId and event_id = p_event_id;
976:
977: Cursor check_for_row_exsistance(X_Person_Id in Number,X_Event_Id in Number) is
978: Select count(*)

Line 979: from per_bookings

975: Where person_id =p_personId and event_id = p_event_id;
976:
977: Cursor check_for_row_exsistance(X_Person_Id in Number,X_Event_Id in Number) is
978: Select count(*)
979: from per_bookings
980: where person_id = x_Person_Id and event_Id = x_Event_Id;
981:
982: Begin
983: --

Line 997: per_bookings_pkg.Delete_Row(X_Rowid => l_rowId);

993: fetch getBookingRowid into l_rowId;
994: close getBookingRowid;
995: --
996: hr_utility.set_location('Row Id in Delete '||l_rowId,10);
997: per_bookings_pkg.Delete_Row(X_Rowid => l_rowId);
998: hr_utility.set_location(' After Row Id in Delete '||l_rowId,10);
999: --
1000: end if;
1001: --

Line 1011: PER_BOOKINGS_PKG.Update_Row(X_Rowid => l_rowId,

1007: --
1008: hr_utility.set_location('Row Id '||l_rowId,10);
1009: hr_utility.set_location('Booking Id '||p_Booking_Id||'business Group Id '||p_Business_Group_Id||'event Id '||p_event_id,10);
1010: --
1011: PER_BOOKINGS_PKG.Update_Row(X_Rowid => l_rowId,
1012: X_Booking_Id => p_Booking_Id ,
1013: X_Business_Group_Id => p_Business_Group_Id,
1014: X_Person_Id => p_personId,
1015: X_Event_Id => p_event_id,

Line 1050: PER_BOOKINGS_PKG.Insert_Row(X_Rowid => l_Row_Id,

1046: close check_for_row_exsistance;
1047:
1048: if l_count = 0 then
1049:
1050: PER_BOOKINGS_PKG.Insert_Row(X_Rowid => l_Row_Id,
1051: X_Booking_Id => l_Booking_Id ,
1052: X_Business_Group_Id => p_Business_Group_Id,
1053: X_Person_Id => p_personId,
1054: X_Event_Id => pkg_event_id,