1 package PA_LABOR_SCH_RULE_PKG AUTHID CURRENT_USER as
2 -- $Header: PALABSRS.pls 120.3 2011/03/14 03:57:46 rkuttiya ship $
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_BASE_HOURS IN NUMBER
20 ,p_rbc_element_type_id IN NUMBER
21 ,p_CREATION_DATE IN DATE
22 ,p_CREATED_BY IN number
23 ,p_LAST_UPDATE_DATE IN DATE
24 ,p_LAST_UPDATED_BY IN number
25 ,p_LAST_UPDATE_LOGIN IN number
26 ,x_return_status IN OUT NOCOPY varchar2
27 ,x_error_msg_code IN OUT NOCOPY varchar2
28 );
29 PROCEDURE update_row
30 (
31 p_rowid IN varchar2
32 ,p_ORG_LABOR_SCH_RULE_ID IN number
33 ,p_ORGANIZATION_ID IN number
34 ,p_ORG_ID IN number
35 ,p_LABOR_COSTING_RULE IN varchar2
36 ,p_COST_RATE_SCH_ID IN number
37 ,p_OVERTIME_PROJECT_ID IN number
38 ,p_OVERTIME_TASK_ID IN number
39 ,p_ACCT_RATE_DATE_CODE IN varchar2
40 ,p_ACCT_RATE_TYPE IN varchar2
41 ,p_ACCT_EXCHANGE_RATE IN number
42 ,p_START_DATE_ACTIVE IN DATE
43 ,p_END_DATE_ACTIVE IN DATE
44 ,p_FORECAST_COST_RATE_SCH_ID IN number
45 ,p_BASE_HOURS IN NUMBER
46 ,p_RBC_ELEMENT_TYPE_ID IN NUMBER
47 ,p_CREATION_DATE IN DATE
48 ,p_CREATED_BY IN number
49 ,p_LAST_UPDATE_DATE IN DATE
50 ,p_LAST_UPDATED_BY IN number
51 ,p_LAST_UPDATE_LOGIN IN number
52 ,x_return_status IN OUT NOCOPY varchar2
53 ,x_error_msg_code IN OUT NOCOPY varchar2
54 );
55 PROCEDURE delete_row (p_ORG_LABOR_SCH_RULE_ID in NUMBER);
56
57 PROCEDURE delete_row (x_rowid in VARCHAR2);
58
59 PROCEDURE lock_row (p_org_labor_sch_rule_id in NUMBER);
60
61 END PA_LABOR_SCH_RULE_PKG;