APPS.ZPB_AW_WRITE_BACK dependencies on ZPB_ACCOUNT_STATES

Line 585: UPDATE zpb_account_states

581: AND user_id = v_task.asuser;
582:
583: END IF;
584:
585: UPDATE zpb_account_states
586: SET has_read_access = 0
587: WHERE user_id = v_task.asuser
588: AND business_area_id = v_task.business_Area_id;
589:

Line 597: --check this user for read access and update has_read_access flag in zpb_account_states

593:
594: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
595: 'Checking for Read access in accounts_states table for User'||l_user_id);
596:
597: --check this user for read access and update has_read_access flag in zpb_account_states
598: ZPB_SECURITY_UTIL_PVT.validate_user(l_user_id,
599: v_task.business_area_id,
600: l_api_version,
601: FND_API.G_FALSE,

Line 617: update zpb_account_states

613: end if;
614:
615: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
616: 'Updating accounts_states table has_read_access col for User'||l_user_id);
617: update zpb_account_states
618: set has_read_access = x_has_read_acc
619: where user_id = l_user_id
620: and business_area_id = v_task.business_area_id;
621:

Line 658: --check this user for read access and update has_read_access flag in zpb_account_states

654:
655: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
656: 'Checking for Read access in accounts_states table for User'||l_user_id);
657:
658: --check this user for read access and update has_read_access flag in zpb_account_states
659: ZPB_SECURITY_UTIL_PVT.validate_user(l_user_id,
660: v_task.business_area_id,
661: l_api_version,
662: FND_API.G_FALSE,

Line 678: update zpb_account_states

674: end if;
675:
676: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
677: 'Updating accounts_states table has_read_access col for User'||l_user_id);
678: update zpb_account_states
679: set has_read_access = x_has_read_acc
680: where user_id = l_user_id
681: and business_area_id = v_task.business_area_id;
682:

Line 856: l_user_id zpb_account_states.user_id%type;

852: l_personal_aw_nm zpb_users.personal_aw%type;
853: l_personal_aw_nmq zpb_users.personal_aw%type;
854: l_start number;
855: l_end number;
856: l_user_id zpb_account_states.user_id%type;
857: b_commit boolean := true;
858: b_start_aw_daemon boolean := false;
859: x_user_account_state varchar2(12);
860: x_return_status varchar2(1);

Line 1075: UPDATE zpb_account_states

1071: b_commit BOOLEAN := TRUE;
1072:
1073: BEGIN
1074:
1075: UPDATE zpb_account_states
1076: SET has_read_access = 0
1077: WHERE business_area_id = p_business_area_id
1078: AND user_id = p_user_id;
1079:

Line 1103: UPDATE zpb_account_states

1099: ELSE
1100: x_has_read_acc := 0;
1101: END IF;
1102:
1103: UPDATE zpb_account_states
1104: SET has_read_access = x_has_read_acc
1105: WHERE user_id = p_user_id
1106: AND business_area_id = p_business_area_id;
1107: