1 package PA_LABOR_SCH_RULE_PKG AUTHID CURRENT_USER as
2 -- $Header: PALABSRS.pls 115.2 2002/12/02 23:36:03 riyengar noship $
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY varchar2
6 ,x_ORG_LABOR_SCH_RULE_ID IN OUT NOCOPY number
7 ,p_ORGANIZATION_ID IN number
8 ,p_ORG_ID IN number
9 ,p_LABOR_COSTING_RULE IN varchar2
10 ,p_COST_RATE_SCH_ID IN number
11 ,p_OVERTIME_PROJECT_ID IN number
12 ,p_OVERTIME_TASK_ID IN number
13 ,p_ACCT_RATE_DATE_CODE IN varchar2
14 ,p_ACCT_RATE_TYPE IN varchar2
15 ,p_ACCT_EXCHANGE_RATE IN number
16 ,p_START_DATE_ACTIVE IN DATE
17 ,p_END_DATE_ACTIVE IN DATE
18 ,p_FORECAST_COST_RATE_SCH_ID IN number
19 ,p_CREATION_DATE IN DATE
20 ,p_CREATED_BY IN number
21 ,p_LAST_UPDATE_DATE IN DATE
22 ,p_LAST_UPDATED_BY IN number
23 ,p_LAST_UPDATE_LOGIN IN number
24 ,x_return_status IN OUT NOCOPY varchar2
25 ,x_error_msg_code IN OUT NOCOPY varchar2
26 );
27 PROCEDURE update_row
28 (
29 p_rowid IN varchar2
30 ,p_ORG_LABOR_SCH_RULE_ID IN number
31 ,p_ORGANIZATION_ID IN number
32 ,p_ORG_ID IN number
33 ,p_LABOR_COSTING_RULE IN varchar2
34 ,p_COST_RATE_SCH_ID IN number
35 ,p_OVERTIME_PROJECT_ID IN number
36 ,p_OVERTIME_TASK_ID IN number
37 ,p_ACCT_RATE_DATE_CODE IN varchar2
38 ,p_ACCT_RATE_TYPE IN varchar2
39 ,p_ACCT_EXCHANGE_RATE IN number
40 ,p_START_DATE_ACTIVE IN DATE
41 ,p_END_DATE_ACTIVE IN DATE
42 ,p_FORECAST_COST_RATE_SCH_ID IN number
43 ,p_CREATION_DATE IN DATE
44 ,p_CREATED_BY IN number
45 ,p_LAST_UPDATE_DATE IN DATE
46 ,p_LAST_UPDATED_BY IN number
47 ,p_LAST_UPDATE_LOGIN IN number
48 ,x_return_status IN OUT NOCOPY varchar2
49 ,x_error_msg_code IN OUT NOCOPY varchar2
50 );
51 PROCEDURE delete_row (p_ORG_LABOR_SCH_RULE_ID in NUMBER);
52
53 PROCEDURE delete_row (x_rowid in VARCHAR2);
54
55 PROCEDURE lock_row (p_org_labor_sch_rule_id in NUMBER);
56
57 END PA_LABOR_SCH_RULE_PKG;