APPS.PQH_PROCESS_EMP_REVIEW dependencies on PER_BOOKINGS

Line 993: from per_bookings

989: l_booking_id Number;
990:
991: Cursor getBookingRowid(p_Booking_id In Number) is
992: select rowid
993: from per_bookings
994: where Booking_id = p_Booking_id;
995:
996: Cursor getBookingRowidForBooking(p_personId In Number,p_event_id In Number) is
997: Select rowid

Line 998: From per_bookings

994: where Booking_id = p_Booking_id;
995:
996: Cursor getBookingRowidForBooking(p_personId In Number,p_event_id In Number) is
997: Select rowid
998: From per_bookings
999: Where person_id =p_personId and event_id = p_event_id;
1000:
1001: Cursor check_for_row_exsistance(X_Person_Id in Number,X_Event_Id in Number) is
1002: Select count(*)

Line 1003: from per_bookings

999: Where person_id =p_personId and event_id = p_event_id;
1000:
1001: Cursor check_for_row_exsistance(X_Person_Id in Number,X_Event_Id in Number) is
1002: Select count(*)
1003: from per_bookings
1004: where person_id = x_Person_Id and event_Id = x_Event_Id;
1005:
1006: Begin
1007: --

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

1017: fetch getBookingRowid into l_rowId;
1018: close getBookingRowid;
1019: --
1020: hr_utility.set_location('Row Id in Delete '||l_rowId,10);
1021: per_bookings_pkg.Delete_Row(X_Rowid => l_rowId);
1022: hr_utility.set_location(' After Row Id in Delete '||l_rowId,10);
1023: --
1024: end if;
1025: --

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

1031: --
1032: hr_utility.set_location('Row Id '||l_rowId,10);
1033: hr_utility.set_location('Booking Id '||p_Booking_Id||'business Group Id '||p_Business_Group_Id||'event Id '||p_event_id,10);
1034: --
1035: PER_BOOKINGS_PKG.Update_Row(X_Rowid => l_rowId,
1036: X_Booking_Id => p_Booking_Id ,
1037: X_Business_Group_Id => p_Business_Group_Id,
1038: X_Person_Id => p_personId,
1039: X_Event_Id => p_event_id,

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

1070: close check_for_row_exsistance;
1071:
1072: if l_count = 0 then
1073:
1074: PER_BOOKINGS_PKG.Insert_Row(X_Rowid => l_Row_Id,
1075: X_Booking_Id => l_Booking_Id ,
1076: X_Business_Group_Id => p_Business_Group_Id,
1077: X_Person_Id => p_personId,
1078: X_Event_Id => pkg_event_id,