DBA Data[Home] [Help]

APPS.ZPB_AW_WRITE_BACK dependencies on ZPB_SECURITY_RULE_DEFINITION_T

Line 558: UPDATE zpb_security_rule_definition_t

554: l_err_msg := SQLERRM;
555:
556: IF INSTR(v_task.token, 'ReadAccess',1) > 0 THEN
557:
558: UPDATE zpb_security_rule_definition_t
559: SET status = l_status,
560: error = error || '; ' || l_err_msg
561: WHERE business_area = v_task.business_Area_id
562: AND rule_type = 'READ'

Line 567: UPDATE zpb_security_rule_definition_t

563: AND user_id = v_task.asuser;
564:
565: ELSIF INSTR(v_task.token, 'WriteAccess',1) > 0 THEN
566:
567: UPDATE zpb_security_rule_definition_t
568: SET status = l_status,
569: error = error || '; ' || l_err_msg
570: WHERE business_area = v_task.business_Area_id
571: AND rule_type = 'WRITE'

Line 576: UPDATE zpb_security_rule_definition_t

572: AND user_id = v_task.asuser;
573:
574: ELSIF INSTR(v_task.token, 'Ownership',1) > 0 THEN
575:
576: UPDATE zpb_security_rule_definition_t
577: SET status = l_status,
578: error = error || '; ' || l_err_msg
579: WHERE business_area = v_task.business_Area_id
580: AND rule_type = 'OWNERSHIP'