APPS.PA_LABOR_SCH_RULE_PKG dependencies on PA_ORG_LABOR_SCH_RULE

Line 40: from pa_org_labor_sch_rule

36: ,x_error_msg_code IN OUT NOCOPY varchar2
37: )IS
38: cursor return_rowid is
39: select rowid
40: from pa_org_labor_sch_rule
41: where ORG_LABOR_SCH_RULE_ID = x_ORG_LABOR_SCH_RULE_ID;
42:
43: cursor get_itemid is
44: select pa_org_labor_sch_rule_s.nextval

Line 44: select pa_org_labor_sch_rule_s.nextval

40: from pa_org_labor_sch_rule
41: where ORG_LABOR_SCH_RULE_ID = x_ORG_LABOR_SCH_RULE_ID;
42:
43: cursor get_itemid is
44: select pa_org_labor_sch_rule_s.nextval
45: from sys.dual;
46:
47: l_return_status varchar2(100) := 'S';
48: l_error_msg_code varchar2(100) := NULL;

Line 70: INSERT into pa_org_labor_sch_rule

66: IF l_debug_mode = 'Y' THEN
67: print_msg('Info transacton id ..'||x_ORG_LABOR_SCH_RULE_ID);
68: End If;
69:
70: INSERT into pa_org_labor_sch_rule
71: (
72: ORG_LABOR_SCH_RULE_ID
73: ,ORGANIZATION_ID
74: ,ORG_ID

Line 190: FROM pa_org_labor_sch_rule

186: --rkuttiya added for 12.2. Projects Payroll Integration
187: ,BASE_HOURS
188: ,RBC_ELEMENT_TYPE_ID
189: --
190: FROM pa_org_labor_sch_rule
191: WHERE ORG_LABOR_SCH_RULE_ID = p_ORG_LABOR_SCH_RULE_ID
192: FOR UPDATE OF ORG_LABOR_SCH_RULE_ID NOWAIT;
193:
194: recinfo cur_row%rowtype;

Line 240: UPDATE pa_org_labor_sch_rule SET

236: Nvl(recinfo.rbc_element_type_id,0) <> nvl(p_rbc_element_type_id,0) ) THEN
237: IF l_debug_mode = 'Y' THEN
238: print_msg('firing update query');
239: End If;
240: UPDATE pa_org_labor_sch_rule SET
241: ORGANIZATION_ID = p_ORGANIZATION_ID
242: ,ORG_ID = p_ORG_ID
243: ,LABOR_COSTING_RULE = p_LABOR_COSTING_RULE
244: ,COST_RATE_SCH_ID = p_COST_RATE_SCH_ID

Line 294: DELETE FROM PA_ORG_LABOR_SCH_RULE

290: l_debug_mode := NVL(l_debug_mode, 'N');
291:
292: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
293:
294: DELETE FROM PA_ORG_LABOR_SCH_RULE
295: WHERE ORG_LABOR_SCH_RULE_ID = p_ORG_LABOR_SCH_RULE_ID;
296: if sql%found then
297: IF l_debug_mode = 'Y' THEN
298: print_msg('Delete Success');

Line 312: from PA_ORG_LABOR_SCH_RULE

308: PROCEDURE delete_row (x_rowid in VARCHAR2)IS
309:
310: cursor get_itemid is
311: select ORG_LABOR_SCH_RULE_ID
312: from PA_ORG_LABOR_SCH_RULE
313: where rowid = x_rowid;
314:
315: l_ORG_LABOR_SCH_RULE_ID Number;
316:

Line 344: FROM pa_org_labor_sch_rule

340: ,FORECAST_COST_RATE_SCH_ID
341: --rkuttiya added for 12.2 Projects Payroll Integration
342: ,BASE_HOURS
343: ,RBC_ELEMENT_TYPE_ID
344: FROM pa_org_labor_sch_rule
345: WHERE ORG_LABOR_SCH_RULE_ID = p_ORG_LABOR_SCH_RULE_ID
346: FOR UPDATE OF ORG_LABOR_SCH_RULE_ID NOWAIT;
347:
348: recinfo cur_row%rowtype;