APPS.CS_TM_LABOR_SCHEDULES_PKG dependencies on CS_TM_LABOR_SCHEDULES

Line 1: PACKAGE BODY CS_TM_LABOR_SCHEDULES_PKG as

1: PACKAGE BODY CS_TM_LABOR_SCHEDULES_PKG as
2: /* $Header: csxttmlb.pls 120.1 2005/06/17 11:26:38 appldev $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 47: cursor C is select ROWID from CS_TM_LABOR_SCHEDULES

43: X_LAST_UPDATE_DATE in DATE,
44: X_LAST_UPDATED_BY in NUMBER,
45: X_LAST_UPDATE_LOGIN in NUMBER
46: ) is
47: cursor C is select ROWID from CS_TM_LABOR_SCHEDULES
48: where TM_LABOR_SCHEDULE_ID = X_TM_LABOR_SCHEDULE_ID
49: ;
50: begin
51: insert into CS_TM_LABOR_SCHEDULES (

Line 51: insert into CS_TM_LABOR_SCHEDULES (

47: cursor C is select ROWID from CS_TM_LABOR_SCHEDULES
48: where TM_LABOR_SCHEDULE_ID = X_TM_LABOR_SCHEDULE_ID
49: ;
50: begin
51: insert into CS_TM_LABOR_SCHEDULES (
52: TM_LABOR_SCHEDULE_ID,
53: BUSINESS_PROCESS_ID,
54: START_TIME,
55: END_TIME,

Line 205: from CS_TM_LABOR_SCHEDULES

201: ATTRIBUTE13,
202: ATTRIBUTE14,
203: ATTRIBUTE15,
204: SECURITY_GROUP_ID
205: from CS_TM_LABOR_SCHEDULES
206: where TM_LABOR_SCHEDULE_ID = X_TM_LABOR_SCHEDULE_ID
207: for update of TM_LABOR_SCHEDULE_ID nowait;
208: recinfo c%rowtype;
209:

Line 325: update CS_TM_LABOR_SCHEDULES set

321: X_LAST_UPDATED_BY in NUMBER,
322: X_LAST_UPDATE_LOGIN in NUMBER
323: ) is
324: begin
325: update CS_TM_LABOR_SCHEDULES set
326: BUSINESS_PROCESS_ID = X_BUSINESS_PROCESS_ID,
327: START_TIME = X_START_TIME,
328: END_TIME = X_END_TIME,
329: MONDAY_FLAG = X_MONDAY_FLAG,

Line 375: delete from CS_TM_LABOR_SCHEDULES

371: procedure DELETE_ROW (
372: X_TM_LABOR_SCHEDULE_ID in NUMBER
373: ) is
374: begin
375: delete from CS_TM_LABOR_SCHEDULES
376: where TM_LABOR_SCHEDULE_ID = X_TM_LABOR_SCHEDULE_ID;
377:
378: if (sql%notfound) then
379: raise no_data_found;

Line 383: end CS_TM_LABOR_SCHEDULES_PKG;

379: raise no_data_found;
380: end if;
381: end DELETE_ROW;
382:
383: end CS_TM_LABOR_SCHEDULES_PKG;
384: