DBA Data[Home] [Help]

APPS.PA_LABOR_SCH_RULE_PKG dependencies on PA_ORG_LABOR_SCH_RULE_S

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 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