DBA Data[Home] [Help]

APPS.PA_LABOR_SCH_RULE_PKG dependencies on PA_ORG_LABOR_SCH_RULE_S

Line 41: select pa_org_labor_sch_rule_s.nextval

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

Line 220: UPDATE pa_org_labor_sch_rule SET

216: Nvl(recinfo.FORECAST_COST_RATE_SCH_ID,0) <> nvl(p_FORECAST_COST_RATE_SCH_ID,0) ) THEN
217: IF l_debug_mode = 'Y' THEN
218: print_msg('firing update query');
219: End If;
220: UPDATE pa_org_labor_sch_rule SET
221: ORGANIZATION_ID = p_ORGANIZATION_ID
222: ,ORG_ID = p_ORG_ID
223: ,LABOR_COSTING_RULE = p_LABOR_COSTING_RULE
224: ,COST_RATE_SCH_ID = p_COST_RATE_SCH_ID